Two users experience different result of consolidation script on same target folder – how can I isolate the real issue?
When running a python executable /consolidation script on several excel files, the user sees “Error Processing File ‘~XYZ_file name_123.xlsx’ : File is not a zip file”. The script is supposed read several tabs per file and consolidate with 8-10 other files. I myself have no issue running the script successfully however when this teammate runs the script on our target folder , he is seeing the above error for 4 out of the 10 files. The strange thing is there are no zip files and they are not supposed to be any zip files, if the file was ever in a zip file it was done so by someone upstream in the process before it’s landed in target folder. The error means the script will leave these files out of the final consolidation when they should be included.