Patch Release v3.13.2

Enhancements

• Documents that are "viewable" will now open in a new tab instead of downloading by default.

Bug Fixes

• Resolve downloading of uploaded HTML reports. Will now open in a new tab.
• Resolve standard users not being able to access user settings page.
• Resolve admin not being able to reset settings of another user.
• Resolve filtering of project column in the item table.

Patch Release v3.13.1

Bug Fixes

• Resolve issue with creating traveler instances from the multi-edit page.
• Resolve issue with linking traveler template from the multi-edit page.
• Resolve page crash after pulling up a discrepancy log for traveler with no discrepancy.
• Resolve not being to remove allowed property values in the property edit page.
• Resolve null exception when adding properties from the multi-edit page.
• Remove invalid primefaces attributes from some views.

Release v3.13.0

Machine Design

• Split up controllers for machines.
• Allow updating inventory for machines that already have inventory selected
• Add 'branch' submenu
  • Move the 'move to trash' to submenu.
  • Add option to update permission for all items in branch.

Control Relationship

• Add control hierarchy list page.
• Top level nodes are control type nodes that control nodes in housing hierarchy.
• Allow selection on housing nodes into the control hierarchy.
• Add interface to parent functionality to define interface between controlled nodes.
  • ex: Direct Connect, RS232, Subnet X, etc.
• Allow jump to control node from housing hierarchy and jump to housing hierarchy from control hierarchy.
• Allow removal of removal of control relationship and control node.
• Allow search for control hierarchy.
• Only allow an ioc to control the same machine once.
• A machine element can only be controlled by on other element.
• Disable favorites + D&D for control elements.
• Standardize machine tree relationship children loading.
  • Cable toggle is now only for standard machines.
• Add APIs to create control elements and created control relationships.
  • Add utility to read spreadsheet and use API to create control hierarchy.

Promoted machine elements

• Functionality allows creation of machine element that represents assembly element.
• New db attribute to specify representing element id.
• Allow create a machine design from assembly element.
• Fetches assignment from parent assigned assembly.
• Allow creation of machine relationships to assembly elements via representing machine element.
• Support move to trash and dissasociate with representing element id.
• Support machine templates.
• Update the tree to allow toggle show/hide of assembly elements.
• Add handling to machine hierarchy import spreadsheet format for 'Assembly Part' column to create promoted machine items from assembly elements.

Primefaces 11

• Resolve Style issues
  • Resolve action column icons
  • Resolve black icons where white icons go
  • Widen input for num of rows customize dialog
  • Resolve inline for image property value + primary image button icon
  • Convert ui-icons to fontawesome
  • Resolve location selection highlights in dialog and tiered menu.
  • Black blockui on machine design instead of transparent.
  • Resolve menubar spacing and update styling.
  • Resolve formatting with log editable row.
• Resolve inventory update BOM item not updating after selection.
• Update data table to show stripped rows and use single sort mode.
• Resolve tree pre-render issues
• Resolve multi-edit location tree selection menu stuck inside datatable cell.
• Update all select data table uses to use the override variable.
• Resolve lazy data table filter map comparison issue + new sort map.
• Resolve issues with streams.
• Resolve issues with plugins.
• Restore functionality of selenium tests to be compatible with updated UI framework.
• Resolve issues with selection data tables that seemed to be ignored by pervious framework release.
• Optimize new galleria component for CDB.
  • Resolve display issues
  • Resolve out of memory exception for certain uploads.
  • No more done button on upload, automatically save after finish.
• Decrease margin size
• Make header smaller
• Resolve clickable items in header not highlighted.
• Increase font size in header buttons.
• Improve contrast on data table rows.
  • More vibrant borders.
  • More vibrant alternating rows.
• Improve contrast on data table header.
• Improve contrast on panel headers.
• Improve spacing of buttons.
• Improve color of buttons for better visibility.
• Make table header smaller.

Location enhancements

• Optimized recursive queries fetch items in a location.
• Shorten housing/location column.
  • Provide icon/link to location/housing item.
  • only show name of location/housing item.
  • Show the location/housing hierarchy string upon hover for tooltip.
• Items located in location on the location detail page.
  • Inventory located here (by relationship, by assignment, and by installation)
  • Machines located here
  • Location children (previously elements list)

