Troubleshooting
Problem
Customer wishes to to export structures (for example company and/or account configuration information) from their system.
How can they do this?
Cause
For example, they may want to either:
- (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)
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
6. Click "Run" button.
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) 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 only wish to export some of the account structures)
- or alternatively simply click "Select All" to export everything.
6. Click "Run" button.
After the process has completed, you will have a file (typically called "FstrucController.FZP") in the export folder location.
=========================================
Optional: If you would like to import those structures (created above) into a different database, then you can now perform the following steps:
(2) Steps to import structures into a different/separate database
- Ensure no users are using the target database
- As a precaution, create a backup of the database that you are intending to import the structures into (target database)
- Launch Controller, and logon to target database as an administrator (e.g. ADM)
- Click "Maintain - Users - Single Mode"
- Click "Transfer - Import Structures"
- Browse for the structure file that was previously created (see above). The system identifies the structures in the file and populates the window accordingly.
- Click on the 'Run' icon and the import will begin.
- IMPORTANT: After the import has completed, you must run a database optimisation. Click "Maintain - Database - Optimize". Tick/select all available options. click "Run".
=========================================
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
1040517
Was this topic helpful?
Document Information
Modified date:
12 November 2019
UID
swg21348007