Hi Layale
This might be a good starting point:
http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips
Cheers
hg
*Hilton Gibson*
Ubuntu Linux Systems Administrator
JS Gericke Library
Room 1025C
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
On 22 January 2015 at 12:48, Layale Bassil <l...@aub.edu.lb> wrote:
> Thank you so much Terry,
>
>
>
> I will have a look at this tool. But I need to know if there is any way I
> can have a list of all items imported to dspace that do not have any
> bitsream (0 added files). A reporting tool? A query to run on the database?
>
>
>
> Your help is very much appreciated.
>
> Regards.
>
>
>
>
>
> *From:* Terry Brady [mailto:terry.br...@georgetown.edu]
> *Sent:* Thursday, January 22, 2015 8:15 AM
> *To:* Layale Bassil
> *Cc:* dspace-tech@lists.sourceforge.net
> *Subject:* Re: [Dspace-tech] Authorization of DSpace items...
>
>
>
> In XMLUI, there is a tool that will let you apply bulk changes to
> permissions.
>
>
>
> Administrative -> Authorizations -> Advanced Authorizations Tool
>
>
>
> I have only used it a couple of times, but it was very handy when I used
> it.
>
>
>
> On Wed, Jan 21, 2015 at 7:41 AM, Layale Bassil <l...@aub.edu.lb> wrote:
>
> Hello All,
>
>
>
> As far as I know, authorizations in DSpace are usually set for a
> community, or collection, or even at the item level. If we setup the
> authorization for a collection, then we load data, all items inherit that
> setup before loading, and we cannot globally change the authorization for
> those items.
>
>
>
> Currently, on the DSpace instance I am working on (version 4.2), all item
> bitstreams are not accessible by users; however, I need to change the
> authorization of those bitstreams to be (Anonymous) according to the
> publication date.
>
>
>
> How can this be done? Is there any add-on that can help me changing the
> access authorization of an item bitstream? Or any script to do so on a set
> of items instead of going at each item?
>
>
>
> Your help is very much appreciated.
>
> Regards.
>
>
>
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> 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
>
>
>
>
>
> --
>
> Terry Brady
>
> Applications Programmer Analyst
>
> Georgetown University Library Information Technology
>
> https://www.library.georgetown.edu/lit/code
>
> 425-298-5498
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> 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
>
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
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
