Project Description:
Looking for a php script to clean up local db from a rets data feed (XML feed), Have script in hand to get the data but now need one to clean up the data base (i.e. data pull from remote server would return data that I can have n local db and remove the ones I can't on local db).
Below is more or lees what I need. The script will need to query the remote server and check it with my local db if row is not in visible in remote server it would change the status of the row in the local db. Please note that their is more then one data feed going into db so some more fields will need know in script to only change the rows for that feed
Run a cleaning process to purge out “old” records
Often times, your RETS access will not have access to retrieve all available records. For example, you may only be able to view status active records. Running incremental updates as described in Step 2 will only return records that 1) have changed since the given time, and 2) you’re able to see. If, for example, a property was changed from status active to status pending, the modification timestamp is updated, but, since you’re not allowed to see records of that status, you won’t see that record in your incremental downloads (and don’t know to remove it from your local database).
In order to make sure your local database reflects accurate information (including updates to records you can no longer see), a cleaning process is needed to purge out those “old” records. Rather than trying to gain access to something telling you about the listings you can no longer see, the reverse process will tell you what you need to know using the access you already have: the RETS server tells you about properties you SHOULD have, so if you have a record that’s not in that list from the RETS server, you know it needs to be deleted from your local database.
The description is a bit vague, but seems an easy job. If you select me, please let's have a quick chat to make sure I understand correctly so I give you the correct script. If you have a server we can test it there, if not then we can test it on my server, I've mysql+php on there.