RETS connector install fails

[Libor V]

Hi,

Reloading .NET definitely seems like a good idea. Let me know if it
helped.

LV



************************************************** ****************************************
This message may contain confidential or proprietary information intended only for the use of the addresses(s) named above or may contain information that is legally privileged. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message and any copies immediately thereafter.
************************************************** *****************************************

-----Original Message-----
From: aspirin [mailto:]
Sent: Friday, November 20, 2009 2:48 PM
To: Libor Viktorin
Subject: [RETS-disc] RETS connector install fails

Hi Libor;

enjoyed talking to ya, had fun talking about Bluegrass, and you worked
for a long time trying to help me. So Thanks for that!

Then i had a thought. I have an older xp machine and i would try to
download it on that, and attempt to install. When i did the setup
downloaded .NET framework 2.0 and installed without a hitch!

So maybe i have to reload .NET framework 2.0 on my laptop?

[aspirin]

I tried to use the wizard to make a task and do a full pull and got this error message:


Running task "mytest"
Server: http://rets.mlsli.com:6103/rets/server/login
User name: mylogin
Full pull
Local time: 12/8/2009 4:22:45 PM
Server time: Wed, 09 Dec 2009 00:23:00 GMT
Metadata stored in C:\Documents and Settings\mystuff\metastore1.1.0.2.xml

Running step "search data"
Data file: C:\Documents and Settings\mystuff\output1.xml
0 records downloaded
Error detected: server failed the request
Request: SearchType=Property&Class=ResidentialProperty&Form at=COMPACT-DECODED&QueryType=DMQL2&Query=(A_c=|),(Ad_text=),( Addr=),(Adult_comm=|),(Amenities=),(Cable=|),(Cond =),(County=|),(Fuel=|),(Greenfeat=),(Heat=|),(List _agent=),(Pets=|),(Pool=|),(Stove=),(Town=|),(Zoni ng=)&Count=1&Select=
RETS Status code = 20206: Invalid DMQL query (0)
Step finished at 12/8/2009 4:22:46 PM

Last URL requested:
http://rets.etc/search?SearchType=Pr...ount=1&Select=

Task "mytest" failed
--------------------------------------
Not sure what i did wrong ...this? RETS Status code = 20206: Invalid DMQL query (0)

[simsonkate]

Hi
Just giving my input here

SearchType=Property&Class=ResidentialProperty&Form at=COMPACT-DECODED&QueryType=DMQL2&Query=(A_c=|),(Ad_text=),( Addr=),(Adult_comm=|),(Amenities=),(Cable=|),(Cond =),(County=|),(Fuel=|),(Greenfeat=),(Heat=|),(List _agent=),(Pets=|),(Pool=|),(Stove=),(Town=|),(Zoni ng=)&Count=1&Select=

The query above doesn't seem to have any search criteria defined

Query=(A_c=|),(Ad_text=),( Addr=),(Adult_comm=|),(Amenities=),(Cable=|),(Cond =),(County=|),(Fuel=|),(Greenfeat=),(Heat=|),(List _agent=),(Pets=|),(Pool=|),(Stove=),(Town=|),(Zoni ng=)

All the search fields present above don't have defined any search criteria ... you can give it a shot doing something like this --- setup a search criteria which will enable you to make a full pull and also have a valid search setup --- price equal - greater than zero, sqft egual - greater than zero ---

Hope that helps
Kate

[Libor V]

It looks like you have selected bunch of criteria, but no value for
them. Go back to your Search Criteria tab and make sure there are some
values for each criteria.

Libor



************************************************** ****************************************
This message may contain confidential or proprietary information intended only for the use of the addresses(s) named above or may contain information that is legally privileged. If you are not the intended addressee, or the person responsible for delivering it to the intended addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message and any copies immediately thereafter.
************************************************** *****************************************

-----Original Message-----
From: aspirin [mailto:]
Sent: Wednesday, December 09, 2009 3:21 PM
To: Libor Viktorin
Subject: [RETS-disc] Task failed message

I tried to use the wizard to make a task and do a full pull and got this
error message:


Running task "mytest"
Server: http://rets.mlsli.com:6103/rets/server/login
User name: chelwwrks
Full pull
Local time: 12/8/2009 4:22:45 PM
Server time: Wed, 09 Dec 2009 00:23:00 GMT
Metadata stored in C:\Documents and
Settings\mystuff\metastore1.1.0.2.xml

Running step "search data"
Data file: C:\Documents and Settings\mystuff\output1.xml
0 records downloaded
Error detected: server failed the request
Request:
SearchType=Property&Class=ResidentialProperty&Form at=COMPACT-DECODED&Que
ryType=DMQL2&Query=(A_c=|),(Ad_text=),(Addr=),(Adu lt_comm=|),(Amenities),(Cable=|),(Cond=),(County=| ),(Fuel=|),(Greenfeat=),(Heat=|),(List_agen
t=),(Pets=|),(Pool=|),(Stove=),(Town=|),(Zoning=)& Count=1&SelectRETS Status code = 20206: Invalid DMQL query (0)
Step finished at 12/8/2009 4:22:46 PM

Last URL requested:
http://rets.etc/search?SearchType=Pr...alProperty&For
mat=COMPACT-DECODED&QueryType=DMQL2&Query=(A_c=|),(Ad_text=),( Addr=),(Ad
ult_comm=|),(Amenities=),(Cable=|),(Cond=),(County =|),(Fuel=|),(Greenfea
t=),(Heat=|),(List_agent=),(Pets=|),(Pool=|),(Stov e=),(Town=|),(Zoning=)
&Count=1&Select
Task "Baybenjamin" failed
--------------------------------------
Not sure what i did wrong ...this? RETS Status code = 20206: Invalid
DMQL query (0)

[aspirin]

OK i was able to configure fields more carefully and do a full pull.
I used the metadata browser to view it and it looked like a lot of info was there.

Now how can i get this to display and auto schedule on a website?
I can make databases on my server but do i use the RETSconnector for this or another client?

Should i just generate a script with RETSconnector and try to figure how to cron on my server or should i use a client and which?
Very confusing.

[Libor V]

Create a task n RetsConnector, schedule it to run as often as you need, and in the Notification tab call a program that will parse the RETS data into your DB.


RetsConnector gets the data from server to your local file; you have to create a program that will get the data from the file to the DB (or website).

[simsonkate]

Hey
It's a process which has a few stages, just as LiborV said ... doing the pull with RETS Connector it's one of them. After that you have to import the information from the files obtained with RETSConnector into the database (located on your server)

You can do that by running an application after the RETSConnector pull finishes. This should connect to the database, and just import the information

You can also do that by running a script on the server, which should be scheduled with a cron on the server (if you do that, the script should be able to "read" the information from your files)

Hope that helps

Kate

[aspirin]

For the Forum: Note it WAS my laptops .NET framework that was not working.
I reloaded that and now am getting success with full pulls.