Versions Compared

Key

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

Page in draft: this should be the concept page for data.

Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleOther pages in this topic
children

This topic is for application designers who need to define data tables, attributes, properties and relationships.

Overview

The end point purpose of an application that displays is to display data to users and lets to enable them to make changes to the data. 



  •  screen displays data in grids and charts → view
  • user adds, removes or changes the data - form fields, buttons which are wired to actionflows

How you set this up

  1. Load existing Data: 
    • Quick load from excel
    • Use analysis model to connect to databases or other external data
  2. Define data structure: Use ERDs define the logical structure of the data that your application using tables and relationships.  Understanding ERDs and Defining Data Structures using ERDs
  3. Compile views: Decide what your application users need to see. Set up views for these
  4. Connecting data to screens: Design s


Action types and table types - calclulate etc.

Transactional

  • changing individual or small numbers of records - transactional changes.
  • You can also bulk change. Use an analysis model for complex processing of large number of data records.


Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleSections on this page

Table of Contents
maxLevel4
indent12px
stylenone



You can:

  • either define an ERD before adding any data to PhixFlow. In this case you create the tables, attributes and relationships
  • or you can load data from external sources first. You can then drag tables into the ERD and simply add the relationships.

Getting Data in

  • loading data page to do??: New concept page
    • Enter data yourself
    • Load excel files
    • Use an analysis model
    • generate test data
      • API to import from a tool
      • using input multipliers

Seeing Data

If you are working with tables that have records, to see them:

  1. Click on a table in the ERD to open its properties.
  2. In the properties toolbar, click 
    Insert excerpt
    _more_options
    _more_options
    nopaneltrue
    .
  3. Select View Chart (this should be default view!??).
  4. PhixFlow displays a grid showing all the data records.
Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleOther pages in this topic

Child pages (Children Display)