Inline Editor not Loading Rows, Requested unkown parameter 'EID' for row 0.

jaredgerber

This is the error I'm getting: Datatables warning: table id=commissionsschedule - Requested unkown parameter 'EID' for row 0.

I see the correct number of rows loading to the table, but the data is not loading. I'm using the latest datatables trial download, Editor & tableTools (DataTables-1.10.4-trial).

Here is the link:
http://174.120.222.66/~opes/admin/rpt_commission_scheduleZ.php#cas

Here is my document ready function:

$(document).ready(function() {
    editor = new $.fn.dataTable.Editor( {
        ajax: "php/processList.php?list=commissionschedule&has_form=false",
        table: "#commissionschedule",
        fields: [ {
                label: "PlanID:",
                name: "EID"
            }, {
                label: "Commission Type:",
                name: "CommissionTypeID"
            }, {
                label: "Commission%:",
                name: "CommPct"
            }, {
                label: "Target%:",
                name: "Target"
                }
        ]
    } );

Here is sample output from the processList.php:

{"sEcho":0,"iTotalRecords":"218","iTotalDisplayRecords":"218","aaData":[
["2","1","1.15","0.55"],
["3","1","1.1","0.53"],
["66","1","1","0.51"],
["75","1","1.15","0.55"],
["1632","1","0.075","0.025"],

I'm also running the server script, but I'm getting a database connection error there too:

$db = NEW mysqli("localhost", "opes", "mypass", "opes_com_track");
include( "../res/DataTables/php/DataTables.php" );
Editor::inst( $db, 'tlkpcommissionschedule' )

Can anyone tell me what I am doing wrong?

allan

Hi,

Your data is array based (e.g. ["1","2","1","1.15","0.55"]) but you are specifically telling DataTables to except object based data through the use of the columns.data option.

You can use arrays for DataTables and Editor by setting columns.data and fields.data to be integer values, but if you can alter the server-side script to send back objects, it might be easier in the long run.

It might also be worth reading the data section of the manual about this topic.

Allan

jaredgerber

Thank you for pointing me in the right direction. I've read the data section in the manual now :-) I'm looking forward to seeing this inline editor running.

I removed the column & field specifications and it started working. As you recommended, I'm trying to get my scripts to return objects instead.

I've encoded the data using the server side script in the "Object data source" example:
https://datatables.net/examples/server_side/object_data.html

But it's outputting arrays:
http://174.120.222.66/~opes/admin/php/processListObj.php

Do I need to use different parameters for the json_encode() call?
...
echo json_encode(
SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
...

jaredgerber

SUCCESS!!

Ok -- I got my php script to return objects -- yayyy!!
http://174.120.222.66/~opes/admin/php/processListObj.php?list=commissionschedule&has_form=false

Also, I got the inline editor up and running!!
http://174.120.222.66/~opes/admin/rpt_commission_scheduleZ.php#cas

Now for getting it to save back to the server & a little styling / column formatting.

Thanks.

jaredgerber

It's editing the data now, how can I get it to update the table from my edits?

http://174.120.222.66/~opes/admin/rpt_commission_scheduleZ.php#cas

The changes I make in the grid are not getting saved back to my table -- am I missing something here?

allan

It's editing the data now, how can I get it to update the table from my edits?

Does your "php/processListObj.php?list=commissionschedule&has_form=false", script implement Editor's client / server communication requirements?

Allan

jaredgerber

I don't think so -- I'll check that out.
```
<?php
require_once ("../../Library/dbCon.php");

/*
* DataTables example server-side processing script.
* See http://datatables.net/usage/server-side for full details on the server-
* side processing requirements of DataTables.
* @license MIT - http://datatables.net/license_mit
*/

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* Easy set variables
*/

// DB table to use
$table = 'qrycommissionschedule';

// Table's primary key
$primaryKey = 'CommissionScheduleID';

// Array of database columns which should be read and sent back to DataTables.
// The db parameter represents the column name in the database, while the dt
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columns = array(
array( 'db' => 'CommissionScheduleID', 'dt' => 'CommissionScheduleID' ),
array( 'db' => 'DT_RowID', 'dt' => 'DT_RowId' ),
array( 'db' => 'EID', 'dt' => 'EID' ),
array( 'db' => 'CommissionTypeID', 'dt' => 'CommissionTypeID' ),
array( 'db' => 'CommPct', 'dt' => 'CommPct' ),
array( 'db' => 'Target', 'dt' => 'Target' )
);

// SQL server connection information
$sql_details = array(
'user' => $GLO_USER_NAME,
'pass' => $GLO_PASS,
'db' => $GLO_DB_NAME,
'host' => $GLO_HOST_NAME
);

require( '/home/opes/public_html/res/DataTables/php/ssp.class.php' );

echo json_encode(
SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
);

<?php > ``` ?>

jaredgerber

Thanks again for your response.

I have reviewed http://editor.datatables.net/manual/server -- I couldn't find an example script that handles edit, create or remove. I saw the sample data exchanges - is there a sample server side script for handling those data exchanges?

Thank you.

allan

is there a sample server side script for handling those data exchanges?

Certainly - in the Editor download package. See installation instructions.

Note that the Editor PHP libraries support server-side processing themselves. You don't need to use the ssp.class.php file.

Edit Example of Editor with server-side processing using the Editor libraries: http://editor.datatables.net/examples/simple/server-side-processing.html .

Allan

jaredgerber

Ok on ssp -- thanks.

So -- I don't have to code the handlers manually for edit, create & remove? I thought that there should be a simple way to get data back to the tables. I just can't put the puzzle together :-)

In your examples, I see that it's actually saving data -- which is what makes me thing there is 2 way exchanges going on. However, I don't see any onsubmit=function() calls in your samples. So I'm a bit confused about how things get done.

Does this sample that you're referring to here process post data to the table or is it posting to the datatables?
http://editor.datatables.net/examples/simple/server-side-processing.html

    ->process( $_POST )
    ->json();

allan

onsubmit=function()

There isn't - it is all handled by Editor. When you click the submit button in the Editor form it calls submit() which submits the data to the server.

Does this sample that you're referring to here process post data to the table or is it posting to the datatables?

It is processing the data contained in the $_POST variable.

Allan