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 Saverio, I'm preparing to release a version 2.2.10 that has functionality that you are requesting. You will be able to specify two new parameters - list of additional columns and list of additional values to add that data to each row that is imported.
Please let me know what kind of issue you are experiencing when you are not able to get it to work.
Hi, can you provide information about the size of your dataset and the log of the error and which version of the Smart Service you are using. I have recently tested this smart service with 3.5 million records in my local environment and did not experience this issue.
Hi, please let me know the Smart Service where you have observed this behavior.
Hi, currently there is no way to do that with "Import Excel to Database". I'm preparing a release of v2.2.10 that has an enhancement to "Import CSV to Database" that supports ignoring null columns.
Please let me know if the CSV smart service will work for you or if you absolutely need the Excel one.
Hi Satya, it is OK to use v2.2.9 right now as the deprecated APIs have not been removed. I'm preparing to release version 2.2.10 that will also include the fixes this situation.
Hello,
when using the readexcelsheet() function I noticed the documentation for the "startRow" parameter says the first row is based on the 0 index. When I pass a 0 for that parameter, the function behaves as intended and reads all rows in the excel sheet. When I pass a 1 however, it performs the same behavior.
To exclude my headers on the first row, I have to pass the number 2 to the startRow parameter.
A small inconvenience, but thought I'd post here. Maybe the function is confused because the majority of Appian is based on an index base of 1? We're on version 20.2 in our Appian environment.
I found the issue. The permissions were not correct on the plugin files on the server.
Is there a way to ignore columns with nulls when using the Import Excel to Database service?
Hi All,
We are currently on Appian v20.2 and Excel Tools (v2.2.9). I have observed below deprecated Appian APIs are being used in the plug-in.
Could you please let me know if hey have any impact on the smart services or functions of the plug-in?
Thanks!
Satya B Andra.