Worth Data 5000 Chapter 5: ,

Chapter 5:

If you are ready to upload data, we assume you have established correct communication between your TriCoder and host and have

collected some sample data, preferably using the Default Program #0 or Sample Program #1 Tutorials. By default, the TriCoder

uploads using a Car riage Return Separated format. For many users, the default f ile format works fine, but others may req uire more

complex or even custom upload file formats. By default, the TriCoder transmits it‟s data in the following order:

ID + Prefix + data + Checksum chs + Suffix + Terminator

You should keep the above order in mind when determining how to upload your data. Before we actually upload any data, lets discuss

some of the most common file formats.

If you are planning to upload your data into an Excel worksheet, you should consider using our KwikCount/EX™ program.

KwikCount/EX is a n Excel add-in that makes updating worksheets faster and easier. If you are trying to update several columns of

data, need accumulation or subtraction functions, or are using t he TriCoder for physical inventory, you should defi nitely look into

using KwikCount/EX.

KwikCount/EX is free with any TriCoder purchase and is available on the Utilities CD-ROM that came with your TriCoder. You can

also find more information on KwikCount/EX at http://www.barcodehq.com/kwikcountex.html.

The pr ogram you are using to process your data will determine what format the uploaded file needs to use. There are several

commonly used formats – Carriage Return separated, Comma separated; and Flat File formats. By default, the TriCoder upload s

using the CR (Carriage Return) sepa rated format. We will cover each format in order of ease of use, with the default uploadin g

format first.

By default, the TriCoder uploads its data in the following format:

DATA(CR) 11111111

DATA(CR) data looks like: 22222222

DATA(CR) 33333333

This format i s called Car riage Return separated. Each piece of d ata is followed by a Carriage Return (or Carriage Return/ Line

Feed if Serial Interface), causing each piece of data to appear on a separate line. The TriCoder does this by using the Terminato r

Character. The Terminator Character is the character that follo ws each piece of data either when the TriCoder is uploaded or when

data is transmitted in NON PORTABLE mode. The default Terminato r Character for a keyboard wedge i s CR (carriage return) and

CR/LF (carriage return/line feed) for a serial interface.

To upload the TriCoder with a Carriage Return delimited file, simply leave the Terminator Character set to the default settings and

upload the TriCoder.