Items On A Label From A Database
After reading manuals, white papers, and help articles, I've learned that labels can be printed from records of a database. However, I'd like to design a label for which a user inputs some data on a data entry form then the rest of the items on the label could be populated with data retrieved from a database based on the data previously input by the user.
0
-
You'll need to create a database connection for the label and then define a query with a query prompt. It might be the case the standard user based data entry form controls are also required. It should be noted that we are not able to consolidate the query prompt and user prompts into a single data entry dialog.
The below training videos should help you get started:
http://www.bartenderbarcodesoftware.com/label-software/training-video-(reading-data-from-database).aspx
http://www.bartenderbarcodesoftware.com/label-software/training-video-(selecting-records-from-a-database-at-print-time).aspx
http://www.bartenderbarcodesoftware.com/label-software/training-video-(data-entry-at-print-time).aspx0 -
[quote name='Ian C - Seagull Support' timestamp='1360085058' post='4322']
You'll need to create a database connection for the label and then define a query with a query prompt. It might be the case the standard user based data entry form controls are also required. It should be noted that we are not able to consolidate the query prompt and user prompts into a single data entry dialog.
The below training videos should help you get started:
http://www.bartenderbarcodesoftware.com/label-software/training-video-(reading-data-from-database).aspx
http://www.bartenderbarcodesoftware.com/label-software/training-video-(selecting-records-from-a-database-at-print-time).aspx
http://www.bartenderbarcodesoftware.com/label-software/training-video-(data-entry-at-print-time).aspx
[/quote]
Thanks for your answer. It sounds like Bartender doesn't support that use scenario. But I think it's not that unusual. Let me elaborate what I want to achieve. I want to print labels triggered by measurement values from a digital scale but the data entry form also accepts a few basic info about a product such as product ID, batch number, etc. And I'd like to add other info to the label retrieved from a database with the product ID as a key.0 -
I understand your question, but alas the functionality of BarTender's database query prompt and user prompt form remains the same. Perhaps an alternative solution for you would be to create your own data entry "front end" application form using something like VB.NET, which would then in turn control BarTender programmatically for opening a label, setting data on the label and then printing.
More information on controlling BarTender via automation can be found in the below white papers:
http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Controlling-Barcode-Label-Software-using-C-Sharp-and-VB.NET(English).pdf
http://www.bartenderbarcodesoftware.com/label-software/whitepapers/Controlling-Barcode-Label-Software-using-ActiveX-Automation.pdf
We intend to augment the functionality of the data entry form and database query going into the future.0
Please sign in to leave a comment.
Comments
3 comments