Zip file gallery

Question

Hei guys!

My goal is to upload a zip file, unpack it and read the files inside. Previously we had a very customized solution where the server had access to the folder destination containing this file. We then used a python tool to unpack it and handle the files.

Now we want to be able to run this alteryx flow from gallery, and upload the zip file with file browse or something similar. We tried some stuff, but no luck :(  is there anyone that have done something similar before ?

jrlindem · Answer

I have not used the interface file browse to handle a .zip file.  But I have created a staging location (one that the gallery has access to) as sort of a "drop box" for users to place the .zip file into.  Then when they initiate the workflow, it searches that location, moves the .zip from there (so that no human intervention can jeopardize the running process) into a new staging or temp folder, then unzips it from that secure location and processes the data.

Since we know the directory tool + dynamic import, for example, can reach into .zip files; this is how we've solved for this type of behavior.

You could also just have your python process handle the file from there.  But in essence, using a "dropbox" location is something worth considering.

Hope that sparks some ideas, -Jay