Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
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
Did you figure it out?
Hello,
I was not sure why I received an error - ???Unknown column <col> in 'field list'???. when I was using Import Excel to Database smart service
I created a new database table (ii_excel_test) in MYSQL database with four columns - id, user, name, date.
I created a xlsx file that include 4 headers and one row
I entered the following values to the data tab of the smart service
I agree on this, it will be easier for us to apply our own error handling if the plugin can handle such error
I agree, this could be handled easier that way rather than trying to just cancel the entire process itself.
How come the Import Excel to Database smart service has output variables Error Occurred and Error Txt, but the activity throws out an exception such as below:
???Unknown column <col> in 'field list'???
Can the plugin also handle such error so we can gracefully perform our own error handling? E.g., notifying user, tagging document as invalid, etc.
Hello Everyone,
we are facing an error when using smart service to import csv to database "PostgreSQL".
Smart Service: "Import CSV to Database v5". Error:"ERROR: syntax error at or near "`" Position: 139"
Appian version 21.1
Any help please?