Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Unfortunately, this isn't currently an option. Typically this handled by having a staging table that takes in all of the columns and then running a stored procedure to transfer from the staging table to the actual table.
Hi All,
Can't we import only a specific columns from csv to database.
Requirement:
I have a csv with 10 Columns, out of which I want to import only 5 column into the database.
ColumnNames property in the import csv to DB plugin is not working it seems.
Any inputs?
Thanks in advance.
Hi, is there any guide on how to configure the Import Excel to Database element? Actually I got this error: "org.apache.naming.NamingContext cannot be cast to javax.sql.DataSource"
We've just upgraded Excel Tools to the latest version (2.2.5) from 2.2.4 and shortly thereafter the STDOUT logs have been filling up with the following message:-
ERROR: Bundle com.appiancorp.ps.exceltools [56] Unable to get module class path. (java.lang.NullPointerException)java.lang.NullPointerException
Has anyone seen this before, know what it means and how to resolve?
Running 19.2 on AppianCloud.
Hi - check the comments above as the lack of the functionality has proven an issue for other practitioners for a while now. No ideal direct replacement exists unless you can use some of the out of the box functionality to achieve your use case.
is "Parse Excel to CDT" service not available in v19.1? if not what is it's alternative?
For the Export Data Store Entity to CSV, can we have an input parameter for the field to sort on? In addition, can this field be one of the fields that is not in the selection.
Import CSV to Database (Smart Service) is failing to correctly parse fields containing commas
Hi Brianc,
Yes I am also having this issue, that function is not displaying for me anymore
How do I find the documentation to configure the plugin? I am using the plugin in Appian Cloud. I downloaded the JAR but haven't found a PDF yet (unless its lurking inside a JAR, inside the JAR...) - looking for details on how to configure Import CSV to Database v4 - thanks!