Integration Builder with .txt trigger using MySQL database
Hello Community,
I am currently working on a project where I aim to build an integration to print labels based on a Bartender template. The trigger for this process is a .txt file that will be dropped into a scan folder. This file contains a barcode string, which I intend to use to query a MySQL database. The database has a table (let’s call it XYZ) that contains line-level information corresponding to the barcode string in the trigger file (e.g., Name, Size, Description, Barcode, Weight, etc.). This information will be used on the actual label that will be printed.
Despite several attempts, I have been unable to configure the integration in a way that allows me to use the data from the trigger file to link it to the MySQL database and extract the line-level data for use on the template.
At this point, I feel overwhelmed with conflicting ideas and suspect that I might be overlooking a straightforward solution. Could anyone provide some guidance or suggestions on how to connect these dots? Any help would be greatly appreciated. Thank you.
-
In your label create a filter/query prompt that performs the lookup in your table.
Now when you Import the label onto the Integration you should see the filter listed under the Query Prompts and you can then link the field name/number from your trigger file to this so at print time that value is used to lookup the correct database record.
0
Please sign in to leave a comment.
Comments
1 comment