Reading from CSV Text file and linking to a SQl table
I have designed a label to read a CSV file and have it linked to a SQL table.
The CSV file has basic information- specifically it has a "part number" field.
The "part number" is linked to a sql table to extract the "label size" to print.
Once we have the label size, we need to print to a different printer using a different template.
I was wanting to use this template, with the joins to the SQL table, to be used in the Integration builder
From what I can see, Integration Builder can only connect to a single datasource during integration.
I need it to connect to the SQL table as well to be able to get the "label size" field so I can use it in the Print Document- Actions- Run Action- Conditionally, based on a variable.
(Unfortunately I cannot include the label size in the CSV input file. Its only available by joining/looking up a SQL table.)
How do I get the Integration builder to connect to a second table with the Integration-InputData as it seems it can only connect to a single data source?
My Actions are Transform Text to Record Set, For Each Database Record, then Print Document(Small Label) and Print Document(Large Label) with conditional printing.
Hope this makes sense!
-
Not tried this but I wonder if you need to use the Part Number (%Event Data%) as the lookup value in an SQL statement in the SQL option from the Database action type.
0 -
Would you have any examples on how to do this?
A screen shot would be wonderful!
0 -
No sorry
0 -
I thought I'd share the soltuion - Use conditional printing in "Page Setup"
Within the BarTender Document/Label, under Page Setup, click on the Template tab, then change the "When to Print" from "Always" to "Conditionally, based on expression".
In the Document/label, link the CSV file to a SQL table which brought in the extra fields needed for the expression.
Then this document can be used in Integration builder alot more simply.
HTH
0
サインインしてコメントを残してください。
コメント
4件のコメント