beautypg.com

Appendix, Data files, Vehicle.csv - vehicle file – Liquid Controls EZConnect Office User Manual

Page 37: Truck.csv - truck file

background image

37

Appendix

daTa fIles

field #

field name

description

field Type

example

1

account

Customer account number (Required)

A12

455

2

number

Customer vehicle number (Required)

A12

45

3

longitude

Longitude of vehicle location (Required)

Floating(±180.--)

87.88

4

latitude

Latitude of vehicle location (Required)

Floating(±90.--)

42.27

5

altitude

Altitude of vehicle location (Required)

Floating(±99999.9)

788

6

tanksize

Size of vehicle tank (Required)

Floating

20.00

7

onroad

On-road vehicle; 0=No, 1=Yes

Integer (0-1)

1

8

department

Department billed for the vehicle

A16

Accounting

9

name

Vehicle name

A12

Skid Loader

10

product

Product code used by vehicle (Required)

A8

D1

“455”,“45”,“87.88”,“42.27”, “788”,“20.00”,“1”,“Accounting”,“Skid Loader”,”D1” [CR/LF]

vehicle.csv - vehicle file

(vehicle.502

)

field #

field name

description

field Type

example

1

LCRunitID

Unit ID of LCR at node address 1 (Required)

A10

1

2

name

Name of the truck

A16

Tanker2

3

number

Operator defined truck number (Required)

Integer

(0-4294967295)

3

4

network

Select 1-meter, 2-meter, 3-meter network (Required)

Integer (0-65535)

2

“1”,“Tanker2”,“3”,“2” [CR/LF]

Truck.csv - Truck file (

Truck.slf

)