Hi Everyone,
I am facing an issue with the "Import Excel to Database" plugin. When reading the Excel file from the mail poller, it is not loading into the staging table. However, if we copy the same file to the local system, open it, and save it again, the data is successfully loaded into the staging table.
Upon reviewing the system logs, I found the following error: [Senario:File was not ingested scenario].
09:08:21.599 [Appian Work Item - 191302 - WorkID 79 - execution01 - process 268462146 - model 172 : ExpressionGroupRequest] ERROR com.vuram.plugins.documentencrypt.CheckDocumentEncryptionUtil - Unable to process document
Any Ideas would be appritiated.
Thanks in Advance!
Discussion posts and replies are publicly visible
You do not provide much information to start guessing on.
The error message is something about a possibly encrypted file.
Then, after modifying the file, it works. It seems to be a problem with that file.
Yes could issue with file format ?
File Format are Same
Could you please try using CSV formats and check if that process throws the same error?
The only plugin that I know of that can decrypt Excel files seems to be this one: https://community.appian.com/b/appmarket/posts/aspose-cells-functionalities
Other option is to code your own plugin. I believe that the Java POI library (What Excel Tools is based on) allows you to decrypt files.