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 Cabralgmcabral@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/ ]
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.comwrote:
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 Cabralgmcabral@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.