Overview
Provides the following custom smart services and functions for handling data in Excel.
Key Features & Functionality
Smart Services included are:
Functions included are:
Is this plugin supports Postgre DB? As I'm facing below issue while using "Import CSV to DatabaseV6"
2023-01-16 09:50:08,138 [Appian Work Item - 1389872 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase61 - Error executing SQLorg.postgresql.util.PSQLException: ERROR: syntax error at or near "`" Position: 15
Hi, Just updated to 2.4.1 on appian 22.4 have been successfully using the Import Excel to Database smart service on previous versions of this plugin.
The behaviour of the smart service has now changed in that the first empty row encountered causes the import to end.
.Is there a way to overcome this behaviour i.e continue past empty line?
Regards
I want to store selected column in database, Any suggestion to achieve this
Hey, can anyone elaborate on "Import Excel to Database" smart service and how to use it ?
It indeed does
I think that the latest package already contains the version 1.10.0
This plugin is susceptible to CVE-2022-42889 (Apache Commons Text Remote Code Execution (Text4Shell). Will any future security updates upgrade Apache Commons Text to version 1.10.0?
NVD - CVE-2022-42889 (nist.gov)
I am using the Export Data Store Entity to CSV smart service to generate a fie that later will be imported into a DB using the Import CSV to Database smart service but I am getting the following error:
ERROR ImportCsvToDatabase61 Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss' java.time.format.DateTimeParseException: Text '11/17/2022 19:11:00' could not be parsed at index 0
Is there any way to format the date values before exporting the data?