RETS Query Examples?

[loki_racer]

I am working on getting our old website to work with our new Rapattoni RETS server. I am able to connect to the server, authenicate, and run the sample query. I'm using a PHP script to do everything.

However, as anyone that has had to deal with RETS or Rapattoni will know, their documentation is horrible. I have been trying to find simple examples of search queries without any luck.

Does anyone happen to have any that they can share?

Thanks.

[Aaron]

Are you using an Open Source PHP script to connect to the server? Or is it something you've coded? I have used some Java software Called ORC which comes with excellent docs and seems to work well except the images come down corrupted, so I will have to find or code something else.

Aaron

[loki_racer]

I have a script that I have coded.

I can get connected and get to the search page. There is just absolutely no useful documentation on building a RETS server query.

[phpsolutions]

Hi loki,

IMHO i think that you shoud try too look at this tool for a second
http://www.crt.realtors.org/projects/rets/viele/

It worked for me ... i managed to download Residential and Land listings and the pictures into a local mysql database.

You can setup scheduled (cron) jobs to run the downloader once a day or so.

It doensn't require a shell to install it ... open the install.sh script and you will see that it's only creating a few folders and sets the permission attributes for them.

Anyway, the only problem that i have now, with this nice application is that i couldn't figure how to run a incremental update.

I hope that this post will help you.

[Aaron]

Thanks phpsolutions, I tried that out, almost got it to work, it even downloaded images!
Now i just have to figure out why it crashes after the first 2 or three listings it downloads with this error. I maxed out my php memory to no avail.

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 86160 bytes) in /var /www/html/vrets/vieleRETS-1.1.2/common/rets_lite/exchange.php on line 187

Looks promising anyways. :-)

[phpsolutions]

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 86160 bytes) in /var /www/html/vrets/vieleRETS-1.1.2/common/rets_lite/exchange.php on line 187

I have memory_limit = 8M in my php.ini and it didn't crashed until now.
Maybe you have some bugs in you php version.

And btw i made the incremental update work.
The DMLQ query looks like this (MLNumber=0+),(LastModifiedDateTime=2006-05-24T03:28:04+)
where MLNumber it's the only one in QUERY_ITEMS , the value '0+' is used as wildcard and LastModifiedDateTime is the DATE_VARIABLE.

I hope that this helps too

Now ... the only problem left that i see, is how to delete the expired listings in an elegant manner.

The delete of the entire database folowed by a new rebuild once a week or so it's out of the question.

Anyone ... any ideas ?

[phpsolutions]

Does anyone happen to have any that they can share?

what about those two?

