Funny/Weird Bug

16 views
Skip to first unread message

Gregory Moore

unread,
Nov 23, 2009, 12:46:18 PM11/23/09
to phr...@googlegroups.com
I just want to know if this has ever happen to anyone.

Client called about a new listing she had entered in to MLS last week.
But the listing was not showing up on her personal site.
So, I did some research and sure enough it wasn't there. I verified
the listing with the local board just so I would not be chasing my tail.

I manually started the phRETS (as opposed to cron job) to run it's
update. The new listing never came up.

So, I updated the script to just pull in that one listing, and BOOM,
there it was!!!

This has never happened to me before.

Can anyone think of maybe what could be wrong? Maybe a weird character
of some sort on the input side?

I have no clue!

Thanks!

Gregg


Troy Davisson

unread,
Nov 23, 2009, 1:03:19 PM11/23/09
to phr...@googlegroups.com
In the normal process, do you have it set to download all listings or are you doing incremental updates based on a modification timestamp?  Can you provide the query you're using for those pulls?

It's not totally uncommon for a listing to be missed in an incremental update type of situation but missing a list when you're doing full downloads is kind of weird.

I suspect that if you had a strange character causing the issue with that listing (in a full download), you'd run into the same thing pulling it individually so I don't think it's an issue with PHRETS directly.






--

You received this message because you are subscribed to the Google Groups "PHRETS" group.
To post to this group, send email to phr...@googlegroups.com.
To unsubscribe from this group, send email to phrets+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/phrets?hl=.



Gregory Moore

unread,
Nov 23, 2009, 1:11:06 PM11/23/09
to phr...@googlegroups.com
Hey Troy,

I am doing incremental updates based on a modified timestamp. I even went as far as setting the time to 2000-10-00....

Hey is the query copied from the script:



$search = $rets->SearchQuery("Property","{$class}","(MLNumber=" . $last_mls . "+),(LastModifiedDateTime=" . $process_date . "+)");

Class would equal resi, lotl, mult, etc...  
My process date would pull from a table that is updated after the previous run.


Let me know if you need anything else!

Gregg

bautes

unread,
Nov 23, 2009, 5:38:23 PM11/23/09
to PHRETS
Sorry I involve on this, I couldn't keep me out.
My batch process do almost the same thing but it only verifies for the
last update on LastModifiedDataTime field. I keep the last one
(greater one) on a system configuration table and it's used again to
start next batch process.
The only difference is on the MLS # field you use. I heard that rets
don't return a sorted data and even if they do it, I'm going to need
to get updates from "old" properties also (ex. L_Status. "active" to
"sold").


If I'm wrong please let me know.

bautes.

On 23 nov, 15:11, Gregory Moore <gregg.moor...@gmail.com> wrote:
> Hey Troy,
>
> I am doing incremental updates based on a modified timestamp. I even  
> went as far as setting the time to 2000-10-00....
>
> Hey is the query copied from the script:
>
> $search = $rets->SearchQuery("Property","{$class}","(MLNumber=" .  
> $last_mls . "+),(LastModifiedDateTime=" . $process_date . "+)");
>
> Class would equal resi, lotl, mult, etc...
> My process date would pull from a table that is updated after the  
> previous run.
>
> Let me know if you need anything else!
>
> Gregg
>
> On Nov 23, 2009, at 1:03 PM, Troy Davisson wrote:
>
>
>
> > In the normal process, do you have it set to download all listings  
> > or are you doing incremental updates based on a modification  
> > timestamp?  Can you provide the query you're using for those pulls?
>
> > It's not totally uncommon for a listing to be missed in an  
> > incremental update type of situation but missing a list when you're  
> > doing full downloads is kind of weird.
>
> > I suspect that if you had a strange character causing the issue with  
> > that listing (in a full download), you'd run into the same thing  
> > pulling it individually so I don't think it's an issue with PHRETS  
> > directly.
>
> > On Mon, Nov 23, 2009 at 12:46 PM, Gregory Moore <gregg.moor...@gmail.com
Reply all
Reply to author
Forward
0 new messages