Appian Usage Insights

Hi,

I'm running into an issue when running a collection run. The node 'Import CSV to Audited Logins table' goes into error with the following message: "Date Format must be one of the following 'yyyy-MM-ddTHH:mm:ssZ','yyyy-MM-dd', 'HH:mm:ss'"
However, the format in the csv contains date in the format "2020-12-14 08:00:59"

It could be that our DB's are upgraded to MariaDB which is causing this issue.

Hi, are you using v2.2.10 of the Excel Tools plugin? I was able to replicate this issue (with MariaDB but I think this will apply to MySQL too) using v2.2.10 -> "Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'HH:mm:ss'". I believe this is an issue with version 2.2.10 of the Excel Tools plugin, whereby the Import CSV to DB smart service fails to properly import dates. You should be able to address this by moving to the previous version (2.2.9) of the Excel Tools plugin.

Hi, are you using v2.2.10 of the Excel Tools plugin? I was able to replicate this issue (with MariaDB but I think this will apply to MySQL too) using v2.2.10 -> "Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'HH:mm:ss'". I believe this is an issue with version 2.2.10 of the Excel Tools plugin, whereby the Import CSV to DB smart service fails to properly import dates. You should be able to address this by moving to the previous version (2.2.9) of the Excel Tools plugin.

You can request to roll back to an earlier version of a plugin via a Support Case, or alternatively there is now a newer version of the plugin (2.2.11) that fixes this issue.

Thanks David. 

We are using version 2.2.10 of the Excel Tools. Since we are using Appian cloud I guess there is no easy way to move to an older version of the plugin.