Reading from CSV Text file and linking to a SQl table フォローする

0
Avatar
Mosen Ali

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!

 

4 コメント

0
Avatar
Pete Thane
コメントアクション Permalink

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
Avatar
Mosen Ali
コメントアクション Permalink

Would you have any examples on how to do this?

A screen shot would be wonderful! 

0
Avatar
Pete Thane
コメントアクション Permalink

No sorry 

0
Avatar
Mosen Ali
コメントアクション Permalink

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

 

サインインしてコメントを残してください。