First time here? Check out the FAQ!

Help In Process From RETS to Front On website

  • retag add tags

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


Nad's avatar
asked 2018-04-14 13:09:18 -0500
edit flag offensive 0 remove flag 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's avatar Shawn Anderson (2018-04-25 09:33:56 -0500) edit
add a comment see more comments

3 Answers


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.

unomateo's avatar
answered 2018-04-23 22:53:20 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments

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.

bwolven's avatar
answered 2018-04-16 14:14:50 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments


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.
DACO's avatar
answered 2018-08-09 06:11:04 -0500, updated 2018-08-09 07:06:16 -0500
edit flag offensive 0 remove flag delete link


add a comment see more comments

Your Answer

Login/Signup to Answer