What are the restrictions for each of the fields in the CSV contact import?

The CSV import tool allows you to map input fields into ActiveDEMAND standard/custom fields. The list below covers the standard AD fields. 

First Name, Last Name, Title, Company, Address, City, Province, Postal Code, Country, Office Phone, Fax, Mobile Phone, Email, Opt-In, Contact Source, Contact Source Description, Industry, Tags

“Bob”, “Smith”, “VP Finance”, Acme Inc”, “123 Some st.”, “San Francisco” , “CA”, ”United States”, “01 (123) 456-7890”, “01 (123) 456-7890”, “01 (123) 456-7890”,“bob.smith@acme.com”, “1”,“Account Introduction”, “”My first upload of contacts”, “Mining”, “Existing Customer, Happy”

First Name"Bob"
Last Name
Title"VP Finance"
Company"Acme Inc."
Address"123 Some St."
City"San Francisco"
Province/State"CA"ISO_3166-Subdivision Name
Postal/Zip Code"123456"
Country"United States"Country Name
Office Phone"01 (123) 456-7890"
Fax"01 (123) 456-7890"

Mobile"01 (123) 456-7890"

Opt In"'true', 't', 'y', 'yes', '1', 'all'" ['true', 't', 'y', 'yes', '1', 'all']:Opted In, anything else, not opted in
Contact Source“Account Introduction”
Must Match Source Types
Contact Source Description“my first upload of contacts”This is a text string that is used to describe the context of the contact being imported in the system. This is an optional field and is only set during imports.
Industry“Mining”Industry Title
Tags“Existing Customer, Happy”Any set of tags. Tags are used to label customers for further segregation
Unsubscribed['true', 't', 'y', 'yes', '1']if set to anything in the list ['true', 't', 'y', 'yes', '1'], the contact will be flagged as unsubscribed and will never receive emails from the ActiveDEMAND account. 
Contact Manager Emailharry@home.comThe contact manager for the contact. Assumed to exist and be an employee of the ActiveDEMAND account.
Twitter Handle
Special Date NamebirthdayA special date can be any named date for the contact (see https://support.activedemand.com/solution/articles/5000622034-nurture-campaign-basics-2-nurturing-with-special-dates-video-)
Special Date
31/12/2000A special date can be any named date for the contact (see https://support.activedemand.com/solution/articles/5000622034-nurture-campaign-basics-2-nurturing-with-special-dates-video-)

Contact Source Types 

"Call-to-Action Web Form"

"Contact Web Form"

"eNewsletter Sign-up"

"Event Registration"

"Event Attendance"

"3rd Party List"

"3rd Party Website"

"Offline Marketing Initiative"

"Online Directory"


"Webinar Registration"

"Account Introduction"

"JumpON Live-Chat"

"Organic Search"

"Search Engine Marketing"

"Phone Call"

"Email Campaign"

"Twitter Follow"


Was this article helpful?
0 out of 0 found this helpful



Please sign in to leave a comment.