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!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

xlsx file download analytic app

salbol1
8 - Asteroid

Attempting to create and app that will allow users to download a multi-tab xlsx file to a local directory path. File is downloaded from an external website, and can be stored on server wherever necessary to facilitate this function.

 

Don't do much app building, so looking for some guidance.

 

Thanks

7 REPLIES 7
SoccerTil
8 - Asteroid

A simple solution is to use an app with File Browse, Folder Browse and Text Box as input. However, to get the job done you'll need a macro that will move the data sheet by sheet. The additional input that the macro will need will be gotten with an Input Data of the select spreadsheet for sheet names.

 

SoccerTil_0-1642605691522.png

 

csmith11
11 - Bolide

Sound's like you'll want to use either the Download Tool or the Python Tool.

 

A lot really depends on the External Site you are downloading the file from.

 

What sort of API connections does the Web site have available? 

 

For example, I'm doing some work with Survey Monkey:

While I'm able to manually navigate to the web page and download a .xlsx file containing my desired output data, trying to do this with Alteryx isn't very simple.

 

Alteryx is not an RPA software. (Google RPA for more information) Therefore, Alteryx can not replicate the manual navigation process to download the .xlsx file. Instead, I have to use the API endpoints made available by Survey Monkey. This means I must download multiple tables that make up the spreadsheet and use Alteryx to join/merge the tables together to formulate the same output that is readily available through a manual download process. (Multiple Table required multiple API calls, which I made using Python)  https://developer.surveymonkey.com/api/v3/#SurveyMonkey-Api

 

If its a semi public external site, could you mention the name here? I might be able to take a peak at the API Documentation to point you in the right direction. 

 

 

 

 

 

 

apathetichell
18 - Pollux

 

Can you give us some more details on how you are envisioning this and the user interaction? Does the user supply the website? Is the website fixed? Is the user running this on designer or through an app interface/server? Is there an issue with authorization?

 

There are a lot of questions and a lot of different possible workflows.

 

salbol1
8 - Asteroid

@csmith11 

The site where the data comes from is a customer locale where I'm utilizing the DL tool to obtain the spreadsheet that has 13 fixed tabs, with first two tabs being conditionally formatted pivot tables, providing summary info to the users. Running from the server, I have it setup to land it in directory path X. Because of the nature of this site, I can't hit it with ad hoc requests, rather this stored xlsx file (overwrite, named the same each day) is written on the server. So in this instance, no API library in place for public consumption data.

 

The underlying function is desired to be an embedded URL that will be placed onto a Tableau dashboard header - the intention being AD groups that will have access to it will be defined in the Collection where the app would be placed. The users accessing this are only those defined as having access to customer "A" data.

 

 

salbol1
8 - Asteroid

@SoccerTil 

So since the Input file is a fixed location on the server, I'll have no directed path that the user would need to select (red comment highlight background). I'm going to just give them the option to select the Output folder path they'd like it to be in when the file downloads to their local machine, with the added ability to change the file name (they can add a date, or whatever they'd like) to append to the output path. Would I utilize a different Input function, or just utilize the same File Browse tool directed to a fixed or UNC path on the server? If that's the case, would I be "hiding" the input function so the users have no idea that they are being directed to a fixed path, and they just see the output file and locale they've chosen?

salbol1_0-1642625042774.png

 

salbol1
8 - Asteroid

I have give credit to our account support team member @pabrahamsen , he provided the solution in 3 tools! From the server directory path a Blob Input tool - 

salbol1_0-1642643978650.png

 

Next, create a field to represent the setup for file replacement naming for the blob output  -

 

salbol1_1-1642644224436.png

 

Lastly, the blob output tool, converting the multi-tabbed and formatted xlsx file -

 

salbol1_2-1642644455455.png

 

When running in the Gallery, the file that is downloaded and overwritten each day is accessed -

 

salbol1_3-1642644784381.png

 

Downloading it saves it into the local users '..Users\"User Name"\Download\' directory path - which is fine in this instance. The ability to push into a directed path was a request, but the main result the users want in this instance is to readily see the data in question.

SoccerTil
8 - Asteroid

If your users don't need to choose the input file then you can remove the File Browse input and embed the filename in the Input Data. If they need to choose the input file from a fixed directory they you would need to chain two workflows together. One for the getting the list of files with a Direcory input and passing the results to a Drop Down input.

Labels