| XC2™ Data Import Options
- Import Customer information only
Mailing and Service Address and Info
See available field list
- Import Device information
Type, Size, Model, Mfg, Serial Number
Service Address, Location, Hazard Type
Next Test Date, Last Test Date, Last Tester, etc.
(Will create Tester Table from this info)
- Import Test History
A. Import from your "Test History" Table
1. Import Pass/Fail Only
2. Import RP/DC/PVB Values
B. Extract from other table (Device Info) with mutliple fields
for each test date
- a) Import Letter History
A. Import from your "Letter History" Table
B. Extract from other table (Device Info) with mutliple fields
for each letter date
b) Import Letter Table
A. Import from your "Letters" Table
B. Extract from Device Info or Letter History
- Import Tester Information
A. Import from Separate Table
B. Extract from Test History or Device Info (See Above)
- Import Test Company Information
A. Import from Separate Table
B. Extract from Tester Info or Test History
- Import Test Kit/Gauge Information
- a) Import Hazard Types
b) Service Types
- Data masssage
Missing Data
Assy Types, etc.
Misplaced data due to Commas, etc.
Parse City, ST Zip field info separate Fields
Parse Address into Number/Direction/Street/Type
|
Import Criteria:
- Standard
- Tokay 4.2
- Tokay 3.7
- Ambitec CheckMate/Plus
Preferred (In order of Preference)
- DBF File
- Tab Delimited ASCII
- Comma Delimited ASCII
Must Include Field List for ASCII Delimited
(Extra Charge if not included)
- Meaning of Data if not obvious
- Type of Data, e.g.
- Date, Alpha, Text with CRs, Real Number, Integer, Boolean
- Include Alpha String length
Non-Preferred (but acceptable if clearly defined):
- Fixed Field Length (Extra Charge!)
- See above RE: Field List
- Not Acceptable unless previously reviewed by EngSoft engineer.
- Any other data format
|
XC2 Data Import PDF File