Versions Compared

Key

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

Goal

You want to derive part of your model from an external source. For Instance you would like to determine the street name and town based on the postalcode and housenumber. 

Ingredients

  • Entities
  • Attributes
  • CSV Wizard
  • CSV File
  • Data rule
  • Page
  • Flow

Recipe

Step-by-step guide

To use Use a data rule to derive information for one or more attribute values. atribute values follow these steps:

  1. Create a domain
  2. Select a csv file
  3. Use the csv wizard

Create a domain

The following domain model displays a Person and Address Entity.

Select a csv file

We will use the a CSV file that has a list of all available adresses to load the street name and town based on the postalcode and town

StreetHousenumberPostalcodeTown
Veemarktkade85222 AEs-Hertogenbosch
Reitscheweg555232 BXs-Hertogenbosch
Wolvenhoek15211 HHs-Hertogenbosch
Verwersstraat415211 HSs-Hertogenbosch

...

Use the csv wizard

You can use the CSV wizard to create a datarule that uses a CSV datasource

...