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
Main address:
- Axpo AG - Hydroenergie, Parkstrasse 23, CH-5401 Baden
- +41-56-200-4483
Contacts:
Name
Description
Email
Phone
Martin Gmür
Main contact for system configuration
+41-56-200-3872
Norbet Wohlkinger
Commercial contact
T: 056-933-4483, M: 079-630-3150
Martin Hase
Leiter Baustelle
Emil Bieri
Electro-Mechanical Leiter
Rene Käppeli
Axpo Informatik
T:056-200-4538, M:079/609-6147
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
Note that that attribute lists in the file 2009.10.19 DrawMGT PSW Limmern Struktur v01.xls generally have a set of code letters. E.g. Bereich has code aa. These same codes also appear in the document code definition and the names of the .txt and .sql files (see below).
Project to DrawMGT Configuration Mapping
This section describes how the mapping from the NOK spreadsheet 2009.10.19 DrawMGT PSW Limmern Struktur v01.xls and the DrawMGT database tables.
Worksheet Name
NOK Description
DrawMGT Table
Notes
Groups
Workgroups
Groups
Ref-aa
Bereich
ContractRef
Ref-b
Projektphase
ProjectPhaseRef
Ref-cc
Fachbereich
CategoryRef
Ref-dd
Dokumententyp
?
Keep separate from DocumentTypeRef
Ref-eee
Objekt
LocationRef
Ref-fff
Kontakt
SiteClassification2Ref
Ref-ggg
?
SiteClassification1Ref
OBSOLETE?
Fachgebiet
?
WorkCategoryRef
OBSOLETE?
Lage
Lage
AlignmentRef
Taetigkeit
?
WorkTypeRef
OBSOLETE?
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
quitRun genMeta.pl