Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Good Day Everyone!
I have a messy excel file as a input file and i need only relevant fields from that. Below is the file and need only the highlighted data to proceed further with the process. Can anyone help me on this ?
Desired Output
You can use a connected system with all plugins by using docs.appian.com/.../fnc_system_a_getDataSourceForPlugin.html
I am trying to extract data from an excel but the format it is providing is difficult to parse. Would appreciate some guidance on how to achieve the desired output.
Desired Output:
Hi Paul, could you please let me know the configuration to merge excel. The second excel is not starting from the specified cell position. Even if we mention a cell, the second excel value starts from bottom of first excel
Is there by any chance a version that uses a Connected System instead of a Data Source?
We are experiencing an error/blocker when trying to use the Import Excel to Database smart service. If the table being written to exists in a custom schema we are presented with the following error:
ERROR ImportExcelFileToDatabase (conn=471777) INSERT command denied to user 'appian'@'10.35.118.196' for table `MY_SCHEMA`.`MY_TABLE`
Hi, we are using Import Excel to Database in which I am giving dates in a column to store in database in a format of 1986-09-21 i.e "yyyy-mm-dd" and its storing in database in exact format but changing the date values from the exact one which I am giving in database.Can anyone help on this ?
merge excel doesn't work. We are trying to combine 2 excel data with same number of columns but still output is not showing any thing. Though cofniguration and excel are correct. It is always generating second excel as it is.
Hi, we are using import csv to database and it works great also for bigger files, with just one exception. Some of the fields in our CSV (which we unfortunately cannot change) contain quotes inside the text, e.g.:
0000|Some Text|"text in quotes" more text|00|123|6789
which is causing the error message invalid char between encapsulated token and delimiter
when searching the internet I found that in apache csv libraries there is also the option to ignore quotes https://stackoverflow.com/questions/26729799/invalid-char-between-encapsulated-token-and-delimiter-in-apache-commons-csv-libr -> CSVFormat.DEFAULT.withQuote(null)
are these libraries used in the plugin? if yes, would it be possible to add this parameter? this would be of great help for us!
Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content.
For example:
Is anything we missed. Can anyone help on this?