0

I'm ultimately needing a way to regularly upload and parse through a multi-page spreadsheet and then summarize some data from it.

After trying Sheetnode (and disliking its Excel importing implementation, which creates a new node for each sheet in the spreadsheet), I'm thinking the Data module coupled with Feeds might be the best solution.

However, I'm needing some way to download the original spreadsheet after parsing. Ideally, this would mean the user adds a spreadsheet to a filefield and hits upload, after which the original is stored in that field and Feeds API is starts to do its magic.

To this end, is there any way of having Feeds import from a file uploaded via the Field API instead of through Feeds' import page?

(Or alternately, the user uploads via Feeds' Import page and the original spreadsheet is then stored in a fieldfield -- either works.)

Many thanks!

0

well bottomline is:

You want to import a spreadsheet (maybe with multiple sheets in it) on a regulary basis.

I'd suggest the module migrate, you find the possiblility to import csv-files (and also an example if i remember right).

Migrate has maybe a little more effort in the start, but it also has many nice features like a hightwatermark, means if there is a counter or a timestamp in your file (for each record), then migrate can skip easily over former imported items.

Also tranformation of data is (if neccessary) with migrate possible.

At least you should have a close look at the module migrate.

  • While I luuurves me some migrate (I used it recently to import a 45,000 node news website), for this project the client staff receive documents in Excel format and won't want to convert them to 4 different CSV files. Unless Migrate has some native Excel importing functionality I'm unfamiliar with, it won't work in this scenario. Thanks for the response, though! – aendrew Jul 31 '12 at 8:24
0

Here's how I did this:

  1. Create content type called "Report"
  2. Add File field
  3. Create a Rules action that uses PHP Excel Reader to parse through the spreadsheets, storing stuff from one sheet in a Data table, other stuff (Mainly row counts) into a serialized text field.
  4. Display content as needed via Views templates.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.