How to export structures (for example account structures), for sending to IBM Support or for copying structures from one database to another

Technote (troubleshooting)


Customer wishes to to export structures (e.g. company and/or account configuration information) from their system. For example, they may want to:
(1) Send their structure configuration to IBM Support
(2) Copy their structure configuration from database1 (e.g. their production system) to database2 (e.g. a test system)

How can they do this?

Resolving the problem

Use the 'Transfer' menu to export and import the relevant structures.

(1) Steps to export structures

  1. Launch Controller, and logon to source database as an administrator (e.g. ADM)
  2. Click "Transfer - Export Structures"
  3. Choose directory (folder) where the export file will be created
  4. If desired, tick the "Compress Export-File" button
  5. Select each of the structures you wish to export (for example tick the 'Accounts/Forms' box if you wish to export the account structures) or alternatively simply click "Select All" to export everything.
  6. Click "RUN".

After the process has completed, you will have a file (typically called "FstrucController.FZP") in the export folder location.

(2) Steps to import structures into a different/separate database
  1. Ensure no users are using the target database
  2. As a precaution, create a backup of the database that you are intending to import the structures into (target database)
  3. Launch Controller, and logon to target database as an administrator (e.g. ADM)
  4. Click "Maintain - Users - Single Mode"
  5. Click "Transfer - Import Structures"
  6. Browse for the structure file that was previously created (see above). The system identifies the structures in the file and populates the window accordingly.
  7. Click on the 'Run' icon and the import will begin.
  8. IMPORTANT: After the import has completed, you must run a database optimisation. Click "Maintain - Database - Optimize". Tick/select all available options. click "Run".

Related information

Cognos Controller User Guide - Chapter 13.

Historical Number


Rate this page:

(0 users)Average rating

Document information

More support for:

Cognos Controller

Software version:

8.3, 8.4, 8.5, 8.5.1, 10.1, 10.1.1

Operating system(s):


Reference #:


Modified date:


Translate my page

Machine Translation

Content navigation