[Dspace-tech] Best practices for scripted metadata modifications

2007-09-11 Thread Mathias Hjelt
We have a few metadata maintenance related tasks (e.g. scan through the metadata of items changed since last run and make sure the metadata complies to certain rules) that we want to automate with scheduled tasks. As I see it we have the following options: - shell / perl scripts that use psql and

Re: [Dspace-tech] Database question

2007-09-11 Thread Bernadette Schlonsok
Hello Mika, this error says, you have duplicated values in a column with unique index. For DSpace 1.4 you can check all unique index as follow: select name, count(*) from epersongroup group by name having count(*)1; select short_description, count(*) from BitstreamFormatRegistry group by

Re: [Dspace-tech] Best practices for scripted metadata modifications

2007-09-11 Thread James Rutherford
On Tue, Sep 11, 2007 at 09:39:05AM +0300, Mathias Hjelt wrote: I guess using the API would be the safest way to access the metadata, but I'm wondering if it's overkill for operations that could easily be carried out with a small number of relatively simple SQL statements in a script. On the

Re: [Dspace-tech] [Dspace-general] Failure on new 1.4.2 ant fresh_install

2007-09-11 Thread Christian Voelker
Hello, Am 11.09.2007 um 09:31 schrieb Munro, LG, Mr [EMAIL PROTECTED]: Hi George, Ant is on version 1.6.5-3 and apache on 2.0.55-4 Java version is: java-1.5.0-sun Any ideas? I reread your Error message. ant is not capable to solve the regular expression on line 88 of build.xml. Before, I

Re: [Dspace-tech] Problem with statistics

2007-09-11 Thread Graham Triggs
Hi, Well, the relevant part of this is the only thing that's not in English!! But the context is clear enough - it's having trouble parsing a valid date. Can you confirm that the start / end dates that you are passing to the script are of the form '-mm-dd'. If your input is valid, then

[Dspace-tech] Cannot view thumbnails

2007-09-11 Thread Hlias Stavrakis
Hi, with ItemImporter tool i specify a jpg bitstream to belong to ORIGINAL bundle and a second image to THUMBNAILS bundle. The ingesting works fine but the thumbnail is not shown. Has anyone any suggestion or idea why this happens? A have set in dspace.cfg file the following properties:

[Dspace-tech] DSpace OAI

2007-09-11 Thread Mika Stenberg
If I restrict access to a collection / community in DSpace, does the restrictions also apply on the data that can be accessed through OAI? Thanks, Mika - This SF.net email is sponsored by: Microsoft Defy all challenges.

Re: [Dspace-tech] DSpace OAI

2007-09-11 Thread Paul Needham
Hi Mika No, as things stand the OAI interface will show all items regardless of any access restrictions you set. Cheers Paul Paul A S Needham Electronic Information Specialist Kings Norton Library Cranfield University -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [Dspace-tech] DSpace OAI

2007-09-11 Thread Claudia Jürgen
Hi Mika, no, the metadata of every item is visible through OAI regardless of restrictions. Claudia Mika Stenberg schrieb: If I restrict access to a collection / community in DSpace, does the restrictions also apply on the data that can be accessed through OAI? Thanks, Mika

Re: [Dspace-tech] Problem with statistics

2007-09-11 Thread Andrea Garrido Fernández
Sorry, I have realized that the query that doesn't work is : SELECT COUNT(*) AS num FROM item WHERE in_archive = 1 AND withdrawn = 0 AND item_id IN ( SELECT item_id FROM metadatavalue WHERE metadata_field_id = ( SELECT metadata_field_id FROM metadatafieldregistry WHERE element = 'date'

Re: [Dspace-tech] Problem with statistics

2007-09-11 Thread Graham Triggs
Andrea, It looks like this is an optimizer issue in Oracle - ie. that it is applying the TO_TIMESTAMP to all the records first, rather than just those that match the metadata_field_id. I've tried rewriting the query so that it uses an inline view to obtain all the metadata records for the date

Re: [Dspace-tech] Problem with statistics

2007-09-11 Thread Andrea Garrido Fernández
Thank you, I´ve solved it! The problem was that in LogAnalyser.java there were two if clauses in a wrong order, i.e, I changed in the method public static Integer getNumItems(Context context, String type) these if clauses: if (type != null) { query.append( AND item_id IN (

[Dspace-tech] Problem with indexing 1.4.2 (update)

2007-09-11 Thread George Kozak
Hi... This is an update to the indexing problem that I wrote about a problem with DSpace 1.4.2 When I did an index-all, I got the following error: Indexing all Items in DSpaceERROR: Relation dctyperegistry does not exist Several people suggested that I had a CLASSPATH problem. Sure