Table of Contents
Automatic field assignment when importing addresses (CSV)
Description
If a CSV file contains a heading line, the import can automatically assign the fields if the column headings correspond to known terms. Several terms are sometimes possible for each address field.
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 |