Creatio base
This documentation is valid for Creatio version 7.12.0. We recommend using the newest version of Creatio documentation.

How to import contact addresses

Contact records can contain information about several addresses of different types: business, home, delivery, etc. Only one of these addresses can be set as the primary address and copied to the address column of the [Contact] object.

First, prepare the import file. Each row in the Excel file must contain a contact’s full name that must be identical to the full name value of the contact record, one address and its type. Select the contact’s primary address in the [Primary] column and set the “True” value. For the rest of addresses, set the “False” value. Specify country, city and postal code in the separate columns of the imported file (Fig. 1).

Fig. 1 An example of Excel file ready for address import

chapter_universal_import_prepare_file.png 

To import prepared data on the addresses detail:

1.Enter the record of a random contact in the [Contacts] section.

2.Click the btn_detail_menu.png button of the [Addresses] detail and select the [Data import] action.

3.Click the [Select file] button and specify the prepared import file or drag the file directly to the Import Wizard page.

4.On the next page, the “Address”, “City”, “Country”, “ZIP/postal code”, “Primary” and “Address type” columns are determined automatically, and the “Full name” column must be mapped to the [Contact] column. Click the [Next] button.

Note

To map the columns in the imported Excel file and bpm’online automatically, make sure that the column titles in the Excel file must match corresponding column names in bpm’online.

5.Select the [Contact], [Address type] and [Address] columns on the “Duplicate management” page of the Import Wizard. Click the [Start data import] button.

The import process runs on the background. After the import is complete, you will receive a message in the notification center. Check import results.

See also

How to prepare a file

How to import a customer database

Video tutorials

Universal import from Excel to bpm’online

Did you find this information useful?

How can we improve it?