Excel Tools

Hi Dmitry Bocharnikov, so we are trying the same with New Columns: "PROCESS_ID","CREATED_BY" ,New Column Values: pp!id,pp!initiator, its only considering processId, but not created by, any solution to this( meaning considering only 1 parameter. Any solution to this please?

Note : Using a .dat file

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 ?