Import/Export support

• New import spreadsheet for cable design connections with endpoint device, device port, and cable connector.
• Enable update and delete modes for cable design connections.
• New import spreadsheet for defining connector types.
• Change spreadsheet formats for component and cable catalog ports and connectors to reflect portal/schema changes.
• Enable update and delete modes for component and cable catalog ports and connectors.
• New import spreadsheet for users.
• New import spreadsheet for groups.
• New import spreadsheet for item types (technical systems).
• New import spreadsheet for item categories (functions).
• New export spreadsheet for extracting cable design data for pull list generation.
• Enable export and transfer modes for cable design items.
• Add support for QR ID in import framework to reference associated items.
• Enable use of QR for assigned item reference in machine hierarchy import format.
• Add support for creating promoted machine items for assembly elements via new 'Assembly Part' column in machine hierarchy import.
• Use busy indicator during long-running tasks.
• Condense import wizard's validation table content to show item attributes in a single column instead of a column per attribute.
• Enable export/update/delete of catalog assembly elements via import spreadsheet.

Cable management

• Improve portal handling for component catalog ports and cable catalog connectors.
• Resolve issue manually creating cable inventory due to missing property type.
• Remove gender from connector schema, use name to reflect gender where appropriate.
• Rework synchronization of device ports and cable connectors from catalog items to design items.
• Rework views for managing device ports, cable connectors, and cable design connections.
• Resolve Primefaces 11 related issues in cable views.
• Enhance external pull list script to load CDB export format, add tagging module for identifying length calculation approach for cables, fix performance issues reading Excel file, add length calculation module.
• Enhance external CDB pre-import script to generate latest CDB import formats for cable catalog and cable design, improve feedback, improve performance reading Excel file, enhance header validation and error reporting.
• Integrate cables with Search feature of CDB.
• Allow adding Cables to component catalog assemblies and assign specific instances to component inventory assemblies for inventory tracking.
• Add display mode for cable lists (Cable catalog, cable inventory & cable design).
• Allow creation of "cable assemblies" in cable catalog and cable inventory domains.
• Enable full set of catalog and inventory domain features in cable catalog and cable inventory domains, reorganize code for sharing.

Plugins

eTraveler

• Ability to pull up discrepancy log for each traveler assigned to an item.
• Resolve issue with Binders crashing CDB page.

General

• Store user file name when uploading + downloading files.
• Always show current location at top of location history dialog.
• Allow resize of columns in all entity list pages.
• Improve expired session dialog to allow attempt to restore current page.
• Enhance user group management
  • Better selection of user group in user details page.
  • Selection of users in group details page.
• Resolve about page taking up too much resources for loading item counts per domain.
• Deprecate machine inventory.
• Resolve many JSF1095 warnings
• Resolve discriminator column + converter name warnings.
• Appropriately label item identifier 1 & 2 for search results.
• Allow editing for connectors.
• Allow user to reload the details of the page in their open tab upon session expiration.

Performance

• Add db caching for mostly static entities (excluding items, properties, logs, etc.).

Query Based Pagination

• Fetch only one page at a time instead of all the items for a lazy data table (great for huge data lists).
• Add functionality for MAARC
  • With query based loading of self element.
• Add functionality for system logs

Query based search

• Search for items and item elements using query and limit results to 1000.

API

• Allow specifying sort order when creating locations.
• Allow install state to be specified when installing inventory to machine design.
• Allow fetching machine design by name pattern.
• Allow creation of promoted machine elements using API.
• Use new standardized set assigned item function to update assigned item to perform same things for UI and API.
• Add API exception object parsing function to factory.
• Split up API into the API and CLI on pypi.

Test

• Import support for selenium test
  • Sources

Bug fixes

• Resolve ignored sort order for top level machines.
• Resolve issue with lazy data models not being able to switch sort to a new column.
• Resolve spelling ItemDomainMachineDesignIdListRequest doman -> domain
• Resolve missing jsonignore for currentHierarchytItemElement
• Resolve issue for fetching system logs by date.
• Resolve issue with update property metadata throwing cannot find entity.
• Resolve issue with not setting property value target value in API.
• Resolve null exception when updating columns on item list pages.
• Resolve traveler summery crashing firefox.
• Resolve 32 character bug in trigger with new version of mariadb.
• Resolve permission issue for stored procedures in new version of mariadb.
• Resolve ignored dbHost configuration for python API.
• Resolve missing LD_LIBRARY_PATH when building python API.
• Resolve log4j vulnerability.
• Resolve missing row expansion functio...

