Excel Tools

Hi Shala,

can you please change this part of code  bellow to let the user choose File Encoding.

DatabaseUtils.exportBufferedDataToFile

bw = Files.newBufferedWriter(Paths.get(filePath), StandardCharsets.UTF_8);

thanks.

We are unable to load special characters (from German language - ex. "ü") using the Import CSV to Database Smart Service. We are encountering error "java.lang.IllegalStateException: IOException reading next record: java.io.IOException: (line 5) invalid char between encapsulated token and delimiter"

Hi, 

Issue resolved (sort of) - open and save source excel manually before using merge service.

Regards

• Security Updates

Regarding:

• Export SQL data to CSV

I'm unable to locate/find this smart service when I search from the palette in Process Model. Can you please suggest?

How to import Excel to CDT ?

Hello,

Does 'Export SQL to Flat File' smart service continue to work fine with the 2.2.19 version of this plug-in?
Since I have a requirement to export multiple tables using SQL to CSVs.

Albeit  'Export SQL to Flat File' is deprecated, would there be any issues using it?
Also, is there any replacement for  'Export SQL to Flat File' ?

Please help, thank you!

Hello,

I do not see smart service Export CDT To Excel in the new version of Excel tools. Is there any reason why the Export CDT To Excel smart service has been removed in the new version of Plugin?

Thanks!

Has anyone had any luck on the above issue? We have similar requirement where we are using PostgreSQL

Hello All,

The service is erroring out as it cannot identify IFS() excel function, is there any workaround or anyway we can solve this?