Contact Information Header Fields

The fields listed in this topic may or may not be available to you, depending on the version of Top Producer you are currently using. To verify all fields that you have access to, perform an export from Top Producer to a file and view the header row in a spreadsheet program. Take note of all fields that are available.

The field names in the list of header fields are not case-sensitive, although you should try to follow them as closely as possible.

To print this topic, click the cursor in this pane and click the Print toolbar icon.

Contact information

The field that appears in bold-italics (e.g., Contact ID) is a system field and should not be modified. The system fields are in bold-italics. Most of these fields are NOT included in the list of header fields. These fields typically contain keyed ID codes or flags which instruct Top Producer on how to link certain items like listings, property types, etc. You should never edit these fields in the .CSV file.

For contacts with multiple properties, each property appears as an additional record linked to the same contact via the Contact ID. Because of this Contact ID, most of the contact's name details do not need to be repeated for each additional record.

Header Field Name	Description
Contact ID	Contact ID association field. A unique sequence of characters to denote that contact's ID that should not be edited in any way.
Contact Type	Contact types assigned to this contact.
Source	Source of the primary contact.
Inquiry Form	Inquiry form of the primary contact.
Urgency	Urgency (prioritization) of the contact.
Primary FirstName	First name of the primary contact.
Primary LastName	Last name of the primary contact.
Primary Initial	Middle initial of the primary contact.
Primary NickName	Nickname of the primary contact.
Primary Jr_Sr	Jr., Sr. name suffix of the primary contact.
Primary Mr_Mrs	Mr., Mrs. name prefix of the primary contact.
Primary Title	Title of the primary contact, for example, Manager.
Primary Designation	Designation of the primary contact, for example, CRS, GRI.
Letter Salutation	Letter salutation.
Envelope/Label Salutation	Envelope/Label salutation.
Company	Company name.
Primary Gender	Gender of the primary contact.
Primary Birthday	Birthday of the primary contact (MM/DD/YYYY format)
Email Address	Email address of the primary contact.
Web Address	Web address of the primary contact.
Other Email_Web Addr	Other email/web address of the primary contact, for example, [email protected].
Other Email_Web Desc	Description of other email/web address of the primary contact, for example, Home email.
Other Email_Web Type	Type of other email/web address of the primary contact (can only be Email or Web site).
Home Phone	Home phone number of the primary contact.
Home Phone Ext	Home phone number extension of the primary contact.
Home Ph Desc	Description of home phone number of the primary contact, for example, Unlisted number.
Bus Phone	Business phone number of the primary contact.
Bus Phone Ext	Business phone number extension of the primary contact.
Bus Ph Desc	Description of business phone number of the primary contact, for example, Downtown office.
Other Phone	Other phone number of the primary contact.
Other Phone Ext	Other phone number extension of the primary contact.
Other Ph Desc	Description of other phone number of the primary contact, for example, Second line.
Other Ph Nums Title	Title of second other phone number of primary contact, for example, Cellular.
Other Phone Nums	Second other phone number of the primary contact.
Other Phone Nums Ext	Second other phone number extension of the primary contact.
Other Ph Nums Desc	Description of second other phone number of the primary contact.
Mobile Phone	Mobile phone number of the primary contact.
Mobile Phone Ext	Mobile phone number extension of the primary contact.
Mobile Ph Desc	Description of mobile phone number of the primary contact, for example, Car phone.
Pager Number	Pager number of the primary contact.
Pager Ext	Pager number extension of the primary contact.
Pager Desc	Description of pager number of the primary contact, for example, Work pager.
Fax Number	Fax number of the primary contact.
Fax Ext	Fax number extension of the primary contact.
Fax Desc	Description of fax number of the primary contact, for example, Home office.
Contact Note Date	Date of the contact note.
Contact Notes	Contact notes (3000 character max.)
Secondary FirstName	First name of the secondary contact.
Secondary LastName	Last name of the secondary contact.
Secondary Initial	Middle initial of the secondary contact.
Secondary NickName	Nickname of the secondary contact.
Secondary Jr_Sr	Jr., Sr. name suffix of the secondary contact.
Secondary Mr_Mrs	Mr., Mrs. name prefix of the secondary contact.
Secondary Title	Title of the secondary contact.
Secondary Designation	Designation of the secondary contact.
Secondary Gender	Gender of the secondary contact.
Secondary Birthday	Birthday of the secondary contact (MM/DD/YYYY) format.
FF FirstName	Family/friend's first name.
FF LastName	Family/friend's last name.
FF Birthday	Birthday of family/friend contact (MM/DD/YYYY format).
FF Relation	Relation to the primary contact, for example, sister.
FF Resident	Resides with the primary contact. Must be Yes or left blank for No.
Asst FirstName	First name of the primary contact's assistant.
Asst LastName	Last name of the primary contact's assistant.
Asst Initial	Middle initial of the primary contact's assistant.
Asst Designation	Designation of the primary contact's assistant.
Asst Email	Email address of the primary contact's assistant.

