It's all about the answers!

Ask a question

Can I use RTC4.0.2 and BIRT2.6.2 to fetch data from csv file


Tojan John (1172678) | asked Sep 05 '14, 6:38 a.m.

Hi,

I am using RTC4.0.2 client version and BIRT2.6.2version. I wanted to fetch data from csv file. Can I use data source as flat file with this configuration? If yes, where should i place the csv file? Any help on flat file data source is much appreciated. Thanks,

Regards,

Tojan.

One answer



permanent link
Don Yang (7.7k21110138) | answered Sep 07 '14, 7:59 p.m.
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?

Comments
Tojan John commented Sep 08 '14, 4:52 a.m.

 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


Donald Nong commented Sep 08 '14, 9:00 p.m.

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/

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.