Document toolboxDocument toolbox

Release Notes



Release 2024.2 is now available; it is a major release that contains new features and refinements. 



NOTE: PHP 8.3 is supported and recommended for this upgrade.



We will begin scheduling 2024.2 updates on customer Test systems starting on November 24th, 2024.

Notable Changes

Please review the Database Changes in 2024.2 and make any necessary changes to your AdHoc Grids, Custom Events, and API calls.

Review and Refresh Session(s)

We are planning two Review and Refresh sessions for 2024.2. The first session is scheduled for December 3rd, 2024, at 11:00 AM Eastern, and the second is scheduled for December 4th, 2023, at 3:00 PM Eastern. 

Key

 

Bug Fixes

 

bugFix.png

 

New Features

 

 

addFeature.png

 

Changed Features

 

 

Improved Performance

 

 

Removed Features

 

 



Release 2024.2 (11-22-2024)



Component

Description

Type

Documentation

Component

Description

Type

Documentation

API

  • Adds an API endpoint for pulling Cable View Path Reports

  • Adds an API endpoint for rendering HTML and PDF Custom Reports.

  • Adds an API endpoint for Locations.

API

Cable API Endpoint

Locations API Endpoint

Billing

 

 

  • Adds a Configuration Option to control Invoice Link on ViewBill, allowing for Custom Report Invoices.

  • Adds a Configuration Option to hide the View Bill Full Details link.

Configuration Guide

Billing Parameters

  • Corrects a spelling mistake (Quantity) on the Invoice.

 

Catalogs

  • Adds the ability to modify Location Types for non-building Locations. The system still prevents creating a building inside of another building.

Location Catalogs

Cable

  • Fixes an issue preventing Ports/Pins/Lens (PPL) from being added to Service Desk Cabling when using Auto Assign.

  • Adds a check for Move To Location when populating the Auto Assign Location.

  • Fixes an issue that prevented the Origination, Destination Equipment, and Locations from grouping on the Cable Maintenance Grid.

  • The Card # field for Cabling Equipment is no longer hidden, regardless of status.

  • Resolves an issue where transferring a partial set of Pair/Strands unlinks the Cabling Equipment from the untransferred pairs.

  • Fixes the Pair/Strand transfer to only edit the Pair/Strand Equipment on the Pairs within the transfer range.

 

CustomerCenter

  • Expired Requests in CustomerCenter can no longer attempt to be approved. They are still viewable through the approvals grid and will be labeled as expired.

  • CustomerCenter now supports Work Requests.

  • The Approval menu item in CustomerCenter now displays the number of requests awaiting approval.

Requests

Work Orders

Approvals

  • Resolves issues with searching Call Details by Authcode in CustomerCenter.

  • Resolves issues with searching the Directory in CustomerCenter.

  • Improves error reporting in CustomerCenter.

  • Corrects an error preventing Custom Reports from rendering on CustomerCenter

 

General

  • Adds PHP 8.3 Support

  • Introduced more cell copy options in the grid context menu.

    • Right-click → Copy Row

    • Right-click → Copy Column

    • Adds the following Copy Formats for the Copy Row and Copy Column options:

      • JSON

      • CSV

      • TSV (Excel)

  • Updates the Custom Logic validation to support PHP 8 language-level features and token parsing.

  • Ending Emulation on the Users grid reloads the previous filters.

  • Custom Logic Changes

    • Adds Custom Logic functions createFile() allowing the creation of files in the Inbound or Outbound directories and arrayToCsv() to assist in generating CSV data.

    • Adds the detach and detachDb methods in Custom Logic.

    • Adds the sendSystemMessage method for use in Custom Logic. This allows Custom Logic to generate system messages for a specified contact.

    • Updates the Custom Logic ->call() method to allow for committing data immediately upon successful completion.

  • Adds a config viewer grid at Admin > Config Viewer to display the PCR-360 configuration values and descriptions.

  • Adds a Log Viewer menu item for viewing the PCR-360 error logs

    • Errors are no longer logged in the Error Log Explorer; they are now logged in a log file under logs.

    • The Log file name is specified by constants.APP_LOG_FILENAME

    • Available log files are defined by logviewer.logfile[] = PATH values in the .ini file

  • Minor rework of Addresses that resolves difficulties adding or editing Addresses.

  • Composer Changes

    • Adds required PHP Extensions to Composer config so that Composer will validate the required extensions.

    • Updated to a PHP 8.3 compatible version of the Zend framework forked from shardj/zf1-future.

    • Updated to a PHP 8.3 compatible version of the Zend framework Extras forked from shardj/zf1-extras-future.

    • Moves the MS Graph library to composer.

    • Moves the Leaque OAuth2 cleint (used by Graph) to Composer.

    • Removes GuzzleHttp from the Library. It was not added to composer as it will be included by MSGraph as a dependency.

The Grid

Users

Allowed Functions in Custom Logic

Config Viewer

Log Viewer Grid

Misc Parameters

Locations Tabs

  • Adds indexing support for Cable Maintenance, PPL, and Location grids.

Grid Toolbar

Grid Indexes

  • Removes the “Error Log Explorer” (System Log table).

 

  • Fixes the functionality and enables for saving with ctrl+s (or cmd+s for Mac) on all PCR forms.

The Data Entry Form

Imports & Exports

 

 

 

 

  • Adds Custom Reports to File Export capability.

 

  • Applies a fix to the _commit and _rollback methods of the Oracle and MySQL adapters to check for an existing transaction before trying to perform and action on it. Resolves the “PDO Exception” errors occasionally for Imports.

  • The Approval Criteria Import now supports the Tier field.

 

