Folder Selection Using Tree Interface Tool for Server – Step Guide

[Dhrish]

Folder Browse is not supported for apps shared in the Analytics Gallery / Server, so we need a solution similar to Folder Browse for selecting folders. By using Tree Tool, we can accomplish this and can restrict the user’s access to a specific directory and get an organized, hierarchical data structure for folder selection.

Analytical App                                                                                                                                         Workflow

Step-By-Step Instructions:

1. Setting up Tree Tool:
   1. Drag and Drop the Tree Tool onto the Canvas.
   2. In the configuration window select the ’Single Selection’ check box.
   3. Add the Directory path to the Root Path.

2. Setting up Action Tool (To input files):
   1. Drag and Drop the Action Tool onto the Canvas.
   2. Connect the Tree Tool to the Action Tool.
   3. In the configuration window select the action type as ‘Update Value with Formula’.
   4. In the Value or Attribute to Update select the Directory path.
   5. Add the formula: FileGetDir([#1]).

3. Setting up Directory Tool:
   1. Drag and Drop the Directory Tool onto the Canvas.
   2. Connect the Action Tool to the Directory Tool.
   3. In the configuration window set up the connection to the folder. 
4. Setting up Action Tool (To output files):
   1. Drag and Drop the Action Tool onto the Canvas.
   2. Connect the Tree Tool to the Action Tool.
   3. In the configuration window select the action type as ‘Update Value with Formula’.
   4. In the Value or Attribute to Update select: Directory - value.
   5. Add the formula: FileGetDir([#1])+’Directory\Subfolder’+’FileName|||SheetName’.

5. Setting up Output Tool:
   1. Drag and Drop the Output Tool onto the Canvas.
   2. Connect the Action Tool to the Output Tool.
   3. In the configuration window set up the connection to the file.

6. Setting up Text Input Tool:
   1. Drag and Drop the Text Tool onto the Canvas.
   2. Connect the Text Tool to the Output Tool.
   3. Add data.

7. Connect Browse tool to Directory Tool.

When the user runs the analytic app, they need to select one file from the folder that is required.

Browse Tool                                                                                                                                        App Results

    

Thanks,

Dhrishya