topic Re: wt is .csv file in Application Development and Automation Discussions

wt is .csv file

Former Member — Thu, 16 Oct 2008 14:25:46 GMT

wt does .csv file format meant by?

y do we need to convert .xls to .csv file format.

Re: wt is .csv file

Former Member — Thu, 16 Oct 2008 14:35:06 GMT

CSV file is a text file where the field are separeted by a sign: usually semicolon.

So a record has a format like this:

field1;field2;field3;

The good property is this file is field dimension indipendent: so u don't need to know the length of every field, all you need to know is a new information will be place after a semicolon.

Max

Re: wt is .csv file

Former Member — Thu, 16 Oct 2008 15:34:28 GMT

whenever we do uploading , is it like the ultimate file format to be in csv.

i mean dat from .txt or .xls shld be converted in .csv......

bt y....?

is it tab separator or field sep or semicolon.....

Re: wt is .csv file

Former Member — Thu, 16 Oct 2008 15:42:13 GMT

I don't understand where your problem is: which kind of file to be used depends on your program.

- convert a file from XLS to CSV is easy because u can save excel file in CSV format (it's a chance given by excel);

- convert a text file to CSV: probably it should try to open the file using excel and then save it in CSV format.

For the CSV format it need to have semicolon as separator.

Max

Re: wt is .csv file

Former Member — Thu, 16 Oct 2008 15:48:20 GMT

dat means using csv file , u hv no duplicate entries whereas in excel its der, m i correct so we r converting from xl to csv.

wt is full form of csv...

Re: wt is .csv file

Former Member — Thu, 16 Oct 2008 17:52:53 GMT

open an excel file, press save as from the menu, and then see the what does .csv stands for

Re: wt is .csv file

Former Member — Fri, 17 Oct 2008 00:53:59 GMT

And make a bit more effort to use appropriate English please.

sms-spk lks lk ah pc ah sht wch te pstr ds nt cr abt rly... plz!

Re: wt is .csv file

Madhurivs23 — Sat, 18 Oct 2008 08:08:58 GMT

Hi Max,

I saw this thread for searching info on CSV file.

My requirement is that, I want to download internal table data into .csv file..

1. So I make the file name with .csv.

2. call GUI_DOWNLOAD FM, passing WRITE_FIELD_SEPARATOR = 'X'

I got all the fields in one coulmn which I dont want. I want each field to be in separate separate column.

So I change the filename from .csv to .xls . and its working properly for presentation server. is there any drawback to store the file in .xls rather than .csv?

second question is :

If I want to save the .xls file in application server, how should I do that?

If I do it using open dataset, then should I open dataset in text mode or binary mode?

and the file name will be .xls?

Thanks in advance,

regards,

Madhuri

Re: wt is .csv file

Former Member — Mon, 20 Oct 2008 07:58:39 GMT

You should open an your post for a your question.

1) Anyway the parameter WRITE_FIELD_SEPARATOR inserts a tab between two fields, so it can't be used to download a csv file.

If you want to create a CSV file, u need to insert the separator (semicolon) by yourself, so your internal table should have only one big field where you write all informations separated by a semicolon.

If you wan't to convert the data by yourself it can use std fm like SAP_CONVERT_TO_CSV_FORMAT.

Yes u can create an XLS file by fm GUI_DOWNLOAD, in this case you need to transfer BIN (for binary file) to parameter FILETYPE.

2) If you can write/read a file in a path of Application Server by directly your operating system (I suppose WIndows), it's like just a PRESENTATION SERVER.

If you can write/read a file only by SAP, probably the easier way is just to create a CSV file.

Max