Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

BACKGROUND JOB

Former Member

‎2010 Sep 23 10:56 AM

0 Likes
615

Hi

I have a requirement to run a program in a background job, but the user wants the output to be downloaded to excel automatically after the background job if finished, they do not want to download the spool to excel they want it automatically done. I need to download the file into the LOCAL path (C:\)

please help me how can i do this?

thanks a lot

Moderator message: background/download/GUI problems = FAQ, please search before posting, use meaningful subject lines when posting.

locked by: Thomas Zloch on Sep 23, 2010 1:23 PM

Hi

I have a requirement to run a program in a background job, but the user wants the output to be downloaded to excel automatically after the background job if finished, they do not want to download the spool to excel they want it automatically done. I need to download the file into the LOCAL path (C:\)

please help me how can i do this?

thanks a lot

Moderator message: background/download/GUI problems = FAQ, please search before posting, use meaningful subject lines when posting.

locked by: Thomas Zloch on Sep 23, 2010 1:23 PM

Reply
3 REPLIES 3
Read only

former_member386202
Active Contributor

‎2010 Sep 23 11:00 AM

0 Likes
568

Hi,

Download data at Application Server using OPEN DATASET, CLOSE DATASET and then using standard transaction CG3Z trasfer that file to presentation server.

Regards,

Prashant

Read only

JoffyJohn
Active Contributor

‎2010 Sep 23 11:27 AM

0 Likes
568

Upload/download program to local file location cannot run in background.

So design you program so that after the schedule job completion, the output is written to application server,

Using open data set cammand or written to some FTP location.

Read only

Former Member

‎2010 Sep 23 12:05 PM

0 Likes
568

Design your code so it would do the transfer of data output to presentation server (w/c can be viewed in AL11) at the very end of the process.

Have some search about OPEN DATASET for writing 'OPEN DATASET p_2unxfl FOR OUTPUT IN TEXT MODE ENCODING NON-UNICODE.' (this writes the data to the presentation server).

Once the data is already in the presentation server, you can run CG3Z to download it to the local drive in excel form. I haven't tried yet but as mentioned above, 'GUI_UPLOAD' is not possible in the background. Maybe you can explore from there to make it possible to automatically download the output data into excel form in local drive and share with us what you will discover