Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By ginga8 on
I am working on a project that requires data be importing into the Drupal database from an XML file. On a nightly basis, we need to check the XML file to see if any records have changed and if so update Drupal accordingly.
Is their something out there that will do this?
Comments
An 'XML import' is a very
An 'XML import' is a very broad description for what you need to do, so it's hard to say if there are modules that could do (at least a part of) the job.
Depending on your situation (can you code php?), it might not be really hard to write a custom module for this. you would have to write an import script (probably using Drupal API functions to write the data to the database) and implement hook_cron to make sure it runs on cron jobs.
New information
We have got further details on the situation that the client is looking for.
They would like to capture the feed live on the site and not store it in the database.
Example of this would be going to the website and landing on a page that is to display information on cottages. The page would call the feed and pull in all information from the XML feed. So every time someone visits the page the XML is called. The XML feed has many fields of information. We will probably style it using XSTL.
Can someone point me in the right direction.
Example URL
http://search.domain.com/accommodations/opSearch.php?language=english&li...
Thanks
OK, I see. I think there are
OK, I see. I think there are quite some modules that work with xml parsing and import, but I don't know which is the best for your situation. Some links:
http://drupal.org/project/feedme (drupal 5 onlt at the moment)
http://drupalmodules.com/search/node/xml
http://groups.drupal.org/node/21338
Just pull the content
Thanks for the help, is there anything to just pull the content in and display and not store it in the Drupal DB. I may have to just write straight PHP to do this.
You can write a little xml
You can write a little xml parser module that will do this fairly easy. There's even an example in the book Learning Drupal Module Development in on of the earlier chapters.
Contact me to contract me for D7 -> D10/11 migrations.