Importing Two Addresses for the Same Account

Importing Two Addresses for the Same Account

Contents

Two Addresses on the Same Row
Two Addresses on Different Rows

NeonCRM's Import Manager allows you to import up to two addresses for new accounts. Depending on the format of your data, this can be done in one of two ways.

Two Addresses on the Same Row

This option is only available if you are doing an account batch update using IDs from NeonCRM OR you are importing data without account IDs. With this option, you can have a single row that contains the data for both of the addresses that you wish to import, as seen below:

2015-09-29_10-20-39.png

In this example, we are importing data with NeonCRM account IDs.

To begin your import, go to Account > Import Manager and select New Import.

2015-09-29_10-22-00.png

In Step 1, provide a Title for your import. For Does your spreadsheet contain an Account ID column?, select Yes. For Are these account ID numbers from NeonCRM?, select Yes. Click Save and Continue.

2015-09-29_10-23-06.png

On Step 2, make sure the Account checkbox is checked, then click Save and Continue.

2015-09-29_10-24-09.png

On Step 3.1, upload your .CSV file. For Does your spreadsheet have a header row?, select Yes. For How is your address data formatted?, select Each row contains one account and multiple addresses. Then click Upload data.

2015-09-29_10-25-32.png

On the Import Column Mapping page, select New Mapping to continue. On the next page, map the columns in your spreadsheet to the appropriate fields in NeonCRM. The fields for the second address begin with "Secondary." Click Continue.

2015-09-29_10-28-32.png

On the Field Value Mapping page, confirm that NeonCRM has appropriately matched data options, then click Next.

2015-09-29_10-58-22.png

On the next page, determine if you would like to save your mapping, then click Import your data.

2015-09-29_10-59-29.png

You will be notified that your accounts have been updated. Click Go to the Imports list for more information about the updated accounts.

2015-09-29_11-00-15.png

In the Addresses section of the updated account(s), you will now see both addresses.

2015-09-29_11-01-37.png

Two Addresses on Different Rows

This option is only available if you are importing data with IDs from another system. More information on importing accounts with IDs from another system is available here. With this option, you can have a single row that contains the data for the account along with the first address, and succeeding rows with the additional addresses that you wish to import, as seen below:

2015-09-29_11-12-50.png

In this screenshot, ID is the ID number from another system.

To begin your import, go to Account > Import Manager and select New Import.

2015-09-29_10-22-00.png

In Step 1, provide a Title for your import. For Does your spreadsheet contain an Account ID column?, select Yes. For Are these account ID number from NeonCRM?, select No, they are from another system. For What type of data are you importing?, select I am importing new accounts. Click Save and Continue.

2015-09-29_11-14-03.png

On Step 2, provide the name of the system that your IDs are from, then click Save and Continue.

2015-09-29_11-15-39.png

On Step 3.1, upload your .CSV file. Select the appropriate options for your data for the header row, account type, and duplicate questions. For How is your address data formatted?, select Each account has multiple addresses. Each row contains a different address. Then click Upload data.

2015-09-29_11-17-05.png

On the Import Column Mapping page, select New Mapping to continue. On the next page, select the column that contains the ID(s) from another system. Click Next.

2015-09-29_11-17-59.png

On the next page, map the columns in your spreadsheet to the appropriate fields in NeonCRM. Click Continue.

2015-09-29_11-19-12.png

On the Field Value Mapping page, confirm that NeonCRM has appropriately matched data options, then click Next.

2015-09-29_11-19-39.png

On the next page, determine if you would like to save your mapping, then click Import your data.

2015-09-29_10-59-29.png

You will be notified that your accounts have been imported. Click Go to the Imports list for more information about the imported accounts.

2015-09-29_11-20-30.png

In the Addresses section of the updated account(s), you will now see both addresses.

2015-09-29_11-21-16.png

Related Guides

Back to top ^

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk