#1 2023-07-18 10:07:15

igray
Member
Registered: 2023-07-18

Dynamic List from CSV to MariaDB Table Data Sink

Hi there,

I have created a CSV Datasource which I have then created a Dynamic List. I now what to send the output of that to a table in a MariaDB database. When I send the report to the Table Datasink I get the following exception.

class net.datenwerke.rs.base.service.datasources.definitions.CsvDatasourceConfig cannot be cast to class net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasourceConfig (net.datenwerke.rs.base.service.datasources.definitions.CsvDatasourceConfig and net.datenwerke.rs.base.service.datasources.definitions.DatabaseDatasourceConfig are in unnamed module of loader org.apache.catalina.loader.ParallelWebappClassLoader @12c7a01b)

The two column names in Dynamic List are the same as the two fields in the MariaDB table which happen to be;
NGN
Routed

Any thoughts why I am gettting this exception?

Thanks,

Ian

Offline

#2 2023-07-20 15:38:50

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Ian,

this is currently not supported (CSV datasources -> table datasinks). I raised ticket RS-7623 for looking into this.

Regards,
Eduardo

Offline

#3 2023-07-20 19:02:10

igray
Member
Registered: 2023-07-18

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Eduardo,

Thanks for the update and for raising the ticket.

Much appreciated,

Ian

Offline

#4 2023-07-25 20:07:20

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Ian,

pls note that sending CSV/Script datasource data to table datasinks will be supported in the next RS 4.7.0. This is already implemented and will be available in 4.7.0.

Regards,
Eduardo

Offline

#5 2023-07-25 20:14:11

igray
Member
Registered: 2023-07-18

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Eduardo,

That is fantastic. Thanks so much for the update and for the rapid turn around. We really appreciate it.

All the best,

Ian

Offline

#6 2023-12-18 12:04:41

igray
Member
Registered: 2023-07-18

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Eduardo,

You have previously said that CSV/Script datasource data to table datasinks will be supported in the next RS 4.7.0.

I just wondered if you had a time frame of when that might become available?

Thanks,

Ian

Offline

#7 2024-02-02 08:14:43

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Ian,

we are currently working hard on the next RS 4.7.0 release which will contain of course more new features and improvements.

We can not mention a specific date/time frame, but keep tuned!

Regards,
Eduardo

Offline

#8 2024-09-17 07:20:50

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Ian,

pls note that 4.7 is released where this functionality is implemented: https://reportserver.net/releasenotes/RS4.7.0.html

RS-7623    New Feature    Support sending CSV/Script datasource data to table datasinks

Regards,
Eduardo

Offline

#9 2024-09-17 07:32:35

igray
Member
Registered: 2023-07-18

Re: Dynamic List from CSV to MariaDB Table Data Sink

Hi Eduardo,

Thanks so much for this. We will try this out in the next few days.

Kind Regards,

Ian

Offline

Board footer

Powered by FluxBB