Reading from CSV Text file and linking to a SQl table S’abonner

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 commentaires

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

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
Actions pour les commentaires Permalien

Would you have any examples on how to do this?

A screen shot would be wonderful! 

0
Avatar
Pete Thane
Actions pour les commentaires Permalien

No sorry 

0
Avatar
Mosen Ali
Actions pour les commentaires Permalien

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

 

Vous devez vous connecter pour laisser un commentaire.