|
|
| 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
| |
Latest revision as of 10:45, 9 December 2011
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