Patch Release v3.12.4

• Resolve log4j vulnerability.

Patch Release v3.12.3

Administrative

• Add support for host specific portal deploy configuration files. (This will allow a dedicated host for portal).
• Allow building support only for deployment of portal.

Assembly Enhancements

• Add a scroll panel in assembly BOM builder (create + edit) when necessary.
• Add prepare reorder button that will automatically show all items (useful with assemblies that go over configured items per page).

Cable Enhancements

• Add new cable end designation property type and use for distinguishing cable end for cable catalog connectors and cable design connections.
• Add new cable design list view columns with filtering for devices connected to each cable end.
• Add actions column to connections table on cable design item view with links for editing and deleting connections.

Import Enhancements

• Add support for new import spreadsheet format for assigning a template to existing machine items.

API

• Add API to add/update metadata on a property value by a map/dict, this allows setting many key values pairs at once to property value.
• Add test for new API.

Other

• Status history effective date is promoted over entered on date. Entered on date is not shown.

Bug Fixes

• Resolve part name naming issue where the names would repeat for same catalog item on browse by function row expansion.
• Resolve issue with uploading PDFs and generating their previews.

Patch Release v3.12.2

Bug fixes

• Resolve issue with is_housed default to false. Should default to true.
• Resolve header style issue and style enhancements on the top menu bar.
• Support more screen sizes on the cascading location menu model.
• Resolve issue in machine hierarchy import when specifying default root node option due to duplicate references to the same object

Patch Release v3.12.1

Bug Fixes

• Resolve issue where it was possible to create multiple location relationships when updating an inventory item with no location prior. The issue occurred when setting a new location and updating few other components on the details page.
• Resolve issue where after deleting first connector the second one would fail at deletion.

Release v3.12.0

Machine Design

• New specialized tree model
  • Lazy children loading
  • Does not need to fully reload to show cables.
  • Faster query based filter with limitation on too many results (resulting in unresponsive GUI).
  • Expand all functionality now a part of machine tree model limits too many expanded nodes.
• Ability to update a machine by assigning it a machine template to use.
• Enhance expand all feature to limit user from expanding too many machine nodes.
• Add quick link to view machine design details.

Cable Catalog

• Add GUI elements for managing connectors on cable catalog items.

Cable Design

• Implement lazy data table for cable design to prevent long load times.
• Add GUI elements for displaying cable connectors and connections.
• Add optional columns for displaying, filtering, and sorting cable connection details to list view.

Support for multiple tabs

• "Current" is now fetched from a view scope by the session controller.
• "Current" is passed around when navigating through pages.
• Back button will not cause update issues and only works when item page will result in valid result (id is included in the url).
• Multi-tab framework allows inclusion of large pages such as multi-edit to limit to one tab per user.

Controller Utilities

• Code is split into GUI session & raw functionality code (utility).
• Additional layer of common functionality between APIs and GUI
  • Improves API and GUI code reuse
  • Improves API stability
  • Removes potential "session" race condition in APIs.
  • Easier to implement complex API functions.
• All APIs now utilize only controller utilities.

Location

• Split up location into location and housing.
• Update APIs to support new location + hosing split.
• Remove location edit lock by housing in machine as it isn't relevant to the domain.
• Enhanced location menu model for selecting locations
  • Split large lists to prevent lists going off screen.
  • Widen long name location menu items to prevent location utilizing double vertical space.
• Add a "is_housed" field to item elements.
  • Allows for skipping fetching location by housing relationship. The user can keep maintaining a unique location while the item can be linked to a housing parent.
  • Useful for "planned" components in the machine.

Import/Export

• Add export facility and export wizard gui.
• Add export/transfer mechanism to generate output for import on a different CDB system (without ids).
• Add update facility.
• Add compare facility.
• Add delete facility.
• Add options tab to import wizard.
• Add options tab to export wizard.
• Add confirmation tab to export wizard with number of items to be exported.
• Improve feedback and error reporting.
• Add grouping mechanism for core metadata fields, use to add collapsible sections for field groups on item detail views and list view customization dialog in cable catalog, cable design, and cable inventory domains.
• Source domain
  • Enable export/update/compare/delete.
