Excel Tools

Hi,

after updating the plug-in to the latest version we get the following error in one of the features:
Error Evaluating UI Expression Expression evaluation error [evaluation ID = d2a80:fc853] in rule 'ais_cases' : The function 'getdatasubsetdownloadlinkfromprocess' is unavailable.

Do we need to make an update in the feature to update this model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset ?

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!