Requested file format is not supported: File/Browse tool

[ScottHill]

I have a workflow that a user sends me an Excel file and I run the workflow and send her back the results. The workflow works perfectly. However, I would like to take vacations, so I want to make this self-service for her. So I added a File/Browse tool and made it into an app. It works using the magic wand when I run it on the desktop, and also after I saved it up to the server. But when I go into the server gallery and run it as an app, and the dialog box comes up for me to select a file, it says the file format is not supported. I am trying to load the same Excel file as when I run it with the wand, but it won't take it. Or any other Excel file it would seem. Any ideas?

[fmvizcaino · Accepted solution]

Hi @ScottHill ,

The file browse doesn`t work exactly the same way in Designer and Server. On Designer, the tool will basically replace the file path with the one you selected, whereas, on the Server, the file is uploaded.

You can check the list of supported files here: https://help.alteryx.com/current/en/designer/tools/interface-tools/file-browse-tool.html#allowed-fil...

If you are uploading a regular xlsx file, you shouldn`t have a problem. Which excel file type are you trying to load?

 Best,

Fernando Vizcaino

[ScottHill]

I am trying to upload an xlsx file. Maybe this has something to do with the file path then? Like the server doesn't have access to my One Drive?

I tried copying the file to my local hard drive instead, and it still says it doesn't support the file type. 

It is likely the server doesn't have access to the path that I used in Designer. Do I need to change the path in designer to point to some shared network location or something?

[ScottHill]

I figured it out. Apparently in the file specification I have to put the whole thing, Excel Files (*.xlsx)|*.xlsx, not just *.xlsx. In Designer it worked because it was just replacing the path, but it failed when running on server.