Importing Entities and Contacts Together
It is now possible to import data for Contacts and some entities together, meaning you can import the following types of records with a single Import Assistant job:
-
Customers and Contacts
-
Leads and Contacts
-
Prospects and Contacts
Review the following guidelines for importing entities and contacts together:
-
Requirements for Importing Entities and Contacts in a Single Job
-
Setting the Global Subscription Status Field for Entities and Contacts
-
Subsidiary Field Not Required for Entities and Contacts in OneWorld
Requirements for Importing Entities and Contacts in a Single Job
-
You can use one CSV file that contains both entity and contact data, or you can use two separate files, one containing entity data and one containing contact data.
-
If you use one file, contact field values are stored by column, and you are limited to importing five contacts per entity in each import.
-
If you use two files, contact field values are stored by row, and this limitation on imported contacts per entity does not apply.
-
-
If you use two files, you need to complete the File Mapping page of the Import Assistant to define a column in the contact data file that maps to the primary key column in the entity data file, such as Customer ID. (So if the Contacts CSV file does not include this column, you should add it before the import.)
-
You must ensure that the Ignore Read Only Fields advanced option is enabled.
-
Whether you use one or two files, you can map required fields for both entities and Contacts in one step on the Import Assistant's Field Mapping page.
You have the option of mapping the Attached Role field for Contacts. This field describes how the Contact is attached to the entity. Standard role values include Alternate Contact, Primary Contact, Consultant, and Decision Maker.
The Customers and Contacts single job import does not support the import of contact access data, such as password, login, and role. You can import this data in a separate Customers Only import after your Customers and Contacts import has completed successfully. See Importing NetSuite Access Details for Customer Contacts.
When you import entities and contacts together with the Update or the Add or Update options, all fields in the contact records that have a default value in the UI will take the default value. This happens even if you have given a different value to these fields in your CSV file. If you want to update the value of such fields for contacts, you must use the Contacts Only import.
Benefits of Importing Related Records Together
This approach of combining related records has the following advantages:
-
The process is quicker and easier, as you can import both record types during the same import, rather than requiring two distinct imports.
-
You are no longer forced to rely on name matching to link contacts and entities together, which can be prone to inaccuracy.
Importing Address Sublist Data for Contacts
When you import entities and contacts together, the Address sublist for contacts is not available for mapping. However, the address sublist values imported for each entity (customer, lead, or prospect) record are copied to all of the entity's contacts. If a contact already has one or more addresses, the newly imported address data is added; it does not overwrite existing address data.
When you map the fields in the entity’s Address sublist, their values are imported to the Address subrecords on entity records and copied to the Address subrecords on all related contact records.
By default, the entity Address field is read-only, and data from other address sublist fields is copied into it. If you map the Override field and set it to Yes (meaning true), you can import data for the Address field.
Setting the Global Subscription Status Field for Entities and Contacts
The Global Subscription Status field on lead, prospect, customer, and contact records determines whether these entities can receive email sent through campaigns and email merge operations.
-
Four values are possible: Confirmed Opt-In, Soft Opt-In, Soft Opt-Out, and Confirmed Opt-Out, but only the soft values are available to be set by import.
-
If you want to send campaign email, set this field's value to Soft Opt-In, because you cannot send campaign email to users with Soft Opt-Out status; you can only send opt-in email.
Note:Certain jurisdictions, such as the European Union (EU), have regulations regarding whether you can contact entities if you do not have their explicit permission to do so. You should check that your global subscription status adheres to the regulations in the recipient’s jurisdiction.
-
If you do not include this field in an import, its value is defaulted, based on the Unsubscribed to Marketing By Default option at Setup > Marketing > Marketing Preferences. By default, this option is disabled, and the Global Subscription Status field defaults to Soft Opt-In. When this option is enabled, the field defaults to Soft Opt-Out.
-
After an import, you can change the value of the Global Subscription Status between Soft Opt-In and Soft Opt-Out manually in the user interface and through mass updates. Only recipients themselves can change the value to Confirmed Opt-In or Confirmed Opt-Out.
For more information about global subscription statuses, see Subscription Management.
Subsidiary Field Not Required for Entities and Contacts in OneWorld
If your account is using NetSuite OneWorld, the Subsidiary field is a required field for importing entities and contacts together.
The Subsidiary field is not required for importing entities and contacts together only in an account that is not a OneWorld account.
Steps for Importing Entities and Contacts Together
-
Before you start the Import Assistant, review one of the following topics to get some background information about entity imports: Customers Only Import, Leads Only Import, or Prospects Only Import.
-
Ensure that each CSV file includes required columns.
If you are using two files for the import, the file containing Contacts data should include a column with values that map to the entities' primary key field values. You will need to map the two files' key columns on the Import Assistant's File Mapping page.
-
Start the Import Assistant by going to Setup > Import/Export > Import CSV Records.
-
On the Scan & Upload CSV File page:
-
Choose the import's record type:
-
Customers and Contacts Together
-
Leads and Contacts Together
-
Prospects and Contacts Together
-
-
If needed, change the default character encoding. For information, see Choose Import Character Encoding.
-
Choose the number of files to upload:
-
One file to upload
-
Multiple files to upload
-
-
Click the Select buttons and browse to the CSV files for entities and contacts data.
If you also are importing sublist data, you can select files for sublist data as well. For information, see Sublist Data Import.
-
After you have selected one or more files to upload, click Next.
-
-
On the Import Options page:
-
Select a Data Handling option.
-
If needed, expand the Advanced Options and make changes. For information, see Set Advanced CSV Import Options. Note that the Ignore Read-Only Fields advanced option must be enabled.
-
Click Next.
-
-
(If you are uploading multiple files only) On the File Mapping page:
-
Select a key column for the CSV file containing entity data. (The Import Assistant refers to this file as the Primary File.)
-
Select the Contacts column containing values to be mapped to entity key values.
-
Click Next.
-
-
On the Field Mapping page, review the Import Assistant's auto mappings shown in the center pane.
-
Note that Contact fields may be mapped multiple times so that multiple linked contacts can be imported for each entity.
-
Make sure that required fields (fields marked Req. in the center pane) are mapped. You can set default values by clicking the edit icon.
-
Click Next.
-
If necessary, correct any mapping errors.
-
-
On the Save Mapping and Start Import page, provide a mapping name and, optionally, a description, then click Save and Run.
Import Job Processing for Entities and Contacts Imports
The following table illustrates the actions taken during job processing for imports of Customers, Leads, or Prospects together with Contacts. This processing varies based on the following:
-
Data handling option (Add, Update, Add or Update)
-
Reference type (Name, Internal ID, External ID)
-
Whether auto-generated numbering is enabled
Matching Conditions |
Add |
Update |
Add or Update |
---|---|---|---|
|
|
|
|
Name Matching |
— |
— |
— |
No Matching Entity, No Matching Contact |
Add Both |
Fail Both |
Add Both |
No Matching Entity, 1 Matching Contact |
Fail Both |
Fail Both |
Add Entity, Update Contact |
No Matching Entity, 2 Matching Contacts |
Fail Both |
Fail Both |
Fail Both |
|
|
|
|
1 Matching Entity, No Matching Contact |
|
Fail Both |
Update Entity, Add Contact |
1 Matching Entity, 1 Matching Contact |
Fail Both |
Update Both |
Update Both |
1 Matching Entity, 2 Matching Contacts |
Fail Both |
Fail Both |
Fail Both |
|
|
|
|
2 Matching Entities, No Matching Contact |
|
Fail Both |
Fail Both |
2 Matching Entities, 1 Matching Contact |
Fail Both |
Fail Both |
Fail Both |
2 Matching Entities, 2 Matching Contacts |
Fail Both |
Fail Both |
Fail Both |
|
|
|
|
Internal ID or External ID Matching |
— |
— |
— |
No Matching Entity, No Matching Contact |
Add Both |
Fail Both |
Add Both |
No Matching Entity, 1 Matching Contact |
Fail Both |
Fail Both |
Add Entity, Update Contact |
|
|
|
|
1 Matching Entity, No Matching Contact |
|
Fail Both |
Update Entity, Add Contact |
1 Matching Entity, 1 Matching Contact |
Fail Both |
Update Both |
Update Both |
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.