Import data or create nodes from Excel
Hi! I would like implement a functionality in a web site for able to upload an excel file, with a determined format, and then, I want to generate nodes with this information. Exists a module or a medium to do that? or how can i insert data into drupal database from an excel file? thanks a lot
The most likely starting point would be node_import: http://www.drupal.org/project/node_import It will not handle Excel files natively however--you will need to have them available as CSV files. If that is not possible for what ever reason, you may look into a tool which converts between the formats (there are a few ways to do this in the unix world, including one direct xls2csv program, although I do not know what package it is a part of). Luke On Thu, 30 Jul 2009, Gustavo Cabral wrote:
Hi!
I would like implement a functionality in a web site for able to upload an excel file, with a determined format, and then, I want to generate nodes with this information. Exists a module or a medium to do that? or how can i insert data into drupal database from an excel file?
thanks a lot -- [ Drupal support list | http://lists.drupal.org/ ]
Hi. Take a look at the node_import module. We use it on a number of sites to do mass import of nodes for club and event listings. Still has some nuances to it but overall it gets the job done. http://drupal.org/project/node_import Blessings, Tom On Thu, Jul 30, 2009 at 6:05 PM, Gustavo Cabral <gmcabral@gmail.com> wrote:
Hi!
I would like implement a functionality in a web site for able to upload an excel file, with a determined format, and then, I want to generate nodes with this information. Exists a module or a medium to do that? or how can i insert data into drupal database from an excel file?
thanks a lot -- [ Drupal support list | http://lists.drupal.org/ ]
The node import advice you received so far is great. Another potential solutions is the combination of Table Wizard and Migrate modules http://drupal.org/project/tw http://drupal.org/project/migrate These were recently discussed on the Civic Actions blog: http://civicactions.com/blog/2009/jul/25/migrating_your_website_drupal There's also a whole discussion on the topic comparing options at http://groups.drupal.org/node/21338 And a group for discussing them at http://groups.drupal.org/content-migration-import-and-export There are tons of resources for this topic, but it's still relatively hard to do the work itself. Regards, Greg On Thu, Jul 30, 2009 at 5:05 PM, Gustavo Cabral<gmcabral@gmail.com> wrote:
Hi!
I would like implement a functionality in a web site for able to upload an excel file, with a determined format, and then, I want to generate nodes with this information. Exists a module or a medium to do that? or how can i insert data into drupal database from an excel file?
thanks a lot -- [ Drupal support list | http://lists.drupal.org/ ]
-- Greg Knaddison | 303-800-5623 | http://growingventuresolutions.com Cracking Drupal - Learn to protect your Drupal site from hackers Now available from Wiley http://crackingdrupal.com
Excellent summary, Greg! Also, feedapi and the field mapper with the csv parser !!! Victor On Fri, Jul 31, 2009 at 9:54 AM, Greg Knaddison <greg.knaddison@gmail.com>wrote:
The node import advice you received so far is great.
Another potential solutions is the combination of Table Wizard and Migrate modules
http://drupal.org/project/tw http://drupal.org/project/migrate
These were recently discussed on the Civic Actions blog:
http://civicactions.com/blog/2009/jul/25/migrating_your_website_drupal
There's also a whole discussion on the topic comparing options at http://groups.drupal.org/node/21338
And a group for discussing them at http://groups.drupal.org/content-migration-import-and-export
There are tons of resources for this topic, but it's still relatively hard to do the work itself.
Regards, Greg
On Thu, Jul 30, 2009 at 5:05 PM, Gustavo Cabral<gmcabral@gmail.com> wrote:
Hi!
I would like implement a functionality in a web site for able to upload an excel file, with a determined format, and then, I want to generate nodes with this information. Exists a module or a medium to do that? or how can i insert data into drupal database from an excel file?
thanks a lot -- [ Drupal support list | http://lists.drupal.org/ ]
-- Greg Knaddison | 303-800-5623 | http://growingventuresolutions.com Cracking Drupal - Learn to protect your Drupal site from hackers Now available from Wiley http://crackingdrupal.com -- [ Drupal support list | http://lists.drupal.org/ ]
Greg! thanks a lot, Now I have to work hard and try to learn about this, je. Your help was really great to my work. I want just can say thanks to all of you guys, and I hope I be able to help you guys someday like you all do it to me. Bye! Gustavo.
participants (5)
-
Greg Knaddison -
Gustavo Cabral -
Luke -
Tom Lucas -
Victor Kane