John Preston | 30 Jan 21:07 2015
Picon

Use of DSpace 4.1 SearchService to get SQL like distict query

I am trying to use the SearchService to retrieve all the distinct values of a metadata field for items in a collection. I understand from various posts that solr should have such a capability using facet searches, however I am having a problem wrapping my head around how to use the DiscoverQuery class and search service to get it done. Can anyone point me in the right direction or give me a starting bit of code that would help me.


John 
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Mark H. Wood | 30 Jan 17:07 2015
Picon

How to count submissions within an interval?

I wanted to double-check: given DSpace 4.0 with PostgreSQL, should
this not give me the number of Items submitted in the year 2014?

  SELECT COUNT(*) FROM metadatavalue
   WHERE metadata_field_id =
    (SELECT metadata_field_id FROM metadatafieldregistry
     WHERE metadata_schema_id = 1
     AND element = 'date'
     AND qualifier = 'accessioned')
   AND to_date(text_value,'YYYY-MM-DD') >= '2014-01-01'
   AND to_date(text_value,'YYYY-MM-DD') < '2015-01-01';

-- 
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Andrew Reid | 30 Jan 15:50 2015

Help with mod_jk, SSL, and local authority cert


  Hi all --

  I'm having an issue with a local development copy of DSpace 3.2,
which I set up to try out some development ideas.  It's xmlui.

  What I did was, I copied over a production system, including
the postgres database and LDAP authentication, and all the DSpace
app files, ran the "change-handle-prefix" script, so the dev server
won't screw up the real prefix, and emptied the $DSPACE/handle-server
directory.  

  The copied system duplicates the production set-up in almost
all respects, I'm using an Apache 2.2 front end, running everything 
over SSL, and connecting to Tomcat 6 via the mod_jk mechanism.

  The major difference is, the copied system's Apache server
