Difference between revisions of "How to move deposits between users"

From EPrints Documentation
Jump to: navigation, search
m
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[http://italnet.net.cn/img/obiettivo-minolta/ obiettivo minolta af 70 300] [http://nibko.info/data/dj-alien.htm dj alien] [http://nibko.info/data/magari-and.htm magari and renato zero] [http://puli.org.cn/web/video-scandalo/ video scandalo celebrita] [http://zodip.info/description/o-zone.htm o zone dragostea din tei remix] [http://hangzhau.cn/html/kiss-kiss/ kiss kiss, bang bang] [http://zodip.info/description/reflex-digitali.htm reflex digitali pentax 5] [http://zodip.info/description/sebe.htm sebe] [http://italnet.net.cn/img/recenzione-critica/ recenzione critica shakespeare in love] [http://italnet.net.cn/img/sartirana-lomellina/ sartirana lomellina] [http://puli.org.cn/web/blenders/ blenders] [http://italnet.net.cn/img/ricevitore-digitale/ ricevitore digitale terrestre per pc] [http://hangzhau.cn/html/nuovo-canzone/ nuovo canzone di jamelia] [http://puli.org.cn/web/budah-bar/ budah bar] [http://nibko.info/data/hafez.htm hafez] [http://italnet.net.cn/img/thunder-tiger/ thunder tiger ek4] [http://hangzhau.cn/html/www-economia/ www economia unict it] [http://nibko.info/data/originalsin.htm originalsin] [http://italnet.net.cn/img/ces-t/ ces t la vie] [http://hangzhau.cn/html/hotel-playa/ hotel playa del carmen] [http://puli.org.cn/web/lettore-mp/ lettore mp3 gb] [http://italnet.net.cn/img/stampanti-a/ stampanti a3 per rete] [http://nibko.info/data/climatizzatori-classe.htm climatizzatori classe a] [http://italnet.net.cn/img/gare-di/ gare di moto] [http://hangzhau.cn/html/gfu/ gfu] [http://puli.org.cn/web/sony-lettore/ sony lettore mp3 20 gb nw-hd3] [http://zodip.info/description/consegna-fiore.htm consegna fiore] [http://nibko.info/data/yakumo-tft.htm yakumo tft 17 xj] [http://zodip.info/description/picozzi-libri.htm picozzi libri] [http://puli.org.cn/web/liturgia/ liturgia] [http://hangzhau.cn/html/kimil-sun/ kimil sun] [http://nibko.info/data/lharem.htm lharem] [http://hangzhau.cn/html/vendere-diamante/ vendere diamante on line] [http://puli.org.cn/web/spompinatrici/ spompinatrici] [http://nibko.info/data/roland-td.htm roland td] [http://nibko.info/data/io-ho.htm io ho te] [http://hangzhau.cn/html/intel-pentium/ intel pentium 4 570 3 8] [http://nibko.info/data/gilda-news.htm gilda news scuola materna] [http://italnet.net.cn/img/www-imagens/ www imagens com br] [http://puli.org.cn/web/calicanto/ calicanto] [http://puli.org.cn/web/scanner-x/ scanner x dia] [http://hangzhau.cn/html/ver-videos/ ver videos de perreo] [http://puli.org.cn/web/the-best/ the best disco in the town] [http://zodip.info/description/cicciolina-foto.htm cicciolina foto] [http://puli.org.cn/web/sex-and/ sex and the city. stagione 01] [http://italnet.net.cn/img/neuro-linguistica/ neuro linguistica] [http://hangzhau.cn/html/time-stood/ time stood still] [http://puli.org.cn/web/wamu-com/ wamu com] [http://hangzhau.cn/html/gazetta-ufficiale/ gazetta ufficiale 4 serie speciale 42] [http://puli.org.cn/web/adidas-titan/ adidas titan mid lea] [http://italnet.net.cn/img/nat-kink/ nat kink cole] [http://hangzhau.cn/html/golf-cabrio/ golf cabrio] [http://italnet.net.cn/img/monica-belucci/ monica belucci biografia] [http://puli.org.cn/web/concessionari/ concessionari] [http://italnet.net.cn/img/appren/ appren] [http://hangzhau.cn/html/bomb-/ bomb  jack] [http://nibko.info/data/natural-tits.htm natural tits] [http://zodip.info/description/al-quaida.htm al quaida] [http://zodip.info/description/scandalo-grande.htm scandalo grande fratello] [http://italnet.net.cn/img/non-sparare/ non sparare] [http://hangzhau.cn/html/argonauti/ argonauti] [http://italnet.net.cn/img/dlink-dslgt/ d-link dsl-g604t wireless] [http://zodip.info/description/computer-da.htm computer da polso] [http://italnet.net.cn/img/maschio-femmina/ maschio femmina] [http://hangzhau.cn/html/fabulous-breathe/ fabulous breathe video] [http://hangzhau.cn/html/sergio-mendes/ sergio mendes magalenha] [http://nibko.info/data/o-sole.htm o sole] [http://hangzhau.cn/html/centro-tumori/ centro tumori di milano] [http://puli.org.cn/web/langolo-del/ langolo del mobile sas] [http://nibko.info/data/nederlandse-zenders.htm nederlandse zenders] [http://nibko.info/data/nikos-vertis.htm nikos vertis] [http://nibko.info/data/codici-liberty.htm codici liberty city gta] [http://italnet.net.cn/img/xd-card/ xd card] [http://italnet.net.cn/img/qui-a/ qui a le droit] [http://puli.org.cn/web/gps-palmari/ gps palmari palm 650] [http://italnet.net.cn/img/televisori-combo/ televisori combo] [http://zodip.info/description/i-nomi.htm i nomi dei 12 apostoli] [http://zodip.info/description/download-music.htm download music vedio] [http://puli.org.cn/web/toc/ toc] [http://nibko.info/data/sostiene-pereira.htm sostiene pereira] [http://hangzhau.cn/html/natasha-hovey/ natasha hovey] [http://italnet.net.cn/img/www-chiamami/ www chiamami it] [http://italnet.net.cn/img/stampante-epson/ stampante epson stylus photo r320] [http://italnet.net.cn/img/tn-brother/ tn-6600 brother toner] [http://zodip.info/description/hossam.htm hossam] [http://nibko.info/data/un-giorno.htm un giorno di pioggia] [http://hangzhau.cn/html/volo-boston/ volo boston] [http://puli.org.cn/web/citta-ostia/ citta ostia] [http://hangzhau.cn/html/steppenwolf-the/ steppenwolf the pusher mp3] [http://italnet.net.cn/img/ice-cream/ ice cream car] [http://puli.org.cn/web/foto-di/ foto di maurizia paradiso] [http://puli.org.cn/web/insegna-scorrevole/ insegna scorrevole] [http://nibko.info/data/abbigliamento-diesel.htm abbigliamento diesel] [http://nibko.info/data/san-salvador.htm san salvador monnlight] [http://nibko.info/data/naked-italian.htm naked italian women] [http://hangzhau.cn/html/motorola-/ motorola 980 vodafon] [http://italnet.net.cn/img/opel-corsa/ opel corsa gsi] [http://hangzhau.cn/html/remota-backup/ remota backup] [http://hangzhau.cn/html/scopare-a/ scopare a napoli] [http://italnet.net.cn/img/u/ u883] [http://puli.org.cn/web/autoofficine-treviso/ autoofficine treviso] [http://zodip.info/description/di-salto.htm di salto] [http://zodip.info/description/sammer-sunshine.htm sammer sunshine] [http://puli.org.cn/web/game-boy/ game boy emulater] [http://nibko.info/data/adattatore-per.htm adattatore per stampante bluetooth hp] [http://zodip.info/description/classifica-banca.htm classifica banca italiana] [http://nibko.info/data/cheaptickets.htm cheaptickets] [http://hangzhau.cn/html/tinka/ tinka] [http://puli.org.cn/web/cuscinetti-a/ cuscinetti a sfera teramo] [http://hangzhau.cn/html/ricevitore-satellite/ ricevitore satellite digitale] [http://nibko.info/data/canzoni-stonate.htm canzoni stonate] [http://puli.org.cn/web/willem-dafoe/ willem dafoe] [http://puli.org.cn/web/the-carpenter/ the carpenter and his clumsy wife] [http://italnet.net.cn/img/spartiti-tstiera/ spartiti tstiera] [http://italnet.net.cn/img/copertine-per/ copertine per lettini] [http://italnet.net.cn/img/gian-de/ gian de martini] [http://hangzhau.cn/html/il-ranch/ il ranch della violenza] [http://nibko.info/data/modena-agenzia.htm modena agenzia] [http://hangzhau.cn/html/moto-modellismo/ moto modellismo] [http://italnet.net.cn/img/shopper/ shopper] [http://zodip.info/description/ultimate-warrior.htm ultimate warrior torna sul ring] [http://italnet.net.cn/img/cavaleiros/ cavaleiros] [http://hangzhau.cn/html/nec-ni/ nec n341i software] [http://zodip.info/description/chat-merc.htm chat merc] [http://zodip.info/description/il-lupo.htm il lupo e il cane] [http://zodip.info/description/i-vagabondi.htm i vagabondi delle stelle] [http://hangzhau.cn/html/garmin-gpsmap/ garmin gpsmap 60c 60cs] [http://hangzhau.cn/html/confederazione-italiana/ confederazione italiana agricoltori] [http://zodip.info/description/fiat-punto.htm fiat punto nuovo] [http://hangzhau.cn/html/dajen/ dajen] [http://hangzhau.cn/html/outside-alone/ outside alone] [http://hangzhau.cn/html/tokina/ tokina 12 24] [http://italnet.net.cn/img/centrilavoro/ centrilavoro] [http://puli.org.cn/web/webchat/ webchat] [http://italnet.net.cn/img/dvd-s/ dvd s550] [http://nibko.info/data/aggroberlina.htm aggroberlina] [http://hangzhau.cn/html/gmax/ g-max] [http://zodip.info/description/mamma-insegname.htm mamma insegname a ballar] [http://zodip.info/description/www-ubisoft.htm www ubisoft it] [http://nibko.info/data/h-b.htm h b dx 3220] [http://hangzhau.cn/html/il-tagliaerba/ il tagliaerba] [http://italnet.net.cn/img/nicon/ nicon 4600] [http://nibko.info/data/presentazione-tesi.htm presentazione tesi laurea] [http://italnet.net.cn/img/kodak-/ kodak - easyshare dx7590 zoom] [http://zodip.info/description/microscopia.htm microscopia] [http://italnet.net.cn/img/inno-agli/ inno agli alpini] [http://zodip.info/description/z-.htm z 40 casio] [http://hangzhau.cn/html/notebook-masterizzatore/ notebook masterizzatore dvd interno] [http://hangzhau.cn/html/i-buoni/ i buoni e i cattivi] [http://zodip.info/description/www-sciacca.htm www sciacca it] [http://italnet.net.cn/img/i-don/ i don t wana know] [http://puli.org.cn/web/ostello-milano/ ostello milano marittima] [http://zodip.info/description/capodichino-airport.htm capodichino airport] [http://nibko.info/data/blocchi-autocad.htm blocchi autocad 2d] [http://italnet.net.cn/img/ktcen/ ktc-en133 256] [http://italnet.net.cn/img/climatizzatore-panasonic/ climatizzatore panasonic] [http://puli.org.cn/web/responsabile-ricambi/ responsabile ricambi sud (italia sud)] [http://hangzhau.cn/html/baobab/ baobab] [http://italnet.net.cn/img/the-lion/ the lion sleep] [http://zodip.info/description/clio-.htm clio 1.2 rti] [http://nibko.info/data/asus-pwd.htm asus p5wd2 premium i955x fsb1066] [http://italnet.net.cn/img/toyota-italia/ toyota italia] [http://italnet.net.cn/img/toner-stampante/ toner stampante epson c900] [http://nibko.info/data/dpp-fp.htm dpp fp30] [http://puli.org.cn/web/giochi-d/ giochi d avventura] [http://nibko.info/data/km-fiat.htm km0 fiat multipla diesel auto km 0] [http://hangzhau.cn/html/peugeot-/ peugeot 106 sport] [http://hangzhau.cn/html/ran/ ran] [http://hangzhau.cn/html/hp-videoproiettore/ hp videoproiettore] [http://nibko.info/data/www-fidenza.htm www fidenza it] [http://zodip.info/description/davila.htm davila] [http://italnet.net.cn/img/suonerie-polifoniche/ suonerie polifoniche cantate] [http://zodip.info/description/toples.htm toples] [http://nibko.info/data/tnt-corriere.htm tnt corriere] [http://italnet.net.cn/img/albergo-lido/ albergo lido jesolo] [http://puli.org.cn/web/darkness-traduzioni/ darkness traduzioni testi] [http://puli.org.cn/web/ricoh-aficio/ ricoh aficio cl7000] [http://nibko.info/data/occhiali-sole.htm occhiali sole diesel] [http://nibko.info/data/scopa-elettrica.htm scopa elettrica aeg] [http://hangzhau.cn/html/seconda-prova/ seconda prova matematica svolta] [http://italnet.net.cn/img/calzature-per/ calzature per bambini] [http://italnet.net.cn/img/qarluq/ qarluq] [http://zodip.info/description/asus-kux.htm asus k8u-x] [http://italnet.net.cn/img/lettori-dvd/ lettori dvd e divx kiss dp 500] [http://puli.org.cn/web/pink-nuda/ pink nuda] [http://italnet.net.cn/img/vallesi/ vallesi] [http://hangzhau.cn/html/angeline-jolie/ angeline jolie] [http://puli.org.cn/web/claudio-baglioni/ claudio baglioni pace] [http://nibko.info/data/emilio-roy.htm emilio roy] [http://nibko.info/data/tornero.htm tornero] [http://puli.org.cn/web/lancome-tonique/ lancome tonique confort] [http://italnet.net.cn/img/il-santo/ il santo gral] [http://zodip.info/description/visiomatic.htm visiomatic] [http://zodip.info/description/marini-.htm marini 2005 calendario] [http://italnet.net.cn/img/pampers/ pampers] [http://zodip.info/description/marc-antony.htm marc antony] [http://italnet.net.cn/img/sfondo-cartone/ sfondo cartone fumetto] [http://italnet.net.cn/img/cobra-mp/ cobra mp3] [http://hangzhau.cn/html/copertine-film/ copertine film in dvd] [http://zodip.info/description/gli-esclusi.htm gli esclusi] This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand.
+
[[Category:Howto]]
 +
[[Category:Management]]
  
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.

  1. View the item
  2. Under the Actions tab click Change Owner (if you don't see Editorial Actions then you don't have the correct privileges)
  3. Enter the username of the user to transfer ownership to and click Change