community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

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

Moderator
Moderator

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
(view in My Videos)
Mike Spoula
Support Knowledge Manager
Alteryx
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
Alteryx Certified Partner
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 

Alteryx Partner
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 

Alteryx Certified Partner

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

 

 

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

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.


 

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
Bolide
Bolide

Great image!

Asteroid

My life when we first started using macros

 

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