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

FINDER 3.0 - Search all your workflows contents for keywords, tools, inputs, outputs etc

anthony
11 - Bolide

I got around to fixing 2.0 version which had absolute path issues that required linking macros back up. Thanks Wayne at Alteryx for testing.

 

The problem:

I create a lot of workflows (800 and counting) and often need to find workflows that created a specific yxdb or csv file. Or I need to find all workflows that use a specific tool - like the Download Tool(eg xml = download.download), so I can remember how I set it up for a API so I can use in another service.

 

The Need:

Crawl all my directories with yxmd/mc files and then search the filename and file xml for keywords.

 

The Solution:

This workflow takes the path(s) you specify and creates a list(via .bat file - eg windows only) of all your yxmd/mc Files/Paths and then runs through a batch macro to look for the keyword you are searching and returns the file name and path so you can copy and open to get on with your business.

 

There are 3 inputs:

  1. The Path(s) you want to search for all of your yxmd/mc files to create the list. CAUTION: Don't start to shallow like "C:" as this will take a long time to search EVERY directory on your computer - even more of an issue for network drives.
  2. The temp path to save your list of yxm* files absolute paths. This must be a directory associated with the user (eg docs/download and not a system path)
  3. The Search Term - NOTE: this uses the contain function so it is broad match. Best to start wide and narrow down as you become familiar with the results.

Capture.PNG

 

Once enter your information: RUN to see your results by

  1. Keyword in File Name (excluding path)
  2. Keyword in Files broken out by yxmd or yxmc with counts of occurrences for keyword in the file. (side note: I discover my text 'inputs' stored in workflows makes the files large. Just search for <r> and you will see some very large counts if you manage to store data in your workflows.)

Capture.PNG

 

Some notes on searching for a tool in a workflow.

  1. Start with the tool name but if the results are large and finding stuff you don't want or did not expect look up in xml to see real alteryx name
  2. a good example is the download tool - if I search for "download" I get 279 results, but if I search for "download.download" there are only 136 results

 

If I search for "download" - it pickups a path with folder download

<Field name="C:\Users\Anthony\Downloads\FInder Temp Rebuild\AFind_N_YX_Files.yxmc" size="254" source="File: C:\Users\Anthony\Downloads\FInder Temp Rebuild\YXM_listOfPathReport.csv" type="V_String" />

 

This is the actual download tool name

<GuiSettings·Plugin="AlteryxConnectorGui.Download.Download">

 

To look up in xml, either just open your yxmd file in a text editor and try to find what it is, or create a temp workflow with that tool and look at xml in configuration for the workflow (I think you must turn on xml in users settings for it to show up in conf section)

 

Capture.PNG

 

Hopefully you find this useful as it was a pita to setup with relative paths and export into a file for others to use ;)

 

 

APPENDIX

 

I added a bat file output to diagnose issues and if you want to see what is creating the list of files.

 

If you run into issues, you can run each line in a CMD to see which line is causing errors.

Capture.PNG

 

 Random notes on creating this package workbook.

I had all kind of issues getting this to work for various reasons.

  1. The mapped drive had odd issues and required some of the flags you see in that bat file, I don't even remember what they were but you can look up if really interested.
  2. package workbooks with nested macros and paths to files are way messy to make sure they work on someone else machine.
    1. I ended up having to put the 2 macros and CSV into a temp folder and work from there. My local macro folder was causing all kinds of confusion for me and the export.
    2. Once in the temp folder I opened each one and set the relative paths to that folder for all files/references. eg options>advanced options>workflow dependencies
    3. Once the references where setup with the .\ relative paths format, I had to clean up references in the macros to paths/files and also update my control parameters to 'update' the correct part of the path. This took several iterations and was probably the most complicated.
    4. I had hard coded the temp file name into the macro and that was confusing matters so I moved out of macro and add file in the main workflow after the users sets their path. This full temp file path is now passed to the macro.

 

 

16 REPLIES 16
jwycoff1
6 - Meteoroid

I agree with previous replies, this is a GREAT tool! I'm such a newb, I had to ask Alteryx support for help, I had to re-download and start from scratch.

 

So... as a newb, I'm just wondering why you didn't replace the question tool with the tool mentioned and re-upload?

 

Thx again!

anthony
11 - Bolide

Capture.PNG

 

Basically it is pain in the arse to package up nested macros with relative paths so I have not made the effort to fix it for the community. It works on my machine :)

_wlm_horton
5 - Atom

I would love a workflow that does the exact things you listed, with one addition, I'd also like to list the macros in each workflow.

labradley
6 - Meteoroid

can you use this on your gallery?

 

Deon_Carstens
5 - Atom

I'm also getting this error:

Deon_Cars_0-1604985237169.png

 

anthony
11 - Bolide

Look at previous pages - explains how to fix the macro that is causing the error.

londonhanson
Alteryx
Alteryx

This new workflow allows you to download all workflows from the Server, then search through the XML for any term found in the workflow:

Search Gallery Workflows for Connections, Files, Queries, Tools and More

London Hanson

Customer Support Engineer
Alteryx, Inc.
Labels