CAIRS VERSION 4.0.14.23.317
FEATURES/REFINEMENTS
System Admin
- FEATURE – Added a CES process to test All Global Reports to see successes and failures
Subscribers
- FEATURE – Removed the 6-character minimum username length requirement
Entire System
- REFINEMENT – Adjusted how error messages are displayed to account for the Show Technical Details system setting
Global Reports
- REFINEMENT – Several refinements were made including adding a custom data source, adding an empty selection to clear a selected format, ability to adjust the initial column size, etc.
Accounting
- REFINEMENT – Dynamic Billing – Equipment & Service and Levy charges are now rounded in advance
- REFINEMENT – Dynamic Billing – Prorated charges are now included in the Equipment and Services portion of a bill
KNOWN ISSUES AND WORK AROUNDS
CONFIGURED ITEMS > CISCO: This known issue occurs in Version 21.204 r 4 and below. The ‘Remove Deleted Cisco Phones’ and ‘Remove Deleted CTI Phones’ button do not work.
Work Around – In order to delete all Standard Sets that are marked as “Removed” in the switch, the user needs to manually delete each one-by-one. Or, we could provide a SQL script to remove these as needed.
_____________________________________________________________________________________
ORDERS/TROUBLES > ORDERS > ALL ACTIVE ORDERS: In Dynamic, when creating a Work Order for EWSD set, the EWSD Set button disappears from the Data Components Ribbon Group if the user clicks the ‘Create Work Order’ before adding EWSD set.
Work Around – To avoid this, an EWSD component must be added before creating the work order.
_____________________________________________________________________________________
WORK FLOW: Adding more than 50 custom fields to a work flow will generate an error in CAIRS. Programming is assigned to work a fix for this restriction.
Work Around: Do not use more than 50 custom fields in work flows until the restriction is fixed.
_____________________________________________________________________________________
VIEWING CAIRS AND MONITOR DISPLAYS: If you are attempting to expand columns in CAIRS and are doing so while viewing CAIRS from a monitor that is not your primary desktop/laptop screen then the expand will not work and instead the column will minimalize to where it almost seems hidden.
Work Around: This is not a CAIRS issue but rather a Windows issue that can’t be fixed through programming in CAIRS. The Work Around is: if you are working in any form or display with columns that can be adjusted move the view to the monitor associated to your desktop/laptop and you will be able to make all necessary adjustments to columns size and placement.
_____________________________________________________________________________________
CONFIGURED ITEMS-DATA FILL: When the pane is in edit mode the data fill option is NOT available.
Work Around: To get out of edit mode click on the scroll bar, any labels, the window header or somewhere else that isn’t an editable cell.
GOOD TO KNOW
ACCOUNT CODE BULK CHANGE: If you are using Dynamic Billing in CAIRS then you will no longer have the ability to bulk change Account Codes as Customer Codes are now being used as the billing master code.
GENERAL WORK ORDERS: CLOSING ALL SERVICE REQUESTS: Until all Sub-Service Requests/Sub-Work Orders associated to a General Work Order are in a Completed or Cancelled status the General Work Order will not complete and close automatically.
CONFIGURATION PACKAGES: When adding a Configuration Package, fields should never be duplicated within a package. For example, if you choose to add an Organization field (or any other field) twice, when the general order is opened in
EXPORTING WORK ORDER AND TROUBLE TICKET DETAILS TO .TXT: When exporting Work Order and Trouble Ticket details to .txt, you will be required to name the file and save it to a location on your computer. The .txt file does not auto-name the file like exports to PDF and Excel.
ACCOUNTING: OFFICIAL ACCOUNTS: CUSTOMER CODE: When opening a Customer Code using the “Account Funding View” you must open the record first and then click the “Show All” option in the Funding pane to populate the associated data.
BASIC VIEW: Basic View has been added to most application modules in CAIRS. This view should be used only if you are looking for a quick list of all of the items in a specific menu option. For example: Go to Configured Items>Set Management>Configured Sets>Views: Basic View and do a Show All query. You will get a list of every telephone number in the data base. This view was added to help several customers who just needed the identifying number or name of an item quickly. To avoid getting into this view choose a different view in that application module and do a Show All. Once you do that CAIRS remembers where you were last and when you open that application the new view (other than Basic) becomes your default view.
Release Test Plan
A formal release test plan is used to guide QA engineers through the entire CAIRS software. The test plan provides a measurable and consistent series of test cases. Each test case contains detailed test steps to reach an end result.
Testing Breakdown: Release 4.0.14.23.212 – 23.317
Completed Formal Tests: 7,500 +
Release 4.0.14.22.104 Fixed Trouble Tickets/Bugs
| Version | Title | Work Item Type | Release Note |
| 310 | Match with Previous Field Search in GR not working | Bug | Match with Previous Field search will now compare properly with the field before it. Field preceding field with Match with Previous Field search must not have any value in the search. |
| 310 | Create setting to allow edit of Default Metadata | Task | System Setting “Enable Edit Default Metadata” added for CAIRS7 |
| 310 | Vendor Media Import cost from file being ignored | Bug | Charges from Vendor imports are assigned from file that is imported. Instead of pulling default pricing from the equipment or service in CAIRS. |
| 310 | Global Report. Using < or > on Search.SpecialSearch.DateKey.Today broken | Bug | < and > operators fixed for Global Reports using the special Today parameter on a Date field. |
| 310 | Site level errors when creating name | Bug | CAIRS7 to validate Byte fields for acceptable values after edit. |
| 310 | Open Record Management and lock record notification | Task | Added logic so that the record will only unlock if the user that locked it closes the record. |
| 310 | Subscribers – Removed arbitrary 6 character minimum user name length requirement. | Task | Subscribers – Removed arbitrary 6 character minimum user name length requirement. |
| 310 | Global Report – Current User search (and other bug fix) | Task | Added a “Current User” search for text fields that will search for the currently logged in user. This allows reports like “Orders created by me” to be created in the report builder. |
| 310 | Advanced Search was positioned and sized incorrectly | Task | Advanced Search was positioned and sized incorrectly |
| 310 | Global Reports – Need a way to test all global reports in the system. | Task | Added a CES process to test all global reports. The tests bug how many failed and succeeded, and log other metrics, which can be reported on in the system admin metadata menu by building a report. |
| 310 | Need a way to show account status close date without using a view | Task | Added a calculated field for “close date” in Account Status Management table that only shows a close date when the account status is actually closed. |
| 310 | More Global Reporting Improvements | Task | Fixed concatenation of fields with functions. Also added Month Name and Month Abbv functions. Added an option to track performance metrics on global reports that are run, which are turned on with the new system setting, “Capture Performance Metrics”. |
| 310 | Menus for rejected records have no tables defined for global reports | Task | Added table references for menus for viewing rejected records so those tables can be available for building global reports. |
| 310 | Fix progress indicator for db creator repairs | Task | The dbcreator does not show progress messages for the rename tables and fields conversion, which can take a long time, and was not showing progress updates for conversions that previously showed progress. |
| 311 | Multiple Global Reports have a view as default Primary Report Source | Bug | Various sections in Global Reports now have Primary report sources that are not views. |
| 311 | New Meta FieldDefinition properties needed to track Location specific fields for NENA 911 | Task | Columns in CAIRS.net will now display the dagger mark to signify fields that are relevant for NENA 911 data. |
| 311 | Open Record Management and lock record notification | Task | Added logic so that the record will only unlock if the user that locked it closes the record. |
| 311 | Global Reports – “Maximum Number of Rows (in current group)” cannot be cleared | Task | Global Reports – “Maximum Number of Rows (in current group)” could not be cleared out once a value was entered. This setting can be found in the report builder on the Sort tab under the sort field selection grid. |
| 311 | Global Report – Functions for null or not null values | Task | In cairs.net there are now functions that report true, false, 0 or 1 for values that are null or not null. This is useful when you need a report that shows a checkbox for a null or not null value, and in the case of the functions that return 1 or 0, to get a sum of null or not null values. Note that the SUM of all not null in this case would be the same as a COUNT aggregate but may offer more flexibility if other math is needed. |
| 311 | Global Report – Missing Relationships between tables | Task | Added Missing Relationships between tables in global reports: Added relationship between call type and call record. |
| 311 | Global Report – Data does not load for child band when parent has combined field | Task | Fixed issue with expanding child tree levels when the parent has a concatenate or other combine option. |
| 311 | Global Reporting – Show numbers with no active calls | Task | Global Reporting – Accounting > Calls > Active Calls: Added Number Plan Listing and Standard Directory to the allowed primary data source list. This allows for reports like the last call report, which can show numbers that have not received any calls. |
| 311 | Global Reports – Null values with math expressions in Combine Options | Task | Replaced null values in Global Report data so that null values with math expressions (Add Next, Subtract, Multiply, and Divide) in Combine Options no longer result in a null value in the report data. |
| 311 | Subscribers – Removed arbitrary 6 character minimum user name length requirement. | Task | Subscribers – Removed arbitrary 6 character minimum user name length requirement. |
| 312 | Multiple Global Reports have a view as default Primary Report Source | Bug | Various sections in Global Reports now have Primary report sources that are not views. |
| 312 | Nullable object must have a value error in Fiscal Year | Bug | Fixed an issue when trying to create a new Fiscal Year record. |
| 312 | Exporting report contents to xlxs fails | Bug | Fixed an issue that prevented the export of report data. |
| 312 | Editing an action dropdown results in error | Bug | Fixed an issue when trying to undo a change from a specific type of dropdown through the History view. |
| 312 | System Settings – Users should not be able to add or delete records from this menu | Bug | System Settings – Users can no longer add or delete records from this menu. |
| 312 | Dynamic Billing – Removed BillingPeriodImportedCalls table and related views. | Task | Removed BillingPeriodImportedCalls and all related views. This table is obsolete and does not contain any records. |
| 312 | Global Reporting – Updated Internal Search | Task | The internal way that data is searched from a global report has been changed when a user performs a search. This should have no noticeable effect in cairs.net, but allows for better integration with C7. |
| 312 | Global Reports – “Maximum Number of Rows (in current group)” cannot be cleared | Task | Global Reports – “Maximum Number of Rows (in current group)” could not be cleared out once a value was entered. This setting can be found in the report builder on the Sort tab under the sort field selection grid. |
| 312 | Server Errors not showing | Bug | Bug fix where certain conditions would hide the underlying server error |
| 312 | AvayaRegistration sync bug | Bug | AvayaRegistration sync now only includes primary registration records. Bug fix with AvayaRegistration sync failing after the first run. |
| 312 | Error when deleting any records | Bug | DBcreator no longer adds UK keys on archive db’s. It also removes table constraints other than the primary key on these dbs if found |
| 315 | 911 Site info should come from associated building not associated configured set | Bug | Fixed bug where some 911 data was using the Site information from the the set record instead of the building record. |
| 315 | Create or reuse CAIRS tables for ServiceNow Integration | Task | CAIRS tables for ServiceNow created |
| 315 | Create CAIRS Menu UI for ServiceNow Integration | Task | CAIRS Menu Item for ServiceNow |
| 315 | Create CES Process Placeholder for ServiceNow Integration | Task | CES Service Item placeholder for ServiceNowInterface created. |
| 315 | Dynamic Billing – Include Account in dropdown and in customer accounting editor. | Task | Dynamic Billing – Include Account in dropdown and in customer accounting editor. |
| 315 | Missing scrollbar for collapsed view of global report list | Task | The global report list did not show a scrollbar in the collapsed view of the global report list. |
| 317 | The Duration totals are not exporting in billing files for calls. | Bug | Created new function to replace a malfunctioning Microsoft string function to properly calculate duration totals on Billing Reports |
| 317 | Vendor Invoice Currency Not Applying Applicable Budget Rate | Bug | Most current valid exchange rate is returned instead of the first found. |
| 317 | 911 Site info should come from associated building not associated configured set | Bug | Fixed bug where some 911 data was using the Site information from the the set record instead of the building record. |
| 317 | Pending Unofficial Account status changes not updating. | Bug | Changed error msg on Account status update failure to notify user how to fix the status on accounts that failed. |
| 317 | Column Reordering is not saving | Bug | Fixed an issue with ordering report fields. |
| 317 | User privs cache does not get updated | Bug | Fixed an issue where a user will get authorized, but the server keeps using their cached unauthorized privileges, |
| 317 | Dynamic Billing – E/S and Levy charges need to be rounded in advance | Task | Dynamic Billing – E/S and Levy charges needed to be rounded in advance. Dynamic billing usually rounds when aggregating the data due to fractional charges from vendors, but equipment/service and levy charges all need to be in whole cent amounts. These values now use the default rounding settings, including “Digits to Round After Decimal” and “Always Round Last Digit Up”. For customers that do not want these values rounded, those system settings can be adjusted to match the desired rounding or rounding can be blank for no rounding. |
| 317 | Global Reporting – When adding columns with SUM or AVG, if any of the values are empty, the total is also empty. | Bug | Global Reporting – Fixed an issue when adding columns with SUM or AVG. If any of the values are empty, the total is now the total value of all non-empty columns instead of being empty. |
| 317 | Prorated charges not included in Equipment Service Dynamic Bill | Bug | Prorated charges were not included in Equipment Service Dynamic Bill. This is fixed, as well as an issue related to quantity not being factored into total cost, and Equipment_or_Service_ID not being constrained as unique in the schema. |
| 317 | Call Pricing is Broken | Task | Call pricing is fixed. This fix involved improved handling of record locks to prevent deadlocks while pricing calls and performing other call-related actions at the same time. |
| 317 | When a configured set primary button is linked to multiple call pickup groups a constraint error occurs when opening the set. | Task | In configured sets, if the primary set button was associated with multiple call pickup groups, it resulted in the main record being duplicated in the view. The system allowed the primary set button to be assigned to multiple call pickup groups. Since the view references that table, the duplicated set main record led to the constraint error. The view has been adjusted to only load the first call pickup group member associated with the primary set button. This change ensures there’s no duplication in the view, thus preventing the constraint error. |
| 317 | Global Reports are not being exported/generated as files on the schedule setup. | Task | The Custom Report Distribution CES process will now continue to the next report if a report fails to generate. In Diagnostic mode, this process now provides a detailed log entry for each report, either explaining why the report did not generate, or indicating that the report was generated. Fixed various issues that prevented some reports from generating on the server or running correctly in the client. Added Record ID to client export for Excel and Tab-Delimited Text files, if checked in the distribution tab for that global report. Tab-delimited text files should now always include the heading in the cairs.net client export. |
| 317 | Dynamic Billing – Expected Charge Summary sometimes not showing results in SP for some customers | Bug | Dynamic Billing – Expected Charge Summary was sometimes not showing results in SP for some customers because accounts are not assigned a fiscal year at those locations. This issue has been fixed with a view change that still allows fiscal year to properly filter when it is assigned to accounts. |
| 317 | Global Report Editor – Copy Report Button broken | Bug | Global Report Editor – Coping a global report from the menu resulted in an error for most reports. This is fixed. |
| 317 | Global Report Search – Match with Previous Field Search type not always working | Bug | In a global report, when Match with Previous Field search type is used, the previous field was also being searched with a separate search that would sometimes prevent results from being found or cause incorrect results. This issue affects search in C7 and cairs.net. |
| 317 | Dynamic Billing – Include Account in dropdown and in customer accounting editor. | Task | Dynamic Billing – Include Account in dropdown and in customer accounting editor. |
| 317 | Missing scrollbar for collapsed view of global report list | Task | The global report list did not show a scrollbar in the collapsed view of the global report list. |
| 317 | Add index to SwitchRequest table | Task | Added an index for Status to the SwitchRequest that also includes the request date. |
| 317 | Export Metadata grouped and into individual files | Task | Exporting metadata into separate files. The action is in cairs.net, under the “System Admin > System Settings > Settings” menu, and is called “Group and Export Metadata” Completed initial export, with various grouping options. Package configuration files are also being exported under the combined export. There is also a PackageList folder that includes the possible metadata packages. Added an option to associate global reports to a package in cairs.net. |
| 317 | Fields in global report did not rename when dbcreator ran | Bug | -Fixed bug that was causing report metadata not to update with schema changes during db update -When report fails to load, it now does an update of the metadata based on schema name changes and saves the updated report as necessary |