Biak Project DMS Software Help & Documentation

Get the software

Download the software by clicking this link.

Install

Just follow the instruction provided.

First time Setting

At the first time, database settings are not correct yet. Login using local administrator account [username: “superuser” and password: “superuser” (both without quote)]. Main Window will appear, hover to Settings > Connection menu. Make sure you test connection first by clicking Test Connection before saving it. It’s very recommended to change your local administrator account password.

Hostname, database, port, username, and password field are provided from PostgreSQL server. If you only distribute the software without managing the database server, please provide database settings to end user.

Add object

Add project

There are three ways to add project:

  1. File Menu > Add Project
  2. Click Add Project icon on Toolbar
  3. View Project Table > Right Click on records > Add record(s)

Fill the form with your desired data. Click Save & Add More. It saves previous inputted data and trying to add more records. If you just want to add one data, click Save & Add More button is also required. Click Commit All button, Confirmation Table button will appear. Review the data and you are ready to go by clicking Process button.

Rules:

  • Mandatory fields: ID, Title, and Contractor Name.
  • End Date must be equal to or greater than Start Date.

Add location

There are two ways to add location:

  1. File Menu > Add Location
  2. View Location Table > Right Click on records > Add record(s)

Process are similar to Add Project.

Rules:

  • Mandatory fields: ID and Title.

Add shelf

There are only one way to add shelf:

  1. File Menu > Add Shelf
  2. View Shelf Table > Right Click on records > Add record(s)

Process are similar to Add Project.

Rules:

  • Mandatory fields: ID, Title, and Location ID.

Add folder

There are three ways to add folder:

  1. File Menu > Add Folder
  2. Click Add Folder icon on Toolbar
  3. View Folder Table > Right Click on records > Add record(s)

Process are similar to Add Project.

Rules:

  • Mandatory fields: ID and Title.
  • Folder must be assigned to either Shelf or Location.

Add document

There are three ways to add document:

  1. File Menu > Add Document
  2. Click Add Document icon on Toolbar
  3. View Document Table > Right Click on records > Add record(s).

Process are similar to Add Project.

Rules:

  • Mandatory fields: ID and Title.
  • Folder must be assigned to either Shelf or Location.

Edit/delete object

To edit record(s), right click on record > click Edit record(s). Object edit form dialog and rules is similar to add object. You can select multiple records by holding Ctrl key and select desired record or by holding Shift key.

Query

Query menu could be accessed via Menu > Query or by clicking Query Icon. New dock widget will appear at the bottom. Query dock widget is changing constantly depends on current active table.

Query tips:

  • Contains: pattern search. Example usage: %ble will show results: “Table“, “Double“, etc. %am% will show results: “Ramped”, “Shamed”, “Malam“, “Ampul”, etc.
  • Equals to: exact search
  • Is: NULL to find null field.
  • Search is case-insensitive.

View journal

Journal could be viewed by clicking Journal Icon on toolbar or Menu View > Journal.

View system logs

Currently being developed.

Add/edit/delete user

Administrator or Super Administrator is authorized to add/edit/delete user. User management can be accessed from Menu Administration > Account > Manage User.

Rules:

  • Super Administrator can add Administrator/Editor/Viewer.
  • Administrator can add Editor/Viewer.

Report bugs, suggestions, or improvements

Please email to [email protected]

Contribute in software development

This software is written in Python using mainly PySide, pandas, and psycopg2 (PostgreSQL).

If you are interested in contribute in software development, please email request to [email protected]

Write a Comment

Comment

    • hi Tom,
      I could provide the database sql files you need and then you can simply execute it manually. where should I send this file?