Liquid Controls EZConnect Office - Manual (Page 34)

34
Appendix
daTa fIles overvIeW
The first section of the appendix includes examples of ASCII text files (.csv and .txt) and tables describing each field.
The text file name and the DMS file name are noted in parantheses.
“455”,“AltonJohnnson”,“4568 State Highway 87”,“Suite 100”,“Sapphire”,“NM”,“87755”,“4732224899”[CR/LF]
field # field name description field Type example
1 account
Operator defined account number
(Required)
A12 455
2 name Customer name A35 AltonJohnson
3 address1 Address line 1 A35 4568 State Highway 87
4 address2 Address line 2 A35 Suite 100
5 city Customer city A19 Sapphire
6 state Customer state A2 NM
7 zip Customer zip code A10 87755
8 phone# Customer phone number A14 4732224899
Customer.csv - Customer file ( Customer.slf )
field # field name description field Type example
1 buttonID Operator defined button ID (Required) A16 7900000F69CF6901
2 customer Operator defined customer name (Required) A12 9123
3 vehicle Operator defined vehicle name A12 3333
“7900000F69CF6901”,“9123”,“3333”[CR/LF]
button.csv - button file (button.502 )
Numeric fields must contain a value. If the field
does not have a value, use a “0”.
If an alphanumeric fields does not have a value,
put nothing between the quotes — “”.
fIeld Types
The number in the Field Type column represents the maximum number of characters allowed in the field.
A - Alphanumeric
Integer- Numeric value, no decimal point
Floating - Numeric value, decimal point