dhtmlxDataProcessor - which sync grid with DB by AJAX calls;

Suite and Optimus Suite 5
#1

I am trying your grid. It works fine, but now I want to save the modified data to database table through the …



I am trying your grid. It works fine, but now I want to save the modified data to database table through the �SUBMIT’ button of JSP. How do I do that?



Can u explain how this dataprocessor works in case of JSP and MySQL.

I contain the grid in a form, and when i click ‘submit’ button, the form data gets submitted. But how do I access the post data and update my DB





Please Send me the Details ASAP





Regards

Udhayabalachandar

#2

If  you preffer to use form submit, you can check form integration extension , it allows to process data as result of normal form submit.

dhtmlx.com/docs/products/dhtmlxG … 6617541000

The DataProcessor library uses different way to save data, it not uses direct form submit, but generates its own ajax request to server side script with all necessary data.
So instead of submiting data, you  need to call something siilar to next
        dataproc.sendData();

The JSP based sample was sent to you by email.

#3

Hi Dude…

 We are working in Struts application… We want to save the Edited Grid Data in the database if we use dhtmlDataProcessor it is very easy to update in Database…
We have the license version. But in the sample the Language is PHP… When we implement in JSP it doesnt work…We want the simillar sample in jsp…

Thank you for your reply…

Regards
Udhayabalachandar

#4

When we implement in JSP it doesnt work…
The structure of process is the same for any server side scripting platform.
Please check your email - we send you a sample of dataprocessor usage with JSP server side code.

#5

We are having a similar situation with dataprocessor and struts 2.

we need to retrieve the DHTMLXGRID data and other form data’s to our server side java code , where it will be store to db and then redirected to another page

Currently with dataprocessor.sendData() function, we are getting only the grid data .
we need a way to submit the form , so as to get other values in form

It would be great full if you can provide a sample as you have provided for previous post .
Currently we are using Dhtmlx2.5 Suite Professional

#6

Have you tried to use “integration with form” extension?

dhtmlx.com/docs/products/dht … _form.html
docs.dhtmlx.com/doku.php?id=dhtm … ntegration

#7

Thanks for the reply…

we have tried grid integration with form as mentioned in docs.dhtmlx.com/doku.php?id=dhtm … ntegration . but we are not sure how to retrieve each cell values from grid in server side code .

Currently we have implemented a grid with dataprocessor and we have successfully retrived the cells values in server side code , the problem we are facing is that we need to get other FORM fields along with this grid values and also refresh/reload the page after submit .

what we need exactly is dataprocessor like values (0_c0) along with other FORM fields in server side.

thanks once again

#8

that we need to get other FORM fields along with this grid values

Are you using dataprocessor in auto or manual sending mode?

You can store extra data as userdata of grid

grid.setUserData("some_value", document.getElementById("some_input").value)

all userdata will be sent with each dataprocessor call, and can be retrieved on the server side.
For example, above line will add {row_id}_some_value parameter in the url of dataprocessor.

#9

Thanks for the valuable info…

we are using the manual mode for data sending
dataProcessor = new dataProcessor(oDataActionUrl);
dataProcessor.setUpdateMode(“off”);
dataProcessor.setTransactionMode(“POST”,true);
dataProcessor.defineAction(“insert”,processInsert);
dataProcessor.defineAction(“update”,processUpdate);
dataProcessor.defineAction(“error”,processError);
dataProcessor.defineAction(“invalid”,processInvalid);
dataProcessor.attachEvent(“onAfterUpdate”, processAfterUpdate);
dataProcessor.setVerificator(0, not_empty);
dataProcessor.setVerificator(7, not_empty);
dataProcessor.setVerificator(3, not_empty);
dataProcessor.attachEvent(“onValidatationError”, function(id, messages) {
alert(messages.join("\n"));
return true;
});
dataProcessor.init(otherPymtGrid);

it would be helpful if you can provide us the sample of dataprocessor usage with JSP server side code ,similar to the sample send as mail to user “udhaya”

thanks again…

#10

please can you provide a sample jsp/java code for handling the dataprocessor .code that can retrieve request values and then redirect to some other page

thanks in advance…

#11

You can try to use dhtmlxConnector for Java. Beta version is available here dhtmlx.com/x/download/regula … 9_java.zip

docs.dhtmlx.com/doku.php?id=dhtm … orjava:toc

#12

Hi ,

I am trying to fetch values from my grid to a jsp page… can you please tell me what do i have to mention in the url of myDataProcessor = new dataProcessor(“php/update.php”) ??
It will be helpful if you can provide the usage of dataprocessor in jsp

#13

Example of dhtmlxConnecto usage is available in your dhtmlxConnector package dhtmlxConnector_v09_java\samples