Excel Tools

Is there an issue with the excel import smart service in 19.4?  Was working fine in 18.2.  I get the following error:  ???ORA-01741: illegal zero-length identifier
???

Hi johnh0011 - can you please provide some more context for when you're getting this error and what's not working?

Hi, I am using date format like "2020-08-12" or "2020-08-12 03:43:13" in "Import CSV to DB", but get the error message "Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'HH:mm:Ss'",

Can anybody help me out?

Hi Bhargav Solanki,

We are using Appian Cloud Environment, So do we still need to delete ExportableDataSubset CDT?

Yes, please delete the old plugin, then please delete all old versions of the "ExportableDataSubset" CDT 
After that, deploy paste the new file in the folder.
Then update your model to point to the new version {urn:com:appian:ps:excel:types}ExportableDataSubset.

while tried using the plugin version 2.7.7 on Appian 20.1 Cloud there were no issues reported on process model but on log found below error

2020-06-02 08:09:22,051 [Appian Work Item - 4821 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase5 - Unknown column 'ID' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ID' in 'field list'

But the column ID exists on .csv file and Db table as first column.

while tried using the plugin version 2.7.7 on Appian 20.1 Cloud there were no issues reported on process model but on log found below error

2020-06-02 08:09:22,051 [Appian Work Item - 4821 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.ImportCsvToDatabase5 - Unknown column 'ID' in 'field list'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'ID' in 'field list'

But the column ID exists on .csv file and Db table as first column.