Rice Lake TransAct 3.5 User Manual
Page 69
Importing and Exporting Data
Admin
70
Version 3.5
Converting Weights in an Export File
All weights stored in the database are based on the unit of measure the scale indicator is set to (e.g.
pounds or kilograms). This weight can be converted using the following keywords...
•
Pounds
•
Tons
•
Kilograms
•
Metric Tons
Place the keyword after the database field within the square brackets. When the unit of measure is yards
or count, the
Net
value is not converted.
Example:
Gross Tons, Weight In Kilograms, Net Weight Metric Tons
Import Data
TransAct
can be used to import the data into the
Transaction Table
, once an import definition file has
been defined.
To run the import utility, select
Admin | Utilities | Import Data
from the main menu. The
Transaction
Selection Criteria
window appears. Use this window to select specific data to import.
Figure 49. Transaction Selection Criteria - Import
To import all data from the import file, leave the date range empty and all fields set to
-3 All
. Click the
Import
button.
To import only certain data from the import file, use the
Selection Criteria
form to determine which
information should be extracted from the import file. Data can be selected by ticket number, date range,
account or category codes. To continue, click the
Import
button.