topic Excel file upload in background in Application Development and Automation Discussions

Excel file upload in background

Former Member — Thu, 19 Aug 2010 14:23:09 GMT

any one inform me how to Excel file will be Executed as a background job.

The Excel file will be executed as a background job.

This will eliminate issues related to network speed,

time-outs,user logging off,ect;

and the need for the user to remain logged in to the transaction till it finishes

execution. After the background job completes the output report will be sent to the

user via email as an attachment.

Regards

Gopal

Duplicate thread.

Edited by: kishan P on Aug 24, 2010 10:39 AM

Re: Excel file upload in background

Former Member — Thu, 19 Aug 2010 14:30:12 GMT

It won't be processed as a background job. You'll need to get the file into a usable format and parked in a APPS server folder first. Then a background job can process....Or, read the file in foreground, park it in a server folder or put into Z table, then submit a program as a job to process what you uploaded and stroed.

Re: Excel file upload in background

Former Member — Thu, 19 Aug 2010 14:36:28 GMT

hi,

function module for email attachment -

function module SO_DOCUMENT_SEND_API1

function module for background schedule - u2018ALSM_EXCEL_TO_INTERNAL_TABLEu2019

When scheduling a job in the background the appropriate statement to read in your file is OPEN DATASET, and the file must be on the file system that the SAP server can see.

At anytime, a user can switch of the Personal Computers even though the job is still running in the background. Therefore GUI_* and WS_* function modules are not designed to work in that way, as they need to access your personal computer file.

To choose the correct download method to used, you can check the value of SY-BATCH in your code,

if it is 'X' use OPEN DATASET and if it is ' ' use WS_UPLOAD.

link for help -

Rgds

Raj