Integrating CSV Emitter

Hi, 
 
I've downloaded the CSV emitter from actuate (<a class='bbc_url' href='http://www.actuate.com/products/products-resources.asp?ArticleId=11719)'>http://www.actuate.com/products/products-resources.asp?ArticleId=11719)</a>, renamed the zip file to .jar and dropped it in platform/plugins. 
 
I then added that jar to my build path and created a CSVRenderOption object. 
 
But when I try to render my report to CSV, I get the following exception: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
18-Aug-2008 15:41:09 org.eclipse.birt.report.engine.api.impl.RenderTask render
SEVERE: An error happened while running the report. Cause:
org.eclipse.birt.report.engine.api.UnsupportedFormatException: The output format CSV is not supported.
at org.eclipse.birt.report.engine.api.impl.EngineTask.createContentEmitter(EngineTask.java:1084)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:428)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:167)
</pre>
 
I'm assuming there is a further step to associate the emitter and render so the engine knows what emitter to use for the given render option, but cannot find any documentation on this? 
 
Any suggestion welcome at this stage! :-) 
Cedric

Find more posts tagged with

Comments

mwilliams

Cedric,

Do you have a copy of the eclipse.org book "Integrating and Extending BIRT"? If so, they have instructions on building and deploying the csv emitter plug in. If not, let me know.

cypherdj

I don't unfortunately have this book, but could always order it. I simply followed the steps described on the actuate site. Is there more to it than meets the eye?

mwilliams

Cedric,

I'll just list the general steps that it says to do. It goes into more detail in the book on how to do it, but these are the steps for testing the CSV report rendering plug-in that is says you need to do:

-Build the csv emitter plug in
-Deploy the plug-in to the BIRT run-time engine directory
-Launch a run-time instance of the Eclipse PDE
-Create a Java application that runs a report design and writes the report's table data to a CSV file.
-Create a report design containing a table that maps to a data source and data set
-Run the application and examine the output in the CSV file

I'll have to look at the steps on actuate.com to check for differences.

cypherdj

Thanks Michael, much appreciated. No rush on this, it looks like this requirements might be dropped as we have export to Excel, so users can convert to CSV if they so wish.

Regards,
Cedric

catchme33

hi all frnds
i m working with birt since last week and go tto know that it generates html and pdf format only.
can u plz share the way to generate reports in csv format also
any sort of help will be appriciated
and also would lik eto know how to integrate it with tomcat webapplication,if possible

waiting for reply

mwilliams

Hi catchme33, 
 
As Cedric posted earlier. You can download a csv emitter at <a class='bbc_url' href='http://www.actuate.com/products/products-resources.asp?ArticleId=11719'>Actuate BIRT Community Contributions</a>. 
 
The following link should help you with integrating BIRT with tomcat: 
 
<a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php'>Installing the BIRT Viewer in Tomcat</a>

catchme33

thx michael,
i hav taken csv pluguin
but its giving problem in generating csv format saying

org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:org.eclipse.birt.report.service.api.ReportServiceException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.
at org.eclipse.birt.report.service.BirtViewerReportService.runAndRenderReport(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.BirtRunAndRenderActionHandler.__execute(Unknown Source)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source)
at org.eclipse.birt.report.presentation.aggregation.layout.EngineFragment.doService(Unknown Source)
at org.eclipse.birt.report.presentation.aggregation.AbstractBaseFragment.service(Unknown Source)
at org.eclipse.birt.report.servlet.BirtEngineServlet.__doGet(Unknown Source)
at org.eclipse.birt.report.servlet.BaseReportEngineServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)

......

and so on
i hav tried to find out solution for that
but won't get solution yet
any idea abt this sort of problem
if yes, plz help
thx in adv.
regards
- - - - - - - - -
catchme 33

catchme33

hi all
i hav solved problem with csv emitter
it just that csv emitter is not in correct structure
after correcting it it has started working in eclipse
but it is still not working in tomcat
i belive same plug in will b needed if v need to generate BIRT reports
so anyone can tell me abt
How to use/add plugin in tomcat to run BIRT reports
any help will b appriciated
thx

Cool_Anoop

I am a new user of Birt . I have also faced problem for rendering report(Standalone java apllication) as CSV format. 
Just follow the steps as given for the link 
(<a class='bbc_url' href='http://www.birt-exchange.com/blog/page/2/)'>http://www.birt-exchange.com/blog/page/2/)</a>.

kanneganti

SEVERE: Report engine can not create csv emitter.
14:10:42,468 ERROR [STDERR] java.lang.RuntimeException: org.eclipse.birt.report.engine.api.EngineException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.
14:10:42,468 ERROR [STDERR] at gov.michigan.msp.report.sor.mdp.SORReportProcessor.generateReportBlob(SORReportProcessor.java:374)
14:10:42,468 ERROR [STDERR] at gov.michigan.msp.report.sor.mdp.SORReportProcessor.onMessage(SORReportProcessor.java:284)
14:10:42,484 ERROR [STDERR] at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:531)
14:10:42,500 ERROR [STDERR] at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:466)
14:10:42,500 ERROR [STDERR] at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:435)
14:10:42,515 ERROR [STDERR] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:322)
14:10:42,531 ERROR [STDERR] at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:260)
14:10:42,531 ERROR [STDERR] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:944)
14:10:42,546 ERROR [STDERR] at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:868)
14:10:42,546 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
14:10:42,562 ERROR [STDERR] Caused by: org.eclipse.birt.report.engine.api.EngineException: Report engine fails to initialize csv emitter, please make sure required libraries for this emitter are installed.
14:10:42,578 ERROR [STDERR] at org.eclipse.birt.report.engine.api.impl.EngineTask.createContentEmitter(EngineTask.java:1457)
14:10:42,578 ERROR [STDERR] at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:102)
14:10:42,593 ERROR [STDERR] at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:75)
14:10:42,609 ERROR [STDERR] at gov.michigan.msp.report.sor.mdp.SORReportProcessor.generateReportBlob(SORReportProcessor.java:364)
14:10:42,609 ERROR [STDERR] ... 9 more

mattsbr627

<blockquote class='ipsBlockquote' data-author="'cypherdj'" data-cid="36032" data-time="1219071025" data-date="18 August 2008 - 07:50 AM">
Hi, 
 
 
I've downloaded the CSV emitter from actuate (<a class='bbc_url' href='http://www.actuate.com/products/products-resources.asp?ArticleId=11719)'>http://www.actuate.com/products/products-resources.asp?ArticleId=11719)</a>, renamed the zip file to .jar and dropped it in platform/plugins. 
 
 
I then added that jar to my build path and created a CSVRenderOption object. 
 
 
But when I try to render my report to CSV, I get the following exception: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>

18-Aug-2008 15:41:09 org.eclipse.birt.report.engine.api.impl.RenderTask render

SEVERE: An error happened while running the report. Cause:

org.eclipse.birt.report.engine.api.UnsupportedFormatException: The output format CSV is not supported.

at org.eclipse.birt.report.engine.api.impl.EngineTask.createContentEmitter(EngineTask.java:1084)

at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:428)

at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:167)

</pre>
 
 
I'm assuming there is a further step to associate the emitter and render so the engine knows what emitter to use for the given render option, but cannot find any documentation on this? 
 
 
Any suggestion welcome at this stage! :-) 
 
Cedric </blockquote>
 
 
Hi Cedric - 
 
Were you ever able to get this resolved? I'm experiencing the same exception in my environment using BIRT 2.5.2. 
 
Thanks, 
Matt