Table of Contents
Automatic field mapping at Addresses-Import (CSV)
Description
If a CSV file contains a header row, the import can automatically map the fields if the column headers match well-known terms. For each Addressesfield, several terms are sometimes possible.
Below is an overview of the recognized terms.
Field names
Address field | Recognized designations |
---|---|
Title | Salutation, Salutation |
Title | Title, Title |
Customer number | Customer number, Customer number, Customer number, Customer number, Customer no. Debtor No, KdNr, Deb no, Customer number, Debtor number, Debtor no. |
Vendor number | Supplier number, Supplier number, Supplier number, Vendor, Vendor no. Vendor No, Delivery number, Credit no, Accounts Payable No. Vendor number, Vendor number, Vendor no. |
Personnel number | Personnel number, Pers no |
Name | |
FirstName | First name, vname, First Name |
MiddleName | Middle name, 2. first name, Middle Name |
Last name | Surname, name, LastName, Name |
Suffix | Name suffix, suffix |
Feature | Feature |
business | |
BusinessAddressStreet | Road, Road, str, Street, st, Street (postal address) |
BusinessAddressPostOfficeBox | PF, Post office box, post office box, Box, P.O. Box (postal address) |
BusinessAddressPostalCode | POSTCODE, Post Code, post code, ZIP, Post code (postal address) |
BusinessAddressCity | City, Place, City Place (postal address) |
BusinessAddressState | Federal state, State, Region |
BusinessAddressCountry | Country, country Country (postal address) |
Private | |
HomeAddressStreet | Road, Road, str, Street, St |
HomeAddressPostOfficeBox | PF, Post office box, post office box, Box |
HomeAddressPostalCode | POSTCODE, Post Code, post code, ZIP |
HomeAddressCity | City, Place, City |
HomeAddressState | Federal state, State, Region |
HomeAddressCountry | Country, Country |
Other | |
OtherAddressStreet | Road, Road, str, Street, St |
OtherAddressPostOfficeBox | PF, Post office box, post office box, Box |
OtherAddressPostalCode | POSTCODE, Post Code, post code, ZIP |
OtherAddressCity | City, Place, City |
OtherAddressState | Federal state, State, Region |
OtherAddressCountry | Country, Country |
Telephone, fax, etc. | |
BusinessTelephoneNumber | Telephone, telephone, phone, phone, Business phone |
Business2Telephone Number | Telephone, telephone, phone, tel |
BusinessFaxNumber | Fax, Fax, Fax (business) |
MobileTelephoneNumber | Telephone, telephone, phone, phone, Mobile, Mobile, Mobile, cell phone, Smartphone |
CompanyMainTelephoneNumber | Telephone, telephone, phone, tel |
CallbackTelephoneNumber | Telephone, telephone, phone, tel |
CarTelephoneNumber | Telephone, telephone, phone, tel |
HomeTelephoneNumber | Telephone, telephone, phone, tel |
Home2TelephoneNumber | Telephone, telephone, phone, tel |
HomeFaxNumber | Fax, Fax |
OtherTelephoneNumber | Telephone, telephone, phone, tel |
Other2TelephoneNumber | Telephone, telephone, phone, tel |
OtherFaxNumber | Fax, Fax |
AssistantTelephoneNumber | Assistent |
ISDNNumber | ISDN |
PrimaryTelephoneNumber | Telephone, telephone, phone, tel |
RadioTelephoneNumber | Telephone, telephone, phone, tel |
TelexNumber | Telex |
TTYTDDTelephoneNumber | Telex |
Website | |
BusinessHomePage | Internet Web, home page, Website, site, Website |
HomeHomePage | Internet Web, home page, Website, site, Website |
OtherHomePage | Internet Web, home page, Website, site, Website |
Web Page | Internet Web, home page, Website, site, Website |
Email1Address | Mail, |
Email2Address | Mail, |
Email3Address | Mail, |
IMAddress | IN THE, messenger, ICQ, Skype threema, Whatsapp, Facebook, Google+ g +, Twitter, DNA, app. net |