How do I add a CSV datasource in Japser Server?

Hello, I am trying to publish a report to a jasper server that uses a CSV file as a datasource. In jasper studio I am able to create a csv data adapter for my api which returns a csv file at a URL. How can I add this url as a csv data source so I can use this report on my server? When adding a datasource I only see these options:

Any help on the matter would be appreciated.

Thanks!

r.i.p.Harambe's picture
Joined: Aug 1 2016 - 9:09am
Last seen: 6 years 10 months ago

2 Answers:

Hello,

 

Along with the above solution you can also try another way like this one.

Please refer to the 4.12 section- "File Datasource" of TIBCO JasperReports Server Administrator Guide.
https://community.jaspersoft.com/documentation/v8-v80-v800/tibco-jasperr...

Could you use this file as I made the changes in this file and confirmed I am able to see the datasource i.e Text Datasource i.e CSV datasource in the list.
Make sure you did the comment out i.e. disable the line as given below

   <!-- <value>textDataSource</value> -->

and saved the file and restarted the jasperserver to reflect the changes.

 

I hope this will help you!

 

Thanks!

Attachments: 
Swapnil Pawar's picture
Joined: Apr 22 2021 - 5:44am
Last seen: 2 days 10 hours ago

The best way to do this is to delete your uploaded report,  go back to studio and set your CSV datasource as the default data adapter.  Then when you upload again, you should be able to upload the adapter along with the report. 

See this topic for info on setting a default data adapter.  Then when you upload, select "no data source" and the adapter should come along and set itself.

elizam's picture
14366
Joined: Mar 5 2012 - 9:19am
Last seen: 2 years 10 months ago
Feedback