Can File Browse Only Bring in the File Path

Question

Hi All

I have been working on a project that would allow the user to upload a password protected excel, this file path then updates a text input tool which goes through a python script to save it down without a password.

I have gotten everything working so far, the only issue is I cant seem to find a way to have alteryx not try and open the excel file. It throws me an error because it is password protected, but I just want it to save the file path. I have the file browse open to all file types.

Is there a way to do this? instead of having to have the user paste in the file path?

Appreciate your help and attached a copy of this section of the work flow.

FilePathExamp.yxwz

apathetichell · Answer

tbh - we aren't a server customer --- and I havnen't used it in a bit. My memory is that what you are describing should work (at least on say Server 2022.1)... I'd recommend swapping from dynamic input to batch macro. batch macro is cleaner and better. Open a question on the Server forum --- but my memory is that what works on Deisgner here should be working on Server. Can you confirm that your server workflow looks like the .yxwz above?

cbil · Answer

I was at first using it off the server - so just inputting the file path of the file with a password into the python tool, the python tool opens the file with the password, then resaves it without a password. The dynamic input then reads in the new file that doesnt have the password.

My issue is on the server, when the user does file browse, there is an error when they try to upload the password protected excel sheet (of course because there is a password). I want to see if there is a way to tell alteryx to not try and open the file, rather just save the file path of the chosen file.

apathetichell · Answer

I'd recommend not using dynamic input here. That could be part of your issue... I'd use a batch macro if you need to anything to the existing excel file after unlocking it...  I'm a bit confused though because you have the file-> action-> input--- but you are then opening the Excel file in dynamic input. That would require it to be unlocked. What is your python doing?