What is the default format of csv file generated through iBot (UNICODE / UTF) ?
How can we configure a single iBot to generate CSVs, for example, in UTF format instead of UNICODE (assuming UNICODE is default).
Currently the CSV format in Agents always delivers the report results in tab delimited CSV. Is there a setting that can make the report result in a comma delimited CSV format when the reports are setup via Agents/iBots?
There is no setting that would make CSV output from an iBot be comma delimited as opposed to the tab delimited output from the web UI.
There is an enhancement request for this functionality. for more information, see bug 13802667 - COMMA DELIMITED CSV FORMAT FOR AGENTS/IBOTS has been logged to include this feature in future release.
As a work-around, you can to run a custom script from an Agent to convert tabs to commas. See chapter 4 (http://docs.oracle.com/cd/E21764_01/doc.1111/e18562/schedjobscripts.htm#BABGFBBD) of Oracle® Fusion Middleware Scheduling Jobs Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) Part Number E18562-01 for more information on writing custom scripts.
If helps pls mark