When you want to load organisational data into the YAWL system it is sometimes useful to first delete existing entries. This short tutorial shows how to do this if you have configured YAWL to use a Postgresql DBMS.

Tables

Access the YAWL database with pgAdmin or any other tool. Delete all entries of the following tables - not the tables themselves:

  • rs_participant_role
  • rs_participant_capability
  • rs_participant_position

In the next step delete all entries of the following tables:

  • rs_userprivileges
  • rs_eventlog
  • rs_role
  • rs_capability
  • rs_position
  • rs_participant

Then restart the YAWL engine. All organisational data and users should be gone now.