Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 152210

Summary: Support more features for CSV-files as datasource
Product: z_Archived Reporter: Holger Buchner <Holger.Buchner>
Component: BIRTAssignee: Xiaokun Yi <xyi>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3 CC: Holger.Buchner
Version: 2.1.0Keywords: plan
Target Milestone: 2.2.0 M2   
Hardware: PC   
OS: Windows XP   
Whiteboard: Autoed

Description Holger Buchner CLA 2006-07-28 16:15:25 EDT
When working with with csv-files with BIRT as datasource, it turned out, that they are today hard limited:
They support only ";" as Separators ("," and <TAB> or "|" would be recommended in addition, als well as there is no support for escaped characters in order to be able to have e.g. """ in Text-Columns.
It would be helpfull to be able to select the separation character, the text-field-delimiter as well a an escape-character to be able to have special characters within the dataset. 
To avoid further problems, the determination of the characterset used (e.g. UTF-8, Ansi, Codepage xxx) would help to better specify, what data will is provided for BIRT.
Comment 1 Xiaokun Yi CLA 2006-10-12 23:05:38 EDT
Support for 4 types of flat files were implemented, comma-separated-values(CSV), semicolon-separated-values(SSV), tab-separated-values(TSV), and pipe-separated-values(PSV). It can be specified during the creation of flat file data source
Comment 2 Xiaokun Yi CLA 2006-10-12 23:08:40 EDT
Support for comma-separated-values(CSV),semicolon-separated-values(SSV),tab-separated-values(TSV), and pipe-separated-values(PSV) were added, this can be specified during the creation of the flat file data source
Comment 3 Xiaokun Yi CLA 2006-10-12 23:46:16 EDT
Support for
comma-separated-values(CSV),semicolon-separated-values(SSV),tab-separated-values(TSV),
and pipe-separated-values(PSV) were added, this can be specified during the
creation of the flat file data source