topic Re: uploading file to application server in Application Development and Automation Discussions

uploading file to application server

rajeshkumar_kaveti — Mon, 13 Mar 2006 11:30:43 GMT

Here i have 2 issues while uploading file to Application server.

1. if i use open dataset for output, in scheduling i canntot use GUI_upload . So what is the alternative for me.

2. Using FTP: Please elobarate me on using this FTP possibly with some code.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 11:34:45 GMT

Hi Rajesh,

Why do u want to use.."GUI_upload" when open dataset will work in both background and foreground?

*   Download internal table to Application server file(Unix)
DATA: e_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.      

  open dataset e_file for output in text mode.
  lOOP AT it_datatab......
    transfer it_datatab to e_file.
  ENDLOOP.
 
  close dataset e_file.

What is ur actual requirment?

foreground/background/both?

Reards,

Anjali

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 11:35:03 GMT

Hi rajesh,

1. i have not tried,

but we can also use like this in open dataset

computername\pathname\filename

2. this computername

should be ON (switched on)

so that application server

can access it using

and pick up the file.

regards

amit m.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 11:37:10 GMT

use CG3Z and CG3Y tcodes

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 11:37:47 GMT

FOR THE FIRST PART PLEASE REFER THE LINK

1 <a href="http://72.14.203.104/search?q=cache:WmM6olByMlwJ:www.sap-img.com/ab004.htmOPENDATASETIN+ABAP&hl=en&gl=in&ct=clnk&cd=7">GUI_* and WS_* function modules do not work in background</a>

2 <a href="http://72.14.203.104/search?q=cache:KKvBXqcQ7jsJ:help.sap.com/saphelp_nw04/helpdata/en/fc/eb3ca6358411d1829f0000e829fbfe/content.htmOPENDATASETIN+ABAP&hl=en&gl=in&ct=clnk&cd=3">Basic Form of the OPEN DATASET Statement</a>

To FTP using ABAP, you can have a look at the standard program '<b><u>RSEPSFTP</u></b>'.

IF THESE FIND USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

Message was edited by: ANOOP R.S

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 11:39:46 GMT

Hi,

1. If you want to schedule the data it must not be in the presentation server.

It depends on the logic of how you retreive the data.

If you retrieve the data dynamically from the client upload the data to dataset using transaction CG3Y and CG3Z.

and then perform your scheduling operations there..

You can use FTP_OPEN, FTP_EXECUTE and FTP_CLOSE.

A sample program for FTP:

DATA: BEGIN OF MTAB_DATA OCCURS 0,
LINE(132) TYPE C,
END OF MTAB_DATA.

DATA: MC_PASSWORD(20) TYPE C,
MI_KEY TYPE I VALUE 26101957,
MI_PWD_LEN TYPE I,
MI_HANDLE TYPE I.

START-OF-SELECTION.

MC_PASSWORD = 'password'.

DESCRIBE FIELD MC_PASSWORD LENGTH MI_PWD_LEN.

*-- FTP_CONNECT requires an encrypted password to work
CALL 'AB_RFC_X_SCRAMBLE_STRING'
     ID 'SOURCE' FIELD MC_PASSWORD ID 'KEY' FIELD MI_KEY
     ID 'SCR' FIELD 'X' ID 'DESTINATION' FIELD MC_PASSWORD
     ID 'DSTLEN' FIELD MI_PWD_LEN.

CALL FUNCTION 'FTP_CONNECT'
     EXPORTING
       USER            = 'userid'
       PASSWORD        = MC_PASSWORD
       HOST            = 'servername'
       RFC_DESTINATION = 'SAPFTP'
     IMPORTING
       HANDLE          = MI_HANDLE
     EXCEPTIONS
       NOT_CONNECTED   = 1
       OTHERS          = 2.

CHECK SY-SUBRC = 0.

CALL FUNCTION 'FTP_COMMAND'
     EXPORTING
       HANDLE = MI_HANDLE
       COMMAND = 'dir'
     TABLES
       DATA = MTAB_DATA
     EXCEPTIONS
       TCPIP_ERROR = 1
       COMMAND_ERROR = 2
       DATA_ERROR = 3
       OTHERS = 4.

IF SY-SUBRC = 0.
  LOOP AT MTAB_DATA.
    WRITE: / MTAB_DATA.
  ENDLOOP.
ELSE.
* do some error checking.
ENDIF.

CALL FUNCTION 'FTP_DISCONNECT'
     EXPORTING
       HANDLE = MI_HANDLE
     EXCEPTIONS
       OTHERS = 1.