Error in background job of downloading data to PC

[Former Member]

Hi Gurus,

I hv created a report for downloading data to PC using

GUI_DOWNLOAD FM when scheduling job in background

job is getting canceled...................

give me some solution....

[former_member583013]

You cannot use GUI_DOWNLOAD in background...Try with DATASET

Greetings,

Blag.

[former_member156446]

HI

you can not access the GUI when ur job is in Background.. so you need to change ur FM to WS_*..

[Former Member]

thanks for reply friends ..........pls give some sample code

[former_member223537]

DATA: file TYPE string VALUE `flights.dat`,

wa   TYPE spfli.

FIELD-SYMBOLS TYPE x.

OPEN DATASET file FOR OUTPUT IN BINARY MODE.

SELECT *

FROM spfli

INTO wa.

ASSIGN wa TO CASTING.

TRANSFER TO file.

ENDSELECT.

CLOSE DATASET file.

[Former Member]

thnaks friend.i hv used DATASET as u said...............

But I M getting dump

FILE IS NOT OPEN

this is my code

TYPES:BEGIN OF T_MARD,

MATNR LIKE MARD-MATNR,

WERKS LIKE MARD-WERKS,

LGORT LIKE MARD-LGORT,

LABST LIKE MARD-LABST,

MAKTX LIKE MAKT-MAKTX,

END OF T_MARD.

*******************************************************

***********WORK AREAS**********

DATA: WA_MARD TYPE T_MARD,

WA_MARD1 TYPE T_MARD.

DATA:BEGIN OF IT_MARD1 OCCURS 0,

MATNR(18),

WERKS(4),

LGORT(4),

LABST(13),

MAKTX(40),

END OF IT_MARD1.

TYPES : BEGIN OF TY_BAT,

LINE(100) TYPE C,

END OF TY_BAT.

*********INTERNAL TABLES*******

DATA:IT_MARD TYPE STANDARD TABLE OF T_MARD INITIAL SIZE 0 WITH HEADER LINE .

types: BEGIN OF ITAB1,

FIELD(100),

END OF ITAB1.

DATA : IT_BAT TYPE TABLE OF TY_BAT,

WA_BAT TYPE TY_BAT,

wa_itab1 type itab1.

data : it_tab type table of ALSMEX_TABLINE with header line.

*DATA: FILENAME1 TYPE STRING valu.

*DATA: FILENAME1(500).

DATA: FILENAME1 TYPE RLGRAP-FILENAME .

LOOP AT IT_MARD1.

CONCATENATE IT_MARD1-MATNR IT_MARD1-LABST IT_MARD1-MAKTX

INTO wa_ITAB1 SEPARATED BY ' '.

APPEND wa_itab1 to IT_tab.

CLEAR wa_ITAB1.

CLEAR WA_MARD.

ENDLOOP.

CONCATENATE 'D:\STOCKINH\' SY-DATUM '.TXT' INTO FILENAME1.

open dataset filename1 for output in binary mode." ENCODING DEFAULT.

IF sy-subrc = 0.

EXIT.

ENDIF.

LOOP AT it_tab into wa_itab1.

TRANSFER wa_itab1 TO filename1.

CLEAR wa_itab1.

ENDLOOP.

close dataset filename1.

MESSAGE S001(38) WITH 'Files Generated'.

WA_BAT = 'ftp -s:d:\ftp\ftp_upload.txt'.

APPEND WA_BAT TO IT_BAT.

CLEAR FILENAME1.

FILENAME1 = 'D:\STOCKINH\ftp_upload.BAT'.

open dataset filename1 for output in binary mode." ENCODING DEFAULT.

IF sy-subrc = 0.

EXIT.

ENDIF.

LOOP AT it_bat INTO wa_bat.

TRANSFER wa_bat TO filename1.

CLEAR wa_bat.

ENDLOOP.

close dataset filename1.

CLEAR: IT_BAT.

REFRESH IT_BAT.

WA_BAT-LINE = 'open 10.100.103.199'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'epossync'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'sync@1234'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'lcd D:\STOCKINH\20080201.TXT'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'cd /home/epossync/AMIT'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'binary'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'hash'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'put D:\STOCKINH\20080201.txt'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = ' '.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

WA_BAT-LINE = 'bye'.

APPEND WA_BAT TO IT_BAT.

CLEAR WA_BAT.

CLEAR FILENAME1.

FILENAME1 = 'D:\STOCKINH\ftp_upload.txt'.

open dataset filename1 for output in binary mode." ENCODING DEFAULT.

IF sy-subrc = 0.

EXIT.

ENDIF.

LOOP AT it_bat INTO wa_bat.

TRANSFER wa_bat TO filename1.

CLEAR wa_bat.

ENDLOOP.

close dataset filename1.

[Former Member]

this is the dump

File "d:\stockinh\20080201.TXT" is not open.

[Former Member]

u cannot download files using gui_download in a background scheduled program instead of that u can use OpenDataset-Close dataset.

So that ur requirement works

[Former Member]

Hi

When executing in backend fronend server are not accessible. So we have to download the data to application server.

Something like UNIX path.

Regards

Eswar

[former_member223537]

Hi,

The file path should be from application server.

Execute transaction AL11 & check which folder you can use to download data.

& pass the same name in your program.

Best regards,

Prashant