Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »


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

 Click here to expand...

Bug Fixes

bugFix.png

New Features

addFeature.png

Changed Features

changeFeature.png

Improved Performance

monitor_lightning.jpg

Removed Features

delFeature.png


Release 2024.2 (11-22-2024)


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.

addFeature.png

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.

addFeature.png

Configuration Guide

Billing Parameters

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

bugFix.png

Catalogs

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

addFeature.png

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.

bugFix.png

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.

addFeature.png

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

bugFix.png

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.

addFeature.png

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.

addFeature.pngmonitor_lightning.jpg

Grid Toolbar

Grid Indexes

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

delFeature.png

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

bugFix.png

The Data Entry Form

Imports & Exports

  • Adds Custom Reports to File Export capability.

addFeature.png

  • 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.

bugFix.png

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.

addFeature.png

Equipment

Purchase Order

Purchase Order Pricing

Tenant Management

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

bugFix.png

People

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

addFeature.png

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

addFeature.png

  • 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.

bugFix.png

Services

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

addFeature.png

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.

addFeature.png

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.

bugFix.png

* Indicates external documentation not written by PCR.



Database Changes in 2024.2


Default Schema


Table Name

Change

Table Changes

ADDRESSES

Updated

 Address Changes
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

INSERT INTO EVENTS
(TENANTS_RECID, MODIFIED_DATE, MODIFIED_BY, BROADCAST_BY, EVENT, LISTENER_CLASS, LISTENER_METHOD, OCCURRED_DATE, STATUS,
 ATTEMPTS, FREQUENCY, NEXT_RUN_DATE, PROCESS_LOCKED)
VALUES (0, NOW(), 'system', 'pcr360-cli', 'sd-scheduled', 'Servicedesk_Model_ServiceDesk', 'eventScheduled', NOW(),
        'PENDING', '0', 'Every 5 Minutes', NOW(), '0');

GRID_INDEX

Added

CREATE TABLE `GRID_INDEX`

LISTS

Updated

INSERT INTO LISTS
(TENANTS_RECID, STATUS, MODIFIED_DATE, MODIFIED_BY, LIST_TYPES_RECID, CODE, LISTS_ORDER, VALUE, DESCRIPTION, SYSTEM_USE)
VALUES (0, 1, NOW(), 'system', @list_types_recid, 'COMPLETE_ON', 9, 'Complete On',
        'Service Desk Item or Action scheduled for completion', 1),
       (0, 1, NOW(), 'system', @list_types_recid, 'FINALIZE_ON', 10, 'Finalize On',
        'Service Desk Item or Action scheduled for finalization', 1);

PURCHASE_ORDER

Updated

alter table PURCHASE_ORDER
    add SERVICE_DESK_RECID int null;

alter table PURCHASE_ORDER
    add constraint PURCHASE_ORDER_5_FK
        foreign key (SERVICE_DESK_RECID) references SERVICE_DESK (RECID);

REPORTS

Updated

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

REPORTS_BATCH

Updated

ALTER TABLE `REPORTS_BATCH` MODIFY COLUMN `EVENTS_RECID` INT NULL;
ALTER TABLE `REPORTS_BATCH` ADD `SQL` LONGTEXT NOT NULL;
ALTER TABLE `REPORTS_BATCH` ADD `NOTIFICATION_SUBJECT` VARCHAR(200) NULL;
ALTER TABLE `REPORTS_BATCH` ADD `NOTIFICATION_MESSAGE` LONGTEXT NULL;
ALTER TABLE `REPORTS_BATCH` ADD `NOTIFICATION_ATTACH` TINYINT(1) DEFAULT 0 NOT NULL;

REPORTS_SAVED

Updated

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

SERVICE_DESK

Updated

ALTER TABLE `SERVICE_DESK` ADD `COMPLETE_ON_DATE` DATETIME  NULL;
ALTER TABLE `SERVICE_DESK` ADD `FINALIZE_ON_DATE` DATETIME  NULL;

SERVICE_DESK_ACTIONS

Updated

ALTER TABLE `SERVICE_DESK_ACTIONS` ADD `COMPLETE_ON_DATE` DATETIME  NULL;
ALTER TABLE `SERVICE_DESK_ACTIONS` ADD `FINALIZE_ON_DATE` DATETIME  NULL;

SERVICE_DESK_ACTIVITY

Updated

alter table SERVICE_DESK_ACTIVITY
    add SERVICE_REMARK_DATE datetime null;

SERVICE_DESK_EQP

Updated

alter table SERVICE_DESK_EQP
    add PURCHASE_ORDER_RECID int null;

