Skip to main content

Search

Search

Gs1-128 Udi - Bartender Adds An Extra Check Digit And Discards The Leading '0'

Comments

6 comments

  • Avatar
    Legacy Poster

    In your database setup, can you change the datatype on the field to be text instead of number?

    0
  • Avatar
    Legacy Poster

    In your database setup, can you change the datatype on the field to be text instead of number?

    Hi Slickson,
     
    Thank you for your reply.
     
    I am quite new to using Bartender, so could you please direct me step by step as to how I can change it?
     
    As of now I could not find the option to change it to text on database setup (Bartender version 10.0 SR4).
     
    Thanks

    0
  • Avatar
    Legacy Poster

    I just checked and you may need to reload/refresh your database after playing with the column format in Excel.  The Excel Data source does not allow you to specify the data type, I was thinking of the Text file data source.

    0
  • Avatar
    Legacy Poster

    I just checked and you may need to reload/refresh your database after playing with the column format in Excel.  The Excel Data source does not allow you to specify the data type, I was thinking of the Text file data source.

    Yup done that as well and still the same result.

    0
  • Avatar
    Legacy Poster

    hi, any one have the solution to this issue bring out by pratik789 above?

     

     

     

     

     

     
    0
  • Avatar
    Legacy Poster

    Trying adding an extra row at the top of your database with a value of "dummy record" or similar across all the fields..  

     

    Sometimes the ODBC driver ignores the settings and looks at the data in the first few records and so where you have just numbers in a column it processes the column as if it were always a number and not as a "Text" field even if you have set it as such.  Adding letters into the first record sorts this out.

     

    You can get the same result where your data starts off as numbers in a column and changes to text in later records in the table and so these later fields appear as blanks on the label or else can trigger errors in the case of numeric only barcodes.

    0

Please sign in to leave a comment.