Filechooser on local system

Dear all,
I am tyring to select a file by a file open dialog on local system - not in workspace; e.g. c:\temp\abc.xlsx.
I have to save complete path and filename of the selected file in a variable and only the path in another variable, available in the complete workflow.

Does anyone have an idea how to realize?

Thanks for help!

BR,

Heinz

Look at

node. Or

node

1 Like

I did not find the solution :frowning:

Maybe I am doing something wrong with the configuration.
Do you have a screenshot from configuration tab for selecting a file and sticking complete path with filename in one variable and only the path in another one?

Thanks for help!

BR,

Heinz

Hi @Heinzs ,
If I use the Local File Browser Configuration node suggested by @izaychik63, with the following config:

It returns these flow variables, which look like what you are asking for.

If not, please share what result you are getting, or what isn’t working for you.


[Edit:

Or maybe when you say path, you mean the folder path excluding the file name?

If that is the case, you can convert the variables from that node into table columns (e.g. using variable to table row) and then use either String to URI or Path to URI (depending on whether you use the file path stored in a String or Path column, followed by URL to File Path to return the individual parts of the file and its path, and then you’d put those back into a variable again.

Alternatively, for convenience I’ve encapsulated that into two components, so you’d still need to do Variable to Table Row but then you can call either Path to Extracted File Name Parts or String to Extracted File Name Parts ]

image

These components can be found here

1 Like

Hi @takbb,
I placed only the Local file Browser Configuration node, and executed it.
I am expecting that a file open dialog pops up allowing me to select any e.g. xlsm file for data input and output…

Am I wrong?

Thanks for help!

BR,

Heinz

If you are using the node as a stand alone selector in a workflow - Just open the configuration window of the node (double click or right click / select configuration settings) then select the file location where it says “Default File”.

If you are using it to select a file within a component that you are building - Then it should be available in the configuration window of that component.

If you use the widget version of this node, then you would access the file selector in the “interactive view” instead of the configuration window.

1 Like

Thx for help! Now it works…

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.