Overview
Provides several smart services and functions for handling data in Excel and CSV formats.
Key Features & Functionality
Smart Services included are:
Functions included are:
How to configure import excel to database smart service?
getdatasubsetdownloadlinkfromprocess this function is deprecated from the latest version of excel tool(2.2.16) plugin.
Please suggest if any alternative is available.
How can I use the "Query Appian Logs" function?
Hi All,
I get the below message in the health check report and we have the latest Excel Tool plugin 2.2.15 with APPIAN 21.3
"Excel Tools (com.appiancorp.ps.exceltools) references private Appian APIs[private] com.appiancorp.common.xml.XmlBeanSerializer.populateObject(java.lang.Object, org.w3c.dom.Node)"
Could you please let me know , why am i getting this error even with the latest excel tool plugin?
Has anyone had any joy with using the function queryappianlogs in a High Availability environment ? It seems to be limited to only retrieving the logs from the application server where the user is using the function ? If this is a current limitation are there any plans to enhance the plug in to pass in the log path as per the Log Reader plug in ?
When using the 'Convert Excel to CSV' smart service in a process model, the node is failing when given an OOXML Excel file. It appears to be an issue with the Apache poi libraries not supporting OOXML files.
Is there any workaround to this? I've tried configuring the error output of the node to display an error message to the end user but it appears that the node fails before it can even write the error output. I also can't think of any way to check the file type in the process as the file extension of the OOXML Excel is identical to that of a regular Excel.
Check the encoding on the CSV file you are giving it - I had the same issue until I swapped the encoding from UTF-8 BOM to UTF-8.
Hello, I'm having a problem while using the Load CSV to Database, its loading the data but for some reason the first column is always set as null, even though they have values, other columns are putting the correct data.
Any idea on the issue ?
Hi,
I am encountering the below error while using the smart service. But the weird part if data is inserted in the data but the smart service is throwing the error.
???(conn=5227088) Incorrect date value: '10/13/21' for column `Appian`.`TEST_TABLE`.`TEST_DATE_2` at row 1???
In the excel I am having the date format as 2020-12-25.