Summary

How can we generate a report in csv format using FOProcessor

Content

Hi

Currently we use BIPublisher reports using FOProcessor API.  I have articles noting that we can generate report output in csv format.  However, I couldn't find any details on how to do the same using FOProcessor.  I am guessing we will have to do do set something in the settings but no documentation can be found on what are all the settings that are supported.  We roughly use the code similar to the snippet attached.  There is no CSV format type CSV defined in FOProcessor.

Doc noting csv format availability: 

https://docs.oracle.com/middleware/12213/bip/BIPRD/GUID-BBB60FD1-06A8-42BA-BD41-B351BD0B4816.htm#BIPRD-GUID-BBB60FD1-06A8-42BA-BD41-B351BD0B4816

Any help is greatly appreciated.

Thank You

Pat Malay

Code Snippet

  public static void main(String[] args)
  {

    FOProcessor processor = new FOProcessor();
    processor.setData(args[0]);     // set XML input file
    processor.setTemplate(args[1]); // set XSL input file
    processor.setOutput(args[2]);  //set (PDF) output file
    processor.setOutputFormat(FOProcessor.FORMAT_PDF);
    Properties prop = new Properties();
    /* PDF Security control: */
    prop.put("pdf-security", "true");   
    /* Permissions password: */
    prop.put("pdf-permissions-password", "abc");
    /* Encryption level: */
    prop.put("pdf-encription-level", "0"); 
    processor.setConfig(prop);
    // Start processing
    try
    {
       processor.generate();
    }
    catch (XDOException e)
    {
       e.printStackTrace();
       System.exit(1);
    }

    System.exit(0);
  }