How to import job tickets

 

It is possible in many cases to import data from an external source into H2OS, to avoid re-trying.

 

To perform the import, custom programming must be performed. You can help us perform this task by printing and marking up the worksheet below with information we'll need to match fields in the external source to corresponding fields in new H2OS job ticket fields. Alternatively you can use any other means at your disposal to provide this information.

 

If you use this chart, fill in the Source field name, data type and length in the 2nd column, and any comments pertaining to this field in the 3rd column. Use the "comments" column for information about the source field that applies or may be useful to performing the import. Only fields for which Source field name, data type and length information are supplied will be imported

 

The fields that define the H2OS Job Ticket are listed in the grid below. Minimum required fields are highlighted in RED
 

 

 

Job Tickets conversion worksheet
 

Field Description

Source field name, data type, length

comments

Database Field
(tracklog.dbf)

data type, length, decimals

 

 

 

 

 

 

 

 

 

 

Job date

 

 

Actiondate

Date(8)

reserved

 

 

Actiontext

Character(40)

Job scheduled time of day

 

 

Actiontime

Character(10)

Job scheduled for AM or PM indicator

 

 

Am_pm

Character(2)

Employee assigned this job. If crew, crew leader's name

 

 

Assignee

Character(30)

reserved (for database auditing)

 

 

Auditcde

Numeric(2)

H2OS job type

 

 

Component

Character(80)

reserved

 

 

Contact

Character(80)

reserved

 

 

Country

Character(4)

reserved

 

 

County

Character(3)

The word "H2OS"

 

 

Custid

Character(120)

reserved

 

 

Custkey

Character(8)

Date/time job completed

 

 

Datecomp

DateTime

reserved

 

 

Dateocc

Date

Date/time job ticket created

 

 

Datereq

DateTime

reserved

 

 

Dateres

Date

Detailed description of the work to be performed.

 

 

Desc

Memo

reserved

 

 

Dp

Character(2)

reserved

 

 

Dpck

Character(1)

reserved

 

 

Entdate

Date

reserved (for estimated job cost)

 

 

Estimate

Character(20)

reserved

 

 

Expdate

Date

H2OS assigned unique customer file number (FILENO)

 

 

Fileno

Numeric(10)

LINE1 of customer record

 

 

Line1

Character(35)

LINE2 of customer record

 

 

Line2

Character(35)

LINE3 of customer record

 

 

Line3

Character(35)

LINE4 of customer record

 

 

Line4

Character(35)

LINE5 of customer record

 

 

Line5

Character(35)

reserved

 

 

Ltc

Character(1)

The operator who last changed this record

 

 

Lupby

Character(30)

The date this ticket was last updated

 

 

Lupdate

Date

Oper ID of last person to update this job ticket

 

 

Lupoper

Character(30)

The time this ticket was last updated

 

 

Luptime

Character(10)

reserved

 

 

Mailsw

Logical

reserved

 

 

Mark

Logical

reserved

 

 

Matchcode

Character(10)

Unique H2OS assigned job ticket file number

 

 

Nfileno

Integer

reserved

 

 

Notes

Memo

Indicates if this job can be scheduled ASAP

 

 

Oncall

 

reserved

 

 

One

Numeric(5)

reserved

 

 

Operid

Character(4)

reserved

 

 

Paiddate

Date

Price of all parts sold to customer for this job

 

 

Partsamt

Numeric(8,2)

reserved

 

 

Pieces

Numeric(3)

priority code can be used if necessary to schedule jobs. Default is 2

 

 

Priority

Numeric(10)

reserved

 

 

Probno

Numeric(10)

Customer name (line1)

 

 

Project

Character(80)

reserved

 

 

Reporter

Character(30)

Oper id of person who entered this job ticket

 

 

Requester

Character(30)

reserved (for name of person reviewing/auditing the job tickets database)

 

 

Reviewer

Character(30)

reserved

 

 

Rgc

Character(1)

reserved

 

 

Rte

Numeric(4)

reserved

 

 

Rtepref

Character(1)

State from customer record

 

 

State

Character(2)

Job status (open, done)

 

 

Status

Character(20)

reserved

 

 

Status2

Character(80)

Customer (preferred) telephone number

 

 

Telno

Character(20)

A brief description of the work performed

 

 

Title

Character(80)

Town from customer record

 

 

Town

Character(19)

reserved

 

 

Version

Numeric(4)

ZIP code from customer record

 

 

Zip

Numeric(5)

reserved

 

 

Zip4

Character(4)

 

 

 

 

 

 

 

 

  Minimum required fields are shown in RED

 

 
Last revised: 8-16-08