Assinging Data database fields

VS Engineering

• 25 de octubre de 2024 09:47

Hi,

I have in my label template database fields set up with a sample list. There are 4 columns (column name = field name).
In the production another service will send the label file and a generated data file to the printer server. The data file contains the same 4 columns, but unfortunately in a different order. This will lead to switched values in my 4 fields on the label.

How can i force to assign the data values of the column 1 to the field 1 even if it is not at first position anymore? The sample list and the production list contain a header line with exact the same names, just in a different order.

 

Thanks for a response.

0

• 

  Krista Sealey

  Moderador

  ★ BarTender Hero ★

  • 28 de octubre de 2024 15:16

  Hello,

  Welcome to the BarTender Community Forums!

  If both files have headers then BarTender should automatically assign the data to the correct field since they are both labeled with the same names. Have you tested this setup? Do you receive any errors?

  Thanks,

  0
• 

  VS Engineering

  ★ BarTender Hero ★

  • 29 de octubre de 2024 09:48

  Hi Krista,
  
  I used a sample file with this data to create the .btw file:
  Serial Number    ProdWeek    ProdYear    Rev   
  00001    36    24    A    

  Then i checked how the data arrive on the server where the printer service runs. It looks like this:
  Serial Number    ProdYear    Rev    ProdWeek    
  12345    24    A    37    

  Unfortunately the order is different and not allways the same.
  I do not get an error from the printer service or the printer itself. Just the data on the label is wrong. With this data above it prints on the label:
  Field "Serial Number" = 12345, Field "ProdWeek" = 24, Field "ProdYear" = A, Field "Rev" = 37
  
  I think it i did something wrong when setting up the database fields.
  My process was Database setup -> from database file -> selected the sample file -> Data format: Tabstopp separated -> First line is a header line
  May you know where to set that it assigns the fields correct?
  
  BR Cornel
  
  

  0
• 

  pthane

  ★ BarTender Hero ★

  • 30 de octubre de 2024 10:04

  My process was Database setup -> from database file -> selected the sample file -> Data format: Tabstopp separated -> First line is a header line

  Try adjusting this to use

  Database setup -> from database file -> DATABASE file -> Data format: Tabstop separated -> First line is a header line

  These are my results using your data above with an extra "File" value added to the end of each to say whether the original or new data 

   

   

  

  

  0

Iniciar sesión para dejar un comentario.