Can editor work on json txt file as data source?

YoDavish

We don't want to use a database for this since the information is very minimal. We have a txt file that contains json objects to load that datatables. I have that working, very similar to this URL below. Can we allow datatables editor to work with an json txt file as the data source where I can add new rows or edit existing ones?

https://datatables.net/examples/ajax/objects.html

Here is my code that includes the editor portion:

editor = new $.fn.dataTable.Editor({
    ajax: 'config_clientsVersion2.txt',
    table: "#table",
    fields: [ 
        {
            label: "G Number:",
            name: "gNumber"
        }, 
        {
            label: "Diagram Types:",
            name: "diagramTypes"
        },
        {
            label: "Require Gleason Score:",
            name: "showGleasonScore"
        },
        {
            label: "Require Percentage:",
            name: "showPercentage"
        },
    ]
});

$('#table').DataTable({
    dom: 'Bfrtip',
    ajax: 'config_clientsVersion2.txt',
    columns: [
        { data: 'gNumber' },
        { data: 'diagramTypes' },
        { data: 'showGleasonScore' },
        { data: 'showPercentage' }
    ],
    buttons: [
        { extend: "create", editor: editor },
        { extend: "edit",   editor: editor },
        { extend: "remove", editor: editor }
    ]
});

kthorngren

You would need some sort of server functionality to update the file.

Kevin

allan

Yes, as Kevin says, updating the JSON file would be up to the server-side, and that is not currently something that our Editor server-side libraries can do. They focus on SQL databases.

So it is quite possible, it would just need the code for it to be written.

Allan