topic Re: how can i store csv file into application server in Application Development and Automation Discussions

how can i store csv file into application server

Former Member — Tue, 18 Dec 2007 09:21:19 GMT

hi dudes

i have csvfiel(excel file) at my desktop.i have to store it into application server.Fm is sap_convert_to_csv_format.

data of excel file is like this

send the code.it is urgent.

kiran

Edited by: kiran jagana on Dec 18, 2007 11:33 AM

Re: how can i store csv file into application server

Former Member — Tue, 18 Dec 2007 10:13:53 GMT

Hi,

you can use method GUI_UPLOAD from class CL_GUI_FRONTEND_SERVICES to achieve that.

Regards

Mark-André

Re: how can i store csv file into application server

meikandan_krishnan2 — Tue, 18 Dec 2007 10:51:20 GMT

hi ,

The function module sap_convert_to_csv_format, converts the internal table to CSV file and download to the local server.

CSV file is nothing but a "Comma Delimited" file.

Test : Save a excel file as CSV and the open with notepad .

U can see the file with comma separated.

So create an internal table with line type as Char1000 or anything related to that . Then loop the original internal table and concatenate all the records separated by "comma".

Eg: Concatenate itab-f1

itab-f2

into wa-line separated by ','.

then tranfer the data to the application server.

Save the file with ".CSV" extension.

Please reward if it helps.

Regards

Meikandan