topic Re: GUI Upload in background in Application Development and Automation Discussions

GUI Upload in background

Former Member — Tue, 07 Mar 2006 02:57:34 GMT

Hi,

Can GUI Upload function be executed in background mode? If yes, then how?

Thanks,

Pankaj

Re: GUI Upload in background

Former Member — Tue, 07 Mar 2006 02:58:39 GMT

Hi Pankaj,

GUI_UPLOAD <b>cannot</b> be executed in the background.

The only possible solution is to upload the file from the presentation server to the application server.

And from there you can read the file in the background using :

OPEN DATASET

READ DATASET

CLOSE DATASET...

Regards,

Wenceslaus.

Re: GUI Upload in background

suresh_datti — Tue, 07 Mar 2006 03:02:33 GMT

HI,

The frontend will not be available during a background process. You simply cannot use the GUI_UPLOAD/DOWNLOAD function modules in the background.

Regards,

Suresh Datti

Re: GUI Upload in background

Former Member — Tue, 07 Mar 2006 03:03:12 GMT

Hi Pankaj

Gui_UPLOAD is not possible in background.

if you want do to in background then copy the file from presentation server to application server using CG3Z/CG3Y .

then use

OPEN DATASET <data set name>.

for doing backgound proceessing.

regards

kishore

Re: GUI Upload in background

hymavathi_oruganti — Tue, 07 Mar 2006 03:10:15 GMT

GUI_UPLOAD cannot be done in background because it needs a path to be entered.

two solutions.

1. u can upload the file to application server using CG3Y and then u can use OPEN DATA SET, TRANSFER, CLOSE DATASET, READ DATA SET which are commands to acceess files from application server. u can schedule these in background

2. If ur path in presentation sever is always same (which might not be possible) then u can save it as a variant and then scheduke it in background with variant

Re: GUI Upload in background

Former Member — Tue, 07 Mar 2006 03:32:47 GMT

Hi,

GUI Upload cannot be used in Background.

Instead you can refer the code below to read from application server.

CALL FUNCTION 'FILE_GET_NAME'
       EXPORTING
            LOGICAL_FILENAME = P_INFILE
       IMPORTING
            FILE_NAME        = INPUTFILE
       EXCEPTIONS
            FILE_NOT_FOUND   = 1
            OTHERS           = 2.
  IF SY-SUBRC NE 0.
    MESSAGE E899 WITH text-064 P_INFILE text-065.
  ENDIF.

* Open the inputfile for reading in text mode
  OPEN DATASET INPUTFILE FOR INPUT IN TEXT MODE.

  IF SY-SUBRC NE 0.
    MESSAGE E899 WITH text-066 INPUTFILE text-067.
  ENDIF.

  DO.
    READ DATASET INPUTFILE INTO TEXT2 . "LENGTH LENG.

    MOVE TEXT2 TO I_MATCONV.
    APPEND I_MATCONV.

    IF SY-SUBRC <> 0.
      EXIT.
    ENDIF.
  ENDDO.

  CLOSE DATASET INPUTFILE.

Regards,

Gayathri

Re: GUI Upload in background

jayanthi_jayaraman — Tue, 07 Mar 2006 05:29:08 GMT

Hi,

You cannot use GUI_UPLOAD in background.Write the same file in application server and then read from application server.This can be done in background.Kindly reward points by clicking the star on the left of reply,if it helps.

Sample code:

For writing in Application Server:

types: BEGIN OF ty_output,
        field(500) TYPE c,
        END OF ty_output.
data : t_output TYPE STANDARD TABLE OF ty_output,
       w_output TYPE ty_output.

* Opening the file for output in text mode
  OPEN DATASET p_afile FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.
  IF sy-subrc NE 0.
    CLEAR g_flg.
    g_flg = c_x.
    MESSAGE s000 WITH text-003 p_afile text-004.
    "Error in opening file for output
    LEAVE LIST-PROCESSING.
  ENDIF.
  LOOP AT t_output INTO w_output.
    TRANSFER w_output TO p_afile.
  ENDLOOP.
* Closing the file
  CLOSE DATASET p_afile.
  IF sy-subrc NE 0.
    "Error in closing file
    LEAVE LIST-PROCESSING.
  ENDIF.

For reading:

DATA : G_DATA(1000) TYPE C,
G_DELIM TYPE C VALUE CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB.
DATA: BEGIN OF T_INPUT OCCURS 0, " Flat file data
       PERNR(9) TYPE C,
       AMOUNT(15) TYPE C,
       W_TYPE(5) TYPE C,
      END OF T_INPUT.


  OPEN DATASET G_AFILE1 FOR INPUT IN TEXT MODE ENCODING DEFAULT.
  IF SY-SUBRC = 0.
    DO.
      READ DATASET G_AFILE1 INTO G_DATA.
      IF SY-SUBRC = 0.
        SPLIT G_DATA AT G_DELIM INTO T_INPUT-PERNR T_INPUT-AMOUNT
                                                 T_INPUT-W_TYPE .
        IF SY-SUBRC = 0.
          APPEND T_INPUT.
          CLEAR T_INPUT.
        ELSE.
          MESSAGE E001 WITH TEXT-012 G_AFILE1.
        ENDIF.
      ELSE.
        EXIT.                       "After reading last Record
      ENDIF.
    ENDDO.
  ELSE.
    MESSAGE E001 WITH TEXT-013 G_AFILE1.
  ENDIF.

Re: GUI Upload in background

Former Member — Tue, 07 Mar 2006 05:44:45 GMT

Hai pankaj,

GUI_* and WS_* function modules do not work in background

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.

*-- Open dataset for reading

DATA:

dsn(20) VALUE '/usr/test.dat',

rec(80).

OPEN DATASET dsn FOR INPUT IN TEXT MODE.

IF sy-subrc = 0.

DO.

READ DATASET dsn INTO rec.

IF sy-subrc <> 0.

EXIT.

ELSE.

WRITE / rec.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET dsn.

*-- Open dataset for writing

DATA rec(80).

OPEN DATASET dsn FOR OUTPUT IN TEXT MODE.

TRANSFER rec TO '/usr/test.dat'.

CLOSE DATASET dsn.

How to Upload csv file to SAP?

Use function module GUI_UPLOAD

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'C:\test.csv'

FILETYPE = 'ASC'

TABLES

DATA_TAB = itab

EXCEPTIONS

FILE_OPEN_ERROR = 1

FILE_READ_ERROR = 2

NO_BATCH = 3

GUI_REFUSE_FILETRANSFER = 4

INVALID_TYPE = 5

NO_AUTHORITY = 6

UNKNOWN_ERROR = 7

BAD_DATA_FORMAT = 8

HEADER_NOT_ALLOWED = 9

SEPARATOR_NOT_ALLOWED = 10

HEADER_TOO_LONG = 11

UNKNOWN_DP_ERROR = 12

ACCESS_DENIED = 13

DP_OUT_OF_MEMORY = 14

DISK_FULL = 15

DP_TIMEOUT = 16

OTHERS = 17.

Regards,

Srikanth.

Reward points if helpful.