Metadata Export

The export creates a flat file containing the metadata in XML format. This file can be moved between different platforms and different instances of ExtraView. The order of objects in the file is defined by the requirements of ExtraView, not by the user. The data export is defined satisfying the requirements of being able to perform an import of the data, to build new objects. In short, all dependent data must follow the data upon which it is dependent.

There are a wide range of options, allowing you to perform exports of all or subsections of the metadata within an ExtraView installation.

Each option that defines a subset of the database is termed a family. This option is available from the Import/Export tab of administration.

Note: If you are using ExtraView with the Apache Derby database, the metadata export feature is significantly limited. You may only perform a metadata export of the complete database, and cannot use the features described below to constrain the export to small parts of the database.

Exporting ExtraView Families

The following are the metadata families that may be exported. Note that any filters you set will also apply to the export file you create:

  • Export all metadata - a complete export is created of all the metadata
  • Export all metadata tables except reports - a complete export less the reports within the source system is created. Your target production system may have reports which differ from your source system, and you may not want to touch the reports on the production system
  • Export layouts and supporting information - this will provide the layouts within the filters you apply, along with all supporting information such as the data dictionary fields
  • Export reports and associated data - this option only exports the reports and their supporting information, such as the fields in the source system
  • Export business rules - only the business rules in the souce system will be exported
  • Export user profile information- only the user information in the source system will be exported
  • Export text messages - this will export all the message tables for all languages. You can use this to then import a new language set into a target system
  • Export a solution - this option allows the preparation of an export file which will be used to migrate an ExtraView solution to one or more remote systems. The option minimizes information outside of your solution from the source database. What will be exported is confined to the following:
    • Only the layouts within the source system that are within the Business Area(s) you select as filters. Layouts in the global area will not be exported
    • Only the fields and their permissions that are used by layouts within the source system will be exported
    • Allowed values for any fields within the layouts will be exported
    • Relationships used by the layouts will be exported
    • Only reports within any folders you select will be exported

If you click the option Minimize the user information exported, then only the essential user information to export the metadata is written to the export file. This may solve a number of issues. For example, user information is often dynamic, and users may frequently change passwords, or administrators may activate and deactivate accounts on a production system or the references to the user information must always be taken from an LDAP or Active Directory server. While you may want the metadata from a development system to be migrated to a production system, you often may want to leave the production data related to users in place.

You may choose some overriding filters for the export. As opposed to exporting the data across all Business Areas and Projects, you may select a single Business Area and Project to export. You may also choose to only export data updated since a specific date and time.

Once you have set up an export profile, you may decide to save the combination for future use. This is accomplished through the Load / Manage Export Profiles button on the menu bar. This will display a popup as follows:

You may create new profiles and save them, load an existing template, replace an existing template or delete an existing template from the popup window. Once you have set up the profile to export, click the Continue with Export button. You are taken to a screen similar to this:

Continuing with the metadata export process

Confirm your choices on this screen, before clicking the Perform Export button.

You will be prompted to enter a file name for the export. This file will be saved on your local file system of your client computer.

An export can take some time, based upon the amount of metadata in your system. Files generated vary in size from a few to more than 50MB in size, dependent on the amount of metadata. As the export starts, one of the first steps is to compare the database against a known reference set of data that describes what the database should look like. In a perfect world, this step would not be needed, but databases can accumulate defects caused by any one of a number of factors. A previous update script might have failed, but the error not being noticed by the administrator; there might have been an incorrect command executed by a database administrator. There are other potential sources of failure as well. The metadata export process examines the database to ascertain if there is any obvious problem that will interfere with the process. The most typical problem encountered is that there is a missing database constraint. When a problem such as this is found, you will see an alert message warning of the event. You will be able to elect to continue, or to stop the process. It is recommended that you do not continue if you are not sure of the ramifications of the error.

An export file can be imported into the same or a different instance of ExtraView. The file can also be used to integrate with other applications.

Items that are Not Exported

There are a number of behavior settings that are not exported with this utility.  This is deliberate, as it is most likely that these settings are specific to the target environment and may be different from those in the source environment.  The list of settings that are not migrated is:

  • APP_HOME
  • CSS_HOME
  • DEBUG_MODE
  • DEFAULT_LANGUAGE
  • DEFAULT_REGION
  • DEFAULT_VARIANT
  • EMAIL_DIRECTORY
  • HELP_HOME
  • HTTP_CHARSET
  • IMG_HOME
  • LOG_DIR
  • NOSPILL_SESSION_COUNT
  • SCHEMA_VERSION
  • SITE_URL
  • URL_PATH
  • USER_ACCEPTS_LICENSE