[Rets-dev] Problem with Importing Rets (MRMLS) listings

Tue Apr 10 09:20:08 CDT 2007

Hi,

I am also working with MRMLS and can offer you some advice. They do limit
the rows and will not suspend the limit. You'll find this to be the case
with many mlses, and it's not a problem when they also implement offset.
MRMLS does. You can retrieve the count attribute and construct a loop that
recursively executes your query with offset (e.g. offset=5001) until you
have everything.

Couple other points of frustration with the MRMLS server:

Expressing dates/times in queries in GMT as the spec requires does not work.
You'll end up with a 7 hour (8 in standard time) gap. Apparently you need to
express the times in Pacific Daylight (or Standard, when we fall back) time.

Also, at least with my login, only Active and Contingent statuses are
visible. Therefore changes in status to anything other than that are not
detectable and they give no mechanism for keeping track of that. On some
regular basis you must retrieve the entire set of listings and remove any
from your local store that don't belong. (This is what MRMLS instructed me
to do). Not fun, but I'm not sure how else to deal with that.

Most of this knowledge was gained through trial & error, but I did speak
with MRMLS for clarification on some of it. You can find contact information
at www.imrmls.com.

Good luck.
Tony

> From: Sangeeta Arora - CIPL <sangeeta at classicinformatics.com>
> Date: Tue, 10 Apr 2007 13:20:59 +0530
> To: 'Paul Stusiak' <pstusiak at falcontechnologies.com>
> Cc: <rets-dev at rets.org>
> Subject: RE: [Rets-dev] Problem with Importing Rets (MRMLS)  listings
> 
> Hi Paul,
> 
> Yes, I am getting <MAXROWS/> tag in the last of the data. When I am getting
> <MAXROWS/> tag then it returns only 5000 rows (listings).
> 
> Is this the problem? It means that if I am not getting <MAXROWS/> tag then
> MRMLS returns complete listing. Is this true?
> 
> Regards,
> 
> Sangeeta Arora
> 
> -----Original Message-----
> From: Paul Stusiak [mailto:pstusiak at falcontechnologies.com]
> Sent: Tuesday, April 10, 2007 12:24 PM
> To: Sangeeta Arora - CIPL
> Cc: rets-dev at rets.org
> Subject: Re: [Rets-dev] Problem with Importing Rets (MRMLS) listings
> 
> Most systems do not permit unqualified queries - large row sets. Some
> vendors have implemented the optional RETS parameters of offset while
> others have different methods for pulling such data. Some do not allow
> such types of queries, either for technical reasons or for policy
> reasons. Some systems will deny access to connections that do "nasty"
> requests, those requests that make an unreasonable demand on the system
> or limit such queries to a specific time window.
> 
> You should contact MRMLS to determine what is permitted and how they
> suggest formulating the query for optimum accuracy and performance. I
> suspect that they will provide you with a technique to walk the results
> through multiple requests. On some systems, if it were permitted, your
> request may result in more than 500,000 rows.
> 
> In any case, you should be seeing the <MAXROWS/> tag if you have
> additional records that can't be sent. You didn't say that you were
> getting a 20208 response.
> 
> Again, I believe that you need to contact the MLS directly.
> 
> Paul
> 
> Sangeeta Arora - CIPL wrote:
>> Hi Paul,
>> 
>> I am connecting with the production server. I am also getting the active
>> listings. My problem is that when I am importing the properties then it is
>> not giving the complete list of properties. It gives the old properties
> not
>> the new one. I think, it exceeds the maximum limit to return the listings.
> 
>> 
>> I am using this query.
>> 
>> 
> $query="CLASS=listing_mrmls_$propType&searchtype=Property&querytype=DMQL2&Qu
>> ery=(state=ca)&StandardNames=0&Format=Standard-XML:1.0";
>> 
>> Here, I am importing the properties for MRMLS for CA state and $propType
>> means RESI, RINC etc. It returns me XML.
>> 
>> Thanks,
>> 
>> San
>> 
>> -----Original Message-----
>> From: Paul Stusiak [mailto:pstusiak at falcontechnologies.com]
>> Sent: Tuesday, April 10, 2007 11:25 AM
>> To: Sangeeta Arora - CIPL
>> Cc: rets-dev at rets.org
>> Subject: Re: [Rets-dev] Problem with Importing Rets (MRMLS) listings
>> 
>> I'd suggest that you get in contact with MRMLS to determine the best way
>> to generate queries of the type you need.
>> 
>> Failing that, I'd suggest you contact the vendor.
>> 
>> This list is generally used for questions about RETS and less about
>> questions on specific vendor implementations, although helpful people
>> may answer your questions.
>> 
>> The MLS should be able to get you an implementation guide, direct you to
>> the correct resource or get you in contact with the appropriate
>> resources at the vendor.
>> 
>> As a general observation, your question is not very specific. There are
>> several questions that you should get answered when you speak with the
> MLS.
>>     1. does your access permit you to see the active listings?
>>     2. does the system permit unlimited row-sets (unlikely) and if not,
>> how do you get the information you need?
>>     3. what is the correct field name for the modification timestamp (to
>> get new listings rather than attempting to get them all again and again
>> when nothing has changed)?
>>     4. are you using the correct class and type to get the information?
>> Maybe you are looking at the historical information.
>>     5. are you connecting to a test server or the production server? Not
>> all test servers have listings that look "real".
>> 
>> Failing that, you could use something like Conduit to get some listings
>> and observe what that application does to retrieve them.
>> 
>> Paul
>> 
>> Sangeeta Arora - CIPL wrote:
>>   
>>> Hi, 
>>> 
>>> I am San. I am importing the Rets (MRMLS) properties. But I am getting
>>>     
>> only
>>   
>>> the old ones. Can you please suggest me that how I can import the new
> ones
>>> and all the listings? I am importing it through
>>> http://rets2.mrmlsmatrix.com.
>>> 
>>> Please help me, if you can. It's really urgent for me.
>>> 
>>> Thanks, 
>>> 
>>> San
>>> 
>>> 
>>> 
>>> _______________________________________________
>>> Rets-dev mailing list
>>> Rets-dev at rets.org
>>> http://lists.rets.org/mailman/listinfo/rets-dev
>>> 
>>> 
>>>   
>>>     
>> 
>>   
> 
> -- 
> Paul Stusiak
> Falcon Technologies Corp.
> 
> 
> 
> 
> 
> _______________________________________________
> Rets-dev mailing list
> Rets-dev at rets.org
> http://lists.rets.org/mailman/listinfo/rets-dev