Hi,
I am getting the error msg :
How can I use a macro on the server? I have copied it to the folder that my workflow is using.
Hi @wonka1234
The macro will need to be accessible by the server machine.
You will need to store the macro in a network location that the server can access.
If you go to Options --> Advanced Options --> Workflow dependencies.. you can edit the path of the Macro to the network location that the server can access.
Hope this helps. If it does, please like the post and mark it as a solution.
You can also add the macro to the upload package when saving to the Gallery. Save a Workflow to Gallery
In the Save Workflow window
Additionally, I have found that I need to often edit the XML if I'm using the macro from a macro directory that I have mounted to Designer. It will often in XML be macro="..\..\location\macro.yxmc". I have found that I have to hard code it to a URI mode, save it as a second yxmd, test it and make sure you don't have the dreaded question-mark-in-place-of-your-macro, and then upload.
To edit the XML, bring any yxmd (or yxwz) into a Notepad++ and look for <EngineSettings Macro= in Notepad++.
The part in the red box is the part that I substituted from "..\..\..\" to the full URI version of the location.
And, yes, the Gallery Server must be configured to have access to this shared drive.
I know this is an older post, but wanted to add some context that helped solve the problem for us. Check if the Designer on your machine has user settings configured to map a macro repository. Those settings can be found here: Options > User Settings > Edit user settings > Macro tab. When that is setup for a user, they should have a matching tool palette folder containing the macros found in that location. If a user drags a macro from that macro tool palette, then the following items needs to checked before the workflow will save to Alteryx server:
Provided all three of those things are done, then you should not see a validation job error with the "unable to find macro" message.