http://rets15.raprets.com:6103/Brunswick/BRWC/search.aspx?Query=(MLNumber=0+)&QueryType=DMQL2&Se lect=RESIANND,RESIAPPL,RESIBED2,RESIBED3,RESIBED4, RESIBED5,RESIBRKF,RESICARF,RESICOMX,RESICONT,RESIC OOL,RESIDBPG,RESIDENN,RESIDIND,RESIDINR,RESIEXTF,R ESIFINA,RESIFIRE,RESIFLOR,RESIFLRN,RESIFOUN,RESIFO YE,RESIGRRM,RESIHEAT,RESIHETS,RESIHMWA,RESIINTR,RE SIIRRL,RESIKITC,RESILIVI,RESILOCU,RESILTFR,RESILTL T,RESILTRR,RESILTRT,RESIMOBL,RESIMSTB,RESINUMS,RES IPARK,RESIPROP,RESIRDFR,RESIRECR,RESIROOF,RESISHOW ,RESISTOR,RESIUTLR,RESIWALL,RESIWATE,RESIWTFE,RESI WTHR,RESIWTRS,RESIWTRT,RESIWTRV,RESIWTVT,RESIZONE, Acres,Age,APN,Area,Association,AvailableDate,Bathr ooms,Bedrooms,City,ContingentDate,ContingentExpira tionDate,County,Directions,EntryDate,Financing,Fin ancingComments,FullBathrooms,GarageSpaces,HalfBath rooms,LastModifiedDateTime,Latitude,LeaseType,Lega lDescription,ListingAgentNumber,ListingCoAgentNumb er,ListingCoOfficeNumber,ListingDate,ListingOffice Number,ListingPrice,Longitude,LotMeasurement,LotSi zeSource,LotSquareFootage,MapPage,MapXCoordinate,M apYCoordinate,MarketingRemarks,MLNumber,MLS,Pendin gDate,PictureModifiedDateTime,PictureCount,PricePe rAcre,PricePerSquareFoot,PropertyDisclaimer,Proper tySubtype1,PropertySubtype2,PropertySubtype3,Prope rtyType,QuarterBathrooms,Bedroom2Area,Bedroom3Area ,Bedroom4Area,Bedroom5Area,BreakfastArea,CarFlRoom Area,DenArea,DiningRoomArea,FoyerArea,GreatRoomAre a,KitchenArea,LivingRoomArea,MasterBedroomArea,Rec RoomArea,UtilityRoomArea,Bedroom2Dim,Bedroom3Dim,B edroom4Dim,Bedroom5Dim,BreakfastDim,CarFlRoomDim,D enDim,DiningRoomDim,FoyerDim,GreatRoomDim,KitchenD im,LivingRoomDim,MasterBedroomDim,RecRoomDim,Utili tyRoomDim,Bedroom2Len,Bedroom3Len,Bedroom4Len,Bedr oom5Len,BreakfastLen,CarFlRoomLen,DenLen,DiningRoo mLen,FoyerLen,GreatRoomLen,KitchenLen,LivingRoomLe n,MasterBedroomLen,RecRoomLen,UtilityRoomLen,Bedro om2Wid,Bedroom3Wid,Bedroom4Wid,Bedroom5Wid,Breakfa stWid,CarFlRoomWid,DenWid,DiningRoomWid,FoyerWid,G reatRoomWid,KitchenWid,LivingRoomWid,MasterBedroom Wid,RecRoomWid,UtilityRoomWid,SchoolDistrict,Schoo lName1,SchoolName2,SchoolName3,SchoolName4,SchoolT ype1,SchoolType2,SchoolType3,SchoolType4,SearchPri ce,SquareFootage,SquareFootageSource,State,Status, StatusComments,StatusDate,StreetDirection,StreetNa me,StreetNumber,StreetNumberModifier,StreetPostDir ection,StreetSuffix,Subdivision,SubLease,SubLeaseE xpiration,ThreeQuarterBathrooms,VirtualTourURL,Yea rBuilt,ZipCode,ZipPlus4,ListingAgentAddress,Listin gAgentContactPhone,ListingAgentFax,ListingAgentFir stName,ListingAgentLastName,ListingAgentMLSID,List ingAgentOfficePhone,ListingCoAgentFirstName,Listin gCoAgentLastName,ListingCoAgentMLSID,ListingCoAgen tPhone,ListingOfficeAddressComplete,ListingOfficeM LSID,ListingOfficeName,ListingOfficePhoneComplete, ListingOfficeStreetAddress,ListingOfficeStreetCity ,ListingOfficeStreetState,ListingOfficeStreetZipCo de,ListingCoOfficeMLSID,ListingCoOfficeName,Listin gCoOfficePhoneComplete,ListingAgentEmail&Class=RES I&Format=COMPACT-DECODED&Count=1&SearchType=Property

and to see what listings where updated

http://rets15.raprets.com:6103/Brunswick/BRWC/search.aspx?Query=(MLNumber=0+),(LastModifiedDateT ime=2006-05-24T01:58:44+)&QueryType=DMQL2&Select=MLNumber,Last ModifiedDateTime,ListingDate,PictureModifiedDateTi me,PictureCount&Class=RESI&Format=COMPACT-DECODED&Count=1&SearchType=Property

[Aaron]

Now ... the only problem left that i see, is how to delete the expired listings in an elegant manner.

The delete of the entire database folowed by a new rebuild once a week or so it's out of the question.

Anyone ... any ideas ?

Using a Mysql Database I use this method. When I get the updated listings, I have the MLS number set to a Unique index. Then use:

REPLACE INTO mlslistings VALUES('".implode("','",$row)."')

Then the old record is replaced with the new one with the updated status. Then I run another query:

DELETE FROM mlslistings WHERE status NOT IN('ACT','NEW');
Or whatever the status codes might be.
Seems to work. might work for what you're doing.
:-)

[RobertD]

We download and maintain all statuses in our system. We don't download the whole thing every time. We limit our downloads to new and updated listings since our last downloads. This allows us to update our data as frequently as we want though we typically don't do it more frequently than every half hour.

[phpsolutions]

We download and maintain all statuses in our system. We don't download the whole thing every time. We limit our downloads to new and updated listings since our last downloads. This allows us to update our data as frequently as we want though we typically don't do it more frequently than every half hour.

We do our update in the same way, but my problem is that i don't have an elegant solution to delete expired listings, because they don't have a status.

So once in a while we have to delete our local database and get the whole thing again.

Do you have a better solution for that ?

Thanks