We are pleased to announce the release of a new tool that can be used to access listing information with the RETS protocol. RETS is the Real Estate Transaction Standard maintained by the RETS Working Group.
Although the tool is not complete yet, the consensus of people who saw it early was that there is enough there to release. RETS-based listing data can be stored in one of four formats:
- Comma-Separated Value (CSV)
- Single table in a Relational Database (RDB)
- Open-Realty 2.0 (OR) database format
This release only supports OR format and text data for the RDB format. Although both of these options use relational databases, the OR option uses a meta approach whereas the RDB option puts all of the data for a listing in a single row. With RDB, if you download 45 fields, your table will have 45 columns. These are the two most difficult options so development should be rapid from this point forward.
VieleRETS is written in PHP an uses the ADOdb project that Ryan Bonham turned me on to. This is a great project if you want to develop PHP that uses the “exact same code” to make connections to any of the following databases:
- MS SQL
- SAP DB
- generic ODBC
If you want to support multiple databases and don’t want to be bothered figuring out the “connect” strings, ADOdb is for you. You will still need to respect differenced in SQL syntax though.
The web page for the VieleRETS project includes down-loadable code, support links and an on-line version of the documentation. A mailing list for VieleRETS can be found at http://mail.crt.realtors.org/mailman/listinfo/viele-dev.
Look for updates to this project soon!