If you need help understanding these instructions, contact Technical Support, who will be happy to talk you through the steps. Currently we are also able to call you back at our own expense.
Most clients cannot create Auto Text compatible files, but they can easily create ASCII comma separated text files (e.g. *.TXT or *.CSV files) using their existing applications; database, spreadsheet or wordprocessor.
Using the Database Utility you can easily convert ASCII comma separated text files to Auto Text compatible files (i.e. newline separated items).
|Note: The Database Utility does not alter the original text file, instead it creates a new version of the file in Auto Text compatible format.|
If a client provides a file in a formats other than ASCII comma separated text, you must convert it to ASCII comma separated text. You should try the following;
- request that the client save it in ASCII comma separated text.
If you have the same software that the client used to create the file, you can do the following;
- open it and save it as ASCII comma separated text.
|TIP: Opening and saving a file may change the sort order of the labels, so ask the client if the order in which the labels are printed is important.|
Now use the Database Utility to create an Auto Text compatible version of the file.
Most software applications (database, spreadsheet, wordprocessor) can easily save a client's file as ASCII comma separated text.
The Database Utility can produce Auto Text compatible files from more common text files produced by most popular applications, like; database, spreadsheet and wordprocessor (e.g. Microsoft Access, Excel, Word, etc.).
Below is an example of the type of file that spreadsheet, database and wordprocessor applications will produce;
1A0219, RED, 16.00
1B0738, BLUE, 17.99
1B1932, GREEN, 11.50
The text file contains several text items (field) per line, separated by commas. The text items may also contain double quote characters; especially if the text item contains a space.
"JIM BROWN", 83160
"PETER JACKSON", 121016
"DAVID SMITH", 177015
Unfortunately the Advantage software requires;
- all text items to be on separate lines
- double quote characters must be removed
- the first line must contain a number, to show how many text items are need per label
In the above examples the Auto Text file would look like these;
Copyright © 2000 CIA (BAR CODES) UK. All rights reserved. Reproduction prohibited.