Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
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
Observe a bug, when import excel file failure, this tool still occupy database and block other database operation
When import a excel sheet with empty cell (in database this column is a integer type), get
Problem: An error occurred in executing an Activity Class. Details: ???Incorrect integer value: '' for column 'CONTACT1' at row 1???
May I know this tool do not allow null value for integer? I test my database schema, column with integer type can be null
Hi Bhargav,
Is this plugin not compatible with 19.4 yet? I'm trying to use it in 19.4. When I executes the process, it completes successfully, but data doesn't seem to import into DB.
I tried both 'Import Excel to database' and 'Import CSV to database' with no success.
Not sure if anyone facing similar issues.