Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Software
  • Labeler
  • Version 7
  • Labeler: Error: Missing values in Labeler when using external data source
Subscribe Download PDF

Labeler: Error: Missing values in Labeler when using external data source

Internal User
2017-04-10
in Version 7

Labeler: Error: Missing values in Labeler when using external data source

Symptoms:
- Labeler drops leading 0s from numbers.
- Alphanumeric values not printing.
- Alphanumeric values not showing up in the Data view.

Solution:

In the folder where your data file resides, Labeler creates a file named SCHEMA.INI that tells it how to deal with the data from the external file. Open that file with Notepad, and it will probably read something like the following. FileName.CSV is the name of the file Labeler is connected to.

[FileName.CSV]
Format=CSVDelimited
ColNameHeader=true

1. Add two lines to what you find, the ones with MaxScanRows and CharacterSet. Do not change the other lines. Save the file.

[FileName.CSV]
Format=CSVDelimited
ColNameHeader=false
MaxScanRows=1
CharacterSet=OEM

2. In the external data file, insert 1 row at the beginning with some text in it. It could be the name of the column, or even something as simple as a single letter.

3. Close and reopen the label file. Labeler should read that column as text and no longer strip the 0s from the beginning of the numbers, or drop data.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

16 of 23 people found this page helpful

Related Pages

  • Labeler: How To: I have a column in a text file with cells that contain both alpha and numeric values in it, but Labeler only sees the cells in that column that are all numeric.

Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro