I'm brand new to Alteryx after a stint in SQL development. My question is this: I will be working to create error reports based on nightly workflows, and I could use some advice on how to best send error/conversion messages to an external file. This file would ideally be part of an existing workflow, and would be emailed automatically to specific recipients. I know how to create a report, and how to email it. My stumbling block is how to export the error messages into the report. I would appreciate any help.
Thanks.
Solved! Go to Solution.
Check out the Events available on the Workflow Configuration window. One of the events you can configure is to send an email after the workflow has finished running that contains the output log of that workflow.
Thanks for the reply--that'll definitely help.
Any thoughts on how to get the log info if you have a web email service like Gmail or Hotmail that requires TLS and can't be configure in the Email Event process?
In that case, you'd probably need to rely on the Logging Directory (configured in System Settings > Engine > General) and return what you need from there.
Also, past email discussions have lead me to the Inviso macro pack for gmail in Alteryx:
https://inviso.dk/blog/post/inviso-macro-pack-gmail-integration-
https://inviso.dk/blog/post/alteryx-and-google-s-oauth2-a-macro-to-solve-your-problems
I hope this helps get you where you need to go.
Thanks for the reply.
I've seen the Invisio macros for email. I need to investigate them further, but they initially don't strike me as being that intuitive to set up. I've made use of building out a simple process using SendEmail that is working.
The issue with using the logs is that a log for a currently running process is blank until the process actually completes (including any "rear end" tools like the Email tool or macros, and events), which means that you can't get the log from a process "within" the workflow.
I'm going down the road of creating a scheduled process that runs on a frequent basis that pulls all of the logs for a given time period and then determines (based on key words) whether a workflow that recently ran is considered an "exception" and needs to be reviewed.
At this point that's my best idea. If you can think of anything better, would appreciate your insights!
Thanks again,
Rod
I've also been looking for options to identify any failures in our nightly workflows. These posts might help:
https://community.alteryx.com/t5/Alteryx-Use-Cases/Analyze-Alteryx-Log-Files/ta-p/61742
How to export all the output log in excel, primarily the conversion errors.
I want this to be generated as an output along with final output of workflow.
an answer to this will be really helpful
Hey, will that work while using the Alteryx server to do a run?