Export MLS Data

MLS members can easily export selected listing data from either CTI Navigator Desktop or CTI Navigator Web as described below. 

CTI Navigator Desktop Export

Overview

Export saves the selected data fields for properties that match search criteria into a text file. To export data, select Export from the File menu on the Data Table. In the "Save in" box, enter the path and name of the file to export into if it is different from the default. In the Layout box, select a previously saved table layout. (A layout must be defined either in a previously saved layout file or by first going to the Table view.) Specify Comma Delimited or Tab Delimited format. Indicate if Field Names should be included on the first row, and how many photos should be included per property. See below for details.

Exporting 

To export the data from a Search Results table to another application, select Export under the File menu. 

Export menu in data table

Ensure that the appropriate data are highlighted in the data table before selecting Export. Programs for which there are predefined export formats are displayed under the Predefined tab. Select the appropriate program and click the OK button. The default location for the export.log is under ...\CTI Navigator\{YourMLS} \Users\{YourUserName}\Export\. Stored in this folder will be the Export.log file and any .jpg files of the main photo associated with the exported properties.

Custom defined exports can be specified by selecting the Custom tab (see image below).  Export Custom Tab Nav Desktop 

Specify the location for the export in the "Save in" box. Click on the down arrow at the end of the Save in box to select from previously entered locations. or click the Browse button to find the appropriate location. 

"Use Layout from Table" is selected by default when using export from a data table. (It is not available when using export directly from a search without first displaying the data in a data table.) To use a previously saved table layout instead of the current table layout, specify the location of the layout definition file in the Layout box. Click on the down arrow at the end of the Layout box to select from previously entered locations, or click the Browse button to find the appropriate location.

Select the custom export format as either Comma Delimited (fields separated by a comma) or Tab Delimited (fields separated by a tab) by clicking on the appropriate radio button. Check the box beside "Include Field Names on First Row" to include column headings. Field names may be used by other applications such as a database program for sorting, or by a word processor in a mail merge function.

Photographs can be included in the export to the same directory as the data files. They will be in jpg format. Select the number of photos to export per property using the drop down arrow beside "Photos per property."

Click on the OK button to process the export; or click on the Close button to exit without exporting. 

CTI Navigator Web Export

Listing data can be easily exported from either the Search Criteria or Search Results screen in CTI Navigator Web.

  1. If exporting from the Search Results screen, first select the listings for which data are to be exported.
  2. Click the Export button at the bottom of the Search Criteria or Search Results screen
    Export data screen in Nav Web 
  3. Either enter the export criteria under the Custom tab, or click on the Predefined tab and select the appropriate predefined export format
  4. For Custom criteria:
    1. Select the Table Layout (current or previously saved)
    2. Select Comma or Tab Delimited format
    3. Check "Field Names in First Row" if desired
    4. Select the Number of Photos per listing to include
    5. If exporting photos, check Zip file(s)
  5. Click the Export button
  6. Enter a File name
  7. Select the File Type (such as txt, csv, xls)
  8. Browse to and Select your desired "Save In" folder
  9. Click the Save button.

Export in Excel/Spreadsheet Format

To export data only (without photos) from CTI Navigator Web (in Windows) to import into Excel or other spreadsheet application:

  1. Click the Export button on a Search Criteria or Search Results screen
  2. Confirm or select Tab Delimited (not Comma Delimited) 
  3. Check "Field Names in First Row" if desired (this is optional)
  4. Click the Export button
  5. Click the down arrow beside "Save As Type" and change to "All Files"
  6. Enter a filename with .xls as its extension (such as MyListings.xls)
  7. Browse to and Select your desired "Save In" folder
  8. Click the Save button.

To simultaneously export data and photos from CTI Navigator Web (in Windows) to import into Excel or other spreadsheet application:

  1. Click the Export button on a Search Criteria or Search Results screen
  2. Confirm or select Tab Delimited (not Comma Delimited) 
  3. Check "Field Names in First Row" if desired (this is optional)
  4. Select the Number of Photos per listing to Export
  5. Verify Zip File(s) is checked
  6. Click in the box under Zip File(s), and replace the ".txt" file extension with a ".xls" file extension for the file name 
  7. Click the Export button
  8. Leave Zip as the "Save As Type"
  9. Browse to and Select your desired "Save In" folder
  10. Click the Save button.

Note: Before attempting to import data in a zip file, first open it (typically by double-clicking) and then double-click on the .xls file itself. The .xls data will open in an Excel spreadsheet. (The photos will be listed separately as .jpg files and do not import with the data.)

Related articles and Internet links:

 

To return to CTI's menu of Help & Tutorials, click here or use the back arrow at the top of your Internet browser.

 

{rev.05.17.2012}