Saving edited data in views

If you're talking about Views integration, then yes the report is read-only. Even if you change values in the spreadsheet view, what ends up being exported is the original view results.

You can turn this into a feature request if you would like to allow the changes to be included in the export.

Changing to feature request.

I would like to not only be able to export the changed data, but save it as well. It seems like this would be possible with an ajax function or through some integration with VBO, but I'm no expert. This functionality would make this module extremely useful...

@deggertsen: Save the data where? In the current node would only be possible if you have edit access to it. Can you help with a usage scenario?

Save the data to the database, where else? Currently when using views the output is read-only, but I would like to be able to make changes to the records on the fly with a spreadsheet. http://drupal.org/project/slickgrid already does this, but it doesn't seem to be as stable or clean as sheetnode and has been giving me some problems. If you want me to explain a use case I can, but basically any view where you are outputting a table of fields could be a use case. I currently have a few sites that would benefit from this.

Thanks

My usage scenario question wasn't clear, sorry. Here's how I imagine the scenario:

* Given a spreadsheet view
* User navigates to spreadsheet view page
* User modifies values on spreadsheet
* User clicks some button "Save to ..."
* User is prompted with title of new sheetnode that will contain modified values and optionally node body
* User clicks "Submit"
* System saves modified values to a new sheetnode with given title and body

Does that make sense to you?

Could this be solved by some kind of integration with http://drupal.org/project/editablefields? As in, having each cell be formatted as an editable field for whatever field is being displayed?

I just committed a proof of concept for this.

To try it:
* update your database, then clear your cache
* add the field "Global: Make spreadsheet editable" to your spreadsheet view
* visit your view page
* write some text in blank cells on the spreadsheet
* click "Save" button below spreadsheet

=> The page should refresh, with your manually-added data persisting along with the view results.

Currently, this solution is limited because new view results will cause the manual data to appear in the wrong rows. That's my next task.

Any progress on this, Karim? I am also interested in this functionality. Thanks!

No progress beyond the proof of concept above. Did you try it?

Would be nice to save to our data module table using a similar "save" method. Currently, I am able to display the data from the table using this sheetnode view. The ability to edit and add to the table would be powerful and useful in many ways. Anyone already try this? Ideas on how to go about this would be appreciated.

I agree with jcam88 - it would be a very powerful feature if there was the ability to add in data/formulas to cells and then export it.

I'm new to this module (which looks fantastic), but I presumed that when I exported the updated spreadsheet view it would contain any additional data/content I'd added. I guess it would need to work with the views data export module for this to be possible.

Thanks

Tom