Excel Tools

• Added support to Import CSV to DB smart service for UTF-8 BOM encoded files

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.

Hi Mike, 

Can it validate/restrict millions of blank rows when our user upload a CSV with millions of blank rows by mistake?

We are facing the issue that it saves millions of blank data to our database in this situation.

Thank you!

Getting issue: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=' at line 1

using same csv file that was exported using export db to csv smart service

yes, faced same thing. header names have to be exact same as DB table names