Excel Tools

Hi,

We are seeing below High Risk when we run the health check even after be on latest version of excel tools.

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

while trying to generate excel through smart node - EXPORT SQL to EXCEL,   
i am getting the below error in process -
The following error was raised by the Export to Excel function: Attempting to write a row[1] in the range [0,5] that is already written to disk.  
And getting the below error in interface - {"error":"APNX-1-0000-000","message":"Invalid Content ID","title":"An Error Has Occurred"} 

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