Posted by Nolan on January 30, 2010 at 12:30pm
Hi,
Does anyone have any experience with integrating csv files with Drupal? I wish to do the following and wish to know if it is possible and if so what the best practive would be - I have a csv file that contains details about properties e.g. price, no. of rooms, location, description etc. and wish to import this information into a node called property. The csv file will be changing on a daily basis, I would therefore like to schedule the import into drupal on a daily basis.
Any advice greatly appreciated.
nolan.
Comments
node import
I've only written modules from scratch to do it but there's other options out there - have you tried
http://drupal.org/project/node_import
http://drupal.org/project/tw
http://drupal.org/project/migrate
Re: integrating csv files with drupal
As mentioned already, "migrate" is what you need. It has the ability to do scheduled updates. IMHO, "migrate" is one of the top underappreciated modules in the Drupal ecosystem.
Import of Excel is possible
Hi,
use dbTube.org to import Excel files into your database. You can "draw" your import
and reuse the import defintion.
greetings
Andreas