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

[KamenRider]

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

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

[binuacs]

@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 @binuacs 

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?

 

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

[binuacs · Accepted solution]

@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 @binuacs and @apathetichell 

I think @binuacs  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