Solved

Trouble connecting to a RETS server using php

Posted on 2007-11-13
2
1,536 Views
Last Modified: 2008-09-15
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!
0
Comment
Question by:tech1984
  • 2
2 Comments
 
LVL 5

Accepted Solution

by:
administradores earned 500 total points
ID: 20275656
This is a complete script that can pull data from RETS and you can learn from there.

http://www.crt.realtors.org/projects/rets/viele/index.html
0
 
LVL 5

Expert Comment

by:administradores
ID: 20275694
Also if you need any help with the code or something don't hesitate to ask.

I posted the above php app because is more complete than any code i can provide.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose. It turns out that Yaho…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now