Inventory

  • The Units field on Equipment Forms can now be updated if the User is an Admin or has explicit form element permissions set.

  • New feature Purchase Order Pricing can default the Service Desk charge amount for Equipment in relation to the purchase price instead of the catalog default.

Equipment

Purchase Order

Purchase Order Pricing

Tenant Management

  • Resolves issues with adding Unit Equipment to a Purchase Order.

 

People

  • Allow for Contact email addresses up to 100 characters in length

 

Reports

  • Adds Import/Export functionality to Custom Report builder.

  • Adds PDF Options to Custom Report builder.

  • Revised Custom Report Attachments.

  • Custom Reports Enhancements

    • Upgraded Bootstrap from v4.0.0 to v5.1.3

    • Adds a new Bills Picker

    • Improves Error Handling

 

  • Batch Report Fixes

    • Allows Template data in the Batch Report Description.

    • Fixes rendering issues with Saved Reports on CustomerCenter.

    • Updates Saved Reports so deletion removes the file from the server.

 

Services

  • Added a MAC Address column to the Phone Services Grid.

 

Service Desk

  • Adds Service Order and Action Numbers to the Service Desk prompt when notifying users of existing Actions on a Service.

  • Service Remarks now display timestamps when viewed from a Service Desk Action.

  • Labor from Voided workflows no longer appear in the Time Entry grid

  • Prevents creating more than a single Remove or Service ID Action for a Service at a time. Returns a message when attempting to create a second Service ID Action or Remove Action on the Service.

  • The Service Desk Actions Equipment grid now includes Equipment from the Service Location and all child Locations.

  • Adds Batch Scheduling for Service Desk Items

    • Adds a feature to Schedule Completion and Finalization of Service Desk items and Child Actions (excluding Estimates) from the corresponding form.

    • Adds Service Desk change values for Complete On and Finalize On.

    • Adds an event to complete scheduled Service Desk items.

    • Adds some common issues to the validation for Service Desk completion so issues can be detected before trying to Complete.

Service Orders

Service Desk Actions

Service Desk Change Actions

Service ID Actions

Service Desk Labor

Service Desk Equipment

Time Entry

Service Desk Bulk Update

Problems

Projects

Work Order

  • Resolves issues with the Service Desk Action printout.

  • Adds logic to attempt to fix orphaned SDC data when another Action is completed for the same Service.

 

* Indicates external documentation not written by PCR.





Database Changes in 2024.2



Default Schema



Table Name

Change

Table Changes

Table Name

Change

Table Changes

ADDRESSES

Updated

alter table ADDRESSES drop index ADDRESSES_1 create unique index ADDRESSES_1 on ADDRESSES ( TENANTS_RECID, STREET_ADDRESS, ADDRESS2, CITY, STATE, ZIP_CODE, HOUSE_NUMBER, HOUSE_NUMBER_SUFFIX, PREFIX_DIRECTIONAL, STREET_NAME, STREET_SUFFIX, POST_DIRECTIONAL ); alter table ADDRESSES drop constraint ADDRESSES_1 alter table ADDRESSES add constraint ADDRESSES_1 unique ( TENANTS_RECID, STREET_ADDRESS, ADDRESS2, CITY, STATE, ZIP_CODE, HOUSE_NUMBER, HOUSE_NUMBER_SUFFIX, PREFIX_DIRECTIONAL, STREET_NAME, STREET_SUFFIX, POST_DIRECTIONAL );

API_PERMISSIONS

Updated

INSERT INTO `API_PERMISSIONS` (`TENANTS_RECID`, `MODIFIED_DATE`, `MODIFIED_BY`, `PERMISSION_NAME`) VALUES ('0', now(), 'pcr360', 'Report'); INSERT INTO `API_PERMISSIONS` (`TENANTS_RECID`, `MODIFIED_DATE`, `MODIFIED_BY`, `PERMISSION_NAME`) VALUES ('0', now(), 'pcr360', 'CableViewPath');

CONTACTS_EMAILS

Updated

ALTER TABLE `CONTACTS_EMAILS` MODIFY COLUMN `EMAIL` VARCHAR(100) NOT NULL;

EQP_CATALOG_CHARGES

Updated

alter table EQP_CATALOG_CHARGES add PO_PRICING_MARKUP_PERCENT int null; alter table EQP_CATALOG_CHARGES add PO_PRICING_MARKUP_FLATRATE int null;

EXPORT_FORMATS

Updated

ALTER TABLE `EXPORT_FORMATS` ADD `REPORTS_RECID` INT NULL;

EVENTS

Updated

GRID_INDEX

Added

CREATE TABLE `GRID_INDEX`

LISTS

Updated

PURCHASE_ORDER

Updated

REPORTS

Updated

ALTER TABLE `REPORTS` ADD `PDF_OPTIONS` LONGTEXT NULL;

REPORTS_BATCH

Updated

REPORTS_SAVED

Updated

ALTER TABLE `REPORTS_SAVED` MODIFY COLUMN `QUERY_STRING` VARCHAR(1024) NULL;

SERVICE_DESK

Updated

SERVICE_DESK_ACTIONS

Updated

SERVICE_DESK_ACTIVITY

Updated

SERVICE_DESK_EQP

Updated

TENANTS

Updated

USERS_PERSPECTIVES

Updated

Metadata Schema



Table Name

Change

Table Changes

Table Name

Change

Table Changes

SYSTEM_LOG

Removed

DROP TABLE SYSTEM_LOG;

USAGE_ADDRESS

Added

create table USAGE_ADDRESS



Archive Schema



Table Name

Change

Table Changes

Table Name

Change

Table Changes

No changes


Supported Versions

Related pages