Can Bartender Capture Info Scanned From A Reader And Populate A File In Order To Create An Inventory File?

Legacy Poster

• October 22, 2015 00:05

So we run a reclaimed lumber mill. We get beams in all the time and now need to create an inventory system. Each time a truckload comes in, we'll measure and grade it, enter this info into Bartender, immediately print a beam tag, then the problem...scan the resulting printed bar code (if necessary) and have it populate an Excel file so we can build an inventory file.

 

We've invested in a tablet, Zebra printer, Bartender Enterprise, hand held scanner, etc. Stuck on building a file. Need to know if Bartender can do it or if I need to use Excel to do it (and if so, how).

 

 I WANT TO:

1. Enter data on tablet from drop down lists and radio buttons (Print Preview screen?)

2. Have it generate a bar code (and print the tag)

3. Store this information into an Excel file to create an inventory file

 

I've gotten to step 2 but need to know how to scan the bar code resulting in the information being populated in the Excel file. I know it will/can copy the bar code into a field, but can Excel then "decode" this barcode and pull out the information thereby populating columns C-K? If so, I'll ask an Excel Wizard...I just need to know if this transfer of info from the scanner happens directly to Excel or if Bartender can handle this (i.e. creating a log file which I can open/export into Excel).

 

Thanks in advance! 

 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • October 23, 2015 09:44

  You can use a document level VB script, via the "File>BarTender Document Options" menu item, using the the OnPrintJobEnd event, to create the Excel file and write content to it.  The below article should help you get started with the script on how to do this:

   

  http://stackoverflow.com/questions/1123605/create-an-excel-file-using-vbscripts

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • October 23, 2015 13:28

  Thanks Ian.

   

  Is this where I select the screen to enter vbscript? If so, which category/subcategory do I select to enter the vbscript?

   

  We were hoping to have it "add to" an excel file rather than create a new one each time which is what the directions seem to indicate. I'll take what I can get though.

   

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • October 28, 2015 19:18

  What you indicate is not it, that is the Print Code Modifier (PCM) which is something else entirely.  It looks like you have an older version or lower edition of BarTender that doesn't support this.  Instead create a text object to act as a VB script container, place it off the label area so it doesn't print, and use an event based VB script to run your code in.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • October 28, 2015 19:23

  Thanks Ian.

  0

Please sign in to leave a comment.