Preactor Views

Rantt can be used to view Preactor data.

In order to display Preactor data in Rantt you will need to create some database views.

Please download the following zip file.


The zip file contains two scripts:

  • FunctionsAndProcedures.sql
  • CreateViews.sql

These scripts will create two views, one for operations and the other for calendar periods, which can then be imported into Rantt easily.


  1. Run FunctionsAndProcedures.sql
  2. CreateViews.sql
  3. Create a new Rantt project and include the newly created views


The operation view only contains a few fields. You can add more fields to the operation view by editing the FunctionsAndProcedures.sql script. (Advanced SQL knowledge is required.)