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
-
Carl Wiedemann -
Iain William Wiseman -
Jim Ruby