Starting a Database
Dear all,
I want to create a database (prob. excel). We have a lot of items where we have to create new labels.
My Idea is to create a database with all information for the new labels we have to print, but the label is generated by scanning the original label (Barcode) on the item.
--> So, by scanning the original barcode on the item, Bartender should automatically create a new label with all information from the database for the corresponding item.
Before I invest a lot of time, just the question:
Is this possible with bartender to scan a code and then automatically create a new printable label?
Cheers and thanks in advance
-
Peter Thane
★ BarTender Hero ★
Yes that is possible.
You would need to create your database and then your label linking the appropriate fields on the label to the matching fields in the database, You would also need to create a database filter linked to the field in the database that holds the information you will be scanning with the barcode reader.
At print time the user would scan the code and BarTender would look for that value in the set field in the database and then print the label with all the other database field values being populated from the data for that selected product in the database.
0 -
Cptlogistik
★ BarTender Hero ★
Hi Peter, thanks for your quick reply.
But I don't get it... How do I link a barcode on my original item to a database.
Just tried some time but it is not working as expectedFor Example:
Original Item Barcode: 0550500000 --> this (barcode) needs to be scanned at the PC
"behind" this barcode, there shall be several information from the database to fill in the corresponding fields likeItem Name: ZETO
Item No.: 12345
Quality: Yellow
I scan the original barcode, and all the information from this code shall appear on the label.
Is there way to tell bartender to do so?
My idea (hope) was to have an Excel file with my Original Info (Barcode) Column A1 and all info to be printed in B1, C1, D1, E1.....BTW, Do you have to this this manually for every item?
0 -
Peter Thane
★ BarTender Hero ★
You would create your label as normal linking the label to your Excel spreadsheet.
Once linked the database fields will appear in the Data Sources column on the left and you can add them to your label:
In the Database setup you would need to create a Filter (query) to perform the look up into the table.
The filter will appear automatically when you go to print or else (as long as you are not using Starter) you could configure/link it so it appears on the a Data Entry form at print plus any other variable information, such as below
At print time the result will be something like this
0
Please sign in to leave a comment.
Comments
3 comments