Excel Tools

Hi Team,I am using import excel to database plugin.but facing some issue..In my excel ,I have one column with integer values,but when any values is null in row ...smart service not able to insert any data in database....Anyone also faced this issue and any resolution. ?

Hi,

We are getting below High Risk when we run the health check.

Excel Tools (com.appiancorp.ps.exceltools) references private Appian APIs
[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)

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!