Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: XML Import Possiblities

  1. #1
    Join Date
    Apr 2004
    Location
    Midlands UK
    Age
    58
    Posts
    322

    Default

    Hi

    I have been contacted by an agent that wants to add over 4000 properties to my site and I would like to know if there is an import option I can use to import their details. I am told that they currently use an XML file to update there property information on another site. Is there anyway I can use this to import the information into my site. As I dont fancy adding over 4000 properties manually.!! Also could somebody please confirm that OR will opperate correctly with such a large number of properties.

    Any suggestions would be helpfull

    Thanks in advance for any advice.

    Lasor

  2. #2
    Join Date
    Jul 2003
    Location
    California
    Age
    42
    Posts
    4,229

    Default

    You'd have to create an import script to map the data from whatever format file they provide you to the open-realty format.

    Yes Open-Realty can handle 4000 listings
    Open-Realty 2 Documentation

    ~The Difference Between an ORDEAL and an ADVENTURE is ATTITUDE~

  3. #3
    Join Date
    Apr 2004
    Location
    Midlands UK
    Age
    58
    Posts
    322

    Default

    Thanks Mick

    I am guessing that the company currently use a client frontend that they update and then when finshed they publish it to several property listinging databases on the web such as www.primelocation.com, www.kyero.com and www.propertyfinder.co.uk. via a xml file.

    Now if I was to get them to supply a copy of there database on cd and then get a import script written to import the 4000 properties. How would I get around the problem of the site being updated on a daily basis via xml file ?. Is it possible or would I be altering the whole of OR to match their format

    Lasor

  4. #4
    Join Date
    Jul 2003
    Location
    California
    Age
    42
    Posts
    4,229

    Default

    Well first thing you'd want to do is get a copy of their xml file and see what the data looks like... you can write an automated script to import a specific file.. then use a cron job to download the file every day and run the import script at a specific time.... basically the same as idea as the IDX import I'm working on for my wife's site except different format of the data file.
    Open-Realty 2 Documentation

    ~The Difference Between an ORDEAL and an ADVENTURE is ATTITUDE~

  5. #5
    Join Date
    Apr 2004
    Location
    Midlands UK
    Age
    58
    Posts
    322

    Default

    Right I now have an example XML file from the company. now what would be my next move? How would I import that in to OR so that it maps to my fields. I have attached the XML file for anybody to look at and give me some ideas.

    <?xml version="1.0" encoding="iso-8859-1"?>
    <root>
    <property>
    <id>MLSPH10048</id>
    <reference>MLSPH10048</reference>
    <price_freq>sale</price_freq>
    <price>444000</price>
    <type>Penthouse</type>
    <town>Estepona</town>
    <province>Malaga</province>
    <beds>4</beds>
    <baths>3</baths>
    <desc><![CDATA[Alarm System* Conveniently Situated for Golf* Conveniently Situated Schools* Conveniently Situated Tennis* Good Rental Potential* Good Road Access* Lift* Prestigious Area* Quiet Location* Satellite TV* Sunny terraces* Walking Distance to Beach* Walking Distance to Rest.* Well presented]]></desc>
    <internalId>MAAAAP5084</internalId>
    <pool>Communal Pool</pool>
    </property>
    <property>
    <id>A1006</id>
    <reference>A1006</reference>
    <price_freq>sale</price_freq>
    <price>140000</price>
    <type>Penthouse</type>
    <town>Manilva</town>
    <province>Malaga</province>
    <beds>1</beds>
    <baths>1</baths>
    <desc><![CDATA[Alarm System* Roof Terrace* Rooms individually heating* Satellite TV]]></desc>
    <internalId>MABAEP1038</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View Of Block</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>View From Roof Terrace</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Communal Pool</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>View From Terrace</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Sitting Room</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Kitchen</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>Bedroom</image7_description>
    <image8><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image8>
    <image8_description>Bathroom</image8_description>
    <pool>
    </pool>
    </property>
    <property>
    <id>MLSPH15308</id>
    <reference>MLSPH15308</reference>
    <price_freq>sale</price_freq>
    <price>260000</price>
    <type>Penthouse</type>
    <town>Calahonda</town>
    <province>Malaga</province>
    <beds>2</beds>
    <baths>2</baths>
    <desc><![CDATA[Air conditioning Hot/Cold* Conveniently Situated for Golf* Fireplace* Fitted Cupboards* Good Rental Potential* Good Road Access* Lift* Lounge Dining Area* Marble Floors* Penthouse* Popular Urbanisation* Roof Terrace* Satellite TV* Sunny terraces* Utility Room* Walking Distance to Rest.* Walking Distance to Shops]]></desc>
    <internalId>MAAAAP9608</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of complex</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>Roof terrace</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Lounge</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Kitchen</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Bedroom</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Bathroom</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>View from property</image7_description>
    <pool>Communal Pool</pool>
    </property>
    <property>
    <id>MLSA16334</id>
    <reference>MLSA16334</reference>
    <price_freq>sale</price_freq>
    <price>250000</price>
    <type>Apartment</type>
    <town>Benalmadena Costa</town>
    <province>Malaga</province>
    <beds>2</beds>
    <baths>2</baths>
    <desc><![CDATA[Air conditioning Hot/Cold* Built to High Standards* Conveniently Situated for Golf* Easy Renting* Excellent Condition* Exclusive Development* Good Road Access* Popular Urbanisation* Prestigious Area* Quality Residence* Quiet Location* Well maintained community* Well presented]]></desc>
    <internalId>MAAAAP9712</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of complex</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>Construction</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>View of complex</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Floor plan</image4_description>
    <pool>Communal Pool</pool>
    </property>
    <property>
    <id>MLSPH16336</id>
    <reference>MLSPH16336</reference>
    <price_freq>sale</price_freq>
    <price>231000</price>
    <type>Penthouse</type>
    <town>Benalmadena Costa</town>
    <province>Malaga</province>
    <beds>3</beds>
    <baths>2</baths>
    <desc><![CDATA[Built to High Standards* Conveniently Situated for Golf* Double Glazing* Good Rental Potential* Good Road Access* Ideal Family Home* Lounge Dining Area* Marble Floors* Popular Urbanisation* Spacious Accomodation* Stylish Accomodation* Tastefully Decorated* Walking Distance to Beach* Walking Distance to Rest.* Walking Distance to Shops* Walking Distance to T. Centre* Well maintained community* Well presented]]></desc>
    <internalId>MAAAAP9777</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of complex</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>View of complex</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Complex and view</image3_description>
    <pool>Communal Pool</pool>
    </property>
    <property>
    <id>MLSV17108</id>
    <reference>MLSV17108</reference>
    <price_freq>sale</price_freq>
    <price>2300000</price>
    <type>Villa</type>
    <town>Benahavís</town>
    <province>Malaga</province>
    <beds>6</beds>
    <baths>6</baths>
    <desc><![CDATA[Air conditioning Hot/Cold* Alarm System* Fireplace* Immaculate Condition* Independent Apartament* Jacuzzi* Quiet Location* Walking Distance to T. Centre* Well presented]]></desc>
    <internalId>MAAAAP9794</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of property</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>View of complex</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>View of property</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Lounge</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Dining area</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Kitchen</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>Bedroom</image7_description>
    <image8><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image8>
    <image8_description>Bathroom</image8_description>
    <pool>Private</pool>
    </property>
    <property>
    <id>MLSTH15315</id>
    <reference>MLSTH15315</reference>
    <price_freq>sale</price_freq>
    <price>235000</price>
    <type>Townhouse</type>
    <town>Calahonda</town>
    <province>Malaga</province>
    <beds>2</beds>
    <baths>1</baths>
    <desc><![CDATA[Close to all Amenities* Conveniently Situated for Golf* Fitted Cupboards* Good Rental Potential* Good Road Access* Marble Floors* Sunny terraces* Walking Distance to Rest.* Walking Distance to Shops* Walking Distance to T. Centre]]></desc>
    <internalId>MAAAAP9796</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of complex</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>View from property</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Lounge</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Kitchen</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Bedroom</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Bedroom</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>Bathroom</image7_description>
    <pool>Communal Pool</pool>
    </property>
    <property>
    <id>MLSV10212</id>
    <reference>MLSV10212</reference>
    <price_freq>sale</price_freq>
    <price>650000</price>
    <type>Villa</type>
    <town>Manilva</town>
    <province>Malaga</province>
    <beds>4</beds>
    <baths>4</baths>
    <desc><![CDATA[Condition - Good* Conveniently Situated for Golf* Dining Room with Fireplace* Fireplace* Good Rental Potential* Good Road Access* Ideal Family Home* Investment Property* Marble Floors* Popular Urbanisation* Private Terrace* Quiet Location* Satellite TV* Sunny terraces* Well presented]]></desc>
    <internalId>MAAAAP9839</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of property</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>View of property</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Lounge</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Bedroom</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Bedroom</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Independent apartment</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>View from property</image7_description>
    <image8><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image8>
    <image8_description>View from property</image8_description>
    <pool>Private</pool>
    </property>
    <property>
    <id>MLSA22031</id>
    <reference>MLSA22031</reference>
    <price_freq>sale</price_freq>
    <price>330000</price>
    <type>Apartment</type>
    <town>Estepona</town>
    <province>Malaga</province>
    <beds>4</beds>
    <baths>2</baths>
    <desc><![CDATA[Conveniently Situated for Golf* Conveniently Situated Schools* Fireplace* Lounge Dining Area* Marble Floors* Pre install Alarm* Pre-installed Air-Conditioning* Pre-installed Heating* Quiet Location* Satellite TV* Walking Distance to Rest.* Walking Distance to Shops* Walking Distance to T. Centre]]></desc>
    <internalId>MAAAAP9844</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of complex</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>Lounge</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Kitchen</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Bedroom</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Bathroom</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Floor plan</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>Floor plan</image7_description>
    <image8><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image8>
    <image8_description>Layout</image8_description>
    <pool>Communal Pool</pool>
    </property>
    <property>
    <id>MLSF22039</id>
    <reference>MLSF22039</reference>
    <price_freq>sale</price_freq>
    <price>495000</price>
    <type>Finca</type>
    <town>Estepona</town>
    <province>Malaga</province>
    <beds>3</beds>
    <baths>2</baths>
    <desc><![CDATA[Fireplace* Fruit Trees* Good Road Access* Lounge Dining Area* Possibility of extension* Private pool* Quiet Location* Satellite TV* Sunny terraces* Very Good Access* Walking Distance to Beach* Water Deposit]]></desc>
    <internalId>MAAAAP9850</internalId>
    <image1><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image1>
    <image1_description>View of property</image1_description>
    <image2><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image2>
    <image2_description>Lounge</image2_description>
    <image3><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image3>
    <image3_description>Kitchen</image3_description>
    <image4><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image4>
    <image4_description>Bedroom</image4_description>
    <image5><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image5>
    <image5_description>Bathroom</image5_description>
    <image6><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image6>
    <image6_description>Bedroom</image6_description>
    <image7><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image7>
    <image7_description>Patio</image7_description>
    <image8><![CDATA[http://mlsdata.mercuryin.es/thumb/st...pg]]></image8>
    <image8_description>View from property</image8_description>
    <pool>Private</pool>
    </property>
    </root>

    Regards

    Lasor[/code]

  6. #6
    Join Date
    Apr 2004
    Location
    Midlands UK
    Age
    58
    Posts
    322

    Default Any Advice ???

    Hi
    has anybody got close to excepting xml files as a way of importing or updating database.

    I now have several major companies that say they would like to add my site to their xml export.

    If I could crack this one it could mean major things for my site, which of course translate to major donations to OR.

    The agents all seem to be using the same 3 sites www.primelocation.com, www.kyero.com and www.propertyfinder.co.uk and at the click of a button their properties are uploaded or updated on all 3 sites using an xml file similar to the one I have listed above.

    If anybody could assist on this I would very much appreciate it.

    Lasor

  7. #7
    Join Date
    Jul 2004
    Location
    Southwest Florida
    Posts
    65

    Default

    There's a good explanation of using php to parse xml files on Apple's Developer Site (applicable to xml and php in general, not Mac-specific). There are several different methods discussed.

    Once you have the xml file parsed properly, you'd probably need to do some data manipulation to make the xml data match the O-R database structure -- make sure stuff that goes in the db as an array is an array, text fields are text, number fields are numbers, and so on.

    Then you'd need to create the actual INSERT statements to put all the xml data into the correct fields in the db.

    You'd create a php script to do all this.

    Then ideally you'd want to set up a cron job to automatically download the xml file (if that's allowed by whoever you're getting it from), and then run the php script. You'd set up the cron job to do this on whatever schedule you wanted -- daily, hourly, twice a day, or whatever. Or you could create a button that would do it at the "click of a button," which sounds cool but it's actually better if it happens automatically without any user intervention.

    I'm probably going to be looking at doing something like this later this year.
    Sonja Ray

  8. #8
    Join Date
    Apr 2004
    Location
    Midlands UK
    Age
    58
    Posts
    322

    Default

    Thanks Sonjay.

    It all sound very interesting..Very confusing ..But very interesting.

    The fact that it does seem possible is encouraging, and I intend to ivestigate the possiblity further.

    I would be grateful for any other feedback regarding this option, as I feel if it is created it could be a valuable asset to a lot of property website owners, especially over here in Europe.

    Lasor

  9. #9
    Join Date
    Jul 2004
    Location
    Southwest Florida
    Posts
    65

    Default

    Further investigation has revealed that there's a program called Navicat that claims to be able to import xml files into a MySQL database. I haven't looked at it, but it sounds like it might be worth looking into.
    Sonja Ray

  10. #10
    Join Date
    Apr 2004
    Location
    Midlands UK
    Age
    58
    Posts
    322

    Default

    Hi Sonjay

    I had a look at the demo of Navicat. However I fell at the first hurdle, I could not connect to my database. It does sound like an interesting program and may even be capable of doing what I want it to??? May be I will give it another try? If anybody knows of any simular programs then please let me know

    Lasor

Similar Threads

  1. MLS Import Project
    By frobn in forum Feature Request (CLOSED)
    Replies: 9
    Last Post: 03-30-2005, 05:16 PM
  2. mls import
    By virtualgeorge in forum Work
    Replies: 3
    Last Post: 10-01-2004, 03:46 AM
  3. Concept for MLS import
    By frobn in forum Mods (CLOSED)
    Replies: 17
    Last Post: 09-15-2004, 10:26 AM
  4. Import MLS IDX format
    By Denver Dave in forum General Discussion
    Replies: 29
    Last Post: 03-02-2004, 04:59 PM
  5. Remove Import MLS
    By NYColt in forum General Discussion
    Replies: 1
    Last Post: 01-13-2004, 05:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •