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:
Get Workbook and Sheet Metadata
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
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.