• MultiSystemDrawMGT

Multi-System DrawMGT

Introduction

This page describe a design for multi-system DrawMGT. It explains how documents and tasks can be shared between multiple DrawMGT systems.

The initial use for a multi-system DrawMGT will be for the Axpo PSW Limmern project which needs a two-system DrawMGT installation, consisting of confidential and shared servers.

Database Keys for Documents and Tasks

A database key must be defined for documents and tasks that are stored in an external system must be defined. It should have the following components:

1. systemId - identifies the system which is the master system for the record. This field is filled in even if the current system is the master system for the record.

2. drawingId/commentId - the primary key on the external system

These fields will be added to the following tables:

1. Drawings
2. Revisions
3. Comments

4. CommentRevisions

5. SubmittalRevisions

A new database table SystemRef will also be required, which has the following fields:

1. systemId - primary key

2. code - short code

3. name - longer name

4. description

5. url - base URL for accessing the system

6. define

= DIsable of External records

Publish Transaction

A new publish transaction will be implemented that transfers

Submittals

1. How to handle ZIP files for submittals where there is a mix of documents from the confidential and shared systems?

Implementation Checklist

1. Implement login re-routing - To allow a link to be displayed on the system when you are not logged in.

Restrictions

1. Reference data must be the same on both system