Ask Your Question

Help In Process From RETS to Front On website

asked 2018-04-14 13:09:18 -0500

Nad gravatar image

Hi I am getting website developed, i think for developer guy this is first time to develop real estate website with RETS? I have got him user, password credential from real estate board and also got info how to login " core logic " RETS Connector. But he is complaining that " i am try to save data locally ,but its not saving " . I believe he doesn't know how to save data ? what is required to to make it happen. i did research and found that you must have matrix or rows /columns or some tool to place the data locally?? i dont know i am realtor?

I appreciate if you can help me step by step or what steps are involved to bring everything on website display.

"" "Website is in core PHP"

Thanks In Advance


edit retag flag offensive close merge delete


RETS Connector will download the fields you tell it to in a CSV or tab delimited file, as well as the pictures for each listing. Your programmer will need to then read that data into whatever local database you use on your webserver. MLS queries on your website will query the local database not RETS

Shawn Anderson gravatar imageShawn Anderson ( 2018-04-25 09:33:56 -0500 )edit

3 Answers

Sort by ยป oldest newest most voted

answered 2018-08-09 06:11:04 -0500

updated 2018-08-09 07:06:16 -0500


Black Knight Financial Services, maker of Paragon, has stated in this post, that they support 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; 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.


  • 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.


  • RESO WEB (PHP) -- easy to use, lighter code base --'s current and going-forward standard.
  • phRETS (PHP) -- easy to use, heavier code base. Based on'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.
edit flag offensive delete link more

answered 2018-04-23 22:53:20 -0500

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.

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 to see the column prefixes.

edit flag offensive delete link more

answered 2018-04-16 14:14:50 -0500

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-14 13:09:18 -0500

Seen: 611 times

Last updated: Aug 09 '18