4-1
Chapter 4
Uploading Data
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 Program #0 or Program #1 Tutorials. By
default, the TriCoder uploads using a
Carriage Return Separated
format. For
many users, the default file format works fine, but others may require more
complex or even custom upload file formats. For different file formats, see the
last section in this chapter,
File Formats
.
Uploading into Excel
If you are planning to upload your data into an Excel worksheet, you may
want to consider using our KwikCount/EX program. KwikCount/EX is an
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 the TriCoder for physical inventory, you should
definitely look into using KwikCount/EX. You can find more information
on KwikCount/EX at
http://www.barcodehq.com/kwikcountex.html
.
Data Upload
DATA UPLOAD
mode is used to extract the data collected while in
DATA COLLECTION
mode.
DATA UPLOAD
mode uses keyboard
upload (wedge and USB keyboard), or uploading through the
TriCoder
Utilities
(high speed USB and serial).
Before collecting and uploading large amounts of data,
1. test the TriCoder data communication in Non-Portable Mode detailed
in
Chapter 3,
Non-Portable Mode,
and
2. try a small amount of data to make sure your upload works correctly.
Data can be uploaded either into a separate file that is then merged or
processed by your application or it can be uploaded into your application
directly. Before you upload directly into an application, back up any files
that will be altered by the upload – work only with copies, not with your
actual data, until you know your upload works correctly.
For this tutorial, first we will describe a keyboard/USB interface upload
using Windows or the Mac, then a high speed USB or serial upload using
the TriCoder Utilities
If you wish to do a Windows high speed USB or
serial upload to a file, turn to page 4-3.
