Can I use RTC4.0.2 and BIRT2.6.2 to fetch data from csv file
One answer
Yes, you should be able to use data source as flat file for csv. When creating data source, you can browse to csv file hence it should be ok to place csv file anywhere locally, for example, in your Eclipse client Workspace.
Have you tried that? Do you see any specific problem?
Have you tried that? Do you see any specific problem?
Comments
Hi Don,
Yes, I tried and getting below error:
Cannot open the connection for the driver: org.eclipse.datatools.connectivity.oda.flatfile.
org.eclipse.datatools.connectivity.oda.OdaException: Cannot open flat file database under directory C:\test\xxx.csv
If you get this problem after deploying the report, i.e. the report runs on a machine different to the one on which it is designed, the URI to the file "C:\test\xxx.csv" can be invalid. If possible, put the file on the other machine exactly the same as defined in the report. Otherwise, you may need to use parameters to point to the actual file.
http://www.eclipse.org/forums/index.php/t/29739/
http://www.eclipse.org/forums/index.php/t/509169/