Jump to:

23459 Posts in 18906 Topics by 2877 members

General Questions

SilverStripe Forums » General Questions » ComplexTableField inline editing?

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 885 Views
  • JonYYC
    Avatar
    Community Member
    10 Posts

    ComplexTableField inline editing? Link to this post

    Hi,

    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?

    Thanks,
    Jonathan.

    Attached Files
  • swaiba
    Avatar
    Forum Moderator
    1788 Posts

    Re: ComplexTableField inline editing? Link to this post

    Hi JonYYC,

    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.

  • JonYYC
    Avatar
    Community Member
    10 Posts

    Re: ComplexTableField inline editing? Link to this post

    Hi swaiba,

    That's too bad, but I guess you can't have everything, especially when using unusual data formats. Thanks for the response.

    Jonathan.

  • jonm80
    Avatar
    Community Member
    10 Posts

    Re: ComplexTableField inline editing? Link to this post

    have you thought of using vba for this?

    ive been using vba to achieve something simular, now im wanting to have some form of editing data by simply clicking on a value in a table

    something like this? http://dhtmlx.com/docs/products/dhtmlxSpreadsheet/index.shtml

  • jonm80
    Avatar
    Community Member
    10 Posts
    885 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.