CSV Data source with semi colon delimiter

Hi All,
I receive CSV file that have been generated from a software and they have a semi-colon delimiter, as a result every time i try to use it as a data source everything comes in the the first column.
Is there some setup i can do when creating the datasource to ensure that the semi-colon delimiter is taken into consideration.

Thanks in advance.

Berny

Find more posts tagged with

Comments

johnw

In your Data Source, set the flatfile style to SSV.

magic_bern

Thank John for the reply,
I have tried doing setting the style to SSV but only the first column gets return the remaining ones are just not coming back on the data set.
also i am working on a very restricted machine am i am unable to change the file extention to ssv. having to choose *.* when looking for the file when creating the dataset

Thanks

mwilliams

magic_bern,

Did you ever find a solution to this?

Abhijit Mandal

Hello ,
 
I am trying to have CSV file as datasource.
case 1:
I used relative path and it works fine in Eclipse Birt designer.
case 2:
I used absolute path and it works fine in Eclipse Birt designer.
but when i deploy the .rpt files to the server and i keep my CSV file in server same folder where the report are and with the proper path .
and try to run from browser it does not fetch any value ,and same works with Birt designer.
can you please help me to identify my problem.

pricher

Hi,
 
You're not saying if you are using BIRT Open Source or BIRT Commercial (iHub). In BIRT Open Source, the BIRT_RESOURCE_PATH context parameter (in web.xml) will determine where resources (csv files, libraries, etc) are located. By default, it is the same as the BIRT Home, which is the root folder of where BIRT is installed in your application server.
 
Hope this helps,
 
P.

Abhijit Mandal

Thanks for your reply and wish you Happy new Year.
I am using BIRT Open Source,
 and In Server we have BIRT runtime.So no web.xml file .
i putted my CSV file in the server the same location where i am putting my BIRT rpt file,I copied the UNC path from Copy file name of CSV. and i putted UNC path the BIRT_RESOURCE_PATH context parameter (in web.xml) in the designer from which i am designing the report .and saved the report and then putted the .rpt file
in server.but its still not able to fetch the data from CSV .
while designing the Report in Flat file datasource source connection i am using various way as:
Case 1:UNC path of CSV file
Case 2:Absolute path of CSV
Case 3:Relative path of CSV
i also tried in propery binding to change the path with
Case 1:UNC path of CSV file
Case 2:Absolute path of CSV
Case 3:Relative path of CSV
but non of the senerio works after deploying in server can you please help me out.