Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

Wednesday, 1 April 2009

How to change CSV Delimiter in Discoverer

Discoverer does not have the feature to change the delimiter when you export CSV format from it. This has been rejected by Development with the enhancement request :
Bug 3179364 ENH EXPORT CSV FORMAT SHOULD BE ABLE TO SPECIFY THE SEPARATOR
So, Discoverer will always use the comma as delimiter when you export to .CSV format.


Now, to complete the picture, the delimiter is defined on Microsoft Operating System in the Control Panel >> Regional Settings => Numbers tab => List Separator and this is taken for example from Excel, so if you save from excel in .csv the delimiter will be the one defined in the List Separator. In any case, this is not a standard, so the point that it is working this way on Excel does not means that it should works the same on all other softwares, like Oracle Discoverer, this is not a bug in functionality. Generally .csv delimiter is always associated with comma :

http://tools.ietf.org/html/rfc4180
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm

Wednesday, 25 February 2009

How to Change the Alignment of Page Item in HTML Exported Report Arabic Workbooks From Left To Right

Incredible grow in IT area has been observed in Arabic countries. That's why I've decided to post this info:

Exporting Workbooks from Discoverer Viewer with Arabic Locale in "Hyper-Text Markup
Language)archived)(*.zip)" format, does not align Page Items with the rest of the report. Indeed,
the body of the report (datapoints) are aligned to the right, page items instead are shown on the
left. How to change alignment for Page Items ?

Open the workbook with Discoverer Plus, highlight the Page Items then right click and select
"Format Heading". When dialog window shows, select right alignment icon and save the workbook.