Saltar al contenido principal

Búsqueda

Búsqueda

Lbl Qty in integration file

Comentarios

10 comentarios

  • Avatar
    Peter Thane

    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
  • Avatar
    Richard Cooper

    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
  • Avatar
    Peter Thane

    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
  • Avatar
    Richard Cooper

    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
  • Avatar
    Peter Thane

    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
  • Avatar
    Richard Cooper

    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
  • Avatar
    Peter Thane

    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
  • Avatar
    Richard Cooper

    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
  • Avatar
    Focusonthegoal11

    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
  • Avatar
    Peter Thane

    This is normally how I have it set

    0

Iniciar sesión para dejar un comentario.