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

uploading file to application server

rajeshkumar_kaveti — Mon, 13 Mar 2006 10:26:12 GMT

I need to upload a file to application server every 1 hour. And i have to automate this. How do i do it.

Re: uploading file to application server

hymavathi_oruganti — Mon, 13 Mar 2006 10:35:39 GMT

1.if from front end of presentation server

not possible to schedule in background.

2. IF FROM INTERNAL TABLE

write a program,

use OPEN DATASET <DSET> FOR OUTPUT.

transfer DATASET <DEST>.

CLOSE DATASET <DESET>.

u can schedule the program in background in SA38/SE36

to run for every 1 hr.

Message was edited by: Hymavathi Oruganti

Re: uploading file to application server

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

Hi Rajesh,

Try Program RC1TCG3Z.

Hope it helps...

Lokesh

pls. reward appropriate points

Message was edited by: Lokesh Aggarwal

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 10:39:03 GMT

or use sm36

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 10:39:56 GMT

CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
    FILENAME                      =  filnam
   FILETYPE                      = 'ASC'
   HAS_FIELD_SEPARATOR           = 'X'
  TABLES
    DATA_TAB                      = record
          .
open dataset dataset for output in text mode encoding DEFAULT.
loop at record.
transfer record to dataset.
endloop.
close dataset dataset.

Attach a transaction code to this program and you schedule this program to run every 1 hour with Basis...

If you are to upload the file in Background mode GUI_* functions will not work.Then you might have to think of other alternatives...

Regards,

Wenceslaus.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 10:39:56 GMT

Hi Rajesh,

If you mean uploading a file from a frontend to the application server using a job: it is not possible to do this, as there is no connection to your front end in the background.

The file must be in a location you have access to from the background (like a file server). You could use FTP then to copy the file to the application server.

Regards,

John.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 10:42:00 GMT

Hi ,

Use SM36 to schedule a job..

gui_* will not work in background..

you can use only

open dataset

regards

satesh

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 10:42:19 GMT

data to Application server

open dataset p_fleunx for output in text mode.

loop at fltab.

transfer fltab to p_fleunx.

endloop.

close dataset p_fleunx.

set the program in background to trigger every one hour

==================================

To read data from App server.

open dataset p_fleunx for input in text mode.

if sy-subrc ne 0.

write: / 'Process will be aborted.'.

exit.

endif.

Load internal table

do.

read dataset p_fleunx into fltab.

if sy-subrc ne 0.

exit.

endif.

append fltab.

enddo.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 10:46:52 GMT

Hi Rajesh,

U can Schedule your job to run in background for every one hour and u can use the dataset commands

OPEN <DataSetName>

and then looping through the internal table u can transfer the data from workarea to dataset using

TRANSFER <FName> to <DataSetName>

and close the dataset after the endloop using

CLOSE <DataSetName>.

Regards,

Phani

Re: uploading file to application server

rajeshkumar_kaveti — Mon, 13 Mar 2006 11:08:04 GMT

Thanks to all of you for responding with useful solutions

Here i observed 2 options.

1. using open dataset: In scheduling i canntot use GUI_* . So what is the alternative for me.

2. Using FTP: Please elobarate me on using FTP.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 11:23:05 GMT

Hi,

Try this piece of code.

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: uploading file to application server

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

Hi,

For 2: Performing FTP Commands From ABAP

/people/thomas.jung3/blog/2004/11/15/performing-ftp-commands-from-abap

Best Regards,

Anjali

Re: uploading file to application server

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

Hi Rajesh,

Let us know where the source data is residing? Accordingly, we can give a solution.

All FMs which require user interaction like selecting a file etc..will not work in background...

Regards,

Raj

Re: uploading file to application server

rajeshkumar_kaveti — Mon, 13 Mar 2006 11:36:59 GMT

Dear Rajasekhar,

source data is in front end in excel sheet.

Thanks

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 12:01:51 GMT

Hi Rajesh,

If the source file is in the front end, it wont help.

You need to upload the file to your application server using CG3Z or CG3Y.

Otherwise you can save the filename in your presentation server as a variant and then upload it.

See for reference.

Regards,

Wenceslaus.

Re: uploading file to application server

Former Member — Mon, 13 Mar 2006 12:05:21 GMT

Hi Rajesh,

One way of handling this situation is,

1. Try getting the source data into a file on application server instead of frontend.

2. Use Open dataset, transfer and close dataset stmnts as suggested by all for your requirement.

Regards,

Raj