Problem with open dataset

[Former Member]

I have file in temp folder of Application server in Excel format. I have one bapi program which creates saleorder based on the above excel file.

In Presentaion server its working fine(using upload methd). Now my problem is to execute the same in backgound job, So I want to use open Dataet..

It is possible to use excel directly in background job using Open data set. Please let me know the needful

Please forward is there any other way...rally hanging on that..

Thanks and Regds,

Bala

[Former Member]

Bala,

You cannot use background execution for importing a file from the presentation server.

Background execution means basicaly that some work will be done on the server, by the server, without the interaction of a user.

How could the server import a file in background job, from an application server? From which application server? As there is no connection between the server and a specific applicationn server, in background execution...

Bye,

Bogdan

[Former Member]

You have to Convrt your excel file to a flat file and need to all the logic for handling the data if you are using Open dataset.

Same code won't work in open dataset when reading from Application server.

Thanks,

Greetson