topic Re: Getting error 'The system cannot find the specified file' on the Email tool. in Alteryx Designer Desktop Discussions

Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 13:14:05 GMT

Good morning, community.

Hoping that someone can help.

I have a simple workflow in Alteryx Designer that creates an output file and emails it as an attachment.

The Formula tool creates a dynamic variable that it is used as the file name and the Email tool should identify the file to be attached based on that dynamic variable.

The file is successfully created, however, I am getting the error message 'The system cannot find the file specified'.

The AMP engine is not being used.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Mathias_Nielsen — Mon, 30 Sep 2024 13:26:26 GMT

Hi,

I think you need to connect the output tool to the "1" anchor in the block tool. The block until done will run 1, then 2.... Right now it is just running 2 as there is nothing to finish at 1 first. Hope this made sense :D

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 13:37:26 GMT

Hi Mathias, thank you for replying.

I made that change but the error persists.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Mathias_Nielsen — Mon, 30 Sep 2024 13:41:59 GMT

Can you open the file using the DynFileName being passed to the email tool?

I am trying to figure out if it is a filename error or a workflow error

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 13:47:31 GMT

Do you mean if I can open the resulting csv file on my pc? If so, yes, I can open it.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Mathias_Nielsen — Mon, 30 Sep 2024 13:52:53 GMT

Well then you could try this (See photo)

Using the control containers you can run one container after the other. Make sure to connect the containers like in the photo.

Using the control containers requires the AMP engine to be turned on

Re: Getting error 'The system cannot find the specified file' on the Email tool.

binu_acs — Mon, 30 Sep 2024 14:05:21 GMT

@Glopez76 Can you update the full path in the variable "DynFileName" (Z:\...)then use the change entire path from the output tool

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 14:12:01 GMT

Thank you, @binu_acs, this solved the problem. Can you explain why this was needed, as opposed to just change the file name?

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 14:15:55 GMT

@Mathias_Nielsen, I was looking for a way to implement your design with the control containers when @binu_acs suggested something that solved the problem. I don't seem to have the 'control container' functionality for some reason but I will look into this because it actually solves another design problem I'm facing. Thank you for your help.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 14:33:10 GMT

@binu_acs, the workflow is running fine now, with no errors and the file is getting emailed, except that the file does not get saved in my pc now. Is this expected when selecting the option of replacing the entire file path on the Output tool?

Re: Getting error 'The system cannot find the specified file' on the Email tool.

binu_acs — Mon, 30 Sep 2024 15:15:29 GMT

@Glopez76 it should get saved in the path mentioned in your variable DynFilename variable, you can also check the result window where you will see the file name saved.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 16:11:03 GMT

I found those files. Thank you.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

apathetichell — Mon, 30 Sep 2024 16:17:31 GMT

tl dr - but you need to generate your file first (output data) and then read it in (email). you also need to connect both sides to the block until done.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

Glopez76 — Mon, 30 Sep 2024 17:46:56 GMT

Yes, thank you, @apathetichell. That was another design flaw that I needed to correct. The workflow seemed to be working without the Output tool being connected to the Block Until Done tool but I'm thinking the Email tool was emailing a certain amount of records but not the entirety of them.

Re: Getting error 'The system cannot find the specified file' on the Email tool.

apathetichell — Mon, 30 Sep 2024 20:42:07 GMT

@Glopez76 - if you are appending data to the excel file - yes. that's possible.