This is something I have had no experience with whatsoever, so I am hoping that someone can tell me whether it is possible or not.
I have a site up and running, and I am looking at starting a section for people to find holiday properties.
The information of these properties can be accessed via an XML feed of the details and a separate csv of the prices and photos.
The data is presented like so in the XML..
<tcreated>2013-04-09 22:30:26</tcreated> <cweblink>http://www.linhere</cweblink> <nid>55</nid> <nremoteid>0</nremoteid> <tupdated>2013-04-09</tupdated> <cpropname>Brazengate Family Cottage, Long Ashes, Threshfield, Yorkshire Dales (Ref 55)</cpropname> <ccountry>England</ccountry> <carea>Yorkshire Dales</carea> <csubarea>Yorkshire Dales - Wharfedale</csubarea> <short_name>Brazengate</short_name> <cvillagename>LONG ASHES, THRESHFIELD</cvillagename> <nlatitude>54.0789359001</nlatitude> <nlongitude>-2.0351578974</nlongitude> <cpriceinfo>All prices are inclusive of the booking fee.<BR><BR>Winter Short Breaks (WSB) are available at many properties in the "Winter" period - subject to availability. Extra nights are charged pro rata of the weekly rental.<BR><BR>Off Season Breaks (OSB) are available at many properties in parts of the "Low" and "Mid" periods - subject to availability. The price for a 3 night break is either 75% of the normal weekly rental or, if it is higher, the quoted Winter Short Break price. Extra nights are charged pro rata of the weekly rental. OSBs can be booked within a calendar month of the start date of the holiday.<BR><BR>"Last Minute Breaks" (LMB) are available at most properties throughout the "LOW", "MID", "HIGH", "PEAK", "XMAS" and "NEW YEAR" periods. The price for a 3 night break is either 65% of the normal weekly rental or, if it is higher, the quoted Winter Short Break price. Extra nights are charged pro rata of the weekly rental. LMBs can be booked within one week of the start date of the holiday. </cpriceinfo> <nminprice>310</nminprice> <nmaxprice>575</nmaxprice> <nbedrooms>2</nbedrooms> <lkettle>1</lkettle> <lparkingspace>1</lparkingspace> <lsmoking>0</lsmoking> <nsinglebeds>0</nsinglebeds> <ndoublebeds>1</ndoublebeds> <ntwinbeds>1</ntwinbeds> <nbunkbeds>0</nbunkbeds> <nfamilybeds>0</nfamilybeds> <nmaxsleeps>4</nmaxsleeps> <cproppostcode>BD23 5PN</cproppostcode> </cottage>
Now I've seen that there is an add-on called Datagrab, and I am assuming this will be handle this kind of import?
I can see how I can map most of those fields, so that shouldn't be a problem. Where I am a bit unsure is that the images for each entry are stored as urls in a separate csv feed that looks like this...
Now will it be possible to pull those images in the entries that are created via the initial XML import? It would need to match the "nid" custom field (I create) to hold the "nid" value from the XML and match it with the "nid" in the csv image import. Also it would need to order them as per the nPosition value.
I'm hoping this is possible, because there's around 2000 entries that need to be created, and I really do not fancy doing so by hand!