Admin Guide

This represents a guide on how to administrate the database, install a Virtual machine, import and export data

• Datamodel
• Customisation of labeling and symbology behaviour
  • Relevant fields
  • Labelling
  • Symbology
• pgAdmin
  • Install pgAdmin
    • Windows
    • Linux
  • Using pgAdmin
    • SQL query
    • Database dump
• User Roles
• INTERLIS Data exchange
  • General
  • Prerequisites
    • Java
    • Python libraries
    • TWW Version
  • Usage (GUI)
    • Enable admin mode
  • INTERLIS Export
    • Launch export wizard
    • Export model
    • Label export
    • File name and location
    • Validation pre-processing
    • Validation Post-processing ilivalidator
    • Error logs
    • Export extra organisations
  • INTERLIS Import
  • Usage (command line)
    • Dependencies
    • Import
    • Export
  • Quality control
    • Quality control with VSA online checker (Fachprüfung mit VSA Checker (online))
• Customization of the data model
  • Alterations to ordinary data
    • Introduction
    • Altering symbology and labelling behaviour
    • Creation of custom tables
    • Adding fields to base tables
    • Datamodel updates
  • Modification Framework for application schema
    • Creation and loading of modifications
    • Limitations for sql scripts
• TEKSI Module Management Tool
  • Documentation
    • Troubleshooting
• Manual update of the datamodel
  • Requirements
    • Client
    • PostgreSQL
    • Python
    • PUM installation
  • Database update
    • PostgreSQL service
    • Database backup
    • Download and install current database release
    • Create empty database
    • Launch update
• Prepare database for production
  • OID Prefix Settings
  • Obj_ID in the TEKSI Wastewater Module (TWW)
  • Setting Default Values

In discussion:

• dxf (see improved dxf export feature description (since QGIS 3.38) from opengis.ch and QGIS user documentation

• Shape

• MOUSE / MikeUrban (please connect with the developer team if you are interested in this)

• other