Web Viewer (Eclipse) and CSV-export / IDataExtractionTask giving different results
<p>Hi! As stated in the title, I have a problem with extracting data from a report. My goal was to get exactly the same data that is presented when using the integrated web viewer of eclipse.</p>
<p>I noticed that in some cases this isn't working as expected. In particular the problem i am currently facing is that the default CSV-export and my own tool which is using an IDataExtractionTask are both returning two rows containing the same values, while the Web Viewer only shows one row for the same table (what seems to be the expected behaviour). My goal is that users can create reports with the default eclipse designer, check with the Web Viewer if the report works correctly and once finished use the report regularly with my custom tool to further process / export / upload the data to our own systems.</p>
<p> </p>
<p>My question is: how is it possible to extract the data in the exact same way as the Web Viewer does, so that the viewer can be used as a "reliable preview" before the reports are used with an automated tool? Where can i find information on how the data for the web viewer is extracted? Is the DistinctValuesOnly flag of the web viewer set by default? if yes, how can that be changed?</p>
<p> </p>
<p>In case this is relevant, I'm using BIRT 4.4.1</p>
<p> </p>
<p>Thank you in advance!</p>
<p>I noticed that in some cases this isn't working as expected. In particular the problem i am currently facing is that the default CSV-export and my own tool which is using an IDataExtractionTask are both returning two rows containing the same values, while the Web Viewer only shows one row for the same table (what seems to be the expected behaviour). My goal is that users can create reports with the default eclipse designer, check with the Web Viewer if the report works correctly and once finished use the report regularly with my custom tool to further process / export / upload the data to our own systems.</p>
<p> </p>
<p>My question is: how is it possible to extract the data in the exact same way as the Web Viewer does, so that the viewer can be used as a "reliable preview" before the reports are used with an automated tool? Where can i find information on how the data for the web viewer is extracted? Is the DistinctValuesOnly flag of the web viewer set by default? if yes, how can that be changed?</p>
<p> </p>
<p>In case this is relevant, I'm using BIRT 4.4.1</p>
<p> </p>
<p>Thank you in advance!</p>
0
Comments
-
<p>The out of the box CSV data extraction is going to export the CSV based on the data bindings for the particular report elements and is not going to align 100% with the table/preview displayed in the web viewer.</p>
<p> </p>
<p>Instead, there is a CSV emitter that has been created that is intended to export a CSV that more accurately represents what is displayed i the web viewer.</p>
<p> </p>
<p>Take a look at the CSV emitter here: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/801-csv-emitter-plugin-for-birt/'>http://developer.actuate.com/community/forum/index.php?/files/file/801-csv-emitter-plugin-for-birt/</a></p>
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management