Skip to main content

Building Codes with Multiple Locations

A previously released version of EX allowed the same Building Code to be used on multiple buildings (Room Master window) when the code should represent only one building. This issue was resolved in the 7.1 release, but the incorrect data remains and impacts J1 Web system performance. It also means buildings and rooms associated with duplicated codes were not synchronized to J1 Web Facilities.

To Resolve the Issue

Note

This issue only impacts clients that had EX version 7.1 or earlier installed.

  1. Run the Jenzabar-provided query to identify buildings using overlapping building codes.

    WITH distBldg (BLDG_CDE, LOC_CDE) AS
       (
       SELECT DISTINCT BLDG_CDE, LOC_CDE
         FROM ROOM_MASTER
       ),
       dupBldg (BLDG_CDE) AS
       (
       SELECT BLDG_CDE
         FROM distBldg
        GROUP BY BLDG_CDE
        HAVING COUNT(*) > 1
       )
SELECT rm.BLDG_CDE, rm.LOC_CDE
  FROM distBldg rm
  JOIN dupBldg d ON rm.BLDG_CDE = d.BLDG_CDE;
go

  2. Create separate Building Codes for each location.

  3. Update the Room Master data to use the correct building codes manually or using Jenzabar-provided stored procedures.

  4. Ensure your school has installed the 7.1 release. The 7.1 DSU converts the corrected rows into Facilities using the corrected Building\Room Master data, if possible.

    To manually convert this data, execute the following stored procedures in the exact order shown:

    Warning

    For a successful conversion, both must be executed in the specified order.

    EXEC EXi_CONVERT_BUILDING_MASTER;
EXEC EXi_CONVERT_ROOM_MASTER;
go