Server App not pulling in flat files

I have a workflow where the inputs are flat files. The app runs flawlessly when I run it in the designer on my PC. However, after uploading it to our Alteryx server, when I select the flat file from file browse I am presented with the error:

File Upload Error

Requested file format is not supported.

Does anyone have any ideas on how I can get the app on the server to accept flat files?

Error Message

Server

Apps

Accepted answers

All comments

DiganP

@Nchase How's your file browse tool configured? Do you have a sample workflow that has this issue that you can share?

Nchase

@DiganP Hey Digan here is a snip of how it is currently configured:

jdminton

In your app, you likely have a placeholder file that gets updated to the input file, but if that placeholder file is not correctly pathed out in the server app (path from server will be different than from your desktop), the app will fail. Can you check the location of the file from the server to ensure you are able to connect to the placeholder file?

jumaia

Thanks for your quick input. I have the File Browser with specification for Excel to eliminate the need for users to choose the sheet or avoid the incorrect selection. The action tool is then configured to replace the entire filename and not the sheet. See screenshot below. Any thoughts what is wrong?

jdminton

It appears that the replaced string is going to leave the last "x" from .xlsx in the new filename. Meaning when the user adds the new file, it will look for an .xlsxx file.

Also, if the tab name for the user differs, it will not locate the sheet since that part is not being replaced.

jumaia

Sorry,I fixed the missing X but it is still giving me the same error.

And totally understand the tab name

jdminton

What happens when you run on the server in debug?

jumaia

ha, how do I do that?

jdminton

It's been a while since I've been on server. You might want to cross post on the server discussion page.

I can't see the path for your input file since it's obscured, but you should confirm that the path for that input file is reachable from the server. On our server, we have to add the input file templates to a specific folder location so the workflow can run.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335