File format for importing addresses
Addresses are imported into the FA system in semicolon-separated CSV files using the file columns described below. You can set the following properties of the CSV file in Preference → Importing → File format (see Preference - Importing for details):
File delimiter. By default, FA is configured to accept semicolon-separated values. You can change it to another character.
Encoding (UTF-8 or Windows-1252). To import Scandinavian letters, the files should be Windows-1252 encoded to guarantee the correct handling of Scandinavian letters.
Download the CSV file template:
Update address values
You can update existing addresses by importing a new file with corrected data. The system identifies the contact to update by the address ID, so you need to fill in this field. Note that you must specify if you want to keep the old values in each field:
To replace the field value, specify the new value in the import file.
To keep the existing value saved for a field, you can either use three stars (***) in the field or leave the field out completely and remove the field name from the first row of the CSV import file.
Remove address values
To remove an existing value saved in a field, import an empty value into it. Note that if you want to keep any existing values, you need to use three stars (***) in the field or leave the field out completely as instructed in the previous section.
FA Format for importing addresses
# | Code | Required | Name | Description |
---|---|---|---|---|
1 | a.id | No | Address ID | Address ID when updating an existing address (found by exporting the address from the FA system). |
2 | a.contactId | Yes | Contact ID | Unique ID for the contact (for example, social security number or other unique identifier). |
3 | a.name | Yes | Name | Address name. |
4 | a.address1 | No | Address 1 | |
5 | a.address2 | No | Address 2 | |
6 | a.postalCode | No | Postal code | |
7 | a.city | No | City | |
8 | a.country | No | Country | |
9 | a.email | No | ||
10 | a.phone1 | No | Phone 1 | |
11 | a.phone2 | No | Phone 2 | |
12 | a.fax | No | Fax | |
13 | a.electronicCommunication | No | Electronic communication | Define as a number: 1 = Electronic communication allowed 0 = Not allowed |
14 | a.marketingCommunication | No | Marketing communication | Define as a number: 1 = Marketing communication allowed 0 = Not allowed |
15 | a.delete | No | Delete | Define as a number: 1 = Delete address 0 = Keep address |