Export MLS Data

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.

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.

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 Browsebuttonto 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
buttonto 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.

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

If exporting from the Search Results
screen, first select the listings for which data are to be exported.

Click the Export button at the
bottom of the Search Criteria or Search Results screen

Either enter the export criteria under the Custom
tab, or click on the Predefined tab and select the
appropriate predefined export format

For Custom criteria:

Select the Table Layout (current
or previously saved)

Select Comma or Tab Delimited
format

Check "Field Names in First Row"
if desired

Select the Number of Photos per
listing to include

If exporting photos, check Zip
file(s)

Click the Export button

Enter a File name

Select the File Type (such as txt,
csv, xls)

Browse to and Select your desired "Save In"
folder

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:

Click the Export button on a Search Criteria or
Search Results screen

Confirm or select Tab Delimited (not
Comma Delimited)

Check "Field Names in First Row" if desired
(this is optional)

Click the Export button

Click the down arrow beside "Save As
Type" and change to "All Files"

Enter a filename with .xls as its
extension (such as MyListings.xls)

Browse to and Select your desired "Save In"
folder

Click the Save button.

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

Click the Export button on a Search Criteria or
Search Results screen

Confirm or select Tab Delimited (not
Comma Delimited)

Check "Field Names in First Row" if desired
(this is optional)

Select the Number of Photos per
listing to Export

Verify Zip File(s) is checked

Click in the box under Zip File(s), and replace
the ".txt" file extension with a ".xls" file
extension for the file name

Click the Export button

Leave Zip as the "Save As Type"

Browse to and Select your desired "Save In"
folder

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.)