Posted by telcopolis on August 18, 2009 at 11:03am
I want to import CSV rate tables of various supliers into a database.
So it will be possible to search and compare for destinations provided by several supliers.
Is there a way to do this in Drupal?
Comments
*_*
Nop
You have to write your own Drupal script.
No ready-made script will know what are the fields and where to import those data in what tables.
Regards.
:)
Beautifulmind
You can use the Tablemanager
You can use the Tablemanager module to import and display csv files. Unfortunately the Drupal 6 version is still in dev but it does work...
Obviously you won't be able to do much more than standard column sorting seeing as it's just a simple display module but as the above poster said, you'd need something specific for your task to accomplish this.
Pobster
Importing CSV content
Hi,
There is a module for one-off imports that can deal with CSV data: http://drupal.org/project/node_import
Generally I use it when setting up a site, if i need to import existing data as nodes. It works fine for that, and it allows you to map the CSV columns to your CCK fields. However, it isn't designed to import new data automatically, or update existing nodes, so while you could use it to get started, it probably isn't suitable for updating your site.
One module that is designed to pull in data from external sites and add it as nodes is the FeedAPI module: http://drupal.org/project/feedapi. While the base module is designed for pulling in data from RSS feeds, it looks like there's a plug-in for parsing CSV data: http://drupal.org/project/parser_csv, so you might be able to get things working with that. Haven't tried it myself, so do post back and let us know if it worked.