Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

How can I use a flat file dataset in RTC

Questions
Tags
Users
Badges
Raymond Packbier
(11●1●1●2) edited
May 20 '13, 6:33 p.m.
 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

1 vote

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, I was working with RTC 4.0.2 which is deployed on our server right now. The report was using the Jazz live snapshot as well as a flat file data set (the flat file was used to feed some parameters into the report that were coming directly from an excel file). When running the report locally on my machine it worked fine (both for flat file and JAZZ data source), but when deployed on the server I could not find a place to store the flat file so the report would find and use it. 

2 answers
10,194 views
1 vote

2 answers

Permanent link
Kohji Ohsawa
JAZZ DEVELOPER (595●1●3●10) Jul 10 '14, 11:12 p.m.
 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?

2 votes

Permanent link
ankur sharma
JAZZ DEVELOPER (662●1●22●28) Jun 14 '13, 5:09 a.m.
 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.

0 votes

Comments
Joseph Mao
JAZZ DEVELOPER Aug 28 '14, 7:17 a.m.
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. 

Tojan John
Sep 05 '14, 2:55 a.m.
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.

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144
× 485
× 324
× 232

Question asked: Apr 18 '13, 5:49 p.m.

Question was seen: 10,194 times

Last updated: Sep 05 '14, 2:55 a.m.

Confirmation Cancel Confirm