Output error: Unable to open archive for zipping

I have a workflow where some rows should be written to a different tab, some to another, depending on a field called "Server". Attaching below the config of my output tool

However, when running it, I get the following error:

Error: Output Data (16): Unable to Open archive for zipping: \\serverlocation\serverlocation\Test\ZAS54A8.tmp Error Opening file: \\serverlocation\serverlocation\Test\ZAS54A8.tmp
: The system cannot find the file specified. (2)

How can I fix this?

Workflow

Accepted answers

Aidan_K

Hi @AkisM ,

Create a new field with the file location (path) where file to be updated is saved. Ensure you use include the excel filename and filetype at the end of the full path (e.g. "C:Users\samplefile.xlsx")

Use formula tool to create the "full path" using formula [filepath]+"|||"+[Server].

Then change the option under "Take filename/table name from field" to be "change entire path.." and choose the new "full path" field in the selection box. I find this works for me in smiliar cases.

hope this helps,
Aidan

All comments

Aidan_K

Hi @AkisM ,

Create a new field with the file location (path) where file to be updated is saved. Ensure you use include the excel filename and filetype at the end of the full path (e.g. "C:Users\samplefile.xlsx")

Use formula tool to create the "full path" using formula [filepath]+"|||"+[Server].

Then change the option under "Take filename/table name from field" to be "change entire path.." and choose the new "full path" field in the selection box. I find this works for me in smiliar cases.

hope this helps,
Aidan

SanjayVyas

Thanks Aidan, worked for me

kauser

I am having the same issue. can you please show me the solution with a workflow.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703