Dynamic Flat file / URL CSV Stream

Tichy

Hi,

is it possible to give a birt report instead of a flat file an url that returns an input stream containing csv data.
When I use xyz.action (struts2) instrad of xyz.csv I will receive an error message from the birt viewer:

org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details: Failed to prepare the following query for the data set type org.eclipse.datatools.connectivity.oda.flatfile.dataSet. [select "COLUMN_1", "COLUMN_2", "COLUMN_3", "COLUMN_4", "COLUMN_5" from "csvStream.action" : {"Item","COLUMN_1",STRING;"Point","COLUMN_2",DOUBLE;"Deviation","COLUMN_3",DOUBLE;"Style","COLUMN_4",INT;"N","COLUMN_5",INT}] Invalid table name:"csvStream.action"

Is there another possibility to work with streaming csv files?

thx.

bhanley

Have you considered using a scripted data source? This would let you handle the streaming data in a POJO and make the fields available that way.