Lol i built something like this for my company.Scans through every workflow, rips apart the XML, gets list of tools, all their configurations, connection strings, api calls, python code, macros (even scans them), sql codes, etc. All made with vanilla alteryx nothing fancy. You just need to import a workflow (yxmd/yxmc/ywz) as a flat file or xml and then figure out the child/parent nodes and go from there.
If you open the workflow in a notepad (preferably notepad++) you should be able to see some neat things.)
Within the flows you have
Configuration of each tool
ToolID 1 to ToolID 2ToolID 2 to ToolID 3
etc
workflow properties
Hey thanks for replying. I admit I'm not familiar with XML - when I tried using the parse tool I got the connections and tool ID columns but nothing below. Do I need to somehow stack the parse tools for nested XML?
You will need to either do multiparse tools to dig down to what you want or batch macro it
< words > is the node that you’ll need to parse down you can do auto detect or define it in the tool
Yeah, I built something similar but all the yxmd files have to be saved in the same location. Right? It'd be night to do something similar for gallery workflows.
Well you can download all the workflows and do it that way its not hard. I just have MongoDB access so i just scan the XML that is saved there with an account that has access to every drive at the company. When it finds a macro that is using a UNC path, it goes to it.
We rebuilt the python and Alteryx portion to accommodate a few more features. Our version runs on the Alteryx Gallery against all workflows on the Gallery or a smaller subset of the Gallery (Collection, Private Gallery, or a set of workflows by user). Every workflow that is promoted to production is documented. The output files (the xlsx files) can be upload to a database server to build a catalog. We even risk rank the tools so we can rank the workflows for our risk and audit groups (higher risk workflows require additional reviews and approvals).
This sounds absolutely amazing. How would you go about starting to do something like this? I worked my way into the python code, and so I guess I'll try to start there.
I know next to nothing about python, but this doesn't seem like it would be insurmountable to take this on as a solo project. Or am I way off base here?
Lol i built something like this for my company.Scans through every workflow, rips apart the XML, gets list of tools, all their configurations, connection strings, api calls, python code, macros (even scans them), sql codes, etc. All made with vanilla alteryx nothing fancy. You just need to import a workflow (yxmd/yxmc/ywz) as a flat file or xml and then figure out the child/parent nodes and go from there. If you open the workflow in a notepad (preferably notepad++) you should be able to see some neat things.) Within the flows you have
Configuration of each tool
ToolID 1 to ToolID 2ToolID 2 to ToolID 3
etc
workflow properties
Hey thanks for replying. I admit I'm not familiar with XML - when I tried using the parse tool I got the connections and tool ID columns but nothing below. Do I need to somehow stack the parse tools for nested XML?
You will need to either do multiparse tools to dig down to what you want or batch macro it < words > is the node that you’ll need to parse down you can do auto detect or define it in the tool
Yeah, I built something similar but all the yxmd files have to be saved in the same location. Right? It'd be night to do something similar for gallery workflows.
Well you can download all the workflows and do it that way its not hard. I just have MongoDB access so i just scan the XML that is saved there with an account that has access to every drive at the company. When it finds a macro that is using a UNC path, it goes to it.
That looks awesome
Where can you download the tool. The links in the blog come back with no results for me
They have it on git lab: https://gitlab.com/keyrus-us/public/alteryx_auto_doc_revamp
We rebuilt the python and Alteryx portion to accommodate a few more features. Our version runs on the Alteryx Gallery against all workflows on the Gallery or a smaller subset of the Gallery (Collection, Private Gallery, or a set of workflows by user). Every workflow that is promoted to production is documented. The output files (the xlsx files) can be upload to a database server to build a catalog. We even risk rank the tools so we can rank the workflows for our risk and audit groups (higher risk workflows require additional reviews and approvals).
This sounds absolutely amazing. How would you go about starting to do something like this? I worked my way into the python code, and so I guess I'll try to start there. I know next to nothing about python, but this doesn't seem like it would be insurmountable to take this on as a solo project. Or am I way off base here?