Re: [Dspace-tech] Thumbnails for Flash FLA and SWF
On Thu, Jul 05, 2007 at 07:13:37PM -0400, Henrik De Gyor wrote: Could DSpace display a keyframe/thumbnail/preview of a Adobe Flash .fla or .swf file inside the DAM? Theoretically, yes. Much like there is a MediaFilter plugin to generate image thumbnails, if you write one that is capable of extracting a thumbnail from a Flash movie, then it should be easy. This will presumably require the existance of a Java library that understands Flash (I have no idea if such a thing exists, but I assume it does). cheers, Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as HP CONFIDENTIAL. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Any plans for result sorting in 1.5?
Hi Does anyone know if there are plans to incorporate results sorting in the next release? Cheers Charlie -- Gall y neges e-bost hon, ac unrhyw atodiadau a anfonwyd gyda hi, gynnwys deunydd cyfrinachol ac wedi eu bwriadu i'w defnyddio'n unig gan y sawl y cawsant eu cyfeirio ato (atynt). Os ydych wedi derbyn y neges e-bost hon trwy gamgymeriad, rhowch wybod i'r anfonwr ar unwaith a dilëwch y neges. Os na fwriadwyd anfon y neges atoch chi, rhaid i chi beidio â defnyddio, cadw neu ddatgelu unrhyw wybodaeth a gynhwysir ynddi. Mae unrhyw farn neu safbwynt yn eiddo i'r sawl a'i hanfonodd yn unig ac nid yw o anghenraid yn cynrychioli barn Prifysgol Cymru, Bangor. Nid yw Prifysgol Cymru, Bangor yn gwarantu bod y neges e-bost hon neu unrhyw atodiadau yn rhydd rhag firysau neu 100% yn ddiogel. Oni bai fod hyn wedi ei ddatgan yn uniongyrchol yn nhestun yr e-bost, nid bwriad y neges e-bost hon yw ffurfio contract rhwymol - mae rhestr o lofnodwyr awdurdodedig ar gael o Swyddfa Cyllid Prifysgol Cymru, Bangor. www.bangor.ac.uk This email and any attachments may contain confidential material and is solely for the use of the intended recipient(s). If you have received this email in error, please notify the sender immediately and delete this email. If you are not the intended recipient(s), you must not use, retain or disclose any information contained in this email. Any views or opinions are solely those of the sender and do not necessarily represent those of the University of Wales, Bangor. The University of Wales, Bangor does not guarantee that this email or any attachments are free from viruses or 100% secure. Unless expressly stated in the body of the text of the email, this email is not intended to form a binding contract - a list of authorised signatories is available from the University of Wales, Bangor Finance Office. www.bangor.ac.uk - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Any plans for result sorting in 1.5?
On Fri, Jul 06, 2007 at 02:21:08PM +0100, Charlotte Pollock wrote: Does anyone know if there are plans to incorporate results sorting in the next release? The configurable browse work from Richard Jones (which I'm pretty sure includes more powerful sorting for browse) will be included in 1.5. I don't think there are any plans to change the behaviour of search results though. cheers, Jim -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as HP CONFIDENTIAL. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] DSpace Oracle statement pool
Hi , could someone confirms to me that the right thing to do for being able to import large amount of items in DSpace with Oracle, without having the open cursors limit problem, is to set the db.statementpool to false in dspace.cfg (if, for instance, we cannot raise the cursor limit to a very large number in Oracle) ? Thanks a lot. - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Checksum checker not working
On Thu, 2007-07-05 at 17:40 +0100, Jim Downing wrote:
Hi Rafa,
Rafa Carreres wrote:
Running [dspace-src]/bin/checker, I get this error:
Exception in thread main java.lang.RuntimeException: Problem
inserting missing bitstreams. ORA-00911: invalid character
at
org.dspace.checker.BitstreamInfoDAO.updateMissingBitstreams(BitstreamInfoDAO.java:300)
at
My configuration: Dspace 1.4.1 and Oracle. Previously, I have done a
cleanup of the system.
Any idea?
The query being run there is a fairly involved chunk of SQL
(BitstreamInfoDAO.INSERT_MISSING_CHECKSUM_BITSTREAMS). I can't see any
particularly unusual characters in there, so I'd guess that the
timestamp parameters set in .updateMissingBitstreams() are causing the
problem. If you can log the exact query that's being run at the Oracle
end that might give you a clue. Anyone with Oracle-fu able to shed any
light here?
Yep, the checker is pretty bust for Oracle - it's using boolean types,
and LIMIT keyword that don't exist in Oracle.
I've attached a patch to resolve these issues - it's a bit hacky, simply
adding additional variants of the query and switching based on the
configuration parameter (it's going to take too long to properly
Interface the DAOs).
Although, when I was debugging it, the particular invalid character
issue appeared to be the '?' for paramters... but Oracle supports that.
It may just be a quirk of trying to interactively debug the query, and
the PreparedStatement may have actually been falling over on the
comparison of a numeric field to true / false.
Anyway, patch (generated from/against the current 1.4.x branch) is
attached.
G
This email has been scanned by Postini.
For more information please visit http://www.postini.com
Index: src/org/dspace/checker/BitstreamInfoDAO.java
===
--- src/org/dspace/checker/BitstreamInfoDAO.java (revision 2043)
+++ src/org/dspace/checker/BitstreamInfoDAO.java (working copy)
@@ -43,6 +43,7 @@
import java.util.List;
import org.apache.log4j.Logger;
+import org.dspace.core.ConfigurationManager;
import org.dspace.storage.rdbms.DatabaseManager;
/**
@@ -98,6 +99,21 @@
+ select 'x' from most_recent_checksum
+ where most_recent_checksum.bitstream_id = bitstream.bitstream_id );;
+private static final String INSERT_MISSING_CHECKSUM_BITSTREAMS_ORACLE = insert into most_recent_checksum (
++ bitstream_id, to_be_processed, expected_checksum, current_checksum,
++ last_process_start_date, last_process_end_date,
++ checksum_algorithm, matched_prev_checksum, result )
++ select bitstream.bitstream_id,
++ CASE WHEN bitstream.deleted = 0 THEN 1 ELSE 0 END,
++ CASE WHEN bitstream.checksum IS NULL THEN '' ELSE bitstream.checksum END,
++ CASE WHEN bitstream.checksum IS NULL THEN '' ELSE bitstream.checksum END,
++ ?, ?, CASE WHEN bitstream.checksum_algorithm IS NULL
++ THEN 'MD5' ELSE bitstream.checksum_algorithm END, 1,
++ CASE WHEN bitstream.deleted = 1 THEN 'BITSTREAM_MARKED_DELETED' else 'CHECKSUM_MATCH' END
++ from bitstream where not exists(
++ select 'x' from most_recent_checksum
++ where most_recent_checksum.bitstream_id = bitstream.bitstream_id );;
+
/**
* Query that updates most_recent_checksum table with checksum result for
* specified bitstream ID.
@@ -123,6 +139,11 @@
+ order by date_trunc('milliseconds', last_process_end_date),
+ bitstream_id + ASC LIMIT 1;
+public static final String GET_OLDEST_BITSTREAM_ORACLE = SELECT bitstream_id FROM (select bitstream_id
++ from most_recent_checksum + where to_be_processed = 1
++ order by date_trunc('milliseconds', last_process_end_date),
++ bitstream_id + ASC) WHERE rownum=1;
+
/**
* Selects the next bitstream in order of last processing end date, ensuring
* that no bitstream is checked more than once since the date parameter
@@ -135,6 +156,13 @@
+ order by date_trunc('milliseconds', last_process_end_date),
+ bitstream_id + ASC LIMIT 1;
+public static final String GET_OLDEST_BITSTREAM_DATE_ORACLE = SELECT bitstream_id FROM (select bitstream_id
++ from most_recent_checksum
++ where to_be_processed = 1
++ and last_process_start_date ?
++ order by date_trunc('milliseconds', last_process_end_date),
++ bitstream_id + ASC) WHERE rownum=1;
+
/** SQL query to retrieve bitstreams for a given item. */
private static final String ITEM_BITSTREAMS = SELECT b2b.bitstream_id
+ FROM bundle2bitstream b2b, item2bundle i2b WHERE
@@ -284,7 +312,10 @@
{
LOG.debug(updating missing bitstreams);
conn = DatabaseManager.getConnection();
-stmt =
[Dspace-tech] Auto Focus Script for Login
Hey everyone, Has anyone ever used a java script to auto focus on the email address field on login-form.jsp? I've included the java script, but it doesn't appear to be working. e.g. script language=JavaScript type=text/javascriptdocument.application.tlogin_email.focus();/scrip t Jake -- Jake Cameron, BCSc(UNB) Technical Specialist III Library Systems and Web Services University of Lethbridge Phone: (403) 329-2756 Office: L1110C Email: [EMAIL PROTECTED] - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Auto Focus Script for Login
Figured out where I went wrong. Forgot to add id=application to the form tag. -- Jake Cameron, BCSc(UNB) Technical Specialist III Library Systems and Web Services University of Lethbridge Phone: (403) 329-2756 Office: L1110C Email: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cameron, Jacob Sent: Friday, July 06, 2007 2:20 PM To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] Auto Focus Script for Login Hey everyone, Has anyone ever used a java script to auto focus on the email address field on login-form.jsp? I've included the java script, but it doesn't appear to be working. e.g. script language=JavaScript type=text/javascriptdocument.application.tlogin_email.focus();/scrip t Jake -- Jake Cameron, BCSc(UNB) Technical Specialist III Library Systems and Web Services University of Lethbridge Phone: (403) 329-2756 Office: L1110C Email: [EMAIL PROTECTED] - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