alter table SERVICE_DESK_EQP
    add constraint SERVICE_DESK_EQP_10_FK
        foreign key (PURCHASE_ORDER_RECID) references PURCHASE_ORDER (RECID);

TENANTS

Updated

alter table TENANTS
    add PO_PRICING_CONFIGURATION varchar(50) null;

alter table TENANTS
    add PO_PRICING_MARKUP_PERCENT int null;

alter table TENANTS
    add PO_PRICING_MARKUP_FLATRATE int null;

USERS_PERSPECTIVES

Updated

UPDATE USERS_PERSPECTIVES
SET IDENTIFIER = 'Application_Grid_Location_Default,default'
WHERE IDENTIFIER = 'Application_Grid_Location_Location,default';

UPDATE USERS_PERSPECTIVES
SET IDENTIFIER = 'Cabling_Grid_CableMain,default'
WHERE IDENTIFIER = 'Cabling_Grid_Cable,default';

Metadata Schema


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

No changes


Supported Versions

PCR will patch the last two versions of the application and the current LTS Release. Customers will continue to receive Help Desk Support for releases outside of the support period for a given release.  Bug fixes are only released for versions that are actively supported.

Key

Active support

A release that is actively supported.

Critical Fixes Only

A release that is supported for critical security issues only. Releases are only made on an as-needed basis.

End of life

A release that is no longer supported and will not receive bug fixes. Customers using one of these releases should upgrade as soon as possible.


Version History


 Release Types


LTS Release

An LTS Release is a Major Release that PCR will support for at least 12+ months. All other releases are supported for two release cycles. LTS Releases will be patched (as a hotfix) for any Critical or High-Impact bugs applied after a release. These include (but are not limited to): service-impacting issues, billing issues, or charge-related bugs. These issues have no workaround, or the workaround is cumbersome. LTS Releases are intended to relieve “Upgrade Fatigue” for Customers who may not need all of the latest features but need critical bugs fixed. Once the LTS time period has elapsed, PCR will work with customers to move them to the next LTS release.
Once an LTS reaches the last few months of support, it will receive only critical fixes and security patches.

Major Release

Major releases consist of new features and some bug fixes. These features have a relatively large scope with a greater impact on development and testing, e.g. Accounts Receivable, Service Desk Archiving, Work Order, etc.

Minor Release

Minor releases consist mostly of bug fixes and occasionally minor enhancements to the application. Minor enhancements are relatively small changes with a low impact on development and testing, e.g. adding a column to a grid, a new field, or tweaking the API. The specification process will occur in at least the month prior to being assigned.

The specification process will occur in tandem with the traditional development and testing cycle.



Version

Release Type

Release Date

Support Ends

2024.2

LTS

2024.1

Major

  

Critical fixes only until 2025.1 is released

2023.1

Major

  

 

2022.2

Minor

 

 

2022.1

LTS

 

24 months+


Archived Releases No Longer Supported

 Click here to expand...


Version

Release Type

Release Date

Support Ends

Release Notes

2021.3

Minor

 

 

https://pcr360.atlassian.net/wiki/x/zo8QAQ

2021.2

Minor

 

 

https://pcr360.atlassian.net/wiki/x/eY8QAQ

2021.1

LTS

 

 

https://pcr360.atlassian.net/wiki/x/Yo8QAQ

2020.4

Major

 

 

https://pcr360.atlassian.net/wiki/x/A48QAQ

2020.3

Major

 

 

https://pcr360.atlassian.net/wiki/x/g44QAQ

2020.2

Minor

 

 

https://pcr360.atlassian.net/wiki/x/lQYRAQ

2020.1

Major

 

 

https://pcr360.atlassian.net/wiki/x/FI0QAQ

2019.7

LTS

 

 

https://pcr360.atlassian.net/wiki/x/v4sQAQ

2019.6

Minor

 

 

https://pcr360.atlassian.net/wiki/x/DeAQAQ

2019.5

Minor

 

 

https://pcr360.atlassian.net/wiki/x/FosQAQ

2019.4

Major

 

 

https://pcr360.atlassian.net/wiki/x/qIoQAQ

2019.3

Minor

 

 

https://pcr360.atlassian.net/wiki/x/wNUQAQ

2019.2

Minor

 

 

https://pcr360.atlassian.net/wiki/x/DeAQAQ

2019.1

Major

 

 

https://pcr360.atlassian.net/wiki/x/DeAQAQ

2018.1

Major

 

 

https://pcr360.atlassian.net/wiki/x/DeAQAQ

2.1.4.7

Minor

 

 

https://forums.pcr.com/t/release-notes-2-1-4-7-2018-10-09/526


  • No labels