How to Add your Own Application

You may have your own Archibus domain that you wish to add to the standard Archibus schema. To do this you will follow this basic procedure, whose steps are detailed below.

  1. Update the data dictionary tables with your table and field definitions using the Database Update Wizard.
  2. Update the physical tables using the Schema Change Wizard.
  3. Transfer the project data into the new project using the Database Update Wizard.

Step 1: Update the Data Dictionary

  1. Sign into the project that contains the new tables and fields (Project A).
  2. Run the Database Update Wizard as follows to create the export files afm_tbls.csv and afm_flds.csv for the schema that contains the new tables and fields.
    • Transfer Type = Transfer Out
    • Specify Tables = Data Dictionary Tables
    • Start Transfer
  3. Sign out of Project A.
  4. Sign into the project where you want to add the new table (Project B).
  5. Run the Database Update Wizard as follows:
    • Transfer Type=Transfer In
    • Select: personalized-database
    • Select: Next
    • Specify Tables = Data Dictionary Tables
    • Select: Next
    • Select "Start Compare"
  6. In the Multiple Selection panel, select "Table is new" and "Field is New then click on Filter .
  7. In the Apply Chosen panel, select "Apply Selected"
  8. Select Apply Chosen to implement the changes.

Step 2: Update the SQL Tables

  1. Make sure you are signed into Project B.
  2. Run the Schema Change Wizard as follows:
    • You can decide if you want to execute the changes immediately or save them to a SQL script.
    • Since these are new tables, the option to re-create or alter tables has the same effect.
    • For the tables to update, select "All tables with changes in the data dictionary made by the Database Update Wizard."
    • Select Next to begin generating the changes.
  3. If you chose to save the changes to a SQL script, run the script against the Project B database.

Step 3: Transfer the Project Data

  1. Sign into the project that contains the new tables and fields (Project A).
  2. Run the Database Update Wizard as follows to create the project data export files for the new tables.
    • Transfer Type = Transfer Out
    • Specify Tables = Named Tables -- enter the table names to be exported

    • Start Transfer

  3. Sign into the project where the data base structure was just updated (Project B).

  4. Run the Database Update Wizard as follows to import the project data to the new tables.
    • Transfer Type = Transfer In
    • Specify Tables = Named Tables -- enter the table names to be imported
    • Start Transfer