Alteryx Server Ideas

I've created a few apps for our company's private gallery for users. These take a couple of minutes to process. Also, some of them have very long lists to choose from. If the user doesn't make all of the selections because they don't realize there are more questions at the bottom, the app fails--but, only after running through the long process time. It would be nice to have:

1) a pop up message that lets them know they haven't answered all the questions ("STOP! You've a few more questions at the bottom to answer before this app can run.")

2) a customizable pop up message once the app is ready to run. These users don't actually use Alteryx, and aren't necessarily tech savvy or patient. Something along the lines of "OK. Now, stand up, stretch, grab a cup of something warm and come back in a minute or two while your app is processing." would be very nice.

When posting an app to the Gallery, if the app has, say, one PCXML output for the user to see, and one Excel file for the user to download, it would be helpful for to be able to specify which shows first to the user.  For example, I have a PCXML that gives the user summary tables, and instructions on how to go to the drop down above and select the second report, click on the Excel icon, and download it.  But if the Excel report shows up first, then there is no ability to give them instructions and many simply won't be savy enough to go find the PCXML in the drop down.

Currently, many of our most useful apps in the gallery utilises blocked tools (download tool, R tool etc). Every deployment or even minor updates to these apps require emailing the Alteryx Curator account for exception requests. This process is quite cumbersome, although the need for it is understandable. However, given that not a single app from us was ever rejected (and we submitted dozens of requests) , it would be great to have a process in place to apply for a permanent whitelisted status. This would give trusted app authors the ability to deploy apps with blocked tools without emailing the Curator. 

The idea is that we could grab a workflow that had been placed in the scheduler db and then if the workflow is lost as a file then it could be reclaimed from the scheduler db

When you want to re-run a chained app in Alteryx Server, give the option to run the first, second, etc app. Right now it only reruns the last app.

Our team is still fairly new to the Gallery, so if there's something existing that I'm missing, I'd be glad to hear it.

I recently found the following thread : http://community.alteryx.com/t5/Publishing-Gallery/Get-App-User-name-at-Run-TIme/m-p/775/highlight/t...

Which included a text box input with a title of "_cloud:UserID".  I was able to use this to pull in things such as the users login information, email address, etc.

I would like to be able to use a function similar to this in order to generate user-specific usage reports, or dynamically update a "Send Email" tool with the email of the running user.

However, when I inquired about this "_cloud:UserID" API call, I was told that it is an undocumented and unsupported call.

Ideally, I'd like an application/macro tool that does something similar - which takes the user's credentials automatically from the gallery and runs the Application based on those credentials.  This could modify Emails or filter the output of the Workflow.  I'm sure there are other use cases as well.  I think having an officially supported tool to manage this would allow for a wide variety of dynamic applications on the gallery.

Hi,

 We need a way to figure out at which tool alteryx workflow is currently at (i.e., workflow execution progress log) when the workflow is running on the alteryx server scheduler.

This is very useful especially if you have analytical workflows that take long time to run (say 4-6 hours) and at the moment there is NO WAY to figure out at which stage the execution is at from the scheduler.

We can't open the log file on the server as the workflow is IN PROGRESS (we get the standard The process cannot access the file because it is being used by another process) . We can't see the underlying progress log under Scheduler Queue tab either.

It will be useful to capture that information in MongoDB or somewhere so that we can read the In progress log in the real time..

 Thanks,

Sandeep.

It would be nice to connect multiple Databases from different servers, without configuration of Linked Servers

In larger organizations or organizations with global coverage, it is possible for users to be in different time zones from each other and the Alteryx server. 

WIth our implementation of Alteryx server, we have the server time zone set to that of our data warehouse, but this time zone is different than my own by -2 hours. In the case of scheduling a workflow in the future, I normally correct for this by setting the scheule in the time zone of the server and things work alright. 

Problem 1:

It falls apart is when I want to schedule something in the future, but it is within the timespan between my time zone and the server time zone. For example: It is 6PM my time, and 4PM server time. I want to schedule a workflow to run at 5PM server time (7PM my time). When I try to set this up with the Version 10 scheduler built into Alteryx desktop, it overides the date field upon saving to run the following day instead of today as it thinks im trying to schedule the run at a time that has already passed (which it has in my timezone, but not in the server time zone). Upon trying to edit this schedule to reset the date to today, it again reverts upon saving.  

The only way I have found to get around this is to reset the time zone of my computer to match the server time zone, then set the schedule, then reset the time zone of my machine back to local time again. This is not the best experience, and will likely be required more frequently for users as their time zone difference increases. 

Problem 2:

When wanting to run something server side immediately (I do this in cases where the runtime will be long, or im mobile and on a machine with a lower amount of processing resources) the "Once" option can be used in scheduler to push something to server and run it. In my case, due to the timezone difference, the default time set when trying to do this is the current time in my time zone, but 2 hours ahead of the current server time.

I have two proposed resolutions:

1) Transmit Server time zone information to the local scheduler to have everything involving scheduling in Server time. Also for any timestamp fields, include the time zone designation so its clear to the user.

2) Use information from the user's machine and information from the server to do timezone conversions behind the scenes so whenever scheduling or viewing schedules, all timestamps are in local time to the user. I feel this is the prefered solution for the best user experience, but would also be the more complex to implement. 

Thanks,

Ryan

It would be great if i as a developer could create a DB alias connection and for it then to be available to other developers and distributed via the server.

Collaborative working like the above does seem rather limited at the moment.