Skip to Content
author's profile photo Former Member
Former Member

Scheduling Webi report in CSV using SDK (Java)

Can some one pass on references on how to schedule webi reports in CSV format using Java SDK. We have used getWebiFormatOptions() method to retrieve format options and set the format type for PDF, XLS, Webi formats. I don't see CSV format option in IWebiFormatOptions.CeWebiFormat.

Appreciate any help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 18, 2010 at 06:08 AM

    It's strange that in the Java doc, there is not a enum for CSV type in IWebiFormatOptions.CeWebiFormat, but there is a MHTML type.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 19, 2010 at 01:42 PM

    Are you confirming that for CSV, we have to use MHTML ? if that's the case, how do you set the delimiters, string separator etc ..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 23, 2010 at 12:44 PM

    Hi Kiran,

    CSV format is not directly available in Webi, so obtain the report output from reportengine in XLS format and using a XLS to CSV convertion API, convert the XLS to CSV, then schedule it. (Schedule can be of FTP, Email, File server as available in CMC).

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Aasavari Bhave

      hi aasavari,

      I am using an earlier version of BO.

      In the sample code you have provided is it possible to get a xls file, do some manipulations using java and send as csv to email..

      Will it be possible?

      regards,

      nitin ac

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 09:22 AM

    hi aasavari,

    I am using an earlier version of BO.

    In the sample code you have provided is it possible to get a xls file, do some manipulations using java and send as csv to email..

    Will it be possible?

    regards,

    nitin ac

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.