Trouble connecting to a RETS server using php
Posted on 2007-11-13
I am trying to connect to a RETS Server to pull MLS data for a real estate site. I am trying to pull data via a php script that populates the data into a mysql database. All of the images will be put onto our server. Once I am connected I believe that I can deal with the queries to get the data. I finally gave up and downloaded RETS Connector which is a windows based program. I need to come up with a better solution because I am currently downloading all the info from a PC converting it to an xls file, then from the PC to a staging server (Linux) then we sync the directory over to our live server (Linux). After it is on our live server I have a cron job setup to run a php script every night to parse the xls data into a mysql database. The reasoning for all of that is because the RETS Connector program is windows based and all our servers are Linux. Bottom line I need to find a RETS Connection program that we could run from our live Linux server or have a php script to connect. Any help would be appreciated!