Includes a Smart Service "Extract Zip" which will unzip the contents of a given Appian zip document into the destination Appian folder. The newly created/updated documents will be returned as the output. The unzipping process will maintain the folder structure in Appian.
Key Features & Functionality
Will this work for compressed login log files like these?
We've also encountered the following issue with the version 1.3.9 :
When the zip contains, at the same level, identical filenames with different extensions the smart service extracts only one item and continues without error and without any document in the output variables.
-Yes the files (pdf) files are extracted up until it reaches the first excel, and the extractor moves to the next node but the output document list is blank and any variables that its supposed to save the value to is blank as well so the process model gets null errors when referencing the document list.
- Since the zip files with excel files were failing I tried using the "zip utility" app that has a zip extractor smart service and it was able to extract the zip files that had the excel files and was able to output the folder ID of the extracted zip file.
A quick way to replicate is to save different types of files in a subfolder and zip it just to see which file extensions are causing issues.
Hi John Camacho,
Thanks for adding those details. Can you clarify the following?
- "leaves the document list blank" - do you mean that the files are extracted (up until reaching that excel file) but the output activity class parameter (documents) is blank?
- "with another zip extractor" - can you shed some light on what do you mean with this?
Apologies for all the questions but it's just to make sure that we have a shared understanding of the current issue.
Sure we have a zip file with 1 subfolder that has 109 files. When the extract zip smart service is ran the other files are extracted successfully until it gets to the first excel ".xlsx" and then the smart service exits and leaves the document list blank. We tested the same file with another zip extractor and it had no issues with extracting the excel files.
Hi John Camacho, can you shed some light on the scenario (zip file structure, folder structure,..) that is currently failing? On top of that, can you please share the details of your environment?
We are having issues with extracting .xlsx from the zip files since the update to version 1.4.0. The extractor fails if the zip has .xls and xlsx files in it.
If you have not tried it already, enable the following logger in your application server:
Then reproduce the issue. The additional log entries in the app server log should give you more information on what may be going wrong.
More details on how to enable custom loggers here: docs.appian.com/.../Customizing_Application_Logging.html
We are using this plugin to extract .zip file and it is working fine in DEV, SIT and UAT but in PROD - though it is executed without error, the file is not getting extracted. Is there any way we can fix this? Please suggest.
Please note, for the first time we ran this PROD, it extracted but from the second time it is giving the document variable as blank.
© 2023 Appian. All rights reserved.