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:
Has anyone come across the error :
???Unknown column '' in 'field list'???
We've checked the Excel we're uploading and it matches the DB table correctly.
cry me a river
yes this is a bit ridiculous
Hello Everyone,
is there any DB compatibility issues with 'Import CSV to Database' smart service. I am using oracle and it doesn't seem to be working even after correct configuration.
Anyone also faced same issue, please let me know. TIA!
Hi,
Can we use the function readexcelsheet() to read an excel file with an extension .xlsb ?
Am getting the following error if I try to read the .xlsb file.
Expression evaluation error at function fn!readexcelsheet [line 3]:
Thanks.
Is there any limitations for the number of rows or size of the csv for 'Import CSV to Database'?
There's also a comment in that thread that says you can use a webApi to export CVS with more columns
from this post https://community.appian.com/discussions/f/plug-ins/14473/export-to-csv-with-more-than-50-columns it looks like the max is 50 columns
Is there any limitations on the number of columns that can be imported by using 'Import CSV to Database'?
Hi Dipti,
Even I am facing the same issue with paginginfo. Could you let me know if you have any solution for this please?