I am currently using a ComplexTableField to edit data that will be saved in a sparse matrix (E-A-V Model) and it works fine, but it not an optimal user interface for the editor, considering they will be adding a lot of data.
I would like to change the interface to allow multiple lines to be edited at one time (inline editing) and all entries save at one time with one Save button. I will also have to use a custom query to load the data (because not all values exist) and will need to override the writing of the data to the database to preserve the minimal data required for the EAV model.
In the attached image, there is a "Value" column. That is the column that needs to be editable and a 'Save' button associated with it.
Is there a way to do this within the framework? Override a Field Type? Or should I write completely custom PHP code to load, render and save the data and just put it in a tab. If so, are there examples of that I can reference?
I don't think you'll get info on this - I asked Ingo for it recently at a meetup and he said no :(
I've added http://www.simple-groupware.de/demo/simple_spreadsheet/spreadsheet.php?lang=en to our system to edit / view large amounts of data. I always meant to make a module for it, I always do, but didn't...
I would advise sticking to use of Excel and then extend CsvBulkLoader to parse the data for mass data entry.