Output "Message Tool" Error if File Fails to Process in Batch Macro

Question

Hello Everyone -

I hope you are all safe and healthy!

I have a batch macro that: 1) Takes a list of Excel (xlsx) files and gets all their sheet names. If, for some reason a .csv gets in there, I want to create a Message that a particular file didn't process.

My goal is to take all these errors and post them to a file on SharePoint - a log file - for lack of a better word, but I can't for the life of me figure out the proper configuration of the Message tool.

While I am asking questions. Does anyone know what the last two options are (highlighted in yellow) and how to use them?

Thanks,

Seth

NISHA_373 · Answer

I am using message tool and giving configuration in such a way - Before Rows where Expression is true and message type is- Error and stop Passing records through this tool.

But I have a pdf output before the error tool that I want to get generated even if error is present.

But in this case if my file contains error then only error message comes not the pdf output that's generated before.

Can someone help me to generate the pdf output in both the cases but I do not want data to flow if error is present.

error.PNG

error workflow.PNG

PHinkel · Answer

@smoskowitz

That makes a lot of sense.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740

According to the link above you may have issues running the CReW Runner Macro on Server.

Theoretically, it looks like you would take your current workflow and turn it into a Macro or App.

You would then direct the Runner macro to the App that it is supposed to run.

And then you'd put the workflow with the Runner macro onto Alteryx Server.

smoskowitz · Answer

@PHinkel --

This is extremely helpful -- but only for a situation where the file type is incorrect. My goal was to capture all errors during processing and while this does solve one of those instances, there is still a broad range of reasons that a workflow might not process a file. Do you have any thoughts on capturing all errors?

I am aware that the CReW Runner macro will do this, but I am not sure how I can run a workflow I plan on publishing on the server using that tool. Do you have experience with that scenario?

Again, much appreciated, and I appear to be on a quest.

Thanks,

Seth