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

From EPrints Documentation
Jump to: navigation, search
m
 
(9 intermediate revisions by 4 users not shown)
Line 1: Line 1:
[http://peter-land.somee.com/images/small/sunburn.htm sunburn] [http://viemalin.freeweb7.com/resources/articles/caricabatterie-pile.htm caricabatterie pile] [http://yourorus.somee.com/data/underworld-.htm underworld 8 ball] [http://jututor.125mb.com/lib/athlon-/ athlon 64 mobile] [http://dabeutle.t35.com/content/view/pioneer-dvd.htm pioneer dvd r] [http://davelovesyou.somee.com/library/html/bari-sud/ bari sud] [http://flheddina.t35.com/web/si-la/ si la ves de sin banderas] [http://lamcgie.125mb.com/html/nelli-furtado.htm nelli furtado forca] [http://ouquaite.freeweb7.com/img/styles/tv-lcd/ tv lcd philips 26] [http://peter-land.somee.com/images/small/trasloco.htm trasloco] [http://rimarsh.t35.com/images/small/frocetto.htm frocetto] [http://lensman.somee.com/html/van-de/ van de strof] [http://viemalin.freeweb7.com/resources/articles/nuova-smart.htm nuova smart forfour diesel auto nuove] [http://quotes-girl.somee.com/content/view/km/ km 005] [http://lensman.somee.com/html/screensaver-del/ screensaver del signore degli anello] [http://rihelm.125mb.com/img/styles/perle-coltivate/ perle coltivate] [http://betheresa.t35.com/text/directory/www-alessio/ www alessio it] [http://yourorus.somee.com/data/forno-elettrico.htm forno elettrico ad incasso] [http://fergus-mac.somee.com/description/lib/cardiofrequenzimetro-cs/ cardiofrequenzimetro cs100] [http://lamcgie.125mb.com/html/piccolo-uomo.htm piccolo uomo testo mia martini] [http://kiboukni.125mb.com/web/euprepio-curto/ euprepio curto] [http://flheddina.t35.com/web/canon-faxl/ canon fax-l380] [http://nairoz.somee.com/img/styles/telefoni-cellulari/ telefoni cellulari con lettore mp3] [http://quotes-girl.somee.com/content/view/ricetrasmettitori-libero/ ricetrasmettitori libero utilizzo] [http://rihelm.125mb.com/img/styles/assicurazione-biella/ assicurazione biella] [http://lamcgie.t35.com/web/vieni-avanti.htm vieni avanti cretino] [http://jututor.125mb.com/lib/cantante-napoletana/ cantante napoletana valentina stella] [http://coarmago.freeweb7.com/library/html/d-link.htm d link modem] [http://lamcgie.t35.com/web/pagine-bianche.htm pagine bianche treviso] [http://fergus-mac.somee.com/description/lib/carinci-aggiornamenti/ carinci aggiornamenti] [http://dj-deus.somee.com/lib/www-onuitalia.htm www onuitalia it] [http://ouquaite.freeweb7.com/img/styles/linkin-aprk/ linkin aprk] [http://itgurney.t35.com/view/new/hey-mama/ hey mama black eyed peace] [http://dj-deus.somee.com/lib/ostaggi-curdi.htm ostaggi curdi] [http://jututor.125mb.com/lib/alimentatore-stabilizzato/ alimentatore stabilizzato per] [http://lamcgie.t35.com/web/spoolsv.htm spoolsv] [http://lamcgie.t35.com/web/il-vento.htm il vento nei salici] [http://lakitsmi.freeweb7.com/web/cristina-d/ cristina d avena e i tuoi amici in tv 17] [http://jedillar.125mb.com/resources/articles/tiempo-mystic/ tiempo mystic] [http://de-der.somee.com/library/html/conoscienze-via.htm conoscienze via chat] [http://am-i-bird.somee.com/img/styles/computer-pc.htm computer pc] [http://nairoz.somee.com/img/styles/bengo/ bengo] [http://jedillar.125mb.com/resources/articles/peugeot-/ peugeot 1.4 xs] [http://rimarsh.t35.com/images/small/www-passeggino.htm www passeggino carrozzina chicco it] [http://am-i-bird.somee.com/img/styles/canzone-adagio.htm canzone adagio] [http://dj-deus.somee.com/lib/le-braghe.htm le braghe del padrone] [http://davelovesyou.somee.com/library/html/il-goleador/ il goleador stadium] [http://dj-deus.somee.com/lib/albergo-.htm albergo 3 stelle umbria] [http://am-i-bird.somee.com/img/styles/astuccio-per.htm astuccio per orologi] [http://luallard.t35.com/html/micro-hi/ micro hi fi teac] [http://dabeutle.t35.com/content/view/pat-love.htm pat love] [http://thegoogly.somee.com/view/new/nino-di.htm nino di angeli] [http://trocterli.t35.com/img/styles/www-coming/ www coming soon com] [http://jututor.125mb.com/lib/telwin-spa/ telwin spa] [http://dabeutle.t35.com/content/view/dominiche.htm dominiche] [http://luallard.t35.com/html/marco-travaglio/ marco travaglio] [http://nairoz.somee.com/img/styles/telios-hoover/ telios hoover] [http://jedillar.125mb.com/resources/articles/discoteche-e/ discoteche e locali notturni bologna] [http://fergus-mac.somee.com/description/lib/simcity/ simcity 4] [http://thegoogly.somee.com/view/new/mechanic-pump.htm mechanic pump program software] [http://itgurney.t35.com/view/new/letra-de/ letra de danzare] [http://coarmago.freeweb7.com/library/html/la-comunicazione.htm la comunicazione visiva nel vangelo di] [http://de-der.somee.com/library/html/leoluca-orlando.htm leoluca orlando] [http://fergus-mac.somee.com/description/lib/win-tv/ win tv nova ci s] [http://peter-land.somee.com/images/small/dj-nano.htm dj nano] [http://itgurney.t35.com/view/new/pianta-di/ pianta di mestre] [http://nairoz.somee.com/img/styles/lacie-d/ lacie d2 hard drive extreme] [http://jedillar.125mb.com/resources/articles/wild-animals/ wild animals] [http://dabeutle.t35.com/content/view/drago-finale.htm drago finale] [http://coarmago.freeweb7.com/library/html/plastici-ferroviari.htm plastici ferroviari] [http://fawarfo.freeweb7.com/topic/scarichi-per.htm scarichi per moto honda] [http://quotes-girl.somee.com/content/view/patrick-park/ patrick park] [http://quotes-girl.somee.com/content/view/hotel-monaco/ hotel monaco] [http://coarmago.freeweb7.com/library/html/concessionari-fiat.htm concessionari fiat roma] [http://luallard.t35.com/html/especies-en/ especies en peligro de extincion] [http://kiboukni.125mb.com/web/scanner-per/ scanner per negativi 4490] [http://dabeutle.t35.com/content/view/tu-come.htm tu come stai] [http://jututor.125mb.com/lib/rover/ rover 220] [http://kiboukni.125mb.com/web/www-la/ www la pelle it] [http://coarmago.freeweb7.com/library/html/happy-xmas.htm happy xmas john lennon] [http://quotes-girl.somee.com/content/view/ornito/ ornito-] [http://fawarfo.freeweb7.com/topic/pista-mi.htm pista mi inmortal] [http://dabeutle.t35.com/content/view/john-butler.htm john butler trio] [http://dj-deus.somee.com/lib/sicilia-vacanza.htm sicilia vacanza] [http://ouquaite.freeweb7.com/img/styles/barit-george/ barit, george] [http://luallard.t35.com/html/video-gf/ video gf inglese] [http://fergus-mac.somee.com/description/lib/motorizzato-parabola/ motorizzato parabola parabole] [http://dabeutle.t35.com/content/view/guscio-per.htm guscio per samsung] [http://madavid.t35.com/html/hasta-cuando/ hasta cuando] [http://rimarsh.t35.com/images/small/gallerie-fotografiche.htm gallerie fotografiche porno gratis] [http://peter-land.somee.com/images/small/voglio-vivere.htm voglio vivere cosi] [http://itgurney.t35.com/view/new/it-play/ it play yahho com] [http://nationavce.somee.com/library/html/geforce-le/ geforce 6800le 128mb tv dvi] [http://nairoz.somee.com/img/styles/dynasty-street/ dynasty street] [http://nairoz.somee.com/img/styles/photoshop-elements/ photoshop elements] [http://dj-deus.somee.com/lib/conan-ragazzo.htm conan ragazzo del futuro] [http://betheresa.t35.com/text/directory/foto-telefonini/ foto telefonini samsung] [http://fergus-mac.somee.com/description/lib/cascadia-foto/ cascadia foto] [http://jedillar.125mb.com/resources/articles/exosat/ exosat] [http://quotes-girl.somee.com/content/view/testi-canzoni/ testi canzoni di grease] [http://nationavce.somee.com/library/html/galaxie-ball/ galaxie ball] [http://flheddina.t35.com/web/golf-/ golf 1 9 tdi comfortline] [http://coarmago.freeweb7.com/library/html/stampanti-multifunzione.htm stampanti multifunzione di rete] [http://dj-deus.somee.com/lib/hi-fi.htm hi fi onkyo] [http://trocterli.t35.com/img/styles/victory-is/ victory is won] [http://ouquaite.freeweb7.com/img/styles/addii-al/ addii al celibato] [http://nairoz.somee.com/img/styles/giochi-d/ giochi d acqua] [http://trocterli.t35.com/img/styles/leslie-et/ leslie et amine] [http://davelovesyou.somee.com/library/html/lettori-mp/ lettori mp3 con batteria litio] [http://coarmago.freeweb7.com/library/html/hp-.htm hp - c4844a] [http://luallard.t35.com/html/airone-voli/ airone voli aerei] [http://rimarsh.t35.com/images/small/canon-eosd.htm canon eos-350d] [http://dabeutle.t35.com/content/view/mohicani.htm mohicani] [http://am-i-bird.somee.com/img/styles/collezione-orologio.htm collezione orologio donna] [http://thegoogly.somee.com/view/new/nonna-troia.htm nonna troia] [http://peter-land.somee.com/images/small/foto-kledi.htm foto kledi kadiu] [http://lamcgie.125mb.com/html/piveteau-jean.htm piveteau, jean] [http://lamcgie.t35.com/web/audigy-nx.htm audigy nx] [http://viemalin.freeweb7.com/resources/articles/zampogna.htm zampogna] [http://flheddina.t35.com/web/sede-vacante/ sede vacante] [http://nairoz.somee.com/img/styles/il-gambero/ il gambero rosso] [http://dabeutle.t35.com/content/view/leva-voce.htm leva voce mp3] [http://davelovesyou.somee.com/library/html/registratore-dvd/ registratore dvd hd] [http://lamcgie.125mb.com/html/www-enciclopedia.htm www enciclopedia it] [http://peter-land.somee.com/images/small/notebook-toschiba.htm notebook toschiba] [http://viemalin.freeweb7.com/resources/articles/francobolli-san.htm francobolli san marino] [http://ouquaite.freeweb7.com/img/styles/preparatori-moto/ preparatori moto] [http://nationavce.somee.com/library/html/prime-immagini/ prime immagini per unreal tournament 2004] [http://viemalin.freeweb7.com/resources/articles/i-crocifissi.htm i crocifissi nelle scuole commento] [http://viemalin.freeweb7.com/resources/articles/cover-ps.htm cover ps2] [http://trocterli.t35.com/img/styles/renda-francesco/ renda francesco] [http://yourorus.somee.com/data/piero-buscemi.htm piero buscemi] [http://rihelm.125mb.com/img/styles/batteria-per/ batteria per compaq presario 2800] [http://davelovesyou.somee.com/library/html/bora/ bora] [http://peter-land.somee.com/images/small/codici-per.htm codici per cellulari] [http://rimarsh.t35.com/images/small/cifra-canal.htm cifra canal] [http://am-i-bird.somee.com/img/styles/tj.htm tj] [http://lamcgie.t35.com/web/rivombrosa-sexy.htm rivombrosa sexy] [http://davelovesyou.somee.com/library/html/www-virtuagirl/ www virtuagirl2 com] [http://lamcgie.t35.com/web/ghostbuster.htm ghostbuster] [http://lamcgie.t35.com/web/sigla-manga.htm sigla manga] [http://jututor.125mb.com/lib/dr/ dr 7400] [http://luallard.t35.com/html/gha-ndi/ gha ndi] [http://lensman.somee.com/html/pondok-putri/ pondok putri] [http://nairoz.somee.com/img/styles/troia-matura/ troia matura] [http://betheresa.t35.com/text/directory/dschola-it/ dschola it] [http://lakitsmi.freeweb7.com/web/netgear-wgis/ netgear wg102is] [http://peter-land.somee.com/images/small/orari-pulman.htm orari pulman] [http://peter-land.somee.com/images/small/lavoro-piu.htm lavoro piu] [http://luallard.t35.com/html/max-fornari/ max fornari] [http://am-i-bird.somee.com/img/styles/password-messenger.htm password messenger] [http://lamcgie.125mb.com/html/agriturismo-crotone.htm agriturismo crotone] [http://lakitsmi.freeweb7.com/web/yu-yu/ yu yu hakusho. ghost fighters. box 5] [http://jututor.125mb.com/lib/royal-gigolo/ royal gigolo california dreamin mp3 free] [http://rimarsh.t35.com/images/small/la-ragazza.htm la ragazza del vagone letto] [http://nationavce.somee.com/library/html/sierra-entertainment/ sierra entertainment] [http://quotes-girl.somee.com/content/view/tutte-facolta/ tutte facolta universitarie di napoli] [http://fergus-mac.somee.com/description/lib/massimo-urbani/ massimo urbani tabs] [http://nationavce.somee.com/library/html/la-mede/ la mede] [http://jedillar.125mb.com/resources/articles/sensori/ sensori] [http://betheresa.t35.com/text/directory/gard-dipartimento/ gard (dipartimento)] [http://am-i-bird.somee.com/img/styles/jinhae.htm jinhae] [http://madavid.t35.com/html/gallup-agenzia/ gallup (agenzia statunitense)] [http://dj-deus.somee.com/lib/coffee-shop.htm coffee shop] [http://fawarfo.freeweb7.com/topic/albergo-menton.htm albergo menton] [http://coarmago.freeweb7.com/library/html/devo-the.htm devo. the complete truth about de-evolution. devo live] [http://lensman.somee.com/html/ricetta-muffin/ ricetta muffin] [http://nationavce.somee.com/library/html/digital-camera/ digital camera hp r717] [http://kiboukni.125mb.com/web/cartoon-porno/ cartoon porno online gratis] [http://lakitsmi.freeweb7.com/web/motorola-usb/ motorola usb driver] [http://flheddina.t35.com/web/tavolo-rotondo/ tavolo rotondo] [http://jedillar.125mb.com/resources/articles/annuncio-privato/ annuncio privato casa] [http://peter-land.somee.com/images/small/una-casa.htm una casa in bilico] [http://madavid.t35.com/html/gyro-all/ gyro all] [http://nationavce.somee.com/library/html/mario-cut/ mario cut] [http://lamcgie.t35.com/web/phantom-opera.htm phantom opera] [http://dabeutle.t35.com/content/view/volo-riva.htm volo riva garda] [http://lamcgie.t35.com/web/vids-mjpg.htm vids mjpg] [http://quotes-girl.somee.com/content/view/indirizzi-azienda/ indirizzi azienda] [http://itgurney.t35.com/view/new/foto-crimini/ foto crimini di guerra] [http://lamcgie.t35.com/web/edward-clug.htm edward clug] [http://rimarsh.t35.com/images/small/alfa-.htm alfa 166 jtd] [http://nairoz.somee.com/img/styles/boys-boys/ boys boys boys] [http://lamcgie.t35.com/web/i-figli.htm i figli di nessuno] [http://nairoz.somee.com/img/styles/pfm-spa/ pfm spa] [http://nationavce.somee.com/library/html/kad-te/ kad te druga] [http://betheresa.t35.com/text/directory/morte-di/ morte di umberto agnelli] [http://nairoz.somee.com/img/styles/gucci-gg/ gucci gg 2711] [http://viemalin.freeweb7.com/resources/articles/hotel-in.htm hotel in thailand] [http://trocterli.t35.com/img/styles/accessori-nikon/ accessori nikon 5900] [http://davelovesyou.somee.com/library/html/key-page/ key page] [http://madavid.t35.com/html/classificazione-della/ classificazione della cellula] [http://kiboukni.125mb.com/web/daniela-nane/ daniela nane] [http://fergus-mac.somee.com/description/lib/satiricosissimo/ satiricosissimo] [http://rihelm.125mb.com/img/styles/la-famiglia/ la famiglia come risorsa conoscitiva] [http://coarmago.freeweb7.com/library/html/gonne-di.htm gonne di jeans diesel] [http://lakitsmi.freeweb7.com/web/jbl-mp/ jbl mp3] [http://quotes-girl.somee.com/content/view/fred-perry/ fred perry camicia] [http://viemalin.freeweb7.com/resources/articles/foto-anna.htm foto anna edwards] [http://jedillar.125mb.com/resources/articles/jen-rosendahl/ jen rosendahl pics] 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