Excel Tools

Is there a way in this plugin by which we are able to get the sheet name (tabs name) in the excel spreadsheet from this smart service ?

• Added support for PostreSQL.

Hi Team,

I am using plugin html to csv. In converted csv file one of the column which has date value shows as "####".

Could you please advise if we can avoid this and values can be visible to user. ?

Hi there, is there any known problem about concurrency? We have checked that when we execute 2 processes concurrently that call the CSV to DB smart service, it fails due to an SQL exception, but if we relaunch every single failed process model, it can process with no problem. It seems that the plugin cannot manage more than one connection on the same time.

• Upgraded Commons Compress Version

Hi,

Is there any way to avoid the duplicate ingestion of csv data into database. Suppose second file contains the duplicate data compared to the first one, is there any way to ensure that the duplicate data do not append.

Regards,

Dushyant

you'd better set your "row number" columns in database auto_increment and then when it runs smart service it will automatically insert incremented values for each row in your table

Hi

Is there a way when usiing the import CSV to Database smart service and want to include a "row number"  in the target database in order to show which row of the csv the data was imported from?

The row number would start from 1 and be incremented for each row imported. (Kind of like an fv!index in a forEach.) The row number could be included as an additional column and additional value in the smart service inputs

Or

Is it better to just update the target database row number field after the import is completed ?

Regards

Hello, is it possible to fix the not happy flow ? (error handling in case of malformed excel workbook)

Hello, when we have a malformed excel workbook ( worng columns), the error handling doesn't work as expected. Is it possible to fix the not happy flow behaviour ?