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:
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.
Hi,
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?
Hi Mike,
A few of the listed smart services and functions in the description are deprecated in the plugin. Please update the description with available features and deprecated. Please let me know if I can find documentation for it anywhere.
Hi Everyone,
Is there any way to format the data before importing to DB using Load CSV to Database/Import CSV to Database
One of the column is unknown. Can untell me which smart service u r using
hi all,
has anyone come across the following error when attempting to import. the Smart Service is generating the exception :
???Unknown column '' in 'field list'???We've checked the Excel sheet and it looks to be valid with no hidden characters etc.