| Administrator's Handbook |
| Edutizer manuals | Administrator handbook | A2 Manage | Various database scripts | Moving examresults from one user to another |
Moving examresults from one user to another
Task: move all or specific exam result from one user to another.
DISCLAIMER: This script has been tested by MWX engineers. This script is provided without any warranty. Do back up you database before using this script.
When this might become handy:
- merge two users
- exam done under another user name because user account was not available
- user_id of the target user
- user_id of source user
- training_id of the training of which exam results you are about to move
user_id: search users using Administrator or Teacher application. Click user properties. The location of the page will be something like http://..../edituser.asp?userid=314 (administrator application) or http://...../opilane.asp?id=314.
314 - is the user_id.
training_id: in teacher application click on the training (either active or archived). Location of the page will be something like http://........//TrainingView3.asp?id=829
829 - is the training_id.
The script itself:
-- DISCLAIMER:
-- This script has been tested by MWX engineers.
-- This script is provided without any warranty.
-- Do back up you database before using this script
USE Edutizer
UPDATE Examresults
SET user_id = <target_user_id>
WHERE user_id = <source_user_id>
[AND training_id = <training_id>]
|
||||||
| ||||||
|
||||||
