Exporting Server Objects
Exporting server metadata is a process that transfers database server objects to external locations. This section explains how to export existing server objects to a file.
Metadata about the following item types can be exported to simple text files:
- attributes
- attribute values
- groups
- group authorizations
- group symbol access
- journal entry sub-categories
- server rules
- schedules
- symbols
- symbol access roles
- users
- user authorizations
- user symbol access
Note: Users cannot be exported for systems that are on the ISW platform.
For each type of item, the following definitions and properties can be exported to files:
- Items (the name of the item and its principal parameters)
- Descriptions (the descriptions applied to the item, and its language designation)
- Group memberships (the name of the group and the names of all users that belong to that group; this is only available when exporting information on users or groups)
- Parent-child relationships (the parent symbol of the item, if it is a child or leaf symbol; this is available only when exporting information on symbols).
Exporting server objects to files
To export server object information, complete the following steps:
- Open Longview Application Administrator.
- Select File > Export. The Export dialog opens, as shown below:
- Select the item type you want to export and click Next.
- If you selected Attribute Values as the item type, complete these steps; otherwise, continue to the next step:
- Select one of the following attribute value type export options:
Export all attribute values: Exports all attribute values in the system.
Export attribute values for: Exports only attribute values of the selected class. If you use this option, you must select a class in the drop-down list.
- Click Next. The file locations dialog opens.
- Continue to step 6.
- Select one of the following attribute value type export options:
- If you selected Symbol as the item type, complete these steps; otherwise, continue to the next step:
- Select the dimension that contains the symbols to export; otherwise continue to the next step.
- Click Next. The file locations dialog opens.
- Continue to the next step.
-
In the Item File area, type a folder location for the Item file along with the file name and extension (.txt) to which to save it. For example:
C:\Users\Me\ExportFiles\AttributesExport.txt.
- Depending on the type of file you are importing, complete the following fields, as necessary:
Description file (optional): To export descriptions, select Include descriptions. For Description file Location, type a folder location for the description file along with the file name and extension (.txt) to which to save it. For example:
C:\Users\Me\ExportFiles\SymbolDescriptionsExport.txt
. This field applies to Attributes Schedules, Symbols, and Symbol Access Roles.Group membership file (optional): To export group membership information, select Include group memberships. For Group membership file Location, type a folder location for the membership file along with the file name and extension (.txt) to which to save it. For example,
C:\Users\Me\ExportFiles\UserMembership.txt.
. This field applies to Users and Groups.Parent-child file (optional): Optionally, select Include parent-child relationships. For Parent-child file Location, type a folder location for the membership file along with the file name and extension (.txt) to which to save it. For example:
C:\Users\Me\ExportFiles\SymbolRelationships.txt
. This field applies to Symbols.
- Click Finish. An Export Summary dialog opens.
- Review the summary and click Close.
Understanding export file syntax
Export files are in the same format as the related import files. For more information, see Importing Server Objects.