Unable to Open Data for Zipping... The system cannot find the path Specified

Good day guys,

I have a problem that even though I have created a formula indicating the location of the file, still I am encountering this kind of error. Can someone to please let me know how I can solve this issue. What does this error meant? See below screenshots for your reference.

1. Workflow contains errors "Unable to Open Data for Zipping..."

2. Error Committed as written

Output02- Error for zipping.JPG

3. My formula tool

4. Output tool

Please advise how are I am going to solve this. I have tried a lot of things, but I can't solve it.

Thanks,

Kamen

Workflow

Settings

Error Message

Output

Expression

Accepted answers

binu_acs

@KamenRider as per @apathetichell the FilePath missing the '\' at the end of the string it should be \\Sample.Path.for.My.Accounts123\Cities\Name of School\Output\

Can you update your filename like below and try again?

Filename

[FilePath]+'\'+"Philippines Catholic School.xlsx|||Sheet1$A2:I500"

All comments

binu_acs

@KamenRider Are you writing all your output in one Excel file with different tabs? If yes then I think the problem is you are trying to write on the same file at the same time with different output tools. Can you try to run only the first output file and see if you are getting the error or not?

apathetichell

I believe that filegetdir does not return a path ending in "\" - can you add that to your formula tool? I see this error sometimes with improperly formed filename/sheet combos where the path does not exist.

KamenRider

Hi @binu_acs

I am writing the data to different excel however each excel is templated or formatted. I have 14 excel files all in all with different filename. Each is being filtered to different name example Thailand, Taiwan, Philippines which all data pasting will start in A2.

What do you think is any other problem?

Kamen

KamenRider

Hi @apathetichell

What do you mean, I will add "\" just like below?

Output new.JPG

Please advised.

Kamen

apathetichell

hypothesis - filepath is C:\Temp\Data\file.csv

you run:

FileGetDir(C:\Temp\Data\file.csv)

this provides you C:\Temp\Data

You then add the filename - ie "myfile.xlsx|Sheet1$A2:F500" (or whatever)

you now have C:\Temp\Datamyfile.xlsx|Sheet1$A2:F500"

You think you have C:\Temp\Data\myfile.xlsx|Sheet1$A2:F500"- But you are missing a \ in between your path and your filename

Maybe?

KamenRider

Hi @apathetichell

Here's the sample of the structure of my filepath. Note that I'm using a network path.

FilePath

FileGetDir("\\Sample.Path.for.My.Accounts123\Cities\Name of School\Output")

Filename

[FilePath]+"Philippines Catholic School.xlsx|||Sheet1$A2:I500"

I hope this is correct. Please advised

Kamen

binu_acs

@KamenRider as per @apathetichell the FilePath missing the '\' at the end of the string it should be \\Sample.Path.for.My.Accounts123\Cities\Name of School\Output\

Can you update your filename like below and try again?

Filename

[FilePath]+'\'+"Philippines Catholic School.xlsx|||Sheet1$A2:I500"

apathetichell

@KamenRider- let us know if that works or changes the error.

KamenRider

Hi @binu_acs and @apathetichell

I think @binu_acs idea works plus I made some changes on the length of the excel file name. I have read that lengthy characters also help manifest the errors. The workflow now working although sometimes the excel get easily corrupted. I need to change it to another file and rename it and then run the workflow.

I'll close this one but any words or advised to avoid the avoid the from being corrupted is welcome.

Thank you for your assistance and patience. Glad to have you both in this Alteryx Community.

Kamen

binu_acs

@KamenRider good to know it worked for you. Please mark @apathetichell solution, which has the explanation of the cause of the error.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703