Check if File is Open

Question

Is there a way in Alteryx to check if a file is already opened before downloading it?

I'm trying to check if a file is already opened before opening it in Alteryx so that I can avoid errors with the dynamic input tool. I imagine the setup looking something like a Try, Except block in Python.

I've already tried using the Run Command tool for this but am unable to because the PowerShell function below is in a Constrained Language Mode for me.

PowerShell Function: [System.IO.File]::Open("network\folder	est.xlsx", "Open", "ReadWrite", "None")

Constrained Language Mode Definition: PowerShell Constrained Language Mode is a security feature designed to limit the capabilities of PowerShell to reduce the risk of malicious activities. It restricts access to certain language elements and APIs that could be exploited by attackers, while still allowing administrators to perform essential tasks.

If there's no way in Alteryx to do this I'll have to see if IT will allow me to run this function.

Hsandness · Answer

@jrlindem ,

It has taken me weeks to get the OneDrive tool downloaded to our server so I can use it in the gallery so I doubt I can request that they update to a newer version. The previous Alteryx admin we had was great but oh well. Thank you anyways. Going to give the article @dreldrel a shot. I've left designer open for hours before and the Python tool still remains in the state that you see in the screenshot I provided so this might be a support ticket.

dreldrel · Answer

This article might be helpful for your case. Sometimes the Python tool takes longer to open Jupyter Notebook because it uses miniconda.
https://www.geeksforgeeks.org/python/check-a-file-is-opened-or-closed-in-python/

jrlindem · Answer

Ya, all that tracks.  I'm sorry you're experiencing such annoying obstacles.

Regarding python tool:  Yes, I would definitely recommend posting a separate thread (or if that doesn't yield any good answers, open a support ticket).  That said, your version is getting a wee bit old and is probably beyond support.  Any way you can convince your admin's to modernize up a bit?  I think, these days even 2023.1 is near the end of support.