OpenUtilities Substation 2023 (23.00.00.053)

The following items summarize the new features and enhancements in the OpenUtilities Substation 2023 release.

New BOM Manager Export Function
This new function now makes it possible to BOM (Bill of Material) Data) from one project to another using a two-step process. Step 1: Export data from source project. Step 2: Import data into destination project. Selecting Export in BOM Manager exports BOM (Bill of Material) data to a JSON file. Note: The active BOM Tree node controls the contents to be included in the export.


The active node in above image is as followed: Work Order 738882 > BOM Document: HIGH BUS BOM > Revision: 0. Only data associated to this selection will be included in the export file. A Savas dialog will appear after clicking Export button. Select desired file location and enter a file name. Click Save button to complete the export.


Information dialog will appear confirming the successful creation of the export file.


New BOM Manager Import Function
This new function will import BOM (Bill of Material) data exclusive to BOM Manager. The import requires a JSON file formatted identically to the JSON output created using BOM Manager Export. Specific data validation checks are performed to avoid duplicated devices and duplicated custom part numbers. Details explained below.
Three factors determine which records from JSON are eligible for import.
1. Is part record associated to a symbol?
2. Part Type (Coded or Non-Coded)
Part Type Definitions:
Coded Parts: Part numbers residing in Parts Database where NonCoded field does not begin with the letter T or not equal TRUE.
Non Coded Parts: There are two types of Non-Coded parts. 1) Part numbers residing in Parts Database where NonCoded field begins with the letter T or equal to TRUE. 2) Custom Parts where the Auto-Generated Part Numbers begin with NC.
3. BOM Manager Configuration – Parts Database field mapping in Project Options.
Records eligible for import
- All Devices without association to symbol.
Example Device without Association to symbol


- All unmapped BM Data fields for Coded Parts.
- All BM Data fields for both types of Non Coded parts.
Duplicate Device Warning
A check is performed to identify Devices in JSON file that exist in active project. This is necessary to prevent Duplicated Devices. When this condition is encountered, you can choose to abort the process or proceed. Proceeding with import will automatically exclude devices shown in the warning dialog’s device list.


TEMP Device Tags
Device tags are automatically created when adding parts using BOM Manager > Add New > Part. These Device Tags begin with TEMP.
A check is performed to determine if TEMP Devices exist in JSON file. When this condition is encountered, the system will automatically assign new TEMP Device Tags using next available sequence number.
Example Scenario: Export BOM to JSON file from Project #1. Then import JSON file into Project #2.
Conditions
- Project #1 – JSON export contains Device Tag TEMP119


Result
Data for Balloon number 98 imported and Device Tag changed to TEMP22.


Custom Part Number
Custom Part Numbers are automatically created when adding parts using BOM Manager > Add New > Part > Custom Part. These part number being with NC.
A check is performed to determine if Custom Part Numbers exist in JSON file. When this condition is encountered, the system will automatically assign new NC part numbers using the next available sequence number.
Example Scenario: Export BOM to JSON file from Project #1. Then import JSON file into Project #2
Conditions
- Project #1 – JSON export contains Custom Part Number NC00001


- Project #2 - Highest Custom Part Number in project is NC00001


Result
Data for Balloon number 132 imported and part Number changed to NC00002


New BOM Manager Field SubID
Background Infomation
When you assign Part Numbers, the software creates an association between the assigned part numbers and SubID. Part Quantities are calculated using total quantity value for each SubID. The SubID for the first occurrence of a new Device Tag is 1. SubID’s are automatically incremented when a device is duplicated. Choosing YES to below message will incur a new SubID. Thus, creating a duplicate will impact bill of material quantities.


New SubID field added to BOM Manager data grid. If part quantities in BOM Manager or BOM reports are in question, you can use this filed to help investigate quantity discrepancies. Most quantity discrepancies are cause when a Device is inadvertently duplicated.


Import Drawings New Overwrite option
When Overwrite option is enabled, the software automatically replaces existing pages active project.


Import Drawings - Enhaced interface for ProjectWise
The new interface allows you to select specific files prior to opening the Import Drawings dialog. Only the selected files are checkout and available in Import Drawings dialog. Prior to this release, Import Drawings automatically checked out all DGN documents from selected ProjectWise folder. Once all documents were successfully checked out, the Import Drawings dialog is populated.


Drawing Set, Installation, Location Descriptions Comparison
New comparison tools for Drawing Set, Installation, and Location Descriptions allow you to compare value stored in DGN to active project. Workflows that include the use of Import Drawings can result in a condition where project database values differ from values stored in DGN file. You can use these comparison tools to reconcile the differences.


To reconcile differences, select the desired values you want to keep by clicking in the value columns. After a value is selected, the field will contain a green box indicating the selection. To deselect, click filed with green box again. Clicking Update button resolves the property conflict for the selected items.