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.

Converting to Auto Text files

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.

Non-ASCII files

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.

ASCII comma separated files

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

Auto Text files (newline separated)

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;

3
1A0219
RED
16.00
1B0738
BLUE
17.99
1B1932
GREEN
11.50

and

2
JIM BROWN
83160
PETER JACKSON
121016
DAVID SMITH
177015

 

 


Copyright 2000 CIA (BAR CODES) UK. All rights reserved. Reproduction prohibited.