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
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 !!
In Convert Excel to CSV Node, please check the value for "Number Of Columns To Read In Row" in Node Inputs, If that is 0, you will receive an empty CSV. Try giving some value or leaving it to blank instead of 0.
I have faced similar issue last week and when I updated this, the node worked fine.
I am facing an issue with "Convert Excel to CSV". In Excel there is data. However, when the excel is inputted to this smart service to convert it to corresponding .CSV, it gets it converted into a CSV but the CSV is empty.
Any help on why is this happening? It was working fine till 7th June (I checked the folder where both the .xslx and corresponding .csv is getting stored). However it is not working now. Just an FYI, the version of my environment is 20.1 and we the upgrade has happened more than month ago (so I don't think the upgrade has anything to do with this).
Can I get a suggestion of why the smart service is behaving like this? Thanks in advance!!
Yes, please delete the old plugin, then please delete all old versions of the "ExportableDataSubset" CDT After that, deploy paste the new file in the folder.Then update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset.
while tried using the plugin version 2.7.7 on Appian 20.1 Cloud there were no issues reported on process model but on log found below error
2020-06-02 08:09:22,051 [Appian Work Item - 4821 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase5 - Unknown column 'ID' in 'field list' com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ID' in 'field list'But the column ID exists on .csv file and Db table as first column.