CSV datasource

ReportServer (EN)
1

Hello,

I aim to use data from a CSV file. If you have a method, I would thank you a lot to share it ! Below, my unsucceeded attempts.

I have inserted a CSV datasource (with text connector) and, as mentionned in documentation, I have added a H2 internal datasource (the test connection is passed). Then, I have added a dynamic list.

Firstly, I have linked the dynamic list to the H2 database (with empty query). When selecting columns, I get the error
“The report could not be executed: Could not open connection to: jdbc:h2:file:/opt/bitnami/apache-tomcat/temp/rsidb//rsdb with user: bitnami. Query may not be empty”

Secondly, I have linked the dynamic list to the CSV datasource. When selecting solumns, I get the error
“The report could not be executed: java.lang.IllegalStateException: java.lang.IllegalStateException: java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Wrong user name or password [28000-180]”

Regards

2

Hello Mathilde,

I think there might be a misunderstanding. A CSV datasource does not need an additional H2 datasource. It uses it as a backend, but this should all happen behind the scenes. To use a CSV datasource, all you need to do is to create the datasource, say with a text connector. Then input the CSV data into the text field. Then simply select the datasource as the datasource for a report or datasource parameter.

I hope this helps.

Cheers
-Arno

3

Hello Arno,

Thanks a lot for your answer ! Good to know for the H2 database.
However, I still get the error when I try to select colums.
“The report could not be executed: java.lang.IllegalStateException: java.lang.IllegalStateException: java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Wrong user name or password [28000-180]”
This error is quite meaningless because there is no login for pasted text, obviously !
The problem may be in the connection to the H2 internal database ? I also wonder what query could fit a CSV list.
For information, I run with the Ubuntu VM from Bitnami and the client is on Windows.

Have a good week-end,

4

Hi Mathilde,

I just did a fresh install (on a Mac) and there it seems to work. I did the following steps:

  1. Go to Datasources in admin area and create a CSV list
  2. Give it a name, choose the text connector and enter
A;B;C
1;2;3
4;5;6
  1. Click apply
  2. go to report management and create a dynamic list
  3. give it a name and choose as datasource the just created CSV list. Leave the field query wrapper blank and hit apply.
  4. execute the dynamic list.

As for your error message: is there a stacktrace or anything more specific that you could post?

Cheers
-Arno

5

Thank you Arno for the reply.
That was I did, with the error, and now it works …

Regards

6

Glad to hear, that it works now.

Cheers
-Arno