Exporting data

Starting in IBM® Maximo® Application Suite 9.1, you can export or download data to an external file system for backup or importing to another Maximo Application Suite instance. For example, to view or edit user profiles, export user data to a file such as a .csv file.

About this task

You can download up to 60 thousand rows at a time. To decrease the number of rows, apply filters to the table. If you need to export data that exceeds 60 thousand rows, you can export data by using Maximo integration framework. For more information, see Integrating data with external applications or Exporting and importing file-based data.

Procedure

  1. To export data, open the application where you want to export data and filter the information to show a record.
  2. Click click the download icon or Export data.
    For example, to export user data, on the side navigation menu, select Suite > Security > Users. Filter to show one user record and then click the download icon.
  3. In the Export data window, select Export custom columns.
    When you select custom columns, you can select a template to export data, and specify delimiter and text qualifier values. Do not enter a value in the Template name field. For example, to create an initial template for user data, you can export existing user data by exporting the MASPERUSER object structure.
  4. Export the file.

Example

You can update the data in the file and import to simultaneously create multiple records.

As an administrator, you can use the import option to create multiple users in Maximo Application Suite 9.1 by using a .csv file. Before you import users, you can create an initial template by exporting existing user data from the MASPERUSER object structure template. In the template file, specify each users information, such as identity details, contact information, access entitlements, and account status. After you import the file, the users records are created. For more information, see Importing users in Maximo Application Suite 9.1.