How can I use a flat file dataset in RTC
Hi,
I am using a flat file dataset (.csv) in a BIRT report. When I run my report on my local machine, everything is working fine.
When deploying the report to RTC now as a reporting resource, I include the .csv in the 'files' section in the report resource properties window. However, when running the report it throws an error indicating that the file cannot be opened.
I guess the reason is that the absolute path to the file I have specified in the BIRT report designer is not valid on the server and instead I should give a relative path. However, I have not been able to find out which relative path to use here...
Can somebody help me in deploying this report?
Thanks a lot!
BR,
Ray
2 answers
Hi Ankur,
You wrote, "For that, while uploading the report source, you have to attach the csv along in the Files section."
However, I don't think we can user csv in Files section as a data source, because the path of CSV should be an absolute path in a data source. Do you know how to know the absolute path of csv file which is added into Files section?
For that, while uploading the report source, you have to attach the csv along in the Files section. Use the green + sign in web UI or Add button if you are using Eclipse client.
Comments
Flat file data source with relative path seems only available for BIRT in 4.2 or later, from the BIRT 4.2 new and notable features
In RTC 403, we still with BIRT 2.6.2, thus can only use absolute path.
Hi,
I am using RTC 4.0.2 and BIRT 2.6.2 version. I added the csv file into Files section. But throwing below error.
Table (id = 9):
+ An exception occurred during processing. Please see the following message for details:
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: xxx.csv
Any solution will be helpful
Regards,
Tojan.
Comments
ankur sharma
JAZZ DEVELOPER Jun 12 '13, 7:37 a.m.I tested with RTC 403 and it works for me. What version did you try it with? Can you explain the report more. It is connecting only to CSV files or there a data set for Jazz Data Source too?
Raymond Packbier
Jun 12 '13, 10:52 a.m.Hi Ankur,