|
|
| Line 1: |
Line 1: |
| [[Category:Howto]] | | [[Category:Howto]] |
| [[Category:Management]] | | [[Category:Management]] |
| [[Category:Rubbish]]
| |
| {{Obsolete}}
| |
| This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand.
| |
|
| |
|
| First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of.
| | To change the owner of a eprint you need to have editorial privileges for that item and know the username of the user to transfer ownership to. |
|
| |
|
| SELECT userid FROM users WHERE username='USERNAME_GOES_HERE';
| | # View the item |
| | | # Under the ''Actions'' tab click '''Change Owner''' (if you don't see ''Editorial Actions'' then you don't have the correct privileges) |
| The response will be something like this:
| | # Enter the username of the user to transfer ownership to and click '''Change''' |
| | |
| +--------+
| |
| | userid |
| |
| +--------+
| |
| | 23 |
| |
| +--------+
| |
| 1 row in set (0.00 sec)
| |
| | |
| That means they are userid 23. Do this for both the user you are moving eprints from and the one you are moving them to.
| |
| | |
| !! Moving EPrints in the live repository
| |
| | |
| To just transfer eprints in the main repository: (replace TO_USERID and FROM_USERID with the numbers you just found out).
| |
| | |
| UPDATE archive SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
| |
| | |
| !! Moving all EPrints
| |
| | |
| If you want to apppy the change to the user workarea, editorial review etc. you need to run the SQL for all four tables:
| |
| | |
| UPDATE inbox SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
| |
| UPDATE archive SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
| |
| UPDATE buffer SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
| |
| UPDATE deletion SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
| |
| | |
| !! Metadata (abstract) pages
| |
| | |
| The eprint metadata summary pages will not be updated with this new information until you run:
| |
| /bin/generate_abstracts ARCHIVE_ID
| |
To change the owner of a eprint you need to have editorial privileges for that item and know the username of the user to transfer ownership to.
- View the item
- Under the Actions tab click Change Owner (if you don't see Editorial Actions then you don't have the correct privileges)
- Enter the username of the user to transfer ownership to and click Change