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

CSV file from classical model

nishant_mintri

Hi , 
I am trying to generate a csv file from the Classical Model . I first generate the rptdocument and use it to create my csv file . 
When i view the CSV file , my column headers are displayed as the names of the Columns from the Classical Data Set . 
Can anyone explain me , why might this be happening ? 
Attached is my rpt design .
 
And this is my code
 
IEngineTask task=null; 
 IRunTask runTask=null; 
 String rptDocument = "c:\\reports\\testing2Csv"+".rptdocument"; 
 EngineConfig config = new EngineConfig(); 
 try { 
 
 Platform.startup(config); 
 ReportEngine engine = new ReportEngine(config); 
 File csvFile = new File("c:\\reports\\testing2CsvFile.csv"); 
 
 ObjectOutputStream om = new ObjectOutputStream(new FileOutputStream(csvFile)); 
 
 //MY RPTDESIGN 
 IReportRunnable design = engine.openReportDesign("C:\\documents\\columnordering.rptdesign"); 
 runTask = engine.createRunTask(design); 
 runTask.run(rptDocument); 
 
 
 //MY RPTDOCUMENT 
 IReportDocument iReportDocument = engine.openReportDocument("c:\\reports\\testing2Csv.rptdocument"); 
 task = engine.createDataExtractionTask(iReportDocument); 
 
 
 ICSVDataExtractionOption extractionOptions = new CSVDataExtractionOption(); 
 
 extractionOptions.setOutputFormat("csv"); 
 extractionOptions.setSeparator(","); 
 extractionOptions.setOutputStream(om); 
 extractionOptions.setOutputFile("c:\\reports\\testing2CsvFile.csv"); 
 
 IDataExtractionTask iDataExtractTask = (IDataExtractionTask)task; 
 iDataExtractTask.extract((IExtractionOption)extractionOptions); 
 System.out.println(task); 
 
 
 
 }catch (BirtException e) { 
 e.printStackTrace(); 
 } catch (FileNotFoundException e) { 
 e.printStackTrace(); 
 } catch (IOException e) { 
 e.printStackTrace(); 
 } 
 
 }

Find more posts tagged with

Comments

mwilliams

The data extraction task extracts the data from the bound data set of an element in your report. To get the output as in your report layout, you'd need to create a CSV emitter.
 
Here is one option that has been posted in the devshare:
 
<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>
 
Or the Artorus emitters:
 
<a data-ipb='nomediaparse' href='https://www.arctorus.com/arctorus-birt-emitters/features'>https://www.arctorus.com/arctorus-birt-emitters/features</a>

micajblock

Also, the CSV output is a data export. The column headers in the CSV have nothing to do with the column headers in the report but are the binding names in the Table. The attached slightly modified report of yours should get the result you want.

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