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
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.
Bhargav Solanki , we have older installed on premise env. And the newer version file name is "com.appiancorp.ps.exceltools-2.2.7.jar".
How do we install this new version on our on-permise? we have already used smart services from this plugin on few PM.
1. Do we delete the old plugin on _plugin folder and place the new file?
2. or can the new file exisits along with the old plugin ?
please suggest
check if there are empty column after notes. If not copy the content data from the sheet and paste it into new sheet and try it out it might work.
Hello,
I am using "Import Excel to Database" smart service and getting an error "???Unknown column '' in 'field list'???" while writing to the data base. When I check the logs its adding one null column by default, Can anyone please help me in understanding the cause for this error and how to fix it?
insert into `MyTableName` (`ID`, `EID`, `Name`, `Notes`,``) values (\'1\', \'2\', \'gh\',\'\')',1054
Hi Ze-Yang,
As noted in our Plug-in Policies, content is free and made available as-is. All plug-ins are use-at-your-own-risk, and their functionality is not guaranteed by Appian.
HI - similarly to Content Tools, it should work with newer versions thank the "Compatible Version(s):" listed. Compatible Version(s) is a referenced of what the author says they have tested with when submitting the app. Appian has great backwards compatibility, so newer versions than listed should not be an issue.
Is this plugin compatible with Appian 20.1?
Hi Ze-Yang, free apps on the AppMarket are developed and supported by Community contributors. You can comment on AppMarket listings with feedback or contact appmarket@appian.com for more information. If you have a patch, you can request permission to update another person's app and if granted submit the new version through our AppMarket Submissions site
AppMarket FAQ
AppMarket Submissions
May I know where to report the bug or provide a patch