Skip to main content

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 PreferenceImportingFile 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:

FAFormat_addresses.csv

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

Email

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