Differences between revisions 2 and 3
Deletions are marked like this. Additions are marked like this.
Line 25: Line 25:
 1. 2009.10.19 DrawMGT PSW Limmern Struktur v01.xls -- Master configuration file for classifications  1. '''2009.10.19 DrawMGT PSW Limmern Struktur v01.xls''' -- Master configuration file for classifications
Line 29: Line 29:
 1. 2009.10.19 DrawMGT Indextyp-Attribute v01.xlsx -- List of document code types and their components  1. '''2009.10.19 DrawMGT Indextyp-Attribute v01.xlsx''' -- List of document code types and their components
Line 31: Line 31:
 1. 2009.10.19 DrawMGT Doktypen-Prozesstyp v01.xlsx -- List of (project) document types and their  1. '''2009.10.19 DrawMGT Doktypen-Prozesstyp v01.xlsx''' -- List of (project) document types and their
Line 35: Line 35:
 1. 2009.10.19 DrawMGT Prozesstypen Tabelle v01.xlsx -- List of desired workflows  1. '''2009.10.19 DrawMGT Prozesstypen Tabelle v01.xlsx''' -- List of desired workflows
Line 37: Line 37:
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.

NOK Configuration for the Linthal 2015 Project

Note:

  1. NOK is being renamed as Axpo

  2. Axpo Informatic will host our server. They seem to be quite independent of NOK and the Linthal project

  3. This page describes a configuration method for the Linthal project, which could become a model
    • for configuring other project too.

Terminology

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

Contact Names

  1. TODO

Input Data from NOK

See the files attached to this page

  1. 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

  2. 2009.10.19 DrawMGT Indextyp-Attribute v01.xlsx -- List of document code types and their components

  3. 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.

  4. 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.

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

NokConfiguration (last edited 2009-11-03 13:01:22 by softxs)

Copyright 2008, SoftXS GmbH, Switzerland