Crash Magic Online
  Intersection Magic
  Map Magic
  Knowledge Base
  Contact Us


Knowledge Base Article:CMO228 

Registration keys moved to client area: Select login on the left menu bar.

Search home page  

Changing the Crash Magic configuration schema names

Article created: Jun 25 2010, updated: Jun 25 2010

Background:  Users that move their collision database to a new schema will need to update the Crash Magic configuration.

Status:  Info - "how to" article
Keywords:  schema,change,configuration,database
Categories:   *Configuration* *Article - references*


Crash Magic clients that change schema names on their crash data will need to update their Crash Magic configuration with the new information. Users can edit the queries in Crash Magic, but this can be a time consuming process to edit every query. The following steps allow the user to edit all of the schemas in a single file, and import the changes into Crash Magic.

This process is only for changing the schema name use. It will not change the connection to the database. Please, contact Pd Programming if you need assistance in changing connection information.


Their are five tasks that need to be accomplished for changing the schema name. Export the configuration, rename the login name of the current shared user, edit the exported file in a text editor, upload the altered file, select the import elements and change to the new .shared user in the user group.  Once these tasks have been completed you will want the users to log into Crash Magic and test the change to the system.

Export the configuration to a file. Exporting the configuration will allow editing of the configuration in text editor.

  1. Log into Crash Magic as the Group Admin
  2. Click on the .shared user under your user group in the admin tree on left of the screen
  3. Once you have selected .shared user, click on the "Open the Export Wizard" button( This button at the bottom of the screen with a green arrow pointing down on a paper)
  4. Click the "Export the current user (.shared)" link in the "Crash Magic Export" window
  5. Click the check box shown as "Include project, study and report attributes" on the ".shared Import / Export" window
  6. Click the Export this user button
  7. Save the XML file to a location that can be edited in notepad
  8. Click the Done button on the ".shared Import / Export" and "Crash Magic Export" windows to return to Crash Magic.

Change the login of the shared user. Crash Magic will not allow two users with the same login name. This task will allow changes to be imported back into Crash Magic.

  1. Ensure that you are still logged into Crash Magic as the Group Admin, and open to the .shared of your user group.
  2. Click on the green "Settings" tab for the shared user
  3. Change the Login name to .shared to shared+year+month+day (example shared20100629)
  4. Click your user group in the admin tree and confirm the name has changed in the tree

Replace the schema name in a text editor. Queries are stored in an xml format with the schema.table name notation. A global search and replace will change all of the schemas in the file. No other changes a supported.  Altering the xml other than specified could render the xml unusable.

  1. Open the XML file that you exported from the first task in notepad( Do not use Word to edit the file, as it can add unwanted hidden characters)
  2. Click the Edit drop down menu, and select Replace
  3. Enter Old Schema Name Spec in the Find what field( Example Old Schema Name Example)
  4. Enter New Schema Name Spec in the Find what field( Example New Schema Name Example)
  5. Click the Replace All button
  6. Click Cancel to close the Replace window
  7. Click the File drop down menu and select Save
  8. Exit the editor

Import the altered configuration file.

  1. Log into Crash Magic as the Group Admin
  2. Click on your user group in the admin tree on the left of the window.
  3. Click the "Open the Import Wizard" button( This button at the bottom of the screen with a orange arrow pointing up on a paper)
  4. Click the "Browse..." button and select the altered configuration XML file.
  5. Click the "Upload file for import" button
  6. Click the "OK" button when informed that this may take a few minutes
  7. Click the "OK" button when the file has been uploaded.

Select the import items.

  1. With the import wizard still open and the uploaded file selected, click the "Next" button
  2. In the "Crash Magic Import - User Groups" window select your user group and click the "Next" button.
  3. In the "Crash Magic Import - Users" window check the .shared user box and click the "Next" button
  4. In the "Crash Magic Import - PSRAttrs" window click the "Change selection" button
  5. Ensure that the "All" is checked and click the "Select" button to select all of the attributes
  6. Click the "Next" button when all of the attributes have been selected
  7. Click the "Next" button on the "Crash Magic Import - Projects" window( There should be no projects to import)
  8. Click the "Next" button on the "Crash Magic Import - Studies" window( There should be no studies to import) 
  9. Click the "Next" button on the "Crash Magic Import - Reports" window( There should be no reports to import) 
  10. Click the "Import" button
  11. Click "OK" when complete
  12. Click the "Done" button to return to the admin screens

Update the group shared user. This will inform Crash Magic to use the changes that were just uploaded from the XML file.

  1. While logged into Crash Magic as the Group Admin click on your user group in the admin tree
  2. Click the green "Settings" tab of the user group.
  3. Click the "Shared user:" drop down and select the .shared user that was just uploaded.
  4. Exit Crash Magic to save the changes.

 Once this is complete you should test Crash Magic to ensure the changes are correct.

October 23, 2019 4:19AM

© 1999-2019 Pd' Programming, Inc - Lafayette, CO USA