How to Export Contacts from Top Producer

Play 

This article will provide information about exporting contacts from Top Producer 8i into a .csv (Comma Separated Value) file that can be edited and saved locally on your computer. A .csv file is a standard file format that can be viewed and edited by a spreadsheet program like Microsoft Excel, and is commonly accepted as an import file by most 3rd party programs and services.

Making use of your contacts outside of Top Producer 8i requires three separate steps: Searching for and selecting the contacts you wish to export, choosing an export method and saving the .csv file, and editing the content of the file for your desired use.

Step 1: Search for Contacts to Export

1. Click Search for Contacts from the Contacts menu in the main menu bar.

   

2. Enter the search criteria for the contacts you would like to export, for instance a Contact Type. If you would like to export all contacts, do not enter any search criteria. Click the Search button at the bottom of the page.

   Note: For more information about the Advanced Contact Search Feature, click here.

3. On the Search Results screen, select the individual contacts to export by placing a check next to each name, or select them all by placing a check at the top of the list.

   

4. Click Export Contactsat the bottom of the page.

   Note: If the Export Contacts option is not available and you are logged in as an Assistant or as an Agent other than the main account owner, your user account has not been given permission to export. Speak with the account owner about gaining permission to export. Export permissions are configured in the main Agent account by clicking My Account, selecting Team Members, and then editing the appropriate user account.

Step 2: Export Contacts

1. On the Export Contacts screen, choose if you would like to export only the Selected Contacts, or All Contacts in your database.

   

2. Choose one of the four Export Options:

   1. Contact record (names only): This option will export only the name information from each contact record, including all name fields and salutations, contact types and source, birthdays and notes.
   2. Contact record and all addresses and communications: This option will export all contact information and all address information for each record.
   3. Search results columns only: This option will export only the information seen on the previous Search Results screen, including Primary Last and First Name, Primary Address, and Primary Contact Method. Note that this information will be grouped in to 3 columns within the file instead of the multiple individual data columns produced by the other export options.
   4. Contact record and all associated items: This option will export all available information within each contact record, listing, and closing. This option is best used if you wish to keep a local backup of your contacts, are transferring between Top Producer accounts, or are not sure if the other options will provide the required data.
3. Click the Exportbutton to begin the export process. A message will appear stating the request is being processed. The processing time will depend upon how many contacts are being exported, and which of the four export options was selected.

   

4. Once the processing is complete, a prompt will appear allowing you to save the file. Once saved to the computer, the export process is complete.

   Note: If you are using Internet Explorer and you do not receive a prompt to download the file, it is possible that Internet Explorer’s security settings have blocked the download. For information about how to resolve this issue, click here.

Step 3: Editing the Exported Data

If the purpose of exporting the data is to make use of it in a 3rd Party Program or provide it to another service provider, it is likely you will need to edit the content of the file to meet their requirements. If you will be importing the data into another Top Producer 8i account, it is likely not necessary to edit the file. The file can be opened in a spreadsheet program like Microsoft Excel.

While it is outside the scope of Top Producer’s services to provide assistance related to 3rd party products, the below information about the content of the export file will assist you in formatting the data to meet your needs. It is recommended that you make a copy of your export file before you begin editing.

1. The export file will contain extra data that is only necessary for Top Producer Products. An example of extra data can be seen in the column called Contact ID. This column, and any others you do not want to include in the file, can be removed by Right-Clicking the column letter above the information and choosing Delete. This will remove the entire column and shift all subsequent columns to the left. Scroll all the way down and scan the data in each column to determine if it should be deleted.

   

2. Exporting contacts using the Contact record and all addresses and communications option or the Contact record and all associated items option will export all properties for each contact record. Address information for Investment or Other properties will be stored in a separate row of the export file, located directly below the associated contact’s information, and it is immediately identifiable by its lack of contact information. In the example image below, Alex Noel has a primary property at 1503 W 123rd St in Row 115, and an Investment Property at 1457 Cascade Courtlocated on Row 116.

   

   This formatting may not be acceptable for certain uses, such as importing to 3rd Party Programs or submitting to bulk-mailing services, and it might be necessary to reformat this data to match their requirements or to delete the information. Scroll through the information to scan the contents of a row before deciding if it should be deleted.

3. Exporting data using the Contact record and all associated items option also includes Closing information. Since it is possible to create a Closing that links to both the existing Buyer and Seller contact records, choosing to export one of these closing parties might result in the file containing both of these contact records, even if the second contact was not selected during the export process. This is because the link between the Closing and the Contact records must be maintained should the data be imported into another Top Producer account. Without information on all Closing Parties, the Closing could not be recreated during import. This means it is possible the file may contain several contacts that were not selected, and they must be manually deleted from the data.

4. A complete list of all field headers that you may encounter when exporting data can be found in the Import and Export Fields article.

• Next >