6 importing & exporting data, 6 importing and exporting data, Admin – Rice Lake TransAct 2.0 User Manual
Page 42
41
Admin
TransactionTable
Ticket Number
,Number , , ,
,COMMA,
Account
,Number , , ,
,COMMA,
Truck Number
,Character , , ,
,COMMA,
Waste Code
,Character , , ,
,COMMA,
Date Out
,Character , , ,
,COMMA,
Time Out
,Character , , ,
,COMMA,
Weight In
,Number , , ,
,COMMA,
Weight Out
,Number , , ,
,COMMA,
Net Weight
,Number , , ,
,COMMA,
Charge
,Number , , 2,
,COMMA,
Each line contains the following information. You must define a place for
each of the seven delimiters, even if you don’t use the delimiter.
7.6
Importing and Exporting Data
TransAct provides utilities for importing and exporting transaction
information. Currently, only the database Transaction Table can be used for
importing and exporting.
Before importing or exporting, you need to create definition files. A
definition file tells TransAct what information you want to import or export,
and how TransAct should import or that information.
Create definition files using any text editor, such as Windows Notepad or
Dos Editor. Save the files with a .gid extension in the TransAct installation
directory. The first line of the definition file identifies the database table to
use. Each line of the definition file is formatted into seven comma-delimited
columns.
The following is an example of an export definition file named transexp.gid
e
m
a
N
d
l
e
i
F
.
)
r
e
t
a
l
d
e
t
s
il
(
s
e
m
a
n
d
l
e
if
e
s
a
b
a
t
a
d
n
o
i
t
c
a
s
n
a
r
T
d
il
a
V
e
p
y
T
d
l
e
i
F
a
r
e
h
t
i
e
s
i
d
l
e
if
e
s
a
b
a
t
a
d
A
r
e
t
c
a
r
a
h
C
r
o
r
e
b
m
u
N
.
h
t
g
n
e
L
d
l
e
i
F
s
r
e
t
c
a
r
a
h
c
f
o
r
e
b
m
u
N
.
e
li
f
a
t
a
d
t
r
o
p
x
e
o
t
n
e
t
t
i
r
w
e
b
ll
i
w
t
a
h
t
d
l
e
if
f
o
h
t
g
n
e
L
.
d
e
n
if
e
d
s
i
r
e
t
i
m
il
e
d
d
l
e
if
a
fi
d
e
r
o
n
g
I
.
e
li
f
t
r
o
p
m
i
n
a
m
o
r
f
d
e
t
c
a
r
t
x
e
s
l
a
m
i
c
e
D
.
t
n
i
o
p
l
a
m
i
c
e
d
d
e
il
p
m
i
n
a
e
v
a
h
t
a
h
t
s
d
l
e
if
a
t
a
d
c
i
r
e
m
u
n
g
n
i
t
r
o
p
m
i
r
o
f
d
e
s
U
e
h
t
n
e
h
t
,
5
2
0
5
1
s
i
d
l
e
if
d
e
t
r
o
p
m
i
e
h
t
d
n
a
2
s
i
s
l
a
m
i
c
e
d
fi
,
e
l
p
m
a
x
e
r
o
F
.
5
2
.
0
5
1
o
t
d
e
t
r
e
v
n
o
c
s
i
a
t
a
d
e
u
l
a
V
d
e
x
i
F
d
e
x
if
a
n
g
i
s
s
a
o
t
r
o
d
l
e
if
e
li
f
a
t
a
d
t
r
o
p
x
e
n
a
n
i
e
u
l
a
v
d
e
x
if
a
e
c
a
l
p
o
t
d
e
s
U
.
g
n
i
t
r
o
p
m
i
n
e
h
w
d
l
e
if
e
s
a
b
a
t
a
d
a
o
t
e
u
l
a
v