SPAGOBI-863 - Creating BIRT report based on flat file - issue with defining delimiter for flat files

[KnowageServiceAcc]

Details

Key	Value
Key	SPAGOBI-863
Type	Bug
Status	Open
Priority	Minor
Resolution
Affects	3.3.0
Fix
Components	SERVER/Reporting/BIRT, STUDIO
Labels

People

Key	Value
Assignee	Angelo Bernabei
Reporter	KArolina Seczkowska

Dates

Key	Value
Created	2012-05-09T15:08:32.000+0200
Updated	2013-06-18T11:22:35.000+0200
Resolved	n.d.

Description

In SpagoBi Studio it possible to use flat file .csv coded in UTF-8 with comma as delimiter, the issue comes when you need to deploy it to spago Bi server then you need to create data set and there comes an issue you can create data set for it , but the file that has comma as delimiter won't be supported - it's necessary to convert to one with semi colon as delimiter becasue , file with semi-colon will be only supported.

Does it works as designed ? Is it possible to deploy Flat file based Birt reports on SpagoBI server?

Same with configuring Data Source for deploying BIRT report based on flat file- ... when deploying report you need to pass data source..

I tested with different configuration of csv files and below please find my findings:

                                                                 Spago BI Server                                         |          Spago Studio

---

ANSI format, semi-colon as delimiter | works fine | reuturns concatenation of values stored in row
| |
ANSI format, comma as delimiter | reuturns concatenation of values stored in row | works fine
| |
UTF-8 format, semi-colon as delimiter | works fine | reuturns concatenation of values stored in row
| |
UTF-8 format, comma as delimiter | reuturns concatenation of values stored in row | works fine

Comments

no comments