community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Inviso Macros - Enjoy and suggest!

Alteryx Certified Partner
Alteryx Certified Partner
Created on

 

 

 

Inviso Macro Graphic.png

We have a lot of clients with good ideas and that sometimes ends up with new and useful macros. The result is a macro pack that everybody can use. Please give feedback, come with suggestions and hopefully have fun!

 

  • Business Days macro - enables you to calculate the number of business days between a start- and enddate for the Scandinavian countries: Denmark, Norway and Sweden.

  • Conzoom Macro – This macro can pull demographical data directly from Conzoom (Nordic database). Contact us for more info.

  • DST macro - lets you download any table from the Statistics Denmark database (Statistikbanken.dk). The macro does not require login and contrary to the publicly available download options from Statistikbanken.dk, there is no upper limit on rows or records.

  • Facebook Insights – Pull data about your Facebook Page from the Facebook API (Facebook Insights macro)

  • Facebook posts macro - Pull data about posts on your Facebook Page

  • Geocoder - Geodcodes adresseses based on a Google Maps search

  • Publish to Tableau Server with append (requires Tableau server 9.3) - This is build on the existing Alteryx macro however this one lets you append to an existing datasource (Alteryx Publish to Tableau Server macro – now with Append!)

  • SFTP macro - lets you upload directly to a SFTP server in your preferred format. You need to download WINSCP. (SFTP macro for Alteryx)

  • TableauTWBX – Lets you create multiple packed workbooks based on a group (Tableau TWBX macro for Alteryx)

  • WaitASecond – Lets you wait X seconds between processing each record (WaitAsecond – Alteryx waiting tool)

  • WWW Webscraper (Beta) – This macro helps you with the iterative process of scraping multiple pages of data. For example 20 pages of Alteryx community data (Insights to the Alteryx community)

Read more here: Inviso Macro Pack

 

 

Comments
Meteoroid

Great macros!  Using FB macro, but only Page information is there, how to update the macro to include spend, reach, link clicks, impressions, CPC, CTRs, CPMs (I guess those can also be calculated), Website purchases, clicks, views, # of add to carts, # initiate checkouts, and several others?  Tried updating metrics.yxdb, but that didn't work - is Marketing API different than Graph API?

Alteryx Certified Partner

@danielbrun - It appears the link to the macro pack is not working - https://inviso.dk/macros

I get a 404 error.  can you please check out ?

 

It's back working but I can't delete the comment. 

thanks, these are great macros!

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

The link should work again now.

 

You can read more here: https://inviso.dk/blog/post/the-inviso-macro-pack-for-alteryx

 

Daniel

Alteryx Partner

I've been trying interact with my GMail account, I thought I had all the authentication sorted and I don't get any errors in the GoogleOAuth2 macro.

 

But when I do this: https://www.googleapis.com/gmail/v1/users/me/messages i get a "Login Required" message.

 

I don't know how to proceed from here, but I'll try a few things 🙂 

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

Thanks a lot for your question. My first questions is – do you get anything out of the OAuth2 tool? I have drafted a workflow (without tokens) that works for me.

 

Best regards,

Daniel

Alteryx Partner

This is what I get out of the OAuth2 tool:

 

2018-10-09 00_17_57-Alteryx Designer x64 - New Workflow1_.png

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

I looks right. You probably just need to include the Authorization is the header. See attached:

 

Skærmbillede 2018-10-09 kl. 17.12.14.png

Meteor

Hello,

I am using the SFTP macro and believe I have it configured correct however I am getting:  The external program "cmd" returned an error code:1error.png

 

 
Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

Could you try to open the macro and deselect "Run Minimized" and "Run Silent", run the workflow again and see what it writes in the command promt?

 

Skærmbillede 2019-08-07 kl. 06.59.40.png

 

Best regards,

Daniel

Meteor

The dialogue box disappears so fast but it looks like its saying "PATHTOWINSCP" is not recognized as a internal or external operable command or batch file.

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

I can see there is a bug in the macro - I am sorry for that. You can download a fixed version from her: https://share.inviso.dk/q5m34sJN0

 

Just replace the old file named "SFTP Macro.yxmc".

 

Best regards,

Daniel

Meteor

Thank you. I just tried it and am getting the same error message

Alteryx Certified Partner
Alteryx Certified Partner
Hi,

Could we maybe do a skype call by the end of the week?

Best regards,
--
*Daniel Brun-Elgaard *
*+45 21 25 61 20 <+45+21+25+61+20>*
Gammel Kongevej 3E
1610 København V

Inviso.dk
Meteoroid

Hi,

 

I've been trying to use the TableauTWBX macro and have been receiving the below error:

 

TableauTWBX (56) Tool #7: The external program "cmd" returned an error code: 1

 

 

I have the macro configured to write all the files locally on my PC and everything seems to be in order.  Any suggestions?

 

 

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

Could you post the workflow and files here or are they confidential?

 

Best regards,

Daniel