Excel Tools

After updating the plugin getting the following errors (Note: It was working fine in the earlier version) :

1. Import CSV to Database v6  - Changed to Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss'.
   
   Snippet of Datetime format - "2021-12-10 14:20:42.740"
      
   
   
2. Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases. 
     

• Allow designers to map the Excel headers to database column names
• Allow Excel headers to begin at any cell instead of only A1

• Security Updates

Hello,

This version of the jar is subject to the recent commons-text vulnerability. Can you update Apache.CommonsText library?

Thanks

Hi can you please tell criticality of security upgrade 2.2.20 what functions / smart services are affected?

Hello,

Is your plugin is impacted by the CVE-2022-42889 ? Can you update the Apache.CommonsText library to 1.10 ?

Thanks

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)

1 plug-in is using Appian APIs that are deprecated, private or have been removed. Plug-ins using APIs that have been removed from the latest Appian version will fail to function after an upgrade. Plug-ins using private APIs are not supported and risk breaking during an upgrade or between hotfixes. Plug-ins using deprecated APIs require refactoring to use alternative APIs as they will be removed and stop working in a future release.

Regards,
Sandhya

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)