This cheatsheet I made a couple years ago may help. I haven't tried on our 1.8.2, but I doubt it's changed. The usual caveats re. updating your database (backup backup backup), I accept no responsibility for damage, etc. etc.
==========start============= How to move items backwards (or forwards) in workflow 2010-06-30 Find the item_id by searching for title in metadatavalue: select item_id, text_value from metadatavalue where metadata_field_id = 64 and text_value like 'A General Solution%'; Change the worflow state for the item, be sure to set it to an 'owned' state (2, 4 or 6): [select * from workflowitem where item_id = 2394;] UPDATE workflowitem SET state = 2 where item_id = 2394; state step 1 step 1 2 step 1 owned (do-later pool) 3 step 2 4 step 2 owned 5 step 3 6 step 3 owned Get the eperson_id of the person you want to send it back to: select eperson_id, email from eperson order by email; Set the item's owner to the eperson_id you just found: update workflowitem set owner = 14 where item_id = 2394; Item should now appear in 'owner's' do-later pool. (When you set it to a non-owned state, the item can't be seen by anyone assigned to the pool for some reason, hence the need to set owner and state=owned) ==========end============= Joseph Greene Research Repository and Systems Librarian James Joyce Library University College Dublin (353 0)1 716 7398 (353 0)1 716 7686 joseph.gre...@ucd.ie http://www.ucd.ie/library http://researchrepository.ucd.ie -----Original Message----- From: dspace-tech-requ...@lists.sourceforge.net [mailto:dspace-tech-requ...@lists.sourceforge.net] Sent: 27 May 2013 14:31 To: dspace-tech@lists.sourceforge.net Subject: DSpace-tech Digest, Vol 85, Issue 121 Send DSpace-tech mailing list submissions to dspace-tech@lists.sourceforge.net To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/dspace-tech or, via email, send a message with subject or body 'help' to dspace-tech-requ...@lists.sourceforge.net You can reach the person managing the list at dspace-tech-ow...@lists.sourceforge.net When replying, please edit your Subject line so it is more specific than "Re: Contents of DSpace-tech digest..." Today's Topics: 1. Re: Returning a taken task back to Pool? (helix84) 2. Re: Fwd: [Dspace-devel] Item state definitions (Pottinger, Hardy J.) 3. Re: Moving image and bitstream up (Webshet, Sisay (ILRI)) 4. Re: Moving image and bitstream up (helix84) 5. Re: Moving image and bitstream up (Webshet, Sisay (ILRI)) 6. Re: Change permissions in batch (Miguel Angel Robledo) 7. Re: Change permissions in batch (helix84) ---------------------------------------------------------------------- Message: 1 Date: Mon, 27 May 2013 14:14:39 +0200 From: helix84 <heli...@centrum.sk> Subject: Re: [Dspace-tech] Returning a taken task back to Pool? To: Michael White <michael.wh...@stir.ac.uk> Cc: "dspace-tech@lists.sourceforge.net" <dspace-tech@lists.sourceforge.net> Message-ID: <CAGdvKqi9UzavPCjMcsqHYs0BV1gt+ec==xrdrvgypf95vy2...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Workflow is an area I have almost no experience with. But if you want to look around in the database, look at the *workflowitem* and *workspaceitem*tables. You'll be interested in the *item_id* and *owner* columns. To look up *item_id* by title, you can do SELECT item_id, textvalue FROM metadatavalue WHERE textvalue = 'Your Item Title'. *owner* will have a value corresponding to *eperson_id*, which you can look up in the *eperson* table. Don't forget to make backup of your database before doing any changes! Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Mon, 27 May 2013 12:26:34 +0000 From: "Pottinger, Hardy J." <pottinge...@missouri.edu> Subject: Re: [Dspace-tech] Fwd: [Dspace-devel] Item state definitions To: "<heli...@centrum.sk>" <heli...@centrum.sk> Cc: dspace-tech <dspace-tech@lists.sourceforge.net> Message-ID: <8351f1cd-1013-47d7-a35f-15e0833cc...@missouri.edu> Content-Type: text/plain; charset="us-ascii" In a way, this is a start at documenting our business rules, which is useful work in and of itself, but would be especially useful for building a "business logic layer", which is something many of us have expressed an interest in. As Peter Dietz observed more than a year ago, it is currently up to each interface to implement these rules. My comment at this point is "carry on." But, I should also add, "How can we help?" --Hardy Sent from my iPad On May 27, 2013, at 3:16 AM, "helix84" <heli...@centrum.sk> wrote: > On Mon, May 27, 2013 at 9:52 AM, Andrea Bollini <a.boll...@cineca.it> wrote: >> As I haven't received yet any feedback or comment I'm trying to get more visibility on the tech list. >> Please note that imho it is very important for the consistent of the DSpace data model that we all agree about standard scope and usage of item state. > > > Hi Andrea, > > I think the reason you didn't get feedback is that you're describing > how things should work, while it's not completely clear how it differs > from how things currently work. To get feedback, you should describe > the status quo, why it is not ideal and propose a change. > > For example, I notice that no interface except XMLUI currently doesn't > respects the "discoverable" attribute (the private state). It's clear > that this is a problem. So the proposal should say whether we should > add support to all other interfaces or wait for a more final solution > and what that would be. > > I know this is a lot of work and I appreciate you started looking into > it, thank you. > > > Regards, > ~~helix84 > > Compulsory reading: DSpace Mailing List Etiquette > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > > ---------------------------------------------------------------------- > -------- Try New Relic Now & We'll Send You this Cool Shirt New Relic > is the only SaaS-based application performance monitoring service that > delivers powerful full stack analytics. Optimize and monitor your > browser, app, & servers with just a few lines of code. Try New Relic > and get this awesome Nerd Life shirt! > http://p.sf.net/sfu/newrelic_d2d_may > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------ Message: 3 Date: Mon, 27 May 2013 12:35:49 +0000 From: "Webshet, Sisay (ILRI)" <s.webs...@cgiar.org> Subject: Re: [Dspace-tech] Moving image and bitstream up To: "heli...@centrum.sk" <heli...@centrum.sk> Cc: "dspace-tech@lists.sourceforge.net" <dspace-tech@lists.sourceforge.net> Message-ID: <e85032c6eb6d454884774965c255140111a4a...@ilrietmbx.ilri.cgiarad.org> Content-Type: text/plain; charset="utf-8" REMINDER Hi Heliex, The whole "Filels in this item" section -----Original Message----- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Monday, May 27, 2013 12:16 PM To: Webshet, Sisay (ILRI) Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Moving image and bitstream up On Mon, May 27, 2013 at 11:02 AM, Webshet, Sisay (ILRI) <s.webs...@cgiar.org> wrote: > however I want to bring the image and bitsream to the top of the page. The whole "Files in this item" section or just one of the bitstreams. If so, which one? Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------ Message: 4 Date: Mon, 27 May 2013 14:38:13 +0200 From: helix84 <heli...@centrum.sk> Subject: Re: [Dspace-tech] Moving image and bitstream up To: "Webshet, Sisay (ILRI)" <s.webs...@cgiar.org> Cc: "dspace-tech@lists.sourceforge.net" <dspace-tech@lists.sourceforge.net> Message-ID: <cagdvkqgyva8knytgyqpd-nzkxx+tswvh3qfsjxhomsme9qs...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 https://github.com/DSpace/DSpace/blob/dspace-3.1/dspace-xmlui/src/main/webap p/themes/Mirage/lib/xsl/aspect/artifactbrowser/item-view.xsl#L40 In the itemSummaryView-DIM, move the first three lines down to the end of the template. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------ Message: 5 Date: Mon, 27 May 2013 13:01:37 +0000 From: "Webshet, Sisay (ILRI)" <s.webs...@cgiar.org> Subject: Re: [Dspace-tech] Moving image and bitstream up To: "heli...@centrum.sk" <heli...@centrum.sk> Cc: "dspace-tech@lists.sourceforge.net" <dspace-tech@lists.sourceforge.net> Message-ID: <e85032c6eb6d454884774965c255140111a4a...@ilrietmbx.ilri.cgiarad.org> Content-Type: text/plain; charset="utf-8" Thanks helix84, It works this way http://dspacetest.cgiar.org/handle/10568/25142 -----Original Message----- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Monday, May 27, 2013 3:38 PM To: Webshet, Sisay (ILRI) Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Moving image and bitstream up https://github.com/DSpace/DSpace/blob/dspace-3.1/dspace-xmlui/src/main/webap p/themes/Mirage/lib/xsl/aspect/artifactbrowser/item-view.xsl#L40 In the itemSummaryView-DIM, move the first three lines down to the end of the template. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------ Message: 6 Date: Mon, 27 May 2013 10:21:42 -0300 From: Miguel Angel Robledo <marobl...@santafe.gov.ar> Subject: Re: [Dspace-tech] Change permissions in batch To: heli...@centrum.sk Cc: "DSpace-tech@lists.sourceforge.net" <dspace-tech@lists.sourceforge.net> Message-ID: <51a35de6.9080...@santafe.gov.ar> Content-Type: text/plain; charset=UTF-8; format=flowed Hi, I need to apply it to a number of collections and their associated's elements. I understand that I must do it by SQL because XMLUI only applies to the collection for new items. Is that correct? They have an example of the SQL statement to apply? Thanks -- Ing. Miguel Angel Robledo Infraestructura de Firma Digital Secretar?a de Tecnolog?as para la Gesti?n Ministerio de Gobierno y Reforma del Estado Provincia de Santa Fe San Mart?n 2466 3? Piso (S3000FSB) Santa Fe +54 342 4508700/4574891 int 5132 El 24/05/13 16:18, helix84 escribi?: > If you have more complex needs (e.g. you need to specify a set of > items, not a complete collection), then it's quite easy to do this > using SQL. If this is what you need, feel free to ask for details (and > specify what you need). ------------------------------ Message: 7 Date: Mon, 27 May 2013 15:30:30 +0200 From: helix84 <heli...@centrum.sk> Subject: Re: [Dspace-tech] Change permissions in batch To: Miguel Angel Robledo <marobl...@santafe.gov.ar> Cc: "DSpace-tech@lists.sourceforge.net" <dspace-tech@lists.sourceforge.net> Message-ID: <CAGdvKqhc3h6hCAxPD31OS2Gah3hvWhLLT6yz7jE=akecim2...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 On Mon, May 27, 2013 at 3:21 PM, Miguel Angel Robledo <marobl...@santafe.gov.ar> wrote: > I need to apply it to a number of collections and their associated's > elements. I understand that I must do it by SQL because XMLUI only applies > to the collection for new items. No, there must be something you misunderstood. It's true that collection permissions apply only to new items. However, the wildcard policy admin tools is able to change access policies on all exising items or bitstreams in a specified collection. So I think you can use it. It's safer than SQL. But let us know if you still think it doesn't do what you want. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette ------------------------------ ---------------------------------------------------------------------------- -- Try New Relic Now & We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, & servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may ------------------------------ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech End of DSpace-tech Digest, Vol 85, Issue 121 ******************************************** ------------------------------------------------------------------------------ Try New Relic Now & We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, & servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette