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!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #105: Think Like a CSE… Tools are missing!

MikeSp
Alteryx
Alteryx

Last week's challenge can be found here!

 

We are thrilled to bring you the first Challenge of our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you! This month we present the case of the missing tool. 

 

Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.

 

The Case: A co-worker builds a workflow and shares the YXMD (workflow file) and a YXMC (macro file) with a colleague. However, when the colleague attempts to open the workflow, they receive a message stating “This workflow references macros that are missing or inaccessible. Saving this workflow will permanently disable these tools”. Can you resolve the case?

 

Explanation of the Problem: A co-worker emailed me his workflow on Friday night along with a macro he created right before he left for a long vacation, and he’s gone somewhere that he doesn't have access to email so I can't get him to package the workflow for me. My co-worker needs me to run the workflow while he’s gone and provide my manager with the (very important) report output that comes out as a PDF. When I opened the workflow to run it on Monday I received the following message:

 

2018-02-26_9-35-03.png

 

This (very important) report is due in my manager’s email in 24 hours! Can you help me fix the workflow in time?

 

Asset Description:

File Purpose
Reporting_Workflow.yxmd Workflow file that needs to be run to generate the report.
AstronomyPictureOfTheDay.yxmc Macro file that pulls data from an API.

 

Bonus Question: My manager has also asked that the specific configuration for the macro is restored to its original values, as there’s a specific date and API key we wish to use. Can you help me to get this working while retaining the original configuration information saved in the macro?

 

Video Solution (Posted 3/5/2018):

 

Spoiler
Mike Spoula
Senior Solutions Architect
Alteryx
patrick_digan
17 - Castor
17 - Castor
Spoiler
I opened up the yxmd in notepad++ and found the offending code:

Capture.PNG
It's looking for the macro in a macro subdirectory. I just deleted the \Macro part and all was well with the world again.

Capture2.PNG
Natasha
9 - Comet
Spoiler
1) I right clicked on the canvas, choose Macro and navigated to the downloaded macro on my drive

Screen Shot 2018-02-26 at 19.13.30.png

2) To preserve initial configuration I selected the generic tool with missing macro, in a configuration window went to the tab 'XML View' copied XML code from there and pasted it into the newly inserted macro tool

Screen Shot 2018-02-26 at 19.22.26.png

3) To avoid missing macro in the future, I went to Options -> Advanced Options -> Workflow Dependancies and set all all paths as relative

Screen Shot 2018-02-26 at 19.14.11.png 

4) Then I created a packaged workbook in Options -> Export a workflow menu

Screen Shot 2018-02-26 at 19.24.39.png

5) And here is the very important report

Screen Shot 2018-02-26 at 19.08.08.png 

dominiklz
8 - Asteroid
Spoiler
Capture.PNG
quick solution:
open file in Notepad++
ctrl-f for the name of the macro, change path to where it actually is saved
open in Alteryx without error message
run the workflow 
be happy

ah, the perks of working for customers and having seen this exact case a bunch of times before :-)

nice practice to keep the skills sharp 

jamielaird
14 - Magnetar

Another fun challenge. Here's my solution. Solved for the bonus but I can't for the life of me see how to use the original API key -- it looks to have been masked, so is this even possible?

 

Spoiler
1) Replaced the macro
fixed_workflow.png
2) Took original values from the broken workflow

masked_api_key.png

3) Packaged up the workflow and ran the report

report.png

 

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

Solution below! I also ran it with today's date, just for kicks, to see what other sort of results could be seen... Gorgeous! Now this is an app I could really get behind... :)

 

Spoiler
Ended up solving two ways - first, by just replacing the macro with the one downloaded and then updating the parameters to match the values I was seeing in the XML code of the original, broken macro... but then, after looking through the solutions of others, I also corrected it by replacing the Macro folder designation in the text of the workflow, after opening up in Notepad++, then packaged it up as a .yxzp to keep the workflow and macro together.

This was a super cool trick to learn, editing the macro location in text editor - I have had quite a few broken macro problems lately where I could have resolved this way rather than removing and re-adding the macro again! Will definitely keep this one in mind for the future.

Notepad.JPG

Result using original prompt values:
Result.JPG

Result using today's date:
TodayResult.JPG

Cheers,

NJ

AndyBate
8 - Asteroid

 

Spoiler

105.JPG

Only recently learned the Notepad++ editing ability due to issues with version control. So this challenge couldn't have come at a better time, couple of weeks earlier and i would have been stumped.

actions;
changed the macro file path to new directory. 
Saved the Notepad++ edit.
Opened the workflow and ran the file.


 

adamp
7 - Meteor
Spoiler
Original API key wouldn't work but the guest key worked just fine. Date and image quailty settings restored per original configuration.

Challenge105.png
ggruccio
ACE Emeritus
ACE Emeritus

Great image!

bdaniels
8 - Asteroid

My life when we first started using macros

 

Spoiler
Screen Shot 2018-02-28 at 5.19.04 PM.png