topic Upload .csv from application server in Application Development and Automation Discussions

Upload .csv from application server

HKany — Fri, 24 Oct 2008 13:05:02 GMT

Hi,

I am looking for the easiest way to upload a ".CSV" file from the application server and to save the the same file with another name in the same folder on the application server again.

At the moment I only find the way over datasets.

Is there another one?

Yes? Cool! - how?

Thanks in advance.

Re: Upload .csv from application server

Former Member — Fri, 24 Oct 2008 13:44:29 GMT

Use of DATASET is fairly easy - for what reason do you not want to use that?

Re: Upload .csv from application server

BH2408 — Fri, 24 Oct 2008 13:48:06 GMT

Hi ,

Use the Open dataset , READ DATASET and close dataset.

Regards,

Bharani

Re: Upload .csv from application server

Former Member — Fri, 24 Oct 2008 18:16:13 GMT

hi Heiko,

The other posters are correct, particularly since you want to save a second file back to your application server. I tried many was, and the only successful option was to use OPEN DATASET ... CLOSE DATASET


DATA: dsn(40).
DATA: wa_itab like line of itab.

OPEN DATASET dsn FOR APPENDING IN TEXT MODE ENCODING DEFAULT.
IF SY-SUBRC = 0.
LOOP AT ITAB INTO wa_itab.
TRANSFER wa_itab TO dsn.
ENDLOOP.
ENDIF.
CLOSE DATASET dsn.

Re: Upload .csv from application server

HKany — Tue, 28 Oct 2008 14:51:23 GMT

I found it.

To rename a file on the windows filesystem you have to use the SAP function 'SXPG_CALL_SYSTEM'.

It works.