Skip to main content

Export and Import

You can use Longview Server Manager to export and import the data in the database tables.

Note: The database table structure is not exported or imported.

You can use the export and import utilities to perform several tasks, listed below:

Task Description

Clean up leaf data

You can use the export and import utilities to clean up:

  • data corresponding to deleted symbols
  • data corresponding to symbol indexes out of the valid range
  • non-static parent data
  • data with a value of 0.0
  • data with empty character strings

Reorganize symbol indexes

You can collapse deleted symbol gaps, and then reorganize existing symbol lists, collapse out deleted symbols, and reindex all existing data to use the new index coordinates.

Perform data transfers across platforms

The import and export utilities provide flexible data transfers by creating Longview-related binary files independent of the Longview database and server platform.

Note: When you export server data, the export files are created in the export folder of the Custom Files Location (specified in the FILES_CUSTOM_ROOT_PATH server configuration parameter) on the Longview data server and the corresponding log files are created in the logs/export folder. When you import server data the import log is created in the logs/import folder.

To access the Export/Import page, click the Export/Import tile under the Functionality section on the Longview Server Manager home page.

Import/Export page

Server Manager allows you to see all your exports, as well as the version they were exported from and the date they were created.

From the list of exports, you can open the export log file associated with the export, delete the export, or import.

Refresh Button

Click the Refresh button to refresh the export list with the exports on the Longview data server.

Exporting data from database tables

You can use Server Manager to export the data in database tables, though it does not export table structures. The export utility extracts data from the appropriate database tables, creating multiple binary files that can be stored or subsequently imported. (It does not export data from any tables whose name starts with klx_ic.)

To export data from database tables, follow these steps:

  1. Select Export at the top right. The Export dialog displays, as shown below:

    Export dialog

  2. Select from the following options:

    1. Export name: Enter the name that the export will be saved as. The export cannot be more than 64 characters long or contain characters (\ / * ? “ < > | % $) or spaces.

    2. Export all database information: Select this option to export all system, system data, and leaf data tables. This includes metadata, journal entry, batch, locking, symbol statistics, shared files, models, and intercompany tables data. Use this option to reorganize the Longview database structure and optimize performance, export system tables and leaf data for the purpose of leaf-level repartitioning, copy the database to another Longview instance, and create an exact backup of your database.

    3. Export all database information except the leaf data: Select this option to export data from main system tables in the Longview database, including metadata tables such as the dimension and symbol tables. In addition, journal entry, batch, locking, symbol statistics, shared files, models, and intercompany tables data is exported. Data from the leaf data tables is not exported. Use this option to copy the symbols and hierarchy of a database to another database, along with the additional tables.

    4. Export system information only: Select this option to export data from only the main system tables in the Longview database, including metadata tables such as the dimension and symbol tables. Data from journal entry, batch, locking, symbol statistics, shared files, models, intercompany, and leaf data tables is not exported. Use this option to copy the symbols and hierarchy of a database to another database and reorganize the Longview database structure and optimize performance when no data exists.

    5. Do not clean up deleted symbols and data: Select this option to export data from the database in its raw state without removing, re-sequencing, or reorganizing deleted symbols. Use this option to create an exact snapshot of a database at a particular moment in time.

    6. Restrict to data affected by deleted symbols: Select this option to export data from tables that would be affected by symbol re-indexing only. Use this option to reduce the number of tables to export and import. However, it is not suitable if you are using the Export utility to create a backup.

    Note: You can only select one of Do not clean up deleted symbols and data or Restrict to data affected by deleted symbols. If you do not select either option, data is exported from the database and its indexes are reordered.

  3. Click Export.

  4. A status dialog appears, showing the export is in progress.

    Note: The exporting process may take a while.

    Pop-up status dialog showing the export is in progress

  5. A toast notification displays at the top right, indicating that the export was successful. To view the export log file, click View log. The log file opens. For more information, see Log Files.

    Toast notification for successful export

Data from the tables you selected is exported to Longview-related binary files that you can either store or import back into the Longview database.

Importing data into database tables

You can use Server Manager to import data into Longview database tables. To perform this task you must have authorization to Start/Stop servers. The Import utility reads binary files created by the Export utility, and restores the appropriate database tables. Importing data can save time when duplicating a database structure from one server to another, particularly when setting up a new server.

You can use Server Manager to import a specific export from the export list. The Valid to import column shows whether an export can be imported. A green checkmark means that the export can be imported.

To import an export, complete the following steps:

  1. Navigate to the export you want to import.
  2. In the Actions column, select the ellipsis in the same row as the export and click Import.

    Note: The export selected must match the version of the Longview data servers to be able to be imported.

  3. The Import dialog displays. The Import name uses the name of the export file to import.

    Import dialog

  4. Specify the following options:
    • Force the servers to stop if users are connected: Select this option to stop the servers and disconnect any users.
    • Perform a restatement after import is completed: Select this option to force the system to run an immediate restatement (once the binary files are imported). After you select this option, you can further specify the following settings:

      When selecting Perform a recalculate after import is completed in Import dialog

      • Archive monitor file Before/After Recalculation: Specify whether to archive monitor file before or/and after the recalculation and the corresponding file names.
      • Run collect statistics after recalculation: Select this option to run the collected statistics after the recalculation.
  5. Click Import.
  6. A Confirmation dialog opens. Click Yes to continue, which will overwrite all your existing data.

    Confirmation dialog for import

  7. Longview starts importing and displays the importing process and status information.

    Import completed dialog

  8. When the import is completed, you can click the log file names at the top to view the detailed logs.

  9. Click OK to close the Import dialog.

Searching Export files

You can use the Search field to find the exports you want easily. The search filters as you type and displays only the matched exports whose names contain the input text. To clear the search, remove what you have typed from the Search box.

Search exports

Deleting export files

You can use Server Manager to delete exports from your system.

To delete one or more exports, follow these steps.

  1. Click the checkbox on the export(s) you want to delete. To delete all exports, click the checkbox on the header row of the list and all exports are selected.
  2. Click the Delete icon which appears beside Export at the top right. A confirmation dialog opens.

    Note: The delete only deletes the export files. The export log file will remain.

    Confirmation dialog for deleting exports

  3. Click Delete to delete the export(s).

You can also delete an export using the following method:

  1. Navigate to the export you want to delete.
  2. In the Actions column, select the ellipsis in the same row as the export and click Delete. A confirmation dialog opens.
  3. Click Delete to delete the export.

Viewing an export log file

You can use Server Manager to view the export log associated with an export.

To view the export log file, complete the following steps:

  1. Navigate to the export you want to view the export log file for.
  2. In the Actions column, select the ellipsis in the same row as the export and click View log.

The log file opens in a text editor. From here, you can save the file to local or network drives.

Was this article helpful?

We're sorry to hear that.