You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Home > Contacts > Available Import Fields
Available Import Fields
print icon

The fields that may be imported are described in the tables below.

 Available Individual Import Fields

If your data has these fields…

Match it to this during import…

And it will appear here in GrowthZone…

Data to be imported

Import Template field name

Field Name in GrowthZone

Prefix

Prefix

Prefix

First Name (Required)

First Name

First Name

Middle Name

Middle Name

Middle Name

Last Name (Required)

Last Name

Last Name

Common Name

Common Name

Common Name

Suffix

Suffix

Suffix

Title

Title

Title

Account Number

Account Number

Account Number

Individual Phone 1

Phone Work

Phone; Type = Work

Individual Phone 2

Phone Main

Phone; Type = Main

Individual Phone 3

Phone Home

Phone; Type = Home

Individual Phone 4 Phone Personal Phone; Type = Personal
Individual Phone 5 Phone Cell Phone; Type = Cell
Individual Phone 6 Phone Emergency Phone; Type = Emergency
Individual Phone 7 Phone Other Phone; Type = Other
Individual Phone 8 Phone Toll Free Phone; Type = Toll Free

Individual Fax

Fax

Phone; Type = Fax

Individual Email 1

Email Work

Email; Type = Work

Individual Email 2

Email Personal

Email; Type = Personal

Individual Email 3

Email Other

Email; Type = Other

Individual Website

Website Homepage

Web Address; Type = Homepage

Individual Social Site 1

Social Site One

Web Address; Type = Social Site

Individual Social Site 2

Social Site Two

Web Address; Type = Social Site

Individual Social Site 3

Social Site Three

Web Address; Type = Social Site

Individual Address
(Physical & Mailing)

Physical and Mailing Address

Address Line 1; Type = Physical and Mailing

Individual Address 2
(Physical & Mailing)

Physical and Mailing Address 2

Address Line 2; Type = Physical and Mailing

Individual City
(Physical & Mailing)

Physical and Mailing City

Address City; Type = Physical and Mailing

Individual State
(Physical & Mailing)

Physical and Mailing State

Address State; Type = Physical and Mailing

Individual Postal Code
(Physical & Mailing)

Physical and Mailing Postal Code

Address Postal Code; Type = Physical and Mailing

Individual Country
(Physical & Mailing)

If left blank, the import will automatically import your default country which is determined under Setup>Misc>General Settings

Physical and Mailing Country

Address Country; Type = Physical and Mailing

Individual Address
(Physical only)

Physical Address

Address Line 1; Type = Physical

Individual Address 2
(Physical only)

Physical Address 2

Address Line 2; Type = Physical

Individual City
(Physical only)

Physical City

Address City; Type = Physical

Individual State
(Physical only)

Physical State

Address State; Type = Physical

Individual Postal Code
(Physical only)

Physical Postal Code

Address Postal Code; Type = Physical

Individual Country
(Physical only)

If left blank, the import will automatically import your default country which is determined under Setup>Misc>General Settings

Physical Country

Address Country; Type = Physical

Individual Address
(Mailing only)

Mailing Address

Address Line 1; Type = Mailing

Individual Address 2
(Mailing only)

Mailing Address 2

Address Line 2; Type = Physical and Mailing

Individual City
(Mailing only)

Mailing City

Address City; Type = Physical and Mailing

Individual State
(Mailing only)

Mailing State

Address State; Type = Mailing

Individual Postal Code
(Mailing only)

Mailing Postal Code

Address Postal Code; Type = Mailing

Individual Country
(Mailing only)

If left blank, the import will automatically import your default country which is determined under Setup>Misc>General Settings

Mailing Country

Address Country; Type = Mailing

Notes

Notes

Notes on the Individual’s More Info tab

Gender

Valid options:

Male

Female

Note: Other custom entries added in your database under Setup>Misc>Genders are currently not supported. Those would manually need to be changed after import.

Gender

Gender

Primary contact of the business

Is this individual the primary contact of the associated business? (Applies only if being matched to an org upon import)

Valid options:

T, True, Y, Yes

F, False, N, No

An empty field will act like false as well

Is Primary Individual

If this individual is matched to an business during import, if this value is set to Y, Yes, T, or True, then this contact will be set as the Primary Contact of the matching business

 

Custom data

Make sure that the custom field exists in GrowthZone first.

Select the desired GrowthZone custom field(s) on the Optional Columns step on the Import screen.

Data will appear in the selected custom field.

Data that belongs in a GrowthZone list

