Drupal7 Import excel sheet into database
Hi Everyone, Firstly hope I have the right forum. I have a excel spreadsheet each month which contains membership data. I want to upload this to a table which I have created in my module. I have googled a bit to try and understand the best way to do this but am still unclear. Ideally I would like to provide a screen with Year Month File path Browse Button (Which I have done) How do I get the data from the excel and into the table? As I say this will be done once a month and will probably want to rollback. Thanks, Iain
You may want to consider using something like http://drupal.org/project/feeds
Could this export my nodes too? I hve three different type nodes I made under drupal 7 and I would love to get them in to .csv format and be able to import them back either on same or another site. Follow me on: Twitter: http://twitter.com/1rubytweets Facebook: http://www.facebook.com/profile.php?id=1058306793 Join me on: Yahoo: jruby6767 Msn: jruby@charter.net -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Carl Wiedemann Sent: Tuesday, August 30, 2011 12:01 AM To: support@drupal.org Subject: Re: [support] Drupal7 Import excel sheet into database You may want to consider using something like http://drupal.org/project/feeds
On 30/08/2011 5:00 p.m., Carl Wiedemann wrote:
You may want to consider using something like http://drupal.org/project/feeds
I am looking at this at the moment. Not sure yet whether I can make feeds use my table or not. Otherwise I will need to change all of my screens to use whatever it stores the data in. Also I believe this does not support excel at this time. I will create a feed today and (no pun intended) feed back. Iain
participants (3)
-
Carl Wiedemann -
Iain William Wiseman -
Jim Ruby