List Box Selection To Populate Multiple Substrings Values From Excel File
Hello,
I have a product that I need to print three barcodes for at the same time/same label. I would like to pull a substring value for the three barcodes from an excel document. This value would be different for each barcode (see attached screen shot) but they would all be on the same row.
I would like to add a drop down list at my printing prompt that allows the operator to select the "Item" from the excel list to populate the fields SKU1, SKU2, SKU3 from that row into the linked sub strings for the barcode.
Is this possible?
-
Shotaro Ito
★ BarTender Hero ★
One simple solution is create database connection to the excel sheet,
Then use record selection dialog to select a record.
Record selection dialog is rather like listbox than dropdown, though.
Database connection
http://www.seagullscientific.com/label-software/training-video-(reading-data-from-database).aspx
Record selection dialog
http://www.seagullscientific.com/label-software/training-video-(data-entry-at-print-time).aspx
Another solution is get dropdown source from excel
http://forums.seagullscientific.com/index.php?/topic/595-vb-script-dropdown-list-excel/
Use Tab to separate display text and values connected by custom delimiter - something like
---
"ITEM1" & vbTab & "PRODCODE" & "|" & "PRODCODEcc" & "|" & "PRODCODEg" &vbCr
---
on each barcode, use search and transform to chop off unnecessary part - like,
for SKU1, search | and delete after that, then delete | .
but this is a bit tedious approach compare to just use Database.
0 -
Shotaro Ito
★ BarTender Hero ★
viewing attached document, it looks you've already used record selection dialog already - so, the 2nd approach might helps.
However Search and replace is available from BarTender 10.0. prior to that you need to apply transform by More option's VB Script.
0 -
Shotaro,
Thank you for the suggestions. I think in the meantime I need to tackle this in a different way if you could help me out with these two options.
Option 1: I would like to setup the printing prompt so the product code values can be entered via text box for each of the three barcodes. I am able to set this up for two of the barcodes but when I try to do it for the third it does not give me the option to create a new prompt. Not sure what is happening here?
Option 2: Another option I would like to explore is batch generating multiple label files based on this template. I would like to use an excel spreadsheet containing a row with three columns listing the product codes. The three product code values would be pulled from an excel sheet and an individual bartender label file would be generated for each row in the excel sheet.0 -
Shotaro,
Any chance to look at this? I have a lot of labels I need to generate of you could help me with option 2 that would be greatly appreciated!
0 -
Shotaro Ito
★ BarTender Hero ★
Shotaro,
Any chance to look at this? I have a lot of labels I need to generate of you could help me with option 2 that would be greatly appreciated!
Hi Roger, beg your pardon I had been a bit occupied. For option 2, I recon that's basic usage of database connection, try this video.
Database connection
0
请先登录再写评论。
评论
5 条评论