Help In Process From RETS to Front On website

edit

Sounds like your developer need to create the tables properly. There is a lot of data that is returned so the tables will be very large.

here is the script to create the tables based of the information returned. https://github.com/troydavisson/PHRET...

this will create database tables with a lot of columns and make it very slow. I ended up parsing the tables based on the prefix. L_, LM_, LFD_ etc.. This will make the queries much faster since the majority of info that you want to display will be in the L_ table.

Have your developer look at retsmd.com to see the column prefixes.

Not sure what you are looking for. Normally a vendor would use some sort of RETS application to pull data or a RETS library included in their application to access the data. Since you say you are using PHP, you can use the PHRETS library for RETS access. There is also some usage documentation on the GitHub site.

https://github.com/troydavisson/PHRETS

PHP DEVELOPER OPTIONS

Black Knight Financial Services, maker of Paragon, has stated in this post, that they support RESO.org protocols. If your developer is just getting started, I would recommend RESO WEB 2.0 (PHP) over the phRETS (PHP) framework. phRETS is a great framework and I do currently use phRETS.

However, I am switching to RESO WEB 2.0 for two reasons:

1. it is the forward direction of RESO.org; AND
2. it is a much lighter code base than phRETS, which visitors to your website will appreciate.

That said, either will work beautifully for your PHP developer.

RETS / RESO CODING TIPS

• The key to fast queries, is in the design of the query itself (queries use DMQL)
• Query the minimum amount of data fields you need.
• Use pagination.

CODE RESOURCES (GitHub)

• RESO WEB (PHP) -- easy to use, lighter code base -- RESO.org's current and going-forward standard.
• phRETS (PHP) -- easy to use, heavier code base. Based on RESO.org's legacy RETS protocol standards.
• RETSMD.COM -- for testing access credentials and easy to read data schema. RETSMD uses phRETS, and is a good code example of how well the phRETS code base works.