Migrate facilities data to new space definition tables

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 1 minute to read

    • To continue using the image-based floor plans with the new space definition, migrate your data from the old tables to the new space definition tables.

    Before you begin

    Role required: facilities_admin

    About this task

    The migration process only migrates complete data. A space that is not in a level or a level not in a building is not migrated. This behavior can be changed by updating the migration script include. Floors that are not connected to a building are not migrated, nor are spaces that are not part of a floor or building. As part of the migration process, the legacy spaces, floors, and buildings are marked as migrated.
    The migration path for the old tables to the new are:
    • [cmn_building] migrates to [alm_building]
    • [fpv_floor] migrates to [fm_level]
    • [fpv_element] migrates to [fm_space]

    Procedure

    1. Navigate to All > Facilities > Administration > Migrate.
    2. Click Migrate.

    Result

    The following results can be expected:
    • Data is migrated to the new facilities management tables for buildings, floors, and spaces.
    • After a building, floor, or space is migrated, it is marked as migrated, and is not able to be migrated again.
      Note:
      Any object that is marked as migrated does not get migrated again, so you can safely run through the migration process multiple times without creating duplicated objects in the space tables. This behavior can be modified in the migration script include or by resetting the migration flag on the original objects.