|
HowTo..Format Data for Global Contacts Database
This is the file format for the SuperDesk Global Contacts database.
This file is a CSV file - ie All ASCII characters, fields separated by
commas, and text strings that include a comma enclosed by quotes (eg
FileName= "Smith,Fred" ) end each line with a LineFeed (CR/LF is OK).
Do not use a title line.
If you have any questions, contact us.
Field |
Description |
ID |
UINT (unsigned integer) unique record index. |
DisplayName |
String: Actually "FirstName" + " " + "LastName". |
FileName |
String: Actually "LastName" + ", " + "FirstName". |
Title |
String: Acceptable values are: "Dr.", "Miss.", "Mr.", "Mrs.",
"Ms.", "Prof." or "" (nothing) |
FirstName |
String: |
MiddleName |
String: |
LastName |
String: |
Sufix |
String: Acceptable values are: "I", "II", "III", "Jr.", "Sr." or
"" (nothing) |
Position |
String: |
Company |
String: |
BussStreet |
String: |
BussCity |
String: |
BussState |
String: |
BussZip |
String: |
BussCountry |
String: |
HomeStreet |
String: |
HomeCity |
String: |
HomeState |
String: |
HomeZip |
String: |
HomeCountry |
String: |
OtherStreet |
String: |
OtherCity |
String: |
OtherState |
String: |
OtherZip |
String: |
OtherCountry |
String: |
PostalAddress |
String: Acceptable values are: "NONE", "BUSS", "HOME", "OTHER"
or "" (nothing) |
BussPhone1 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
BussPhone2 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
HomePhone1 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
HomePhone2 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
CellPhone1 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
CellPhone2 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
BussFax1 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
BussFax2 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
HomeFax1 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
HomeFax2 |
String: NOTE Should be numeric only. NB Numerics followed by
Alphas are not acceptable |
BussEmail1 |
String: |
BussEmail2 |
String: |
HomeEmail1 |
String: |
HomeEmail2 |
String: |
Website1 |
String: |
Website2 |
String: |
|
| |
|