What are the Restrictions for each of the Fields in the CSV Contact Import?

Modified on Fri, Dec 15, 2023 at 1:31 PM

What are the Restrictions for each of the Fields in the CSV Contact Import?

The CSV import tool enables the User to map input fields into Enquire MAP standard and custom fields, and the list below covers the standard Enquire MAP fields:

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

Examples:

“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”

Label	Example/Format	Notes
First Name	"Bob"
Last Name	"Smith"
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"
Email	"bob.smith@acme.com"
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 Enquire MAP account.
Contact Manager Email	harry@home.com	The contact manager for the contact. Assumed to exist and be an employee of the Enquire MAP account.
Twitter Handle	bob_twitter
Special Date Name	birthday	A special date can be any named date for the contact
Special Date	31/12/2000	A special date can be any named date for the contact

Contact Source Types

Call-to-Action Web Form	Webinar Registration
Contact Web Form	Account Introduction
eNewsletter Sign-up	JumpON Live-Chat
Event Registration	Organic Search
Event Attendance	Search Engine Marketing
3rd Party List	Phone Call
3rd Party Website	Email Campaign
Offline Marketing Initiative	Twitter Follow
Online Directory	Email

Please reach out to the dedicated Enquire Account Manager or Enquire MAP Support team for further assistance.