Alteryx Designer

Definitive answers from Designer experts.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

CReW Macro Support

Alteryx
Alteryx
Created

CReW Macro Support

The CReW macros are a useful collection of tools built by a third party that enhance the functionality of Alteryx Designer.

 

The CReW Runner macros (Runner, Conditional Runner and List Runner) are the only CReW macros supported by Alteryx, but for Alteryx Designer ONLY. These macros are not supported when used on Alteryx Server or Alteryx Designer + Scheduler.

 

Prerequisites

  • Product - Alteryx Designer
    • Version 10.0+
  • Product - CReW macro package (third party)
    • Please note that only the Runner macros are supported by Alteryx on Alteryx Designer only. The other macros that are part of the package are Community supported.

 

Known Issue

There is a "known" issue with workflows using CReW Runner macros on Designer 2019.3.2.15763 causing the Runner macro to crash.

This issue was resolved in 2019.3.5.17947.

 

Additional Resources

Comments
8 - Asteroid

It's mid-October, is the realistic update not for a little while longer? 

Alteryx Partner

A lot of our users desperately need this fix. 

7 - Meteor

Version 2019.3.5.17947 is available for download.

I installed the patch and the Listrunner CREW macro is now working again for my workflows.

9 - Comet

Thanks for testing @dthiessen, we weren't going to let anyone upgrade to 2019.3 until that issue was fixed. We use Crew Macros on both desktop and gallery consistently and not having the ability to have a standard workflow kickoff another workflow would cause major problems.

7 - Meteor

@MichaelAd  schrieb:

CReW Macro Support

The CReW macros are a useful collection of tools built by a third party that enhance the functionality of Alteryx Designer.

 

The CReW Runner macros (Runner, Conditional Runner and List Runner) are the only CReW macros supported by Alteryx, but for Alteryx Designer ONLY. These macros are not supported when used on Alteryx Server or Alteryx Designer + Scheduler.

 

Prerequisites

  • Product - Alteryx Designer
    • Version 10.0+
  • Product - CReW macro package (third party)
    • Please note that only the Runner macros are supported by Alteryx on Alteryx Designer only. The other macros that are part of the package are Community supported.

 

Known Issue

There is a "known" issue with workflows using CReW Runner macros on Designer 2019.3.2.15763 causing the Runner macro to crash.

This issue was resolved in 2019.3.5.17947.

 

Additional Resources


As posted by @MichaelAd the runner macros are supported by Alteryx. So I assume there will be more serious testing before releasing the next version.

 

However, Thank you Alteryx for fixing this issue meanwhile!

Alteryx
Alteryx

Thanks, @dthiessen !

 

The fix for the issue with the CReW Runner macros was released yesterday with the 2019.3.5 Stable update, you can access this version at licenses.alteryx.com.

 

Per Michael's post, the only CReW macros supported by Alteryx are the Runner macros: Runner, Conditional Runner & List Runner and for the Designer only.

Alteryx Partner

Question for the CReW team: 
I'm trying to create a list runner using workflows in my local company Gallery. 