uses a local server SSL certificate (I'll call it "server.pem"),
which is signed by my own local authority certificate, which
I'll call "authority.pem".

  Anticipating the issue I think I'm having, I configured tomcat
to read the Java keystore in /etc/pki/java/cacerts (I am on 
a CentOS system), and used the "keytool" system to add both
the server.pem and the authority.pem to the Java keystore,
thinking this would allow maximum flexibility for SSL connections
in all directions.

  It mostly works -- I can bring up the home-page, I can log
in, and I can navigate around the communities and collections,
but all the collections appear to be empty.  The communities
and collections correctly show the new, fake handle prefix (I'm 
using "123456789")

  It seems that search is not working, when I load community or
collection pages, pages, I see errors like the one below in 
the  DSpace logs.  The Cocoon logs and
the Apache logs do not show corresponding errors.

> 2015-01-30 09:35:10,673 ERROR
> org.dspace.app.xmlui.aspect.discovery.SidebarFacetsTransformer
>  <at>  Error while searching for sidebar facets
> org.dspace.discovery.SearchServiceException:
> javax.net.ssl.SSLHandshakeException:
> sun.security.validator.ValidatorException: PKIX path building failed:
> sun.security.provider.certpath.SunCertPathBuilderException: unable to
> find valid certification path to requested target

  The actual items *are* present in the system, if I navigate to a 
specific item, https://<host>/dspace/xmlui/handle/123456789/≤item-id>,
then I can view the item, and the bitstreams, and it's fine, I 
can view them directly, I just can't browse or search to them.

  So apparently solr connections are not working.

  Evidently there's some subtlety associated with the SSL 
authority cert that I'm missing -- does authority.pem need to 
be added to some other keystore somewhere?  Does it only work
for real, Verisign-type certs?  What's going on?

  Thanks in advance.

				-- A.
--

-- 
Dr. Andrew C. E. Reid
Physical Scientist, Computer Operations Administrator
Center for Theoretical and Computational Materials Science
National Institute of Standards and Technology, Mail Stop 8555
Gaithersburg MD 20899 USA
andrew.reid@...

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Joseph Greene | 30 Jan 10:57 2015
Picon

Bulk withdraw tool?

Hi,

I have a list of item_ids based on an sql query, e.g.

item_id
----------
2
3
15
23
...
(582 rows)

I'd like to withdraw the items from DSpace. I assume it isn't safe to just
change the item.withdrawn field to 'true' (side effects for solr, oai_pmh,
etc). Is this correct?

Does anyone have or know of a tool to withdraw these via the command line?
After looking I only found the bulk metadata edit tool, but these items are
scattered across several collections.

Best regards,
Joseph

Joseph Greene
Research Repository Librarian
James Joyce Library
University College Dublin
(353 0)1 716 7398
joseph.greene@...
http://researchrepository.ucd.ie

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Steven Hayles | 30 Jan 10:26 2015
Picon
Picon

Best approach to bulk delete empty collections (DSpace 4.2)


Hi

We have a DSpace 4.2 instance with many empty collections. What's the best 
approach to finding and deleting them?

Thanks

Steven Hayles
Systems Analyst

IT Services, University of Leicester,
Propsect House, 94 Regent Rd, Leicester, LE1 7DA, UK

T: +44 (0)116 229 7950
E: sh23@...

The Queen's Anniversary Prizes 1994, 2002 & 2013
THE Awards Winners 2007-2013

Elite without being elitist

Follow us on Twitter http://twitter.com/uniofleicester or
visit our Facebook page https://facebook.com/UniofLeicester

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Alexander Wong | 30 Jan 05:37 2015
Picon

More question on Stats logging on DSpace-CRIS 4.1.2

Dear DSpace Community,

WIth Pablo, HKU and CINECA's help, many of the cases were resolved.

Sadly, I am coming back with more questions... on logs.

1. It seems project/ou/rp views are not successfully logged to the dspace.log (which in turn affects the stats report in dspace admin pages)
These are the logs obtained from the dspace.log.2015-01-30 when I browse a project/ou/rp
2015-01-30 12:30:16,450 INFO  org.dspace.usage.LoggerUsageEventListener <at> anonymous:session_id=C8DECB471C6F22310099CE06176C3441:ip_add:203.168.161.234::
2015-01-30 12:30:19,133 INFO  org.dspace.usage.LoggerUsageEventListener <at> anonymous:session_id=C8DECB471C6F22310099CE06176C3441:ip_add:203.168.161.234::
2015-01-30 12:30:25,650 INFO  org.dspace.usage.LoggerUsageEventListener <at> anonymous:session_id=C8DECB471C6F22310099CE06176C3441:ip_add:203.168.161.234::

I am trying to make changes (appending log.info) to 
ResearcherPageDetailsController.java OUDetailsController.java but seems no luck.

2. I just realized monthly reports have a lot of weird strings
jar 1,622
file 1,086
//localhost 882
41 810
56; debug? true; trace 566

I believed these will need another level of coding clean up to make things usable again.
One concern of mine would be -
2015-01-30 06:30:19,994 WARN  org.hibernate.hql.internal.ast.HqlSqlWalker <at> [DEPRECATION] Encountered positional parameter near line 1, column 64.  Positional parameter are considered deprecated; use named parameters or JPA-style positional parameters instead.

Do I need to pay attention to this line?

THanks,
Alexander Wong






------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Bruno Zanette | 29 Jan 23:38 2015
Picon

Examples of REST-API POST/PUT requests using cURL

Hey,

I was doing some tests to prepare myself to write API's documentation,
and to make it easier i've wrote some short scripts that implement all
POST/PUT requests. It contains a script to execute each request, and
descriptor files that describes each request (Verb, Action, and the
request form itself).

It's not very useful but it may help people that are struggling to use
REST-API until the documentation is not ready.

The files are stored at this Git project:
https://gitlab.c3sl.ufpr.br/bnzanette/dspace-rest-requests

--

-- 
Bruno Nocera Zanette
+55 41 9992-2508

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Maureen P. Walsh | 29 Jan 20:54 2015
Picon

DEADLINE EXTENDED: DSpace Interest Group OR2015 Proposals Now Due on February 6, 2015

DEADLINE EXTENDED to February 6, 2015
Call for Proposals - DSpace Interest Group at Open Repositories 2015


Conference Theme: LOOKING BACK, MOVING FORWARD: OPEN REPOSITORIES AT THE CROSSROADS
Conference Dates: June 8-11, 2015
Conference Location: Indianapolis, Indiana
Conference Website: http://www.or2015.net/

Important dates

EXTENDED to 6 February 2015: Deadline for proposal submissions
10 April 2015: Submitters notified of acceptance to interest groups
8-11 June 2015: Conference program


The DSpace Interest Group program committee invites your contributions to OR2015, whether you’re a developer, researcher, repository manager, administrator or practitioner. We invite one to two-page proposals that focus on the use of the DSpace platform and that describe novel experiences or developments in the construction and use of DSpace repositories. Presentation formats could include panels, tutorials, facilitated round table discussions, stories, or presentations of varying length. Please indicate the preferred format in your proposal.


Specific areas of interest for OR2015:


·         Supporting Open Scholarship, Open Science, and Cultural Heritage Online

·         Managing Research (and Open) Data

·         Integrating with External Systems

·         Re-using Repository Content

·         Exploring Metrics and Assessment

·         Managing Rights

·         Developing and Training Staff

·         Building the Perfect Repository

  

Submitting your proposal:


Submit your proposal here: https://www.conftool.com/or2015/ by Feb. 6, 2015


For inquiries, please contact the DSpace Interest Group Chair, Maureen Walsh at walsh.260 <at> osu.edu


We look forward to receiving your proposals!


Maureen Walsh

Institutional Repository Services Librarian

The Ohio State University Libraries

 

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Juanfra Magrini | 29 Jan 19:23 2015
Picon

post in this list


------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Helge Opedal | 29 Jan 14:15 2015
Picon
Picon

Problem with DSpace API POST request creating a new community

Hi,
I am trying to batch create communities in DSpace from command line on a 
Redhat server. The server is a RHEL6 and the installation is a vanilla 
DSpace 4.2.

I am able to get information about existing Communitites in my DSpace 
installation with a curl command like this:
curl -i -H "user:username@..." -H "pass:XXXXXX" -H 
"Content-Type: text/xml" -X GET "http://localhost:8080/rest/communities"

The result is given out:
> [{"id":1,"name":"IT 
> avdelingen","handle":"123456789/1","type":"community","link":"/rest/communities/1","expand":["parentCommunity","collections","subCommunities","log
> o","all"],"logo":null,"parentCommunity":null,"copyrightText":"","introductoryText":"felles","shortDescription":"ITA","sidebarText":"","countItems":1,"collections":[],
> "subcommunities":[]}]

But, when I try to POST data, I can understand how it should be done.
I am trying to do something like this:

> curl -X POST -i -H "user:username@..." -H "pass:XXXXXXX" 
> -H "Content-Type: application/json" -d "{'communityId':'1','name':'A 
> test community','shortDescription':'Community created with JSON'}" 
> "http://localhost:8080/rest/communities"

which might not be the correct way. I have tried others also. The answer 
from Tomcat is:

> HTTP/1.1 405 Method Not Allowed
> Server: Apache-Coyote/1.1
> Allow: GET,OPTIONS,HEAD
> Content-Type: text/html;charset=utf-8
> Content-Length: 1034
> Date: Thu, 29 Jan 2015 13:13:12 GMT
>
> <html><head><title>Apache Tomcat/6.0.24 - Error 
> report</title><style><!--H1 
>
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} 
> H2 
>
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} 
> H3 
>
{font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} 
> BODY 
> {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} 
> B 
> {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} 
> P 
> {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A 
> {color : black;}A.name {color : black;}HR {color : 
> #525D76;}--></style> </head><body><h1>HTTP Status 405 - Method Not 
> Allowed</h1><HR size="1" noshade="noshade"><p><b>type</b> Status 
> report</p><p><b>message</b> <u>Method Not 
> Allowed</u></p><p><b>description</b> <u>The specified HTTP method is 
> not allowed for the requested resource (Method Not 
> Allowed).</u></p><HR size="1" noshade="noshade"><h3>Apache 
> Tomcat/6.0.24</h3></body></html>

The documentation that I try to follow (and understand) is this one:
* https://jspace.atlassian.net/wiki/display/DSPACEAPI/POST_communities

Can someone please point me in the right direction in how to be able to 
POST to DSpace API to be able to create communities (and other elements 
later on)?

My goal is to be able to create from another data source maybe a couple 
of hundreds or thousands communities in 1 DSpace installation, and I can 
not do this by the xmlui web interface, because it would take way to 
much time.

Thank you very much,

best regards,

Helge
University of Bergen
Norway

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Massimiliano Cilurzo | 29 Jan 13:19 2015
Picon

Mirage 2

Dear All,

  We have just installed DSPACE 5.0 on our test environment, and we would like to use the Mirage 2 theme.

But after  installing it we have this problem:

Syntax error: File to import not found or unreadable: ../vendor/bootstrap-sass-official/assets/stylesheets/bootstrap.

              Load paths:

                Compass::SpriteImporter

                /usr/local/src/dspace-5.0-src-release/dspace/modules/xmlui-mirage2/target/themes/Mirage2/styles

                /usr/local/src/dspace-5.0-src-release/dspace/modules/xmlui-mirage2/target/rubygems/gems/compass-core-1.0.3/stylesheets

        on line 16 of styles/main.scss

Could someone help us?

Thanks

Best regards

Massimiliano Cilurzo

 

 

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/

Gmane