• Catalog domain
  • Enable export/update/compare/delete.
  • Add new spreadsheet format for adding ports (connectors) to catalog items.
• Machine domain
  • Enable export/update/compare.
  • Add mechanism for looking up machine item parent by path.
  • Add import wizard option for specifying root machine item for machine hierarchy import and template instantiation.
  • Add new spreadsheet format for export/update of machine items.
  • Add export option for specifying number of hierarchy levels to export.
  • Use displayed hierarchy of filtered items to generate list of items for export.
• Cable catalog domain
  • Enable export/update/compare/delete.
  • Add new spreadsheet format for adding connectors to existing cable catalog items.
• Cable design domain
  • Enable export/update/compare/delete.
  • Add support for import of device ports and cable connectors in cable design import.

Tests

• New test framework tests most API calls.
• Revive the Selenium GUI test framework to work on current version.
  • Add more GUI tests to at the least navigate to every page in CDB
• New test database
• Test script
  • Performs unit, selenium, and API tests.
  • Downloads relevant chromedriver for developer machine.
  • Backs up database, loads in test data, restores original data after tests.

APIs

• Ability to fetch configurable concise item lists to improve performance.
• Ability to create machine placeholders.
• Ability to move machine to a new parent.
• Ability to create catalog items.
• Ability to add elements to catalog "assembly listing".
• Ability to create inventory items.
• Required "request body" parameters added to API calls. Users will no longer be required to specify positional arguments when using the client API.

Plugin Framework

• OpenNMS integration
  • Gives user a dialog on about page with status of all services that CDB relies on.
  • Utilizes the business service feature of OpenNMS to group relevant services.
• eTraveler mass archive functionality.
  • Can be found under summary of travelers pulled up from a template summary dialog.

Other

• Jump to QRID link allows user to type a QRID and quickly jump to the item in CDB.
• Parts of administrative drop down now accessible to standard users shown as "Supplemental"
  • Location, property types, sources, and connector types.
• New roles
  • Maintainer: User that has access to updating all items and advanced features such as import but not system entities such as properties or users.
  • Advanced: User that has standard privileges but also has access to advanced features such as import.
• More counters domain items on about page
• Button to remove installed item from inventory assembly.
• Clean up unused cable functionality from old POC in inventory.
• Deprecate item element tree table (Unused admin setting) Causes performance issues on machine design domain.
• Standardize inventory row expansion to match element lists (part name, etc.). and honor sort order.
• Add more UI instruction details for how to drag catalog into machine.
• Global search QrIds
• Add configurable web.xml and set PROJECT_STATE accordingly.

Bug fixes

• Category & Type use contains string match in list pages.
• Resolve missing MAARC filters for property value.
• Apply reset to new inventory lazy data table when needed.
• Resolve issue where its possible to have repeating results on lazy data model for certain queries.
• Resolve issue with cloning "required" field when cloning elements.
• Resolve issue with "model number" showing up instead of serial number for inventory elements.
• Provide a useful error when metadata value provided is too long.
• Prevent user from attempting to save "$" character in cost field of source.
• Automatically update effective date when changing inventory status field in GUI.
• Resolve multiple location relationships issue with new inventory item issue.
• Other bug fixes

Cable import script

• Add config file facility for script options.
• Improve progress reporting.
• Modify to use openpyxl instead of xlrd for reading excel files from python.
• Streamline API usage for each domain and use batching/concurrency to improve performance for large imports.
• Create user documentation.

Patch Release v3.11.4

Machine Design

• Add property type columns.

Bug Fixes

• Resolve exporting of location string.
• Deprecate exporting PDF. Broken functionality due to outdated library.
• Resolve standard user permissions in machine design.
• Resolve update project from multi-edit screen for inventory items.
• Resolve issue with machine design inventory and standard machine design overriding their settings.

API

• Release API with packaged CLIs.

Patch Release v3.11.3

Enhancement

• Allow sequence title when creating eTravelers from multi-edit page.

Bug Fixes

• Disable reorder of items in multi edit.
• Resolve missing save all button on multi edit.