Alteryx Server Ideas

Hi Alteryx experts!

There were some ideas similar to this one but none like it and really really old ones, so I`m revamping the idea due to recent struggles and the many questions we got on the server discussion board!

Workflow events are nice and helpful but they require the user to add it to every single workflow.

The Gallery admin also struggles to know when a schedule fails. 

There was the Server Usage Report before, but now most server admins have no idea when a schedule fails.

There are many ways of managing schedules and failed jobs (MongoDB, logs, events), but it would be nice to add a simple option to notify a user on each schedule. It would be even better if we added another option to enable this option in all schedules globally!

This idea could be combined with this one from @fjablo 

https://community.alteryx.com/t5/Alteryx-Server-Ideas/Notification-from-the-Alteryx-Server-when-a-sc...

Let me know what you all think!

Best,

Fernando Vizcaino

The current Enterprise Utility Workflow does not have a match/look-up in place between the two environments for user ID's.  Thus, the migration workflow doesn't work without adding in a couple extra API calls.  When we upgrade to a new version of the utility, I have to add this back in. 

It would be nice if the workflow would come with this already configured.

Add entered parameter into the result panel. It helps to debug process and audit.
sometime users save file in different way, and it not directly related to the interactive question
(e.g. Question: "SAP FBL5N Data" Input: "EXPORT (2).XLSX")
when error happen, I need the source file and the parameter.
if this idea is implemented, i just need the screenshot, which faster, without user to re-run the workflow to screenshot and share the parameter setup.

Hello,

Could you make it possible for curators to administer DCM connections created by other users?

Currently if one of the curators creates a connection, then only that person can modify it and give other people access to it.

Therefore if the person who created the connection isn't available then nobody can be given access to the connection.

Any curator can manage legacy gallery connections so to be able to move away from legacy connections and use DCM connections instead we need the same administration capabilities for DCM connections.

Thanks.

The V3 jobs API endpoint woefully lacks any usefulness. The current endpoint only has a get jobs/{jobid} method that is not useful because a database admin must query the database to get a list of all job IDs. To add insult to injury, this method is only limited to the user whose job is running or queued.

These are new features that I am proposing

1. GET jobs/list—This method must be callable by all users. Parameters such as none (default—full list), running, or queued will display jobs with the appropriate status. The job ID of the running or queued job and the worker it is running on must be included in the resultset.

2. GET jobs/{ownerid} — This method must be callable by all users. Like the GET jobs/list above, the resultset must include the job ID of the running or queued job and the worker it is running on.

3. DELETE jobs/{jobid} — This method must be callable by the person who scheduled the job, the owner of the workflow, or the curator. This method is the equivalent of cancelling a job on the Server Admin page - #!/admin/jobs by a curator. All three mentioned people have a vested interest in the running or queued jobs on the server and must be able to cancel those jobs.

4. POST jobs/reassign/{jobid}/{new_job_tag} — This method is restricted to the curator and applies to any job in a queued state. It allows a curator to reassign a job to another job tag or the first available worker for reasons determined by the curator.

This is an enhancement that I am proposing
1. GET jobs/{jobid} — This method must be callable by all users. This will allow any user to get the details of any running or queued job.

Logging requirements

All DELETE or POST methods must be logged and purged based on the Persistence Option > Delete queue and results after (days).

When there is an app that has multiple tabs across the top but can extend down below the page, the user will scroll down to complete the boxes and click the 'Next' button at the bottom. 

This takes the user to the next tab but remains at the bottom of the page.

It would be very useful for this 'Next' button to jump back to the top of the page.

Commas save lives! With large numbers, it's difficult to see what number was actually entered without commas present, and the wrong number can easily be entered as a result:

Is this number

• 100,000
• 1,000,000
• 10,000,000

It's hard to say without taking a really close look!

As the single user who upload workflow MYWorkspace ends up being very crowded.  I move them to collections to be able to share but on My workspace, I can not see which collection they are associated to. It would be nice if there was a column displayed that showed associated collections.   As well as being able to have some different types of category classification.  I would want something like a development stage: (In-progress, UAT level, deployed, retired) If they are retired a way to remove them off my general workspace area.

Hello all,

Right now, we can choose either MongoDb or Microsoft SQL Server as a backend. I would suggest to add Postgresql. Why ?

-it's open-source
-it's reliable
-it's free
-it works well on many environments
-it's popular
-it's already used as backend for Tableau or Qlik and many others
-it respects SQL norm and doesn't have a lot of specificity

Best regards,

Simon

After a job is run on Alteryx Server, Gallery lists Job Results with a Status column containing with one of 2 values:

• Error (represented by a red exclamation point icon); and
• Success (represented by a green checkmark icon).
  See attached screenshot for illustration.

If any WARNING messages are generated by the workflow, the operator/user is unaware unless they take the time to expand the message log details, then scroll through the long list of messages that typically appear in the log.

Because the Success Icon appears whether there are Warnings or not, the user must dutifully spend extra time scrolling through the list looking for Warnings even if there are none to be found.

My Idea: provide additional information under the Status column in one or more of these ways:

1. add a 3rd status option with a yellow/orange icon that indicates if/when 1 or more warnings are present
   • This should be a quick/easy enhancement that would provide immediate value
     
     
2. append one or more numbers after the Icon to indicate counts (see mock-up example)
   • There seems to be ample space for this type of info
   • This could be done at a later date as a subsequent enhancement

I think that the user would benefit from a filter where they could focus on errors, warnings, or other types of messages in the same spirit as the Designer interface, but I recognize that would be a lot of work and I am not asking for that now.

Currently the default 'Rows Per Page' is set to 10 when within various pages on the Gallery. 

As we add more and more Apps to our Gallery it would help to be able to increase the default so it is higher than 10.

This will help ensure users do not forget about or miss tools that are available to them which are hidden on other pages. Additionally, they will not need to remember what page to jump to if the App does not pull through to the first 10 rows, or prevent the need for them having to increase the number of 'Rows Per Page' themselves.

Please could all log file paths on Server have the option to change their location, including 

C:\ProgramData\Alteryx\ErrorLogs\AlteryxE2

To enable all log files to be written to an alternative drive than the installation.

The benefit it to prevent excessive space usage on the C: drive

Support have advised there is no way to alter the path or limit these log files by number or size.

Many thanks.

in version 2019.3, with artisan role, I able to add workflow to collection in the workflow page.

I not sure for later version, but in version 2021.4, only curator can do so. 

If I uploaded a workflow, designer already give me a link to the workflow, hence if I can add the workflow to the collection.

it goes through 2 pages within 2mins (max). it is very fast for me. 

but now, I have to go back to the homepage > collection > add workflow > wait eternal time for server to get the list of workflow > select it > click add.

it extra 5~ steps. with min 10mins extra time. and if the number of workflows larger and larger, 

it has chance that it fails to load the list and have to wait another 10mins, and another and another endless 10mins.

so 2mins > endless 10mins? please add back this feature.

Alteryx DCM has been an incredibly useful addition that supports key security concerns from companies. Currently, only three external key vaults are supported:

• Hashicorp Vault (KV secrets engine) - supported for Designer 22.3 and later.

• CyberArk Conjur - supported for Designer 22.3 and later.

• AWS Secrets Manager

https://help.alteryx.com/current/en/designer/tools/dcm---designer/dcm-external-vaults.html## 

I propose that we also include Delinea Secret Server.

Thank you and hopefully we can start to add more to make this feature widely useable and support security compliance.

Hello! We just upgraded to 23.2, and I see in v3 an endpoint to start a job (v3/workflows/{id}/jobs) and then another to get that job's status (v3/jobs/{jobID}). Compared to v1, I think the outputs endpoint is missing (v1/jobs/{jobID}/output/{outputID}). I'd love for this to be added so we can upgrade from v1 to v3. 

The dcm admin apis look promising. I would love if they could add put endpoints for sharing/execution and sharing/collaboration for admins. There is already a delete command for those two endpoints

I want to let my artisans choose the collaboration option when sharing dcm sources. Currently they'd have to be promoted to curators to do this.

I remember when i started using Alteryx and the gallery i was able to display the results of a workflow run and then copy a value from the screen to complete checks on.

Now when i run a workflow and the .yxdb results and displayed ever if its one record i have to download a file and open it just to copy the value.

Can we not get the screen to allow highlight and control c of text as required?

Results page keeps defaulting back to 50.

I would like that each user for the gallery can default his own amount of records show on the gallery ui .

At the moment i go in a set it to 100 but as soon as the gallery completes a job it then defaults back to 50. i want to be able to go into settings and have a function that says default view and it remembers that every time i open the gallery.