Looking Up A Value From A Tab Delimited .txt File

Legacy Poster

• September 28, 2012 17:22

In Bartender 7.10 I need help on how to take a number which has been entered into the prompt data item I named [b]ECIBarcode[/b] and cause it look up a corresponding [b]CLEICode[/b] data item in a tab delimeted txt file I have named as CLEICode.txt. I have the txt file created already and setup within the bartender label file, I need help with the script which will enable this to happen. I'm not a script expert. It would be really nice if Seagull Scientific published some good examples how to use scripting for some common applications.

Thanks,
Dave

0

• 

  Michael Toupin (mtoupin

  ★ BarTender Hero ★

  • October 01, 2012 18:09
  [quote name='davensac' timestamp='1348852934' post='3367']
  In Bartender 7.10 I need help on how to take a number which has been entered into the prompt data item I named [b]ECIBarcode[/b] and cause it look up a corresponding [b]CLEICode[/b] data item in a tab delimeted txt file I have named as CLEICode.txt. I have the txt file created already and setup within the bartender label file, I need help with the script which will enable this to happen. I'm not a script expert. It would be really nice if Seagull Scientific published some good examples how to use scripting for some common applications.
  
  Thanks,
  Dave
  [/quote]
  
  Hello Dave,
  
  You just need to set up a database query to be able to do this. In your database connection setup window, select the 'query' tab, then populate the fields and operator boxes with your requirements. For criteria, pull the window down to 'new prompt' and you can create a database prompt from there.
  
  Normal print-time prompts don't interact with the database, you'd use this in it's place.

  0

Please sign in to leave a comment.