File download as .zip in server

Question

Hello,

I'm making an analytic app using in Alteryx server of my company.

The app outputs 2 Excel (.xlsx) files and 2 PDF files.

I would like to make the output files in one .zip file to reduce user effort.

Could anyone give a solution for this?

Thank you in advance,

fmvizcaino · Answer

Hey @Masaru_Hirose ,

You don't need to install 7z whatsoever, you can simply download and paste in a folder.

Here is a tutorial about the run command tool. You don't need to worry about the arguments, you can create a bat file with everything the run command tool needs, it will be basically all the files you have used when testing with cmd.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Introduction-to-Batch-Files/ta-p/16053

Best,

Fernando Vizcaino

Masaru_Hirose · Answer

Thank you @fmvizcaino,

I made it in my PC local, but I faced next problem.

I have some questions;

1. Is it necessary to install 7-zip in server?

2. How to input zip file path and raw file path in "Command Arguments" in Run Command Tool? Now I designate the path in "Command Arguments" as C-drive.

Thanks in advance,

fmvizcaino · Answer

Hey @Masaru_Hirose ,

Check this post, it seems to be exactly what you are looking for.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/How-to-download-a-zip-file-using-the-workflow-on-server/td-p/805762

You need to:

1. Use the run command tool to zip all of your files and save to a shared folder.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-use-the-Run-Command-tool-fror-unzipping-a-file/td-p/50819

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Run-Command/ta-p/31548

https://sevenzip.osdn.jp/chm/cmdline/commands/index.htm

2. Use the blob input to open the zip file and a blob input tool to output it and for you to have the option on the gallery

https://community.alteryx.com/t5/Alteryx-Server-Discussions/How-to-download-a-zip-file-using-the-workflow-on-server/td-p/805762

https://help.alteryx.com/20212/designer/blob-input-tool

Best,

Fernando Vizcaino