Overview

PhixFlow can import Excel files, including csv, manually uploaded by a user or collect files from a directory. The following setup illustrates the automated configuration for manually uploaded files. To collect files from a specific location see, Importing a Managed File. The latter can be scheduled for automated collection. 

Manually Upload Solution

1. In the toolbar, find the Create section. Click on File, and drag Collector onto the canvas.
   1. Image Removed
   A properties window opens hover over

   Insert excerpt
   _files _files nopanel true

   , and drag

   Insert excerpt
   _file_collector _file_collector nopanel true

    onto the canvas
   1. Image Added
2. A

   Insert excerpt
   _property_tabs _property_tabs nopanel true

    opens on the right, enter a Name.
3. Hover over your file collector and click the Upload Managed File button on the canvas and click the 

   Insert excerpt
   _upload_file _upload_file nopanel true

    button from the popup menu.
   1. Image RemovedImage Added
   2. Navigate to the Excel file you wish to import.
   3. Click Open.
   4. Click Upload Managed File.
      1. If the file has multiple tabs, select the required tab in the prompt and click confirm. Confirm
4. A

   Insert excerpt
   _file_collector _file

   collector is

   _collector nopanel true

    is created that will hold the imported data.
5. When you are ready to import the data hover over the File Collector and click Run Analysis.Image Removed

   Insert excerpt
   _tables _tables nopanel true

    and click

   Insert excerpt
   _run_analysis _run_analysis nopanel true

   1. Image Added
6. To view the data hover over the File Collector and click View → Default View
   1. Image Removed

   Insert excerpt
   _tables _tables nopanel true

    and click 

   Insert excerpt
   _view_show _view_show nopanel true

   1. Image Added

Automated Solution

See Importing a Managed File.

Learn More

• File Collector Properties 
• Understanding Displaying Data (Views)