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

Tue Apr 10 09:24:57 CDT 2007

sidenote: MRIS also has a great forum hinged all around their RETS support:
http://forums.mris.com/forums/categories.cfm?catid=7&entercat=y

On 4/10/07, Tony Manhollan <tony at realestatepointe.com> wrote:
> 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
>
> _______________________________________________
> Rets-dev mailing list
> Rets-dev at rets.org
> http://lists.rets.org/mailman/listinfo/rets-dev
>