3 Replies Latest reply: Nov 21, 2012 10:58 AM by Srini VEERAVALLI RSS

    Format of CSV file generated through iBot

    832697
      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).

      -Jimit
        • 1. Re: Format of CSV file generated through iBot
          Srini VEERAVALLI
          Check this doc ID 1459947.1

          if helps pls mark
          • 2. Re: Format of CSV file generated through iBot
            832697
            I could not find the doc 1459947.1 anywhere. Do you have a link to it? If yes, plz forward it to jimit_raithatha@infosys.com
            • 3. Re: Format of CSV file generated through iBot
              Srini VEERAVALLI
              Use this

              https://support.oracle.com/epmos/faces/ui/km/SearchDocDisplay.jspx?_afrLoop=324436281886916&type=DOCUMENT&id=1459947.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=130oxyc5cv_71


              Content:
              Goal
              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?


              Fix
              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