I'm looking at using sheetnode for sets of data that consist of a series of tables and I'd like to call them through a taxonomy/term based view and render the output in simple tables and charts

Each set of sheets are structurally identical and would be entered/imported as individual nodes and would be distinguished by at least one hierarchical taxonomic vocabulary. Forget the fact that I have different sets. One is enough for demo purposes.

I'd like to use taxonomy/term arguments to allow for filtered views of data found within the sheets.

Requiring, yes, a new handler to retrieve the value of a cell.

With room to offer additional handlers? That'd be terrific.

The option to allowing the selection of a row, column would be great. Or, a field-defined range of cells (entered by the person importing the data) ? I imagine that would appeal to an endless range of applications.

The taxonomy argument - as is already built in to Views- would allow the same view to process any number of sheetnodes that match the argument(s). Or maybe someone would filter on a cck term, or published date - it's already in Views.

Handlers are what appear to be missing. The whole sheet is one field.

CellRef cell handler

CellRef row handler
CellRef column handler

The output could be as simple as a table, or it could also be processed via template.php and .tpl.php files and fed through any number of graph/chart/map generators.

Comments

infojunkie’s picture

Assigned: Unassigned » infojunkie

Thanks for your suggestion. It is indeed a valuable feature for Sheetnode.

Concerning the row, column (or area for full generality) handler, I understand that you want to output the values through a theme function, the default being a table output. Is that what you meant?

brst t’s picture

Thanks Karim.

I was following this issue queue for a few days before posting, but ended up missing this post from the day before : http://drupal.org/node/579612

Full cck handling would be nice, but calling cell refs by way of template + view would be sufficient for my purposes.

Unfortunately for me, I need a number of fields to be classified within a few taxonomic vocabularies. Going this route would require nearly a thousand different sheetnodes to add/import.

infojunkie’s picture

I just committed a fix with field handlers for sheet cells and ranges. To try, you need to clear the caches, then find the "Sheetnode" group in the list of field handlers. Let me know how that works for you!

infojunkie’s picture

Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.