...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Widget Connector width 900 url https://www.youtube.com/watch?v=9Bl8u2O3CkI&index=18&list=PLbPt6SI1Zhb8CnWh7Gvopto7D6LEwcB9A height 500
Create a mechanism to allow users to import a list of businesses. To recap the steps in the video:
Load a Business File
- Create a File Importer called Import called
Import Businesses. - Load up the To configure the file importer, upload this test file: Import_Businesses_1.csv to configure the file importer, and create .
- Create a stream called
Import BusinessesMake this stream Static to allow for testing and set it to Static to use it for testing. - Run the new stream to import the data.
Link Imported Businesses
...
- Link the
ImportbusinessesBusinessesstream to the Businesses theBusinessesstream. - Create a Sequence to provide a consistent mechanism for populating the contact UID across import from files and app updates:business
UIDfor both file imports and application updates.- Under the application Businessesapplication
Businesses, find Sequences. - Right-click and and select Add SequenceConfigure the sequence, then set:
- Name: BusinessUID
BusinessUID - Start Value: 10000
10000 - Block Value: 1
1
- Name: BusinessUID
- Under the application Businessesapplication
- Open the stream configuration form for Businessesfor
Businesses. - Update the expression for the stream attribute UID to: nextValueattribute
UIDtonextValue('BusinessUID') - Update the
Descriptionexpression_NULL - Update all the other expressions to: into
in.[attribute name] - Except Description which we can set to _NULL Run the stream to populate the data.
Add
...
a Task Plan to Run the Businesses Stream
- Add a Task Plan, ImportBusinessesDon't forget called
ImportBusinessesand remember to enable the task plan! - Add a Task.
- Add the stream Businesses to stream
Businessesto the Analysis Task.
Add a
...
Button to
...
Import Contacts
- Open the
Businessesdashboard. - Add a new action to the
BusinessesStream and set:- Name: ImportBusinesses
- Display Name: Import
- Ask for Confirmation: Tick tick
- Confirmation Message:
- "Are you sure you want to run this import?"
- In the Run Task Plan section:
- Run Selected Task Plan: Ticktick
- Add a Task Plan
- Select
ImportBusinesses - Leave the expression blank - we . We want to run this task plan every time the button is pressedclicked.
- Select
- Finally drag the new action onto the
BusinessesGrid View on theBusinessesdashboard.
Make the
...
Action Refresh the View
...
- Open the configuration form for the grid view
Businesses. - Open the section Refresh Actions.
- Bring up Show the list of streams
- From the repository browser drag Drag your new action into the list of refresh actionsRefresh Actions.
Change to App Mode and test the Import button.
Refresh
...
the Test Data and Try Again
In this exercise you we will refresh clear the test data using rollbackusing Rollback. This is something you will look at in There is more detail about rolling back data in the Modelling Concepts course. Just note that this is a very useful thing while developing models, but should not be used in production systems - at least not without guidance from a PhixFlow project team or PhixFlow support.
...
| Tip |
|---|
Being able to roll back changes to data is very useful when you are working on models in a development system. However, do not use it on a production system. |
- Right-click on the stream
Businessesin the model view and select Rollback Stream. - In the rollback form, untick set
- Keep Old Stream Sets
- Otherwise, leave the default options - by default these will rollback only the latest run (the data loaded from the import): untick
- Keep the default values for the other options.
The default is to roll back the changes from the most recent run. In this case, it will roll back the data loaded by the import.
- Confirm the rollback.
- Once this is complete, refresh the data in the appapplication, and you will see the import lines disappear.
Now try your import Import button again.
File
...
Loading
To tie our the import process together, we will make the import Import button also load a new file of contacts to import. Update your app to load a file from the import button.
- Remove the static flag from the Import Businesses streamthe
Import Businessesstream. - Open the configuration form for the Action Import
Import Businesses. - Pin this form.
- Open the File Upload section and set
- File Upload button: tick
- Get the tag value value from the file importer:.
- From your model view, open details for the file importer.
- Copy the value in the field Tag.
- Go back into the configuration for the custom action Import action
Import Businesses. - Paste the tag value into the field Tag Expr.
Go into App Mode. This time when you press the Import click the Import button, a file upload form will appear - select . Select and upload the test file: Import_Businesses_2.csv and upload it. You will can see the new newly imported contacts businesses are immediately loaded into the app straight awayapplication.
Update
...
the Existing Add
...
Action to
...
Set the UID from
...
a Sequence
To make sure we have a consistent mechanism for setting the Business UID, we need to update the add contact data Add button on the Businesses dashboard to use the sequence, rather than relying on the automated mechanism it is currently using.
- Open the configuration form for the
BusinessesStreamstream.- Add an action and set:
- Name:
AddBusiness - DisplayName:
AddBusiness - In the Stream Item Action Rules section:
- Add a new Stream Item Action Rule
- Add a new Stream Item Action and set:
- Name:
AddBusinessAction - Stream Item Action:
Update - Filter Type:
Selected Items - Copy Values By Name: Untick – this
This is required as you want to set only one value programmaticallyvalue programmatically. - Attributes to Update
- Attribute: UID
UID - Expression:
-
nextValue('BusinessUID')
- Attribute: UID
- Name:
- Name:
- Save all your changes.
- Add an action and set:
- Open the Businesses the
Businessesdashboard. - Apply the new action to the Add button
Addbutton on your dashboard.
| Panel |
|---|
Next video: 17. Auditing Changes |