Skip to main content
alokp677109
alokp677109
November 9, 2022
Question

Excel Tools v2.3.0

  • November 9, 2022
  • 2 replies
  • 1 view

After updating the plugin getting the following errors (Note: It was working fine in the earlier version) :

  1. Import CSV to Database v6  - Changed to 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'.

    Snippet of Datetime format - "2021-12-10 14:20:42.740"
       

  2. Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases.

2 replies

stefanhelzle0001
stefanhelzle0001
Brainy
November 10, 2022

Importing data from a CSV only works reliable when all fields in the DB are varchar or text fields. That plugin does not do any casting or data type conversion. Import your data into a staging table and use a stored procedure to shape the data into your main table.

alokp677109
alokp677109Author
November 10, 2022

[mention:126a676c85024855948336691b0a7b92:e9ed411860ed4f2ba0265705b8793d05] Thanks for your response.

What is the difference between Import CSV to Database v6 and Load CSV File To Database ?

I am getting this error when we are using Load CSV - 

Load CSV File To Database java.lang.Exception: This method only work with MySQL databases
Terms & ConditionsAccessibility statement