Settings and Actions

On the Manage Project dialog's Settings And Actions tab, you can use the following tools.

Settings And Actions dialog

Attributes

In the Manage Project dialog, select Settings And Actions tab > Attributes to open the Edit Object Attributes dialog for adding or removing project attributes. By default, only the Description attribute is included in new projects.

Project Space

In the Manage Project dialog, select Settings And Actions tab > Project Space to open the Set Project Space dialog for defining the 3D box that includes all design areas and model objects in the project.

You can manually define the min–max limits, or click Use to define the project space as the minimum bounding box around the objects currently in the project.

Within the project space, each designer can define the min–max limits of their own working area as described in Set limits and save.

SQL Settings for P&ID

Cadmatic P&ID uses Microsoft SQL Server® for storing diagram data. Therefore, before you open P&ID, you must install SQL Server as described in Install Microsoft SQL Server and set the SQL settings described below as your environment requires.

In the Manage Project dialog, select Settings And Actions tab > SQL Settings for P&ID to open a dialog where you can define how to connect the project to the SQL Server and create the SQL project database.

Setting

Description

SQL Settings for P&ID Database

SQL database server in use

Select this option to allow the project to connect to the SQL Server.

SQL database server not in use

Select this option to prevent the project from connecting to the SQL Server. When selected, the dialog disables all other options except Integration to Plant Modeller.

Important: Selecting this option disconnects the project from the SQL Server and removes the current connection settings.

SQL Settings for P&ID Connection

Connection method

Use ODBC Data Source

Select this option to connect P&ID to the SQL Server using an ODBC Data Source. This method provides a more secure connection, for example, if the database needs to be accessed from outside the company network.

Direct address to SQL Server

Select this option to connect P&ID to the SQL Server using Microsoft ODBC Driver for SQL Server and the database address, which you must specify in the format host\instance.

Encrypted connection

Select this option to encrypt communication between P&ID and the SQL Server. When this is enabled, P&ID checks that the server certificate is from a trusted certificate authority. If the certificate cannot be trusted, including when it is self-signed, the connection fails unless you enable Trust server certificate.

Trust server certificate

Select this option if Encrypted connection is enabled but you do not want P&ID to validate the server certificate. When this is enabled, connections remain encrypted but the identity of the server cannot be confirmed. For example, if the SQL Server uses a self-signed certificate, the connection fails unless this option is enabled.

Important: Where possible, install a certificate from a trusted certificate authority on the SQL Server instead of enabling this option.

Name of SQL database or ODBC data source name

Use Project name as database name

Select this option to use the project name as the database name.

Define Database Name

Select this option to specify the SQL database name or the ODBC Data Source name manually, depending on which is used.

Important: The database name must not contain special characters.

Authentication in the SQL server

Use Windows authentication

Select this option to authenticate access to the SQL database using Windows user accounts.

Use SQL Server authentication

Select this option to authenticate access to the SQL database using SQL Server user accounts.

Use SQL Server authentication (edit values)

If you use SQL Server authentication, select this option to enter the usernames and passwords of the user account and the administrator account.

Database User of SQL Server

Enter the username used for reading and writing diagram data. Then enter the user account password (twice).

Administrator of SQL Server

Enter the username used for database administration. Then enter the administrator account password (twice).

Note: If the specified administrator account (such as 'sa') is permitted to see the open connections in the SQL database, opening the Manage Database Tables tool shows a message when users are connected to the database.

Test connection

Select this to test that the project can connect to the SQL Server.

Create SQL database

Select this to create the SQL project database if the project is new or P&ID has not been used in the project yet.

Note: Another way to create the P&ID database is to select Object > Manage SQL database for P&ID from the Cadmatic desktop.

Manage users

Select this to open the Manage SQL Database Users tool, where you can add and remove P&ID database users without using SQL Server Management Studio. The tool requires a user account with permission to manage SQL Server logins and users. If the current account does not have the required permissions, you are prompted to log in with an account that does.

Adding a new user to the SQL project database

Adding a user creates the login in the SQL server if it does not already exist. It also adds the login to the P&ID project database as either a User (PID_User) or an Administrator (PID_Admin).

Note: In the COS Server, the User Account of an administrative user must be assigned to a User Profile that is included in the P&ID database: Manage database schema security policy. Otherwise, adding the user displays a mismatch error in the Status column until the security policy issue is resolved.

  1. Select the Role for the new user:

    • User – Select this role for normal project users. They can read and write project data.

    • Admin – Select this role for those who need to administer the project database. They can read and write project data, modify the database structure, and back up the database.

  2. Select the Login type (Windows or SQL Server).

  3. Enter the Login name. If using a Windows login, you can click Select to choose a Windows user or group.

  4. If using an SQL Server login, also enter the Password (twice). It must meet the SQL Server password policy requirements: it must be 8–128 characters long, must contain characters from at least three of the following four categories (lowercase letters, uppercase letters, numbers, and special characters), and must not contain the login name.

  5. Click Add. The tool creates the login if it does not exist, adds it to the project database, assigns it to the specified role, and displays OK in the Status column.

