Reading A Trigger File, Using Data For Excel Record Lookup (Bt 2016) フォローする
I'm brand new to BarTender, using 2016.
I have an Excel file. Each record has approx 10 fields. The file can have many records.
My system will get a single alphanumeric string, then have to use that string to search the Excel file. When a matching record is found ( the string matches the corresponding field - part number, for example), I need to print a label that contains the fields in that record. My system will not be opening and searching that Excel file, I need to let BT do that.
I have created a label, have assigned field and file names so that I can properly fill the label. When I print the label manually, I can select the record to print and it does print properly.
I've created an Integration Builder project that uses trigger files. Right now, my system can push a file that will trigger the print.
What I want to do:
1) Put the part number inside the trigger file.
2) Write the trigger file (it will go onto a network location somewhere)
3) Let the Integration trigger on the file
4) Let the integration read the key out of the trigger file
5) Let the integration search the Excel file for the record to print
6) Print the label.
I am stuck at #4 and #5.
At least one of the help videos explains how to create a variable and read an element from a file to put into that variable. I haven't been able to get that to work yet. And then I still need to be able to select which record to print once I do.
I'd appreciate any help or guidance.
Follow-up: I have been able to read the text and put it into a variable %EventData%. Now I am at the point where I have a variable, and I have a spreadsheet. How can I get BT Integration Builder to find the record with a field that matches that variable and then print only that record?