How to print a specific bartender label from Excel Follow

0
Avatar
Melvin Chinchilla

Hi Everyone ,

Hopefully someone knows the answer for this since I'm lost on how to do it :(

I have an Excel file that has a column of serial numbers, then I use a barcode scanner and scan a barcode on several boxes, if this scanned barcode on a box matches a code on this Excel column list, then I need a specific bartender label (I already have it made, it will print this same label everytime if a code matches) to be printed.

Any ideas or examples on how to do this please?

5 comments

1
Avatar
Pete Thane
Comment actions Permalink

If your BarTender label uses data in the same Excel sheet for data then that will not possible they way you are suggesting. Due to access rights only one "person" can have full access to an Excel workbook at a time and BarTender is considered a person in this instance.

The simplest way is do this the other way round in a way.. 

Open the required label in BarTender or Print Station with the label connected to the Excel spreadsheet and a database filter configured linked to your look up value in the spreadsheet. I would also suggest enabling the print until cancelled option on the File>Print>Options screen.

At print time the user scans the code in to the Database entry/filter input and if the record if found the label will print and return to this input screen. If the record is not found then the user will get a message to this regard,(Record not found) and they will have to click OK to clear this.

 

0
Avatar
Melvin Chinchilla
Comment actions Permalink

Hi Pete, thanks a lot for your reply!

I understand now what you mean about the Excel access rights.

However since I'm not very techical with this sort of things, I do not understand what you mean by the Database Filter, is this done on Excel or Bartender? how should i look this up on google or youtube to get an idea on how to do it?

Thanks again and sorry for my lack of knowledge on this.

1
Avatar
Pete Thane
Comment actions Permalink

In your BarTender label use the Database Connection Setup to link your spreadsheet to the label following the the wizard and on screen prompts.

Once you have formed the connection you can then configure a database query/filter to allow you to perform a lookup for a specific record at print time 

In the filter config screen, click on the plus sign next to the AND and then in the choose the field that holds the search value in your spreadsheet (I have chosen the Code), set the Parameter (i left it as the default Equals and then in the drop down entry box choose the New Query Prompts and a new screen will appear

You can give the Query a name or leave it as the default, amend the Text Label (this is what the users will see so I changed it to "Scan the Code"  and as you are using a scanner tick the appropriate box, 

If the use scans a code that is not in the database they will get a message that they will have to clear by pressing enter

If you enable the repeat until cancelled option then the data/scan entry box will contiue to appear after a successful print or a the above no record found.

I hope this helps

 

 

 

  

 

  

 

0
Avatar
Melvin Chinchilla
Comment actions Permalink

Thank you millions Pete, I have managed to do all that with my Excel sheet and the filter as well :) 

Only thing I can't do now is when it reads the code and it matches, how do I automatically send the print command of this label after it has verified that the code is in the Excel file?

0
Avatar
Pete Thane
Comment actions Permalink

Not got a scanner to test with but have you ticked the Data is Entered by a Barcode Scanner as shown above and does you scanner transmit and Enter command after the data is sent (if you scan into Notepad does the cursor move on to the next line when you scan or stay on the same line, if the same then there is no Enter or Carriage Return being sent)

Please sign in to leave a comment.