"<List of Sheet Names>" Not working on File Browse input

[RemcoV]

Hi all,

After upgrading our server yesterday, I found out that uploading an Excel file in a "File Browse" interface tool, does not allow me to select the "<List of Sheet Names>" option on the Server. 

The option is still shown in the User Interface, but after clicking "Ok", the first tab still gets selected.

Has any else seen this issue/hopefully solved it?

[apathetichell]

Assuming this previously worked - it sounds like something may have changed in how the term <List of Sheet Names> is being parsed by your workflow or being passed in by Alteryx Server. I'd look into capturing how this is being formatted internally first - you can do this by uploading a new workflow consisting of:

file browse.

action tool

text input tool

output tool.

action tool should be configured to replace field 1 row 1 with the value passed from the file browse tool. It should then write to a .csv (which you'll pick up in your Server output). When run on Server you should be able to see what is being passed in from your Filebrowse tool and compare that to what is expected in your workflow.

[RemcoV]

Hi @apathetichell,

Thank you for your trouble-shooting idea. The workflow failed in Designer as well, and I managed to already solve that issue with the same logic you proposed.

However, on the server, the option to select <List of Sheet Names> does not seem to work. When selecting the option in the menu that pops up after selecting a file, the option seems to either not register or to default to the first tab. 

Therefore not allowing me to have the list of sheet names being imported to my workflow.

Any ideas on this by any chance?

[apathetichell]

can you share screenshots of your action tools configuration? keep in mind that on server your file will be located at engineworkflow directory and you will need that for any full path replacement to feed into a batch macro to read in multiple sheets. 

[RemcoV]

I think there has been some confusion around what error I am experiencing. Let me try and show the issue again.

I have a workflow that has an interface 'File Browse' tool. This tool asks for a .xlsx file. The rest of the workflow requires the .xlsx file to be read in with its list of sheet names. On Designer, it looks like attachment 1. As it is supposed to, and as I want it to work.

Before the server upgrade to 23.1, this option worked fine on the server. However, after the update the List of Sheets option does not seem to work on the Server. As when I attempt to select the List of Sheets option, the inputfile defaults to the first tab, not allowing me to get the list of sheet names as an input.

I've attached a sample workflow, where the issue occurs, to this message.

On Designer desktop, the list of sheets option does seem to work.

On the Server, the list of sheets option does not seem to work. 

I'ld appreciate any feedback or ideas!

[JeroenJacobs]

Hi RemcoV,

I get the same as you on version 2023.1.1.123, first sheet gets loaded on the gallery, while Designer works properly, so it seems to be a bug.

I built a little macro that you can use to get a list of sheet names as a workaround.

Hope this helps as a temporary solution!

[rlcmtch]

Hi! I'm getting the same error. Do you have any news about a possible hotfix?

[apathetichell]

This seems like part of a series of 2023.1 problems... 

[RemcoV]

We tried to create a workaround using the Python tool, but trying to select sheet names still didn't work. 

At this point, because we were only using two tabs from a singular file, I added two seperate input tools to upload the same file. 

If anyone has a working hotfix, that would be great.