Export users from Spectrum and import into a new server

Products

• Spectrum

Issue/Introduction

Sometimes, there is a need to import a large number of user accounts from an old SpectroSERVER to a new one due to either corruption of data or simply building a new environment without a full SSdb. import. 

You have built a new environment with the latest version of Spectrum but you didn’t import the SSdb. How can you import just the user accounts from the old server?

Environment

Release: Any

Resolution

You can use the Modelling Gateway to export the user accounts from your old machine and import them into the new. 

From the old SpectroSERVER system

1. Log into the system as the user that owns the Spectrum installation
2. If on Windows, start a bash shell by running "bash -login"
3. Make a backup of the $SPECROOT/SS-Tools/.modelinggatewayresource.xml file
4. Edit the $SPECROOT/SS-Tools/.modelinggatewayresource.xml file. In the <ExportConfiguration> tag, set "export_user_models" to "true" and all other parameters to "false"
5. cd to the $SPECROOT/SS-Tools directory and run the following command where <hostname> is the hostname of the old SpectroSERVER system:
   
   ./modelinggateway -vnm <hostname> -e user-account-data.xml
   
   
6. Copy the backup of the $SPECROOT/SS-Tools/.modelinggatewayresource.xml file created in step 1c to the original filename $SPECROOT/SS-Tools/.modelinggatewayresource.xml file
7. Copy the user-account-data-xml file to the $SPECROOT/SS-Tools directory on the new SpectroSERVER system

From the new SpectroSERVER system

1. Log in to the system as the user that owns the Spectrum installation
2. If on Windows, start a bash shell by running "bash -login"
   
   
3. cd to the $SPECROOT/SS-Tools directory and run the following command where <hostname> is the hostname of the new SpectroSERVER system.
   /modelinggateway -vnm <hostname> -i user-account-data.xml