Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Save workflow messages/log in database

rvanderhave
7 - Meteor

Hi all,

 

I want to save the output messages of the workflow, in particular errors and warnings, in a SQL database.

Is it possible to extract the messages and push them to the database? Or at least save them in an Excel file? 

 

Or is there a different way to create an output log? 

 

Thanks in advance for your response. 

8 REPLIES 8
Claje
14 - Magnetar

Hi,


Are you looking to save logs from workflows run on your local copy of Alteryx Designer, or logs from a workflow on the Alteryx Server/Gallery?

There are a few different ways to approach this, and I don't want to put in any extraneous information that won't be of benefit to you, since this topic can take some work depending on the need.

Claje
14 - Magnetar

If you're looking for the ability to easily save an output log post-execution, and don't need to do it in an automated fashion, you can right click any line of the "Results - Messages" tab and choose "Save as".


This will prompt you to save a Text file, which you can name whatever you want.  You could then easily load this text file into a database or store it in a useful location.


If you are looking for a more automated logging process, my initial post still applies.

rvanderhave
7 - Meteor

Hi Claje, 

 

Thank you for your response.

 

I am looking to save logs from workflows run on my local copy of Alteryx Designer. 

Also, I am indeed looking for a more automated logging process, since my workflow are scheduled and kicked off using a VB Script. What would be the best way to approach this?

 

Kind regards

Claje
14 - Magnetar

Are you leveraging the Alteryx Scheduler/Command Line execution, or using another method via VBScript?

If you are using the existing Command Line execution you can write the log to a file by simply including a ">File.log" after the workflow name/configuration.
 
If you're using another method, the best option would probably be the User Settings in your Designer, which would allow you to define a Logging Directory.

 

LoggingDirectory.PNG

 

The downside to this option is that it will happen for ALL workflows, including ones that you are testing.

 

Once you have the logs saved, you can easily read them in as part of a process or load them to a database.

 

The final option if you want to configure this for each workflow (this would still require some more effort to finalize), is to use a Workflow Event after execution to email the log to yourself.  Then you could leverage outlook rules to save this somewhere.  The advantage of this option is that it can be configured per workflow.

 

 

rvanderhave
7 - Meteor

Hi Claje,

 

Thanks again for your response!

 

I am indeed using another method, so I am now saving the logs in a Logging Directory, and writing these to the database. So this solves my problem!

 

Kind regards

Suryanarayan_1
5 - Atom

Can you please share the sample workflow?

vepp
8 - Asteroid
Please share the link to your original post. I am not able to get that.
Wil
5 - Atom

Hi @Claje,

 

I am reading your post and I couldn't for the life of me find this - 

 

"If you are using the existing Command Line execution you can write the log to a file by simply including a ">File.log" after the workflow name/configuration"

 

I would greatly appreciate if you can let me know where I can do this option.

 

Thanks!

Labels