NOK Configuration for the Linthal 2015 Project

Note:

NOK is being renamed as Axpo
Axpo Informatic will host our server. They seem to be quite independent of NOK and the Linthal project
This page describes a configuration method for the Linthal project, which could become a model
- for configuring other project too.

Terminology

Zust. = Approval (Zustimmung)
Indextyp = Document code type

Contact Names

TODO

Input Data from NOK

See the files attached to this page

2009.10.19 DrawMGT PSW Limmern Struktur v01.xls -- Master configuration file for classifications
- Worksheet Indextyp -- describe drawing code format and file names
- Worksheet Attribute PSW Limmern -- list of all the classification and other reference data
2009.10.19 DrawMGT Indextyp-Attribute v01.xlsx -- List of document code types and their components
2009.10.19 DrawMGT Doktypen-Prozesstyp v01.xlsx -- List of (project) document types and their
- corresponding document code types and workflow types. Note that we will implement the project document type as a classification field, and separate from the documentTypeId.
2009.10.19 DrawMGT Prozesstypen Tabelle v01.xlsx -- List of desired workflows

Generated SQL Configuration Files

The NOK configuration information lives in the drawmgt-cfg configuration tree:

cfg/linthal/site/data

Most of the configuration is generated from an Excel file:

linthal-configuration.xls

The initial worksheet called Overview lists the mappings from the NOK attribute lists to their corresponding DrawMGT classification tables. Note that DrawMGT V11.3 has four extra classification tables SiteClassification1-4.

The generation is perform by saving each separate worksheet in the Excel file, in tab-separated format, into a file of the same in the data directory.

E.g. Save the ContractRef worksheet as ContractRef.txt
Save the other worksheets too

Then run a script to generate SQL files:

generateRefData.sh

This script reads the .txt files and outputs .sql files

Then load the SQL into the database:

  mysql -u... -p...
    create database linthal113dev;
    use linthal113dev;

    source app/schema/drawmgt-schema.sql
    source app/schema/data/refdata.sql

    source cfg/linthal/site/data/linthal-configuration.sql

    quit

Run genMeta.pl