What is the Database Utility?

The Database Utility is a Windows program used to convert ASCII comma separated text files (typically produced by users of most; databases, spreadsheets and wordprocessors) in to a text file that can be used with the Auto Text feature of the Advantage software (i.e. an Auto Text file).

For full details of how to use the Database Utility, see this section: Using the Database Utility.

If you want to know more about Auto Text files, see this section: Auto Text feature overview.

What are the features of the Database Utility?

The Database Utility creates Auto Text compatible files. It does this by doing the following;

- creates a first line indicating the number of text items in the Auto Text file.

- optionally skips field names, so they do not appear in the Auto Text file.

- places all text items on separate lines in the Auto Text file.

- removes unwanted double quote characters from the Auto Text file.

- optionally converts text lines to bar codes, after adding them to the Auto Text file.

What do the text files look like?

BEFORE

Here is an example of a file that a client may supply. This file is usually created by exporting data from one of their database, spreadsheet or wordprocessor files;

1A0219, "JAMES SMITH"
1B0738, "TIM BROWN"
1B1932, "PETER JACKSON"

We now use the Database Utility (See: Using the Database Utility) which will read the provided text file and create a new Auto Text compatible file.

AFTER

Here is the resulting Auto Text compatible file, created by the Database Utility;

3
1A0219
>f6g0t2`CgB^5w#
JAMES SMITH
1B0738
>f6g8[2`5p9oPd#
TIM BROWN
1B1932
>f6g8[2`B^FYCZ#
PETER JACKSON

In this example, we have used the Database Utility to add a Code 128 bar code item to each label.

The resulting Auto Text compatible file now contains three items per label; two text items from the origianal text file, plus one bar code item produced by the Database Utility.

The three items can be printed using &1, &2, &3 in your design.

Note: The bar code item is always the last numbered item (&3 in this case), because the bar code item is always added after the other items in the original text file. In this example there were items in the original file, so 

In the case of the bar code item, you would print this item using &3. For item &3 you would also select a bar code fonts with a name that begins 'CIA Code 128 ...' to print the Code 128 bar codes.

Note: You do not always need to include all of the items in your label design, especially if the original file contained unwanted fields (which the client did not know how to remove). You can leave any item out of your design, without upsetting the way the labels print.

 

 

 


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