Skip to Content
1

Batch operation problem with OData Binding from GWM Excel.

May 08, 2017 at 09:00 AM

75

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin May 08, 2017 at 09:21 AM
0

Hi Elton,

Your secondary tag

EPM Add-In for Excel

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

Share
10 |10000 characters needed characters left characters exceeded