Property/Property Information

The field that appears in bold-italics (i.e., Property Type), is a system field and should not be modified. The system fields are in bold-italics. Most of these fields are NOT included in the list of header fields. These fields typically contain keyed ID codes or flags which instruct Top Producer on how to link certain items like listings, property types, etc. You should never edit these fields in the .CSV file.

Header Field Name	Description
Property Type	The type of property of the particular address. Primary properties should contain a value of Primary and Investment properties a value of Investment. Other values may appear here from time to time.
House Number	House number.
Direction Prefix	Direction prefix, for example, N, S, E, W.
Street	Street name.
Street Designator	Street designator, for example, Avenue, Street, etc.
Direction Suffix	Direction suffix, for example, N, S, E, W.
Suite No	Suite number.
PO_BOX	Post office box number.
Bldg_Floor	Floor.
City	City.
County	County.
State	State.
Zip	ZIP code.
Country	Country.
List Price	List price of the current property.
Sales Price	Sale price of the current property.
Taxes	Taxes on the current property.
Tax Year	Tax year of the current property.
Tax Asses	Tax assessment of the current property.
Land Asses	Land assessment of the current property.
Air Con	Air conditioning type.
RV Parking	Recreational vehicle parking availability. Must be Yes or left blank for No.
Attached	Attached property. Must be Y or N.
Bldg Improve	Building improvements value, in $, of the current property.
Tax Roll No	Tax roll number of the current property.
Year Built	Year the current property was built.
Bedrooms	Number of bedrooms in the current property.
Bathrooms	Number of bathrooms in the current property.
Lot Size	Lot size of the current property.
Sq Feet	Square footage of the current property.
Levels	Number of levels of the current property.
House Style	House style of the current property.
Parking	Description of available parking at the current property.
Zoning	Zoning of the current property.
Flooring	Description of the flooring in the current property.
Dist To Transit	Distance to transit from the current property.
Dist To School	Distance to school from the current property.
Last Sold	Date of last sale of the current property. (MM/DD/YYYY format).
Heating	Description of heating type in the current property.
Roof	Description of the roof type on the current property.
Other Items	Description of other items affecting the current property, for example, built-in vacuum.
Construction	Description of construction of the current property.
Exterior	Description of exterior construction of the current property.
Area	Description of area location of the current property.
Fireplaces	Description of fireplaces in the current property.
Basement	Description of the basement in the current property.
Sewer	Description of the sewer in the current property.
Water	Description of the water supply in the current property.
Financing	Description of financing on the current property.
Legal Descr	Legal description of the current property.
Property Descr	Description of the current property.
Room Description	Description of an additional room of the current property.
Room Length	Length of an additional room in feet.
Room Width	Width of an additional room in feet.
Room Dimension	Length and width of standard rooms of the current property, for example, Living room [x] x [y].
Room	Description of a feature room of the current property, for example, Great room.
Features	Description of other features of the current property, for example, Pool.
Site/View	Description of the current property's site/view, for example, Waterfront.