Mappings of Importing
The following sections describe the mappings of
importing
between the source fields and Open Contacts fields. The mappings are
customizable through modifying the XML templates. The template files are located
in the Templates directory, and you need to have knowledge of XML to modify them.
Please check this links for details:
The mapping template file is "ImportOutlook.xml". If the name
of a contact is empty
and the company name is not empty, the contact will be imported as a
company.
| Outlook field |
Field |
Comments |
| First name |
Given name |
|
| Surname |
Surname |
|
| Other names |
Middle name |
|
| Full name |
Name |
If formatted name is not set, name will be "Givenname Surname" |
| Title |
Title |
|
| Comments |
Notes |
|
| |
|
|
| Contacts |
Contact |
multiple contacts will result in multiple contact
field. |
Personal
|
Nick name:
| NickName | |
Primary Phone:
|
PrimaryTelephoneNumber | |
Mobile:
|
MobileTelephoneNumber | |
Pager:
| PagerNumber | |
Phone:
|
HomeTelephoneNumber | |
Phone2:
|
Home2TelephoneNumber | |
Fax:
|
HomeFaxNumber | |
Email:
|
Email1Address | |
Email2:
|
Email2Address | |
Email3:
|
Email3Address | |
Web:
| WebPage | |
Street:
|
HomeAddressStreet | |
City:
|
HomeAddressCity | |
State:
|
HomeAddressState | |
Postcode:
|
HomeAddressPostalCode | |
Country:
|
HomeAddressCountry | |
PO Box:
|
HomeAddressPostOfficeBox | |
Children:
| Children | |
Spouse:
| Spouse | |
Suffix:
| Suffix | |
Birthday:
| Birthday | |
Hobby:
| Hobby | |
Gender:
| Gender | |
Anniversary:
| Anniversary | |
Car Phone:
|
CarTelephoneNumber | |
Web:
|
PersonalHomePage | |
Contact:
| Links |
Work
|
Job Title:
| JobTitle | |
Profession:
| Profession | |
Primary Phone:
|
CompanyMainTelephoneNumber | |
Phone:
|
BusinessTelephoneNumber | |
Phone:
|
Business2TelephoneNumber | |
Fax:
|
BusinessFaxNumber | |
Location:
|
OfficeLocation | |
Billing:
|
BillingInformation | |
Assistant Phone:
|
AssistantTelephoneNumber | |
Assistant:
|
AssistantName | |
Manager:
| ManagerName | |
Web:
|
BusinessHomePage | |
PO Box:
|
BusinessAddressPostOfficeBox | |
Department:
| Department | |
Company:
| CompanyName | |
Street:
|
BusinessAddressStreet | |
City:
|
BusinessAddressCity | |
State:
|
BusinessAddressState | |
Postcode:
|
BusinessAddressPostalCode | |
Country:
|
BusinessAddressCountry | |
Account:
| Account | |
Mileage:
| Mileage | |
Organizational ID:
|
OrganizationalIDNumber | |
CustomerID:
| CustomerID |
Other
|
Street:
|
OtherAddressStreet | |
City:
|
OtherAddressCity | |
State:
|
OtherAddressState | |
Postcode:
|
OtherAddressPostalCode | |
Country:
|
OtherAddressCountry | |
PO Box:
|
OtherAddressPostOfficeBox | |
Phone:
|
OtherTelephoneNumber | |
Fax:
|
OtherFaxNumber | |
Free Busy:
|
InternetFreeBusyAddress | |
ISDN:
| ISDNNumber | |
Language:
| Language | |
NetMeeting Server:
|
NetMeetingServer | |
NetMeeting Alias:
|
NetMeetingAlias | |
Radio Phone:
|
RadioTelephoneNumber | |
Telex:
| TelexNumber | |
Referred By:
| ReferredBy | |
Government ID:
|
GovernmentIDNumber | |
TTYTDD:
|
TTYTDDTelephoneNumber | |
Custom1:
| User1 | |
Custom2:
| User2 | |
Custom3:
| User3 | |
Custom4:
| User4 |
Note:
Categories of contacts may also be imported.
The template is "ImportOutlookExpress.xml". Personal
| Nick name:
| NickName | | Mobile:
| MobileTelephoneNumber | | Phone:
| HomeTelephoneNumber | | Fax:
| HomeFaxNumber | | Email:
| Email1Address | | Street:
| HomeAddressStreet | | City:
| HomeAddressCity | | State:
| HomeAddressState | | Postcode:
| HomeAddressPostalCode | | Country:
| HomeAddressCountry | | Children:
| Children | | Spouse:
| Spouse | | Profession:
| Profession | | Birthday:
| Birthday | | Gender:
| Gender | | Anniversary:
| Anniversary | | Web:
| PersonalHomePage |
Work
| Job Title:
| JobTitle | | Phone:
| BusinessTelephoneNumber | | Fax:
| BusinessFaxNumber | | Pager:
| PagerNumber | | Location:
| OfficeLocation | | Web:
| BusinessHomePage | | Department:
| Department | | Company:
| CompanyName | | Street:
| BusinessAddressStreet | | City:
| BusinessAddressCity | | State:
| BusinessAddressState | | Postcode:
| BusinessAddressPostalCode | | Country:
| BusinessAddressCountry |
The template is "ImportEudora.xml".
| Eudora field |
Section |
Field |
Comments |
| First name |
|
Given name |
|
| Last name |
|
Surname |
|
| Alias |
|
Name |
Without alias defined, the contact will not be imported |
| Title |
|
Title |
|
| Notes |
|
Notes |
|
Personal
| Phone:
| HomeTelephoneNumber | | Mobile:
| MobileTelephoneNumber | | Fax:
| HomeFaxNumber | | Street:
| HomeAddressStreet | | City:
| HomeAddressCity | | State:
| HomeAddressState | | Postcode:
| HomeAddressPostalCode | | Country:
| HomeAddressCountry | | Web:
| PersonalHomePage | | Email:
| Email1Address |
Work
| Phone:
| BusinessTelephoneNumber | | Mobile:
| BusinessMobileTelephoneNumber | | Fax:
| BusinessFaxNumber | | Company:
| CompanyName | | Street:
| BusinessAddressStreet | | City:
| BusinessAddressCity | | State:
| BusinessAddressState | | Postcode:
| BusinessAddressPostalCode | | Country:
| BusinessAddressCountry | | Web:
| BusinessHomePage |
Other Phone
Other Email
Other Web
Notes:
PhoneList (Other Phone), EmailList (Other Mail) and WebList (Other Web)
in Eudora are memo fields. Multiple items in a list will be imported as
multiple fields. For example, if the PhoneList of a contact contains 3
phones in 3 separated lines, Open Contacts will create 3 phone fields in
section "Other Phone".
Open Contacts conforms vCard v2.1 specification. The template file is "ImportVCard.xml".
| vCard field |
Section |
Field |
Comments |
| First name |
|
Given name |
|
| Surname |
|
Surname |
|
| Other names |
|
Middle name |
|
| Formatted name |
|
Name |
If formatted name is not set, name will be "Givenname Surname" |
| Name prefix |
|
Title |
|
| Comments |
|
Notes |
|
Personal
|
Nick name:
| NickName | |
Suffix:
| Suffix | |
Primary Phone:
|
PrimaryTelephoneNumber | |
Phone:
|
HomeTelephoneNumber | |
Mobile:
|
MobileTelephoneNumber | |
Fax:
|
HomeFaxNumber | |
Email:
| EmailList | |
PO Box:
|
HomeAddressPostOfficeBox | |
Unit:
|
HomeAddressUnit | |
Street:
|
HomeAddressStreet | |
City:
|
HomeAddressCity | |
State:
|
HomeAddressState | |
Postcode:
|
HomeAddressPostalCode | |
Country:
|
HomeAddressCountry | |
Birthday:
| Birthday | |
Anniversary:
| Anniversary | |
Web:
|
PersonalHomePage | |
Geo:
| Geo | |
Telex:
| TelexNumber |
Work
|
Job Title:
| JobTitle | |
Role:
| Role | |
Primary Phone:
|
CompanyMainTelephoneNumber | |
Phone:
|
BusinessTelephoneNumber | |
Fax:
|
BusinessFaxNumber | |
Pager:
| PagerNumber | |
Location:
|
OfficeLocation | |
Department:
| Department | |
Company:
| CompanyName | |
PO Box:
|
BusinessAddressPostOfficeBox | |
Unit:
|
BusinessAddressUnit | |
Street:
|
BusinessAddressStreet | |
City:
|
BusinessAddressCity | |
State:
|
BusinessAddressState | |
Postcode:
|
BusinessAddressPostalCode | |
Country:
|
BusinessAddressCountry | |
Web:
|
BusinessHomePage |
Note:
Mailing labels, embedded objects and X fields are
skipped. vCard may not be able to represent all data of the source program, for
example, MS Outlook can hold up to 3 Email Addresses, however, the vCard
file exported can contain only one Email address.
Import from Mozilla Thunderbird is through LDIF. The template file is "ImportNetscapeMozillaThunderbird.xml".
Please be advised that the schema of this template is different from those used
in data sources described above.
| Mozilla field |
Section |
Field |
Comments |
| First name |
|
Given name |
If First name and Last name are not set, they will be set from
Display name |
| Last name |
|
Surname |
If last name is empty, surname will be the email address |
| Display |
|
Name |
|
| Title |
|
Title |
|
| Notes |
|
Notes |
|
Personal
|
Nick name:
|
mozillaNickname | |
Phone:
| homePhone | |
Mobile:
| mobile | |
Pager:
| pager | |
Fax:
| fax | |
Primary Email:
| mail | |
Email:
|
mozillaSecondEmail | |
Web:
|
mozillaHomeUrl | |
Street:
| homeStreet | |
Street2:
|
mozillaHomeStreet2 | |
City:
|
mozillaHomeLocalityName | |
State:
|
mozillaHomeState | |
Postcode:
|
mozillaHomePostalCode | |
Country:
|
mozillaHomeCountryName |
Company
|
Department:
| department | |
Company:
| company | |
Phone:
|
telephoneNumber | |
Web:
|
mozillaWorkUrl | |
Street:
| street | |
Street2:
|
mozillaWorkStreet2 | |
City:
| l | |
State:
| st | |
Postcode:
| postalCode | |
Country:
| c |
Custom
|
Custom1:
|
mozillaCustom1 | |
Custom2:
|
mozillaCustom2 | |
Custom3:
|
mozillaCustom3 | |
Custom4:
|
mozillaCustom4 |
The template file is ImportVista.xsl. Open Contacts use this XML style sheet
to convert a Vista contact file to Open Contacts' format then import the
converted XML. You need knowledge of XSLT to edit this file.
|