Basic Troubleshooting
17.a) Viewing the field you can download
To view the fields you can download via RETS and information about these fields, paste this URL into IE:
http://ntreisrets.mls.ntreis.net/rets/login
and press Enter. Enter your RETS credentials and click n “OK”.
Then, paste this URL into IE
http://ntreisrets.mls.ntreis.net/rets/links
and press Enter.
Below are the choices on this page that will provide you with useful information. While you can select “XML” as an option, “Compact” is more user-friendly.
This option lists all the Look Up fields used in NTREIS RETS:
|
7 |
Metadata Lookup With Resource Name |
This option lists the Look Ups and their list of values:
|
8 |
Metadata Lookup Types for a Resource |
These options allow you to view all the fields in your RETS download on a Class by Class basis.
|
29 |
Agent |
AGENT:AGENT |
XML / Compact |
|
32 |
Media |
MEDIA:MEDIA |
XML / Compact |
|
33 |
Office |
OFFICE:OFFICE |
XML / Compact |
|
35 |
Commercial |
PROPERTY:COM |
XML / Compact |
|
36 |
Vacant Land |
PROPERTY:LND |
XML / Compact |
|
37 |
Lease |
PROPERTY:LSE |
XML / Compact |
|
38 |
MultiFamily |
PROPERTY:MUL |
XML / Compact |
|
39 |
Residential |
PROPERTY:RES |
XML / Compact |
|
40 |
Removed Listings |
REMOVED:REMOVED |
XML / Compact |
You may find it useful to click on “Compact” and then save the file as a ‘.txt’ file and open the file in Excel to view the data in its most user-friendly manner.
The “RETS Field Mapping” file on the RETS Support Page, http://www.ntreis.net/technical/rets.asp, contains a list of the fields used for the IDX and nonIDX profiles. Besides the field names, it includes the Tempo Table and System Name along with the input label and an informal definition. As some of the names are somewhat cryptic, this could be useful. Using the Links page and the “RETS Field Mapping” is the best way to understand the data fields in your download.
After viewing this page, please logout of RETS by pasting this into IE
http://ntreisrets.mls.ntreis.net/rets/logout
and press Enter.
17.b) Verify your credentials and connection
To verify you can connect to the RETS Server and download data, paste this URL into IE:
http://ntreisrets.mls.ntreis.net/rets/login
and press Enter. Enter your RETS credentials.
Paste this URL into IE
http://ntreisrets.mls.ntreis.net/rets/Search?SearchType=PROPERTY&Class=RES&Query=(LISTSTATUS%3DACT)%2C(AREA%3D25)%2C(BEDS%3D5)&Format=COMPACT&limit=25&select=Mlsnum,Modified,Liststatus,Area,Beds
and press Enter.
If the screen returns something like this:
- <RETS ReplyCode="0" ReplyText="Operation Successful">
<DELIMITER value="09" />
<COLUMNS>MLSNUM MODIFIED LISTSTATUS AREA BEDS</COLUMNS>
<DATA>10993688 2009-09-16 10:35:13 act 25 5</DATA>
<DATA>11014572 2009-09-25 13:15:51 act 25 5</DATA>
<DATA>11017435 2009-07-08 01:43:52 act 25 5</DATA>
<DATA>11017590 2009-07-08 01:43:52 act 25 5</DATA>
<DATA>11029848 2009-07-21 11:25:54 act 25 5</DATA>
<DATA>11053894 2009-07-11 18:31:13 act 25 5</DATA>
<DATA>11062066 2009-09-21 13:44:38 act 25 5</DATA>
<DATA>11063906 2009-09-29 08:05:46 act 25 5</DATA>
Then your credentials are working and you can connect. If you are having a problem downloading RETS data through your client, then the problem is probably with your RETS Client. You will have to contact the Technical support for your particular client for assistance.
After viewing this page, please logout of RETS by pasting this into IE
http://ntreisrets.mls.ntreis.net/rets/logout
and press Enter.
Updated: 9/15/2010