Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
- Added LOAD CSV to DB Smart Service - fast CSV import for MySQL database that are not hosted on Appian Cloud
Sanchita GuptaDoes that mean Load CSV to DB Smart Service will work only for databases that are not hosted on Appian Cloud?
So the first issue here is the syntax for calling the function. You cannot use keyword syntax when calling a plugin, you must use position syntax: docs.appian.com/.../Expressions.html
An example syntax would be queryAppianLogs("select * from login-audit",null,{"String", "String", "String","String","String","String"},null,false) to fill out the inputs for sqlStatement, subFolder, columnTypes, timestampFormat, and hasHeader respectively.
Testing using this syntax produces more expected results however passing false for hasHeader seems to skip the first row of data in the file so we will look into fixing that. In the meantime, the Log Reader plugin can also pull csv data.
Can we update the ReadExcelFile function so we can pass paginationData? If I have large data sets in excel, I'd like to control how many rows I read at at time.
Hi - you can request permission from the author to update the plug-in using the AppMarket Submissions site: https://forum.appian.com/suite/sites/appmarket-submissions/page/home
There appear to be two unused arguments for the Import Excel To CSV smart service. Drilling into the plugin, it appears that ExcelHelperUtils.java::convertExcelToCSV does not use numberOfColumnsToReadInRow or rowNumberToReadFrom . It appears that implementation of either would be straightforward, given that they modify iterator start or exit conditions. Would it be possible to get this fixed in the next version of the Excel Tools plugin? Is there a way I can contribute these changes?
Hi April,
Yeah, I posted in discussion excel-generation-with-base-template also requested feature update in feature-request-update-the-export-data-store-entity-to-excel-smart-service-to-accept-an-excel-base-template
Thanks for your reply.
Hi Muthulakshmi - I'd suggest posting your question in Discussions as it will get more visibility there!
Hey All, Is there any smart service which have "Base Template" option, like we had in "Export CDT to excel". Requirement is excel generation with two pages. First page data comes from data store entity, where as second page is static information, which is fixed data. As the "Export Data Store Entity to Excel" not having base template, how to achieve this? Thanks in advance.
Yes, I've reproduced this issue just now as well. It appears that the queryAppianLogs() function doesn't actually support all of the parameters that are listed. Maybe Sanchita Gupta or Michael Chirlin have some insight into this issue.
*..when utilizing queryAppianLogs() with hasHeader=false. For instance:
queryAppianLogs( sqlStatement: "select * from login-audit", hasHeader: false)
returns a result set with the column name the same as the column value, not "COLUMN1,COLUMN2.." as defined. Is anyone else having this issue?