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);
}
