[libRETS-users] RE: libRETS-users Specific Order

[Tony Russo]

Hi Russ,
 
Ouch Limit, Offset, and Order are not guaranteed but you might try something like this using a local mls_index table:
 
 
1.) Create a local temporary mls_index table with 4 fields, MLSNum, PropType, ListStatus, and ModifedDate fields.
 
2.) Create a RETS Search by Property Class for MLSNum, ListStatus, ModifiedDate and limit the query to something that will ensure the results returned fall within the imposed server limits. Try using BETWEEN on fields like ModifedDate, EntryDate, or MLSnum in your query that would allow you to control the number of records returned per search.
 
3.) Loop using the Search from step 2, saving the MLSNum, PropType, ListStatus, and ModifiedDate into your local mls_index table.
 
4.) Upon completion of step 3 you should now have a complete index of all listings on the MLS.
 
5.) You can query your local mls_index table any way you like using your own Limit, Offset or Order to build a set of RETS queries by MLSnum that will always return the number of listings that fall with the server limits.
 
5.) Also listings in your local MLS table not in this mls_index are no longer available (deleted or archived) on the server so you can use this to keep your local MLS table updated.
 
Hope this helps.
 
Tony
 
-----Original Message-----
From: librets-users-bounces at crt.realtors.org [mailto:librets-users-bounces at crt.realtors.org] On Behalf Of Russ Perna
Sent: Monday, January 15, 2007 11:38 AM
To: 'For discussion and help for and by the users of the libRETS C++library'
Subject: RE: [libRETS-users] Specific Order
 
When I asked the MLS, I got a vague answer to the question, and I don't
think they actually knew.
 
If you can't guarantee the sort order, can anyone tell me how they download
their data when the MLS limits the download size?
 
Thanks,
Russ
 
 
Russ Perna
--
Webmaster
Prudential Rand Realty
http://www.prudentialrand.com
845.825.8036