Technical Support WinWITS Import File Layout
The format of the imported ASCII Text file for the PERSONS table is as follows:

Name
Description
Required Value
LastName
Text [50 char max]
Yes - alpha/numeric
FirstName
Text [50 char max]
Yes - alpha/numeric
Company
Text [50 char max]
Yes - alpha/numeric
Department
Text [50 char max]
Yes - alpha/numeric
SubDepartment
Text [50 char max]
Yes - alpha/numeric
Phone
Text [50 char max]
No - " " (space filled)
Fax
Text [50 char max]
No - " " (space filled)
Email
Text [50 char max]
No - " " (space filled)
Address
Text [50 char max]
No - " " (space filled)
City
Text [30 char max]
No - " " (space filled)
State
Text [ 2 char max]
No - " " (space filled)
Zip
Text [20 char max]
No - " " (space filled)
Site
Text [50 char max]
No - " " (space filled)
Location
Text [50 char max]
Yes - alpha/numeric
Room
Text [50 char max]
No - " " (space filled)
StorageLocation
Text [50 char max]
No - " " (space filled)


Example:
LastName, FirstName, Company, Department, SubDepartment, Phone, Fax, Email, Address, City, State, Zip, Site, Location, StorageLocation

ABDEL-RAHMAN,Leo,Faculty/Staff,PHARMACOLOGY,633,,,,,,,, WEST,6S10 BRODY,, ABDULALI,SALMAN,Faculty/Staff,DEPT OF MATHEMATICS,561,,,,,,,,EAST,129 AUSTIN ,,

Note:
The first record of the ASCII Text file is a header line that defines the column names of the WinWITS database. The header line is comma delimited, however the column names are NOT surrounded by quotes (see example).