Beginning the Build of the Database

[raymondkennedy]

So as I enter the beginning stages of the database build. I am ooking for the best and least redundant way of updating and adding new properties to the DB. Originally I plan on importing the past data into it. After that is complete I just wanted to update and insert new properties and info.

I found a field called "RECORDMODDATE" (ModificationTimestamp). I am assuming that this is changed upon any change made to the listing/record. I will have to verify this with my MLS provider. Ideally that will include all status entry's or modifications.

My intentions are to simply update and/or insert (if mls doesn't exist) my database on a daily or multi-daily basis but only the record/listing that were modified on that date.

Any thoughts or tips before proceeding.

[troydavisson]

I recommend checking out the following tutorial: http://www.flexmls.com/developers/rets/tutorials/how-to-efficiently-replicate-rets-data/

That outlines a few of the steps needed in order to do this efficiently. Those 3 steps should give you all of the information you need in order to add new listings to your database, to update listings in your database that update within the MLS and to remove listings from your database that you should no longer have or show.