Make sure that the category list exists in GrowthZone first. The fields within the list must be exist in GZ as well. i.e. the import will not create new entries if they do not exist.

Select the desired GrowthZone category list(s) on the Optional Columns step on the Import screen.

Data will appear in the selected category list.

Tags. The tags mus exist in the database. The import will not create new tags

Tag

Tags will appear on the contact Overview tab.

Membership Data

 

 

Membership Type. The type must exist in the database. An import cannot create a new membership type. 

Membership Type

Membership Type is avaiable for individuals only

Membership Level. The level must exist in the database. An import cannot create new levels

Membership Level

Membership Level

Membership Start Date

Membership Start Date

Membership Start Date

Membership Expiration Date

Membership Expiration Date

Membership Expiration Date

 

 

Available Business Import Fields

Data Import options for Businesses:

If your data has these fields…

Match it to this during import…

And it will appear here in GrowthZone…

Data to be imported

Import Template field name

Field Name in GrowthZone

Business Name

Business Name

Business Name

Account Number

Account Number

Account Number

Business Phone 1

Phone Work

Phone; Type = Work

Business Phone 2

Phone Main

Phone; Type = Main

Business Phone 3

Phone Home

Phone; Type = Home

Business Phone 4

Phone Personal

Phone; Type = Personal

Business Phone 5

Phone Cell

Phone; Type = Cell

Business Phone 6

Phone Emergency

Phone; Type = Emergency

Business Phone 7

Phone Other

Phone; Type = Other

Business Phone 8

Phone Toll Free

Phone; Type = Toll Free

Business Fax

Fax

Phone; Type = Fax

Business Email 1

Email Work

Email; Type = Work

Business Email 2

Email Personal

Email; Type = Personal

Business Email 3

Email Other

Email; Type = Other

Business Website

Website Homepage

Web Address; Type = Homepage

Business Social Site 1

Social Site One

Web Address; Type = Social Site

Business Social Site 2

Social Site Two

Web Address; Type = Social Site

Business Social Site 3

Social Site Three

Web Address; Type = Social Site

Business Address
(Physical & Mailing)

Physical and Mailing Address

Address Line 1; Type = Physical and Mailing

Business Address 2
(Physical & Mailing)

Physical and Mailing Address 2

Address Line 2; Type = Physical and Mailing

Business City
(Physical & Mailing)

Physical and Mailing City

Address City; Type = Physical and Mailing

Business State
(Physical & Mailing)

Physical and Mailing State

Address State; Type = Physical and Mailing

Business Postal Code
(Physical & Mailing)

Physical and Mailing Postal Code

Address Postal Code; Type = Physical and Mailing

Business Country
(Physical & Mailing)

Physical and Mailing Country

Address Country; Type = Physical and Mailing

Business Address
(Physical only)

Physical Address

Address Line 1; Type = Physical

Business Address 2
(Physical only)

Physical Address 2

Address Line 2; Type = Physical

Business City
(Physical only)

Physical City

Address City; Type = Physical

Business State
(Physical only)

Physical State

Address State; Type = Physical

Business Postal Code
(Physical only)

Physical Postal Code

Address Postal Code; Type = Physical

Business Country
(Physical only)

Physical Country

Address Country; Type = Physical

Business Address
(Mailing only)

Mailing Address

Address Line 1; Type = Mailing

Business Address 2
(Mailing only)

Mailing Address 2

Address Line 2; Type = Physical and Mailing

Business City
(Mailing only)

Mailing City

Address City; Type = Physical and Mailing

Business State
(Mailing only)

Mailing State

Address State; Type = Mailing

Business Postal Code
(Mailing only)

Mailing Postal Code

Address Postal Code; Type = Mailing

Business Country
(Mailing only)

Mailing Country

Address Country; Type = Mailing

Notes

Notes

Notes on the Business’s More Info tab

Custom data

Make sure that the custom field exists in GrowthZone first.

Select the desired GrowthZone custom field(s) on the Optional Columns step on the Import screen.

Data will appear in the selected custom field.

Data that belongs in a GrowthZone list

Make sure that the category list exists in GrowthZone first. The fields within the list must be exist in GZ as well. i.e. the import will not create new entries if they do not exist.

Select the desired GrowthZone category list(s) on the Optional Columns step on the Import screen.

Data will appear in the selected category list.

 

Note: The following fields are used for internal purposes only.

  • Do not match them during import:
  • Mailing Country ID
  • Physical Country ID
  • Physical and Mailing Country ID
Feedback
0 out of 0 found this helpful

scroll to top icon