nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Headers in CSV FILE generated

nishant_mintri

Hi , 
I am trying to generate a csv file from the Classical Model . I create my csv file using ICSVDataExtractionOption and IDataExtractionTask . 
When i view the CSV file ,I am only able to see the fields that are linked with the dataset elements and not the Header Rows defined in the rptdesign.
 
Sippets of my code are : - 
 ICSVDataExtractionOption extractionOptions = new CSVDataExtractionOption(); 
 extractionOptions.setOutputFormat("csv"); 
 extractionOptions.setSeparator(","); 
 extractionOptions.setOutputStream(output); 
 IDataExtractionTask iDataExtractTask = (IDataExtractionTask)task; 
 iDataExtractTask.extract((IExtractionOption)options); 
We are using WebLogic 10.3.6 as App server for deploying and Java version is 1.6. 
Can anyone explain me , why might this be happening ? 
Attached is my rptdesign <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?app=core&module=attach&section=attach&attach_id=11135' title="Download attachment"><img src="http://developer.actuate.com/community/forum/public/style_extra/mime_types/unknown.gif" alt="unknown.gif"></a> <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?app=core&module=attach&section=attach&attach_id=11135' title="Download attachment">columnordering.rptdesign</a> 31.27KB and an image <a class="" href="http://developer.actuate.com/community/forum/uploads/monthly_02_2015/post-74325-0-27452300-1424350215.png" title="im.png - Size: 19.9KB"><img height="67" src="http://developer.actuate.com/community/forum/uploads/monthly_02_2015/post-74325-0-27452300-1424350215_thumb.png" width="100" alt="post-74325-0-27452300-1424350215_thumb.p"></a> of what i want to achieve .

Find more posts tagged with

Comments

nishant_mintri

Does no one have any idea about this issue :-( ???

JFreeman

I believe the issue you are facing is due to how the CSV data extraction works. It is not grabbing the headers from the labels in the table, it is using the data binding information for the columns in the table.
 
An alternative will be to use the CSV emitter plugin instead which will output directly to CSV and should carry over your header labels. I added the CSV emitter to my 4.2.2 designer and used it to export your report and all the header rows are all displayed properly.
 
The CSV emitter can be found 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>

nishant_mintri

I am using CSVEmitter , yet I do not get the intended result .
This is my code ... Any Help ?
 
 
IReportRunnable design = null; 
 try { 
 design = BirtEngineHolder.getBIRTEngine().openReportDesign(document.getReportRunnable().getReportName()); 
 } catch (EngineException e) { 
 
 e.printStackTrace(); 
 } 
 IEngineTask task = BirtEngineHolder.getBIRTEngine().createRunAndRenderTask(design); 
 ObjectOutputStream om = new ObjectOutputStream(new FileOutputStream(myCsVFile)); 
 CSVRenderOption csvOptions = new CSVRenderOption(); 
 
 csvOptions.setOutputFormat("csv"); 
 csvOptions.setDelimiter(","); 
 csvOptions.setOutputStream(om); 
 csvOptions.setShowDatatypeInSecondRow(true); 
 IRunAndRenderTask runAndRenderTask=(IRunAndRenderTask) task; 
 runAndRenderTask.setRenderOption((IRenderOption) csvOptions); 
 runAndRenderTask.setEmitterID("org.eclipse.birt.report.engine.emitter.csv"); 
 runAndRenderTask.run();

JFreeman

Can you attach the output you are receiving when using this code and CSV emitter?

nishant_mintri

My generated file is attached here

JFreeman

Can you attach the rptdesign that this csv file was generated from?
 
What is the output you receive when using this code against the "columnordering.rptdesign" sample report you posted originally?

nishant_mintri

Hi Jesse , 
 Due to some security concerns i cannot attach the file rptdesign of the file from which i have generated the output . The output of the columnordering.rptdesign is attached here

JFreeman

The issue may have to do with how your code is using the emitter.
 
Take a look at the attached user guide for the CSV Emitter and try restructuring your code to align with the sample code in the documentation.