Scheduling a Workflow Containing Macro on Server

Hello,

We are just now getting a server environment set up. I am trying to schedule a fairly basic workflow on the server using the controller from my laptop.

I have the drive mapped on the server where the macro is located, and have tried a couple of local locations for hosting the macros as well(I mapped them in using the User Settings). However, whenever I schedule my workflow, it tells me that it cannot find my macro file.

Any thoughts on how I can get the server to use my macro from the shared drive when I publish the workflow to server?

FYI, the macro I created is a knockoff of the publish to tableau so our team could easily switch between out Prod/Dev/QC environments using our functional ID without having to create a new tool or go looking around for the url.

Thanks for any help!

Publish

Gallery

Settings

Macros

Scheduler

Accepted answers

mbarone

I have several apps published to the Gallery with Macros and other data on shared drives. You are correct - unselect the assets during the publishing routine and the app in the Gallery will get them from their location.

All comments

FFFool

I sort of figured it out. When I saved it to the gallery(We still aren't sure how we are going to keep all of our workflows organized) It messed up all of my dependencies. When I scheduled from the version saved to my hard drive, everything worked great. I believe if I saved without the assets selected, it may solve this issue.

mbarone

Thorsty1

We were experiencing a similar issue with Macros and Server. We met with Alteryx Support and discovered that the Workflows with embedded Macros would run if the following conditions existed:

Both the Workflow containing the Macro and the Macro were saved in the same file folder prior to publishing to Server
The file paths were checked to All UNC filepaths in the Workflow Dependencies

Not sure if this helps, but try it out.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703