Wayne, I spent over 5 years working with Real Estate data and the RETS servers. The misfortunate part of RETS is that there is NOT a standard. Every MLS market implements RETS differently. I've written a RETS client in ColdFusion once. It's market specific and the client owns the code. The best I can suggest is to look at phRets and decided if you want to use that or rewrite that to ColdFusion.
The thing to remember it that it's all XML. NExt you have to make http calls to get the meta data, then parse that out then do another http call to get the next level meta data and parse that out. You keep doing this until you have all the meta data that describes the entire data structure. Then create the structure in your DB. Then you start doing http calls to get the data. If the market is a large MLS market, you may have problems with memory limits in the JVM. I've had to run upwards of 4Gb or more in the heap and setup fairly aggressive garbage collections. Your server side needs to be fast. The process of RETS means the code will be running for maybe an hour or more (depending on the data set) and could be making hundreds of HTTP calls. Getting images is almost as fun. But I found I could get them with ColdFusion via RETS and save them to a drive rather quickly. The data is in binary format and may not seem obvious at first when you make the first RETS object call. But ColdFusion will process the data and you can save the image. I just looked in my "junk" code folder where I keep all sorts of test code snippets. I found some RETS test code that may help you. I'll send it privately. Good Luck! Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com [email protected] www.trunkful.com On Aug 6, 2011, at 2:36 PM, Wayne Gregor wrote: > > I need to convert over a couple of real estate website that > are currently receiving MLS data via an hourly FTP feed. > The new system handed down by the National Association of > Realtors is RETS <http://www.rets.org/>. > > Do any of you know if there are any CFC functions out there > that would make it easier for me to interface with this new > system? > > > -- > *Wayne Gregori* > Office: 510-895-1066 > Cell: 510-219-3887 > [email protected] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
