Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Creating Error Log for Export

Meteoroid

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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

 

Event Email Log.png

 

 

 

 

 

 

 

 

 

 

 

 

Highlighted
Meteoroid

Thanks for the reply--that'll definitely help.

Highlighted
Alteryx Certified Partner

@CharlieS 

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?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@RodLight 

 

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.

Highlighted
Alteryx Certified Partner

@CharlieS 

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

Highlighted
Alteryx Certified Partner

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.

Highlighted

an answer to this will be really helpful

Labels