Check if all files inside a folder is in .zip

Question

Hello guys i have an excel file where it has all records of data location on our NAS drives, I want to check if the files inside the folder are in zip file. How can i do it?

so for example excel files row contains this

C:\Users\PC\Desktop\Folder1

So want to check files inside Folder1 is in zip file.

apathetichell · Answer

@Tironial--- https://github.com/apathetichell/2024_AlteryxMacros/blob/main/zipfile_extractor.py - I wrote up a script for this at some point. There's a generalized macro here -> https://github.com/apathetichell/2024_AlteryxMacros/blob/main/zipfile_extractor.yxmc

Tironial · Answer

That post was archived, did anyone still have access to that python script/macro?

danilang · Answer

Hi @Ultralightbeam

The main problem that you have here is finding out the files contained in the zip file, without extracting them.  The ZipMetatdataReader macro from this post uses a Python tool to read the file names contained within the archive.  Compare this list with the list that you can get with Directory tool.

Dan