Strategy for multi-row paste with grid and connector?

Hi,

We use the grid to support editing ordered lists of items, of 4 columns and anywhere between 50 and 2500 items.

Today, we save all when users are done with their edits. This means that the entire list is posted back to the server even for a single cell edit.

We are looking at using the data connector to sync the server side with small updates as the user edits the grid, so that the Save button used at the end can only send a lightweight “Apply Changes” message to the server.

So far so good? That’s what the data connector is meant for?

If yes, my question is about large edits. One important usage scenario is the ability to multi-select rows, then copy and paste them elsewhere in the list. Or, multi-select and move using drag-drop. How is the data connector working in such a case with the dhtmlxGrid? One call to the server for each inserted row? If we start and stop FastOperations, does it have any effect on the data connector? Is there any way to batch the calls to the server? Anyone have been implementing similar scenarios?

Thanks in advance.

So far so good? That’s what the data connector is meant for?
Yes, it will send only updated rows to the server side.

By the way if you are using form integration, it can be used to send only changed data as well
docs.dhtmlx.com/doku.php?id=dhtm … anged_rows

How is the data connector working in such a case with the dhtmlxGrid?
One call to the server for each inserted row

It can be controlled
By default dataprocessor works in auto update mode, which means it will send new request for each update. ( may send a lot of requests at once ) But you can switch it to manual data sending mode

dp.setUpdateMode(“off”);

In such case dataprocessor will collect info about updates, but will not send any data. When necessary you can call

dp.sendData()

and all collected data will be send as a single server side request.