Bug 152210 - Support more features for CSV-files as datasource
Summary: Support more features for CSV-files as datasource
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.1.0   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: 2.2.0 M2   Edit
Assignee: Xiaokun Yi CLA
QA Contact:
URL:
Whiteboard: Autoed
Keywords: plan
Depends on:
Blocks:
 
Reported: 2006-07-28 16:15 EDT by Holger Buchner CLA
Modified: 2009-07-23 00:10 EDT (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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