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:
Hi All,
Is there any other way other than deleting the old version as this seems to manual change for us in 100s of process models and expressions.
One option could be check outdated dependents after the plugin is deployed with new version of Exportable Data Subset. But I haven't tried it and unsure if that will work. Any other suggestions on upgrading the plugin without deleting the older versions?
Thanks in advance,
Arjun.
Hi,
Which format will it support to read date value?
In excel file I had given, 20-07-2020, when readexcelsheet() function, it returns "2020-07-20 00:00:00" (Year-Month-Date time)
For input 05-07-2020, it returns "05-07_2020"
It is behaving differently when date is greater than 12 and less than 12. Which is the correct format to give date in excel file?
Hi Bhargav Solanki,
We are using Appian Cloud Environment, So do we still need to delete ExportableDataSubset CDT?
Hi
We are facing the similar issue, how you have solved this problem?
Is there any known compatibility with non-MySQL databases?We have a postgres on-premise data store, but the 'Import CSV to Database' and 'Load CSV to Database' both throw some syntax related errors (.e.g. unrecognized ` character).
Thanks in advance!
Hi Bhargav Solanki
My CSV has a column of varchar2 type (in Databse) in which data is separated by pipe |, this data is not getting imported.
Can you please provide a detailed description of the steps you are taking including the number of columns in the CSV and where do you see the error?
I am using the plugin "Import CSV to Database4". I am getting the error: "java.lang.ArrayIndexOutOfBoundsException: 12"
Any idea on why it is so? The size of my csv is 20381 KB.
Thanx in advance!!
Thanx Hema, this helped !!