VieleRETS + Node Import

Events happening in the community are now at Drupal community events on www.drupal.org.
webavant's picture

Hi folks! Well I have recently had tremendous success in importing extracted data from VieleRETS to Drupal nodes. Thanks to the amazing Node Import module, I was also able to pull the geographical latitude and longitude fields into Location module's fields and images into imagefield module's fields. I'm still learning the nuances of the Node Import modules, so I will be trying to learn how to update existing listings and remove expired listings in an automated fashion. If anyone is interested in sharing some tips or learning how I am doing this, feel free to ask questions. I am also on #drupal on freenode irc (with all the other wonderful drupal heads). At some point, I would like to document the process for others to utilize.

Comments

I should also mention that I

webavant's picture

I should also mention that I was rather optimistic about using Feeds or Feed API to import the XML exported by VieleRETS. Having found no way to import images into imagefield fields, I abandoned the effort in favor of using Node Import to pull in the CSV exported from VieleRETS which I had to massage using a custom Perl script.

Hello

tevih's picture

Hi webavant,

I'm sticking my toes in the water getting into real estate websites, since a friend asked me if I could help him. Can you get a little most specific about how you are importing RETS?

What I'm envisioning is creating a "property" content type, and importing mls data using node import to the same content type. Is that how it works? Also, how do you update all the imported content to reflect live changes on the MLS?

Thanks!

Sorry for the delayed

webavant's picture

Sorry for the delayed response. I was using VieleRETS to export to CSV, then importing to Drupal using the nodeimport module. I have since abandoned my efforts, but I am sure you could easily replicate the system.

Import

bkelly's picture

Hi tevih -

I use a custom import script that works in three stages.

  1. Process the xml into an import table.
  2. Every minute I process a set of listings, (10).
     • Import/update the agent.
     • Import/update the agency.
     • Import/update the listing and images.
  3. Clean up the expired agents, agencies, listings and flush the import table.

For a site with 20,000+ listings this takes us about 36 hours. Here's a URL to one of the sites that's using this approach: www.mainehomes.com

I hope that helps.

Have Fun - Bill

Those who will not reason, are bigots.
Those who can not, are fools.
Those who dare not, are slaves. - Lord Byron

Real Estate

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: