Batch operation problem with OData Binding from GWM Excel.

ealimeta — Mon, 08 May 2017 09:00:47 GMT

Hello everyone .

Have already set up an ODATA for the sales order create/update .
Actually we are trying to use the binding in BATCH mode from the GWM add-in on Excel.

The BATCH mode actually works from other systems that consume the ODATA
and in the method CHANGESET_PROCESS in the table IT_CHANGESET_REQUESTS we already have all the changesets that need to be executed .

When we use the batch operation via GWM EXCEL the method CHANGESET_PROCESS is executed N times (N - rows in excel) and each time we have only one changeset operation in the table IT_CHANGESET_REQUESTS.

What we need in the GWM batch execution is the same thing as when other external systems consume this ODATA, have all the changset operation in the internal table IT_CHANGESET_REQUESTS .

Using the FIddler tool to debbug the requests we notice differences :

External systems call :

--batch_a

--changeset_a
POST1
--changeset_a

POST2

--changeset_a

POSTN

--changeset_a--

--batch_a--

GWM EXCEL CALL
--batch_B

--changeset_A
POST1
--changeset_A--

--batch_B

--changeset_B

POST2

--changeset_B--

--batch_B

--changeset_C

POSTN

--changeset_C--

--batch_B--

As noticed above when the odata is consumed by external Systems we have only one batch opening and then after every changest command the POST operation ,

Any clue on this ,
Any response would be appreciated .

Thanks.
Toni

Re: Batch operation problem with OData Binding from GWM Excel.

former_member186338 — Mon, 08 May 2017 09:21:54 GMT

Hi Elton,

Your secondary tag

EPM Add-In for Excel

has no relation to the question asked. Please remove it!

Question Re: Batch operation problem with OData Binding from GWM Excel. in Technology Q&A

Batch operation problem with OData Binding from GWM Excel.

Re: Batch operation problem with OData Binding from GWM Excel.