Updating workflow dependencies has not repaired the macros

Question

I've been trying to fix a colleague's broken workflow by updating the workflow dependencies. The macros, two macros repeated 100 times in the workflow, are broken (Black ? with red !). I have redirected the Workflow Dependencies to the correct macro location but this has not fixed the macro, their status remains the same. Any suggestions? Replacing the macros manually is approximately 2 minutes per macros as clicking each macro to edit it takes this time to become live. It's fair to say there are no Alteryx power users within this team as we are all still learning. Thanks in advance.

Anthony

CharlieS · Accepted Answer

I recommend getting to those dependencies before it's opened in Designer. In this scenario, I think some XML editing would take care of this in a snap.

- Before you open the workflow in desinger, open it in a text editor. (or input it into Alteryx as a text file)

- Locate an example of each macro reference in the text. (it might be "\..\..\..\macro.yxmc")

- use a find+replace function/tool to replace those dependencies with complete UNC paths. (like "\directory\folder\folder\macro.yxmc")

- Open it in designer and it should be good to go, or at least valid enough to make any other dependencies you need to.

Anthony21 · Accepted Answer

This has a lot of similarities with other posts:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Errors-Moving-Batch-Macro-Workflows/m-p/27701

I have now fixed this problem with an older, non-corrupted version of the workflow following Charlie S's directions.

Anthony