List Box Selection To Populate Multiple Substrings Values From Excel File 关注

0
Avatar
Legacy Poster

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? 

5 评论

0
Avatar
Shotaro Ito
版主
评论操作 固定链接

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
Avatar
Shotaro Ito
版主
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Legacy Poster
评论操作 固定链接

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
Avatar
Shotaro Ito
版主
评论操作 固定链接

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

http://www.seagullsc...-database).aspx

请先登录再写评论。