[ezRETS-users] Excel Demo

[Keith T. Garner]

On Wed, 16 May 2007 9:04 am, Rick Quatro wrote:
> I am just starting with RETS. I installed the ezRETS ODBC Driver and am 
> trying to do the tutorial on getting data into Excel using the ezRETS 
> Demo server. No matter which fields I choose in the Residential 
> property table, no data is returned to Excel except for the column 
> headings. I tried leaving off filter criteria and I still don't get any 
> data.

First, you must always provide criteria in a query or you'll get an 
empty result set.  This is a RETS limitation.

Second, there are only five properties in the test server, so its really 
easy to miss them.  A good criteria is LP>0.

> When I try to connect to my local MLS through Excel (which is using 
> RETS Server 1.5), I can see the table names, but when I click on the + 
> next to Residential, no fields are displayed. Any help would be greatly 
> appreciated. Thank you very much.

When you configured the connection, did you have StandardNames turned 
on.  If so, turn it off and give it a go.

If not, looks like something else weird is going on and we'll have to 
start debugging.  But I'll wait to see how you're set up before we go 
down that road.

Also, any idea who your MLS's vendor is?

Keith

--
Keith T. Garner                   kgarner at realtors.org
Managing Director - Center for REALTOR Technology
National Association of REALTORS
(From his mobile device)