When I put the URL in there, the fullpath generated was my root directory for the workflow originally (I'll call that ./) with the url appended to it. So, as an example: "C:/documents/Alteryx/Workflows/http://<blah blah>". 

 

That was obviously not my intent. 

 

This is a low-priority item for me--I can always develop these on local drives. But I'm trying to be better about using Server and Gallery since I have it. But without being able to run the things I develop on this platform, I pretty much can't use the platform. 

 

Will there be an updated CReW macro set with list/conditional runners that may allow Gallery URLs, or is the login criteria too strict/<insert other issues here that I can't foresee that you may have>? 

 

Thanks!

 

-Cedric Justice

Alteryx
Alteryx

Hi @thedr9wningman,

 

As per the above article CReW Runner Macros are not supported in Gallery.

 

Thanks.

Alteryx Partner

@MichaelAd I read that, I'm just wondering if that is a permanent thing, or is there maybe more on the horizon that may allow list runners to run on Server--is that a consideration? Should I put it in as an idea? 

Alteryx
Alteryx

Hi @thedr9wningman,

 

Feel free to put it in as an idea.

 

Thanks,

Michael

6 - Meteoroid

Hello, 

 

I have a question about the macros.  For some reason, they keep disappearing from the Alteryx toolbar every other day or sometimes every day and I have to keep reinstalling them.  Has anyone else had this problem? Do you know what's causing it and how I can fix it? I thought it was the anti malware program that my company uses, but they added the filepath as an exclusion and this is still happening.  They also told my that if the antivirus or anti malware program was blocking any files, I wouldn't have been able to install it in the first place.  So, if anyone has an idea of why the macros keep disappearing, I would greatly appreciate your help with this frustrating issue!

8 - Asteroid

Hi, @MichaelAd  @MargaritaW @MarqueeCrew 

 

In trial process of designer v2019.4.6.21113, I have a trouble with use the 'Runner' macro. 

***ENV***

OS: Win7sp1 or  Win10 (Language : Chinese)

***********

Case: A main workflow named is Main.yxmd, it used only a runner macro with a sub workflow sub.yxmd . both the Main.yxmd and sub.yxmd are located in same folder like path ' D:\下载\ABC\ ' or  ' D:\Download\ABC\ '.

1- If start Alteryx designer with Chinese GUI, show below error prompt after click 'RUN' button to running Main.yxmd :  (path ' D:\下载\ABC\ ')

######

2 Field Conversion Errors
Runner(1) Tool #31: Fidld_11: Started running D:\ is not a number.
Runner(1) Tool #23: ModuleFullPath: "D:\下载\ABC\sub.yxmd" could not be fully converted from a WString to a String.

######

 

2- If start Alteryx designer with English GUI, show success prompt after click 'RUN' button to running Main.yxmd :  (path ' D:\Download\ABC\ ')

 

+++++++++++++++

therefore, I guess the fail cause is Chinese character.  so, how can i fix the error point and maybe you will improve the CReW_Runner.yxmc to compatible non Unicode language version ? 

 

 

6 - Meteoroid

Hi,

 

I'm having the same problem as naterusso - my CReW Macros and CReW Test tools keep disappearing.  It has only happened since my PC was upgraded to Windows 10.  A colleague in the office has also upgraded to Windows 10 and appears to be unaffected.  Until today it was only happening overnight, but today I used Alteryx with the tools installed and they worked fine, but I came back to Alteryx a while later and although I could see the tools Alteryx said it couldn't find them, and I have had to reinstall again.

 

Any ideas from anyone would be much appreciated as it is incredibly frustrating!

 

6 - Meteoroid
I found the solution. You need to copy the install files to a directory on your PC and then do the install.

Nathan Russo, CMI
Vertex Inc.
2301 Renaissance Blvd.
King of Prussia, PA, 19406
T: 484-595-9524
nathan.russo@vertexinc.com
vertexinc.com
Vertex Exchange Europe 2020 | 22 April | County Hall Westminster | London
Vertex Exchange U.S. 2020 | October 25 - 28 | Aria Resort and Casino | Las Vegas, NV
[cid:image001.png@01D5D67F.60124B60]
[Follow us on LinkedIn] [Follow us on Facebook]
[VertexCertifiedLogo_Small_RGB_LoRes]
6 - Meteoroid

Thanks, but I have done that several times in different locations on the PC/network, and they still disappear.

8 - Asteroid

Will none of the CReW Macros work with Alteryx Server, or just the Runners won't work?  The message is not very clear.  We use the Dynamic Metadata tool in a workflow and I need it to work in the Gallery. 

Alteryx
Alteryx

Hi @afinzerillo,

 

Great question.

The Runner macros will run on Server, but as they have not been developed for Server, but rather specially for a desktop Designer environment they are very likely to cause issues on Server. It is therefore strongly discouraged to use them on a Production Server. 

8 - Asteroid

Hi @MichaelAd ,

 

Thank you for the reply.  Being "strongly discouraged" is wholly different than "won't work".  Many of us have employed CReW Marcors because as good as Alteryx is, there are certain things is simply can't do.  And Alteryx is unable or unwilling to fix them.  So, the community is forced to use a 3rd party tool.  Which interestingly enough is created by an employee of Alteryx.  Weird.

 

If they will run, albeit strongly discouraged, how do I install and configure them to do so?  I'm willing to take the risk because going back and reengineering all of our workflows to run in gallery without the 3rd party tool is too time consuming.  

 

Thanks!!

Andy

Alteryx Partner
@afinzerillo In MY environment, there are some things I have had to use to ensure success in using the runner macros in the Server environment. 1. The linkage between your macros directory on Designer and the macros directory on Server have to match exactly. For my environment, that means I have to use the URI version for both (instead of a networked drive, I use a Uniform Resource Indicator (? is that what the I is?). 2. In Server, all data sources and aliases to databases also have to match the names/URI paths perfectly with Designer. 3. The path within the runner also must tow this line. For the past 3 months, I have successfully employed a conditional runner in Gallery. It works flawlessly. But it was a uphill climb. And a nightmare to troubleshoot because of the black-box nature of Gallery.
Alteryx Partner
None of my formatting worked and I can't edit. Curios.
7 - Meteor

@thedr9wningmanglad to hear you have the runners working on Gallery. We're investigating it for our own usage.

 

Do you know whether the normal Gallery logs automatically pick up the logs generated when a workflow executes within a runner macro? I'm a bit concerned that even with the macros working, we'll lose some logging in the Gallery and need to establish our own logging to monitor execution within the runners.

Alteryx Partner

As far as I know and have experienced, macros are black-box with respect to logs. I haven't experienced any sub-macro visability from the logging standpoint. It sort of defeats the whole concept of macro-tising a chunk of code. Technically, the Count tool is an altered third-party macro, and we will never see that in our logs, so I highly doubt that you're going to be able to see anything within a macro short of expanding it into your workflow. 

Alteryx Community Team
Alteryx Community Team

@thedr9wningman, Try checking the Show All Macro Messages box in your workflow. For the Decision Tree macro in the sample file, it increases the logging from 1 to 43 messages, see below...

 

NeilR_0-1583093273990.png

 

8 - Asteroid

Hello,

 

In the version 2020.2.3.27789, the Wildcard XLSX Input not working I have the message "Detour tools in macros must terminate within that macro". Can you help me please ?

 

Regards,

Bruno

Alteryx Certified Partner

Hi @psyrio 

 

for you and anyone experiencing difficulties with the Wildcard XLSX Input macro, you can use a different solution to pull data and sheets dynamically from ANY Excel type, not just xlsx.

 

Alteryx can dynamically pull Excel sheet names! 

 

8 - Asteroid

Hi @seven ,

 

Thanks a lot for your post, I have do my own macro but your post is very interresting too.

 

Have a good day.

 

Regards,

Bruno