Lbl Qty in integration file
I am trying to setup an integration which gets the number of labels from the file it detects. CSV file has two fields, Job and Qty, The label has a database connection to an SQL database and uses the Job to get the correct information for the label.
I want to pass the number of labels to be printed to the integration but have not managed to get the Qty to print the requied number of labels.
I can manually set the Qty variable but not from the CSV file.
-
Peter Thane
★ BarTender Hero ★
If you have linked up the file correctly including setting up a dummy file with the field settings in it then you should be able to see the fields in the Actions tab via the Add Variables option and can then click on the Copies box and link this to the field that contains the value in your trigger file.
The database lookup value would be declared the same as I understand that is in your file too
0 -
Richard Cooper
★ BarTender Hero ★
I was getting the data direct from the SQL and had not created a text file that matches the SQL data, it only contains the Job and the No of labels required.
The label has the SQL query that has the Job as query input.
I will setup a dummy file with the field setting in and try to replicate your answer.
Thanks for your help.
0 -
Peter Thane
★ BarTender Hero ★
No need if the quantity is in the SQL database. Click on this button and link the number of copies input in your to this field.
0 -
Richard Cooper
★ BarTender Hero ★
The label qty is set at run time by the software that produces the text file. Unfortunately it not in the batabase.
I have manged to get it working by modifying the text file to only have the qty in it and the filename to be the job number.
In the integration I have used the %InitialEventData% as the copies and the %DetectedFileNameWithoutExtension% for the Job.
It might not be the correct way but its working.
The original text file had the job and qty. The label used an SQL query as the datasource with the Job as a query prompt.
I was hoping to use the job from the text file for the query prompt and the qty from the text file as the label qty.
Thanks
0 -
Peter Thane
★ BarTender Hero ★
You should have been able to do the original way, like with the quantity, linking the variable for the database lookup to the filter via the Query Prompts tab
0 -
Richard Cooper
★ BarTender Hero ★
I will have another go.
Do I need to set the label up with a Text file as the original datasource or use the SQL datasource ?
Thanks
0 -
Peter Thane
★ BarTender Hero ★
I think you will need to link all the fields in your label to the SQL table as normal but leave the Copies as if it were being set via the Print Dialogue box and not a database field.
0 -
Richard Cooper
★ BarTender Hero ★
I tried it with a test label but couldn't get it to work.
Do you have any examples I could download and see the setup?
A very simple one that the label gets info from Sql DB and the print qty is from a text file.
I must be doing something wrong but cannot get it to work.
Thanks
0 -
Focusonthegoal11
★ BarTender Hero ★
I am encountering the same problem. How does the 'Transform Text to Record Set' and 'For Each Database Record' look like? My error: 'The record set source for 'For Each Database Record' has no records. Child actions will not run.'
Thank you
1 -
Peter Thane
★ BarTender Hero ★
This is normally how I have it set
0
Iniciar sesión para dejar un comentario.
Comentarios
10 comentarios