Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleStep 2 Set the data properties


In the stream properties on the right, set:

  1. Basic Settings → Period to Transactional
  2. Tick Audit Manual Changes
  3.  
    Insert excerpt
    _save
    _save
    nopaneltrue
  4.  Click on the pin to keep the stream properties
    open. You will need it later


Expand
titleExplore the possibilities

Look in the Attributes section

You can see that PhixFlow has identified all the properties of the data columns (attributes) such as the type and length. If you want to make any changes to these ...




Expand
titleStep 3 Import the data


...


Expand
titleDetails

You now need to load the spreadsheet that contains the data into your application. 

  • Open your application.
  • Right-click 
    Insert excerpt
    _model
    _model
    nopaneltrue
     and select 
    Insert excerpt
    _add
    _add
    nopaneltrue
    . PhixFlow opens a properties tab for the model.
  • In Basic Settings > Name enter: Businesses
  • In the toolbar for the tab, click 
    Insert excerpt
    _model_display
    _model_display
    nopaneltrue
    .
  • In the workspace on the left, PhixFlow opens an empty model.
  • To load the Excel file, drag a 
    Insert excerpt
    _file_collector
    _file_collector
    nopaneltrue
     from the model toolbar into the model. 
  • PhixFlow opens the properties for the file collector. Add a name: Business-File and 
    Insert excerpt
    _save
    _save
    nopaneltrue
     the properties.
  • In the model, hover your mouse pointer over the file collector. PhixFlow displays a pop-up toolbar. Click 
    Insert excerpt
    _upload_file
    _upload_file
    nopaneltrue
    . Browse to the Excel file.
  • In the upload window, click the  
    Insert excerpt
    _upload_button
    _upload_button
    nopaneltrue
     button. 
    This process
    • automatically configures the file collector properties to upload the file
    • creates a stream ready to hold the data. Streams are like PhixFlow's internal spreadsheets. 

...