Removing users from the SQL project database

You can remove P&ID database users one or more at a time. This action removes the user from the P&ID database, but does not remove the associated login from the SQL Server. You cannot remove a user who is a database owner, an SQL Server system administrator, one of the project's configured accounts, or the user account used to connect the tool to the SQL Server.

  • Select the users you want to remove in the list, and click Remove selected.

Note: If required, use SQL Server Management Studio to remove the logins of removed users from the SQL Server.

Replicate P&I Diagrams

CoDesigner ON

Select this option and define the update frequency to enable Diagram replication in the COS network.

Update frequency (1-1440 min)

Specify the update frequency for replicating diagram data. Opening the Cadmatic P&ID application automatically replicates the local SQL database if the database has not been replicated within the time period that this value defines.

Note: The previous replication might have been triggered by a Plant Modeller Service Instance that has been configured to replicate SQL data according to a schedule (see Diagram tab) or by a user opening the application, whichever occurred last.

CoDesigner OFF

Select this option to disable the replication of diagram data.

Integration to Plant Modeller

Integration in use

Select this option to enable the integration between the P&ID database and Plant Modeller.

For more details on this integration, see Administrating P&ID – Plant Modeller integration.

Integration not in use

Select this option to disable the integration between the P&ID database and Plant Modeller.

SQL backup

Include SQL backup in COS backup

Select this option to include SQL backups (.bak) in COS backups (.bup).

For more details on performing backups, see Backup.

Tip: You can manually back up the current SQL database or restore an SQL backup from a backup file as described in Managing the P&ID database.

Coordinate Systems

In the Manage Project dialog, select Settings And Actions tab > Coordinate Systems to open the Coordinate Systems object browser for managing coordinate systems.

Initially, there is a single coordinate system, Project, which has no rotation or translation applied. You cannot edit it, but you can create additional local coordinate systems that are relative to it. Right-clicking the Project coordinate system opens a context menu that includes commands for managing coordinate systems.

Command

Description

Create Local Coordinate System

Opens a dialog where you define the properties of a new coordinate system COS object.

  • Name – The name of the coordinate system. For example, if you use the coordinate system to model a building, you can use the name of the building.

  • Description – A description of the coordinate system.

  • Rotation angle for xy-plane (degrees) – The rotation of the new coordinate system around the Z-axis, expressed in degrees. Positive values indicate counterclockwise rotation when viewed from the positive direction of the Z-axis.

  • Origin x, y, z – The origin of the new coordinate system relative to its parent coordinate system.

Show Properties

Opens a dialog that shows the main properties of the coordinate system.

When the project has local coordinate systems, creating a new Plant Modeller area, Service Instance, or Agent prompts you to select the coordinate system to use and to define the limits of the area.

Tip: In Plant Modeller, designers can assign model objects from the current coordinate system to another coordinate system, as described in Local coordinates.

Optional Approvals

In the Manage Project dialog, you can specify which object types in the library database require administrator approval before designers can use them in the project's 3D model.

If the approval requirement is later disabled, unapproved objects also become available for use, and existing approvals are retained. If the requirement is then re-enabled, previously approved objects remain approved, while objects that were not approved must be approved before they can be used.

These settings apply to all project sites.

These settings do not apply when the specification editor or a custom script uses the object selection tool.

Do the following:

  1. In the Manage Project dialog, select Settings And Actions tab > Optional Approvals.

  2. In the Manage Optional Approvals dialog, select which object types require approval:

    • Equipment

    • Structural components

    • Catalog parts

  3. Click OK.

eShare

In the Manage Project dialog, select Settings And Actions tab > eShare to open the eShare Integration Settings dialog for managing integration with Cadmatic eShare.

Setting

Description

Project name

The name of the project in eShare.

Address

The protocol (HTTP or HTTPS), host name (or IP address), and port of the eShare server.

Publish Main document & Spools as Multi-page

Select this option to publish a single multi-page spool document, rather than publishing the main document and spool drawings for pipe or duct spools separately.

Note: Set this option at the beginning of the project and do not change it later. Otherwise, both multi-page and single-page documents will appear in eShare.

When you accept these settings, the program connects to the eShare server and creates a new eShare project with the specified name. You are prompted if a project by that name already exists in eShare. After this:

  • You can send the 3D model and design documents to eShare. You can also automate this, as described in Plant Modeller service instance settings.

  • Plant Modeller and P&ID can get data from eShare.

  • Designers can adjust integration settings in the eShare section of Plant Modeller user settings.

eBrowser Expiration

In the Manage Project dialog, select Settings And Actions tab > eBrowser Expiration to open the Set Expiration Date dialog for defining whether Cadmatic eBrowser models published by Plant Modeller will expire after a specified number of days. If the expiration period of a model has elapsed, no viewer can open it.

Setting

Description

Days until expiration

Defines the expiration period:

  • If the value is 0 (default), models never expire. These non-expiring models can also be opened by eShare, limited (unlicensed) eBrowser versions, and older eBrowser versions that do not include this feature.

  • Any other value enables the expiration feature, and only licensed viewer versions that support this feature will be able to open the models before they expire.

Note: When publishing an expiring model as described in eBrowser model, users with User permissions can shorten (but not remove) the expiration period, and users with Administrator permissions can also extend it.

Wave

In the Manage Project dialog, select Settings And Actions tab > Wave to open the Wave Integration Settings dialog for managing integration with Cadmatic Wave.

Setting

Description

Enable Wave integration

Select this option to add the Document requests function to the Documents tab of Plant Modeller, and to add linking and unlinking commands to the Document browser context menu.

Materials import

You can import data from Cadmatic Materials.

Prerequisites

  • You have a folder that contains the 'cata' and 'spec' XML files.

  • If the CX file included in the import contains locked COS objects, your User Account must be assigned to a User Profile that is included in the Checkout lock: Lock objects and Checkout lock: Unlock objects security policies. This is to enable the import process to unlock, update, and lock again the objects.

Do the following:

  1. In the Manage Project dialog, select Settings And Actions tab > Materials import.

  2. Select the 'cata' XML file, and click Open.

  3. In the Select the template source Database dialog, click the database name.

  4. The program imports the data. If any problems occur, a report dialog opens and lists the issues. Click Close.

Materials export

You can export data for other projects that are using Cadmatic Materials. The export creates a CX file that includes the applicable objects.

Prerequisites

  • Attributes include the Is materials template attribute, meaning that this project is configured to function as a template for exporting data to other projects.

  • You have a folder that contains the 'cata' and 'spec' XML files.

Do the following:

  1. In the Manage Project dialog, select Settings And Actions tab > Materials export.

  2. In the Choose either of the xml files defining the export dialog, select either the 'cata' or 'spec' XML file, and click OK.

  3. The program exports the data. If any problems occur, a report dialog opens and lists the issues. Click Close.

Requests For Import

N/A

Check ownerships

On a replica server, you can check whether the local server and the master server agree on who owns each object in a database. Use this check when the replica thinks that the master owns an object and the master thinks that the replica owns it. This can occur, for example, when you restore a database from a backup.

Do the following:

  1. In the Manage Project dialog, select Settings And Actions tab > Check ownerships.

  2. Select the database to check, and click OK.

  3. If there are problems, a dialog opens showing the number of objects with ownership problems. Click Yes to show those objects.

  4. In the object browser, select the Model Object category.

  5. In the object tree, select the listed objects, right-click the selection, and select Request Ownership from the context menu to transfer ownership of the objects to the local server.

  6. If the master server should get ownership, select the objects again, right-click them, and select Relinquish Ownership from the context menu.

  7. Click Close to close the object browser.

  8. Repeat steps 1–2 to verify that no ownership problems remain.

Export

In the Manage Project dialog, select Settings And Actions tab > Export to open the Export Objects dialog for exporting project data to a .cx file.

For more details on the export function, see Exporting project data to CX.

Add Hull Data

In the Manage Project dialog, the Settings And Actions tab displays the Add Hull Data button if the COS server has HCA support enabled, the project includes a Hull product, and Hull data has not been added for the project yet. After you add the data, the button is renamed Hull Data Added and becomes unavailable.

Important: Before adding Hull data, make sure no users are active in the seed project.

Select Add Hull Data to add data for Cadmatic Hull to the project. The Choose COS user dialog opens for selecting the COS user to use for adding the data.

Choose COS user dialog

You can also add Hull data satellite sites if the satellite site COS server has HCA support enabled.

For more details on adding HCA support to COS servers, see Adding HCA support to existing COS servers.

Archive

In the Manage Project dialog, select Settings And Actions tab > Archive to open the Export Objects dialog for archiving a completed design project.

For more details on the archive function, see Archiving.