My team and I are running into an issue with collaboration via Egnyte with Alteryx. The connection on my computer works fine, but were finding that we have to manually refresh the input and output sources anytime my team uses the workflow (which is a lot if there are x10 inputs/outputs)
I tried creating a macro that would just update the input location with my coworkers names:
C:\Users\MaddieD\Egnyte\Shared\......... to ..............C:\Users\Coworker\Egnyte\Shared\
but its a temporary fix and I would love to find a more resolute solution other than having to update the inputs/outputs every time.
Does anyone have any collaboration suggestions or are familiar with Egnyte connections in Alteryx?
Thank you!!
Solved! Go to Solution.
Hi,
You can find the first part of this path with a function in a formula tool:
GetEnvironmentVariable('Userprofile')
You could create your path using this with the following formula:
GetEnvironmentVariable('Userprofile')+'\Egnyte\Shared\'
Then you could use a Dynamic Input instead of the usual Input Data tool to read in your specified files.
Hope this helps!
Hello!
Thank you for your input -- your solution does help with the output so thank you for that!
I'm still running into the issue with the input, because the data isn't pulling from the sources on Egnyte -- they are all the same document, but the Users/MaddieD vs. Users/Coworker is forcing an error. Its not finding the files for the input because the input is directed to the last connection made by the previous user like the picture attached. Is it possible to connect the actual document without having it connect to the user profile so then anyone can run the workflow without having to configure the in/outputs?
Should I just use a macro for the input and then your solution for the output? Thank you again for your help!!
That worked -- thank you!!!
piggy backing on this discussion, is it possible to do something similar for a Directory tool?
So that's a rather interesting topic.
The short answer is "kind of".
The Directory tool itself uses windows file navigation, so %USERPROFILE% looks like it works if you type it in - it will even show you subfolders as you type in a path. However, on runtime, the Alteryx engine takes over and doesn't have a way to handle %USERPROFILE%.
I would recommend creating an Alteryx macro to handle this. You can either do text replacement with an action tool to add support for typical Windows paths (%USERPROFILE%, %APPDATA%, etc), or you could create a drop down or check box to use these functions.
You can even replicate the Directory tool inputs without needing to use HTML inputs or anything like that, so it will look relatively seamless for the end user.
That's a great idea, thank you!
Here's a question... Will this work if the workflow was run from the Alteryx Gallery? How would the server know what UserName to use?