Re: [Dspace-tech] inser/delete into the metadatavalue table
yes, it works
This is the same method used in the API
Andrea
Jose Blanco ha scritto:
> Andrea:
> In looking at the dspace code, it seems like I could use this SQL:
>
> SELECT getnextid(metadatavalue)
>
> And then issue and insert into metadavalue values ( ... ) using the
> metadata_value_id I get from the SELECT statement.
>
> Will this also work?
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrea
> Bollini
> Sent: Thursday, April 05, 2007 3:58 AM
> To: Jose Blanco
> Cc: dspace-tech@lists.sourceforge.net
> Subject: Re: [Dspace-tech] inser/delete into the metadatavalue table
>
> Hi Jose,
> you can of course add metadata with a java script using DSpace API
> without any problems. If you want add metadata from sql script you need
> only to reset the metadata sequence at the end of your script.
> SELECT setval('metadatavalue_seq', max(metadata_value_id)) FROM
> metadatavalue;
> SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue;
> Of course you need also to run index-all at the end.
> Best wishes,
> Andrea
>
> PS: deleting metadata doesn't require sequence update
>
> Jose Blanco ha scritto:
>
>> I sent this question out a few days ago, and did not hear anything.
>> If some one has some info on it, could you let me know.
>>
>>
>>
>> Thanks!
>>
>>
>>
>>
>>
>> *From:* [EMAIL PROTECTED]
>> [mailto:[EMAIL PROTECTED] *On Behalf Of *Jose
>> Blanco
>> *Sent:* Monday, April 02, 2007 12:53 PM
>> *To:* dspace-tech@lists.sourceforge.net
>> *Subject:* [Dspace-tech] inser/delete into the metadatavalue table
>>
>>
>>
>> I have a big chunk of items I would like to add and delete metadata
>> to. Previously I have updated the metadatavalue table when I have
>> just wanted to do updates to certain metadata values, and then ran
>> index-all, but I have never done inserts and deletes to this table via
>> a script, and I want to make sure this will not cause any problems.
>> Could some one let me know if this is safe to do?
>>
>>
>>
>> Thanks!
>>
>>
>>
>> Jose
>>
>>
>>
>> -
>> Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>
> your
>
>> opinions on IT & business topics through brief surveys-and earn cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>
>>
>> ___
>> DSpace-tech mailing list
>> DSpace-tech@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>>
>>
>
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
>
>
>
>
>
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] redirect port 8443 to 80?
Hello, I'm following the Dspace wiki page DspaceOnStandardPorts and ServletSecurity to run Dspace on Tomcat only. I've set up iptables to route port 80 to 8080 and 443 to 8443, then set the Tomcat redirectPort to 443 instead of 8443, so I don't get the 8443 port number such as https://laii-dspace.unm.edu:8443 at the browser address bar, but then when I click the DSpace logo from a secured page such as https://laii-dspace.unm.edu/password-login all the following pages are through https regardless of which the page is, which bothers me. But when I tried to click the dspace logo from the mit dspace page https://dspace.mit.edu/password-login the request to the https://dspace.mit.edu/ seems to be rerouted to http://dspace.mit.edu/. So what's the trick? Thanks, Zhiwu - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Collection submitters
Hi! Claudia, I upgraded from 1.3 to 1.4.1. Few months back i selected an e-person to be deleted from a group. But the second e-person was deleted. Today it happened again. I have not tested this on fresh installation of 1.4.1. Any idea whether this is rectified in 1.4.1. (1) Is there any facts to be taken care when going for a fresh installation of 1.4.1 where 1.3 is installed successfully. Using different folders will be okay. (2) deleting 1.3 source and instalaltion and then going for fresh installation of 1.4 is better. please suggest. Thanks, Jayan From: Claudia Jürgen [mailto:[EMAIL PROTECTED] Sent: Thu 4/5/2007 5:16 PM To: Jayan Chirayath Kurian Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Collection submitters Hi Jayan, was your DSpace instance once on 1.2.*? If so, your problems might be related with: Bug: http://sourceforge.net/tracker/index.php?func=detail&aid=1638565&group_id=19984&atid=119984 Patch: http://sourceforge.net/tracker/index.php?func=detail&aid=1638565&group_id=19984&atid=119984 This will only work, if you have not modified/added admin/submitters in between. Claudia Jayan Chirayath Kurian schrieb: > Hi! > > > > (1) In Dspace 1.4.1 a collection was created and tried adding collection > submitters through edit collection interface - edit button. Clicking > "Select E-people" enabled the e-person menu. But when clicked on "add" > button, the Dspace status bar shows "error on page". Scripting is > enabled. > > > > (2) In Dspace admin tools- Groups, for a user defined group, adding an > e-person to the group deletes the e-persons existing in the group. The > Dspace status bar shows "error on page". Removing existing users is not > happening with the Administration group but cannot add new e-person to > any group including the Administration group. In this case also the > Dspace status bar shows "error on page". > > > > Please suggest. > > > > Thanks, > > Jayan > > > > > > > > > - > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > > > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] inser/delete into the metadatavalue table
Andrea:
In looking at the dspace code, it seems like I could use this SQL:
SELECT getnextid(metadatavalue)
And then issue and insert into metadavalue values ( ... ) using the
metadata_value_id I get from the SELECT statement.
Will this also work?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrea
Bollini
Sent: Thursday, April 05, 2007 3:58 AM
To: Jose Blanco
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] inser/delete into the metadatavalue table
Hi Jose,
you can of course add metadata with a java script using DSpace API
without any problems. If you want add metadata from sql script you need
only to reset the metadata sequence at the end of your script.
SELECT setval('metadatavalue_seq', max(metadata_value_id)) FROM
metadatavalue;
SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue;
Of course you need also to run index-all at the end.
Best wishes,
Andrea
PS: deleting metadata doesn't require sequence update
Jose Blanco ha scritto:
>
> I sent this question out a few days ago, and did not hear anything.
> If some one has some info on it, could you let me know.
>
>
>
> Thanks!
>
>
>
>
>
> *From:* [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] *On Behalf Of *Jose
> Blanco
> *Sent:* Monday, April 02, 2007 12:53 PM
> *To:* dspace-tech@lists.sourceforge.net
> *Subject:* [Dspace-tech] inser/delete into the metadatavalue table
>
>
>
> I have a big chunk of items I would like to add and delete metadata
> to. Previously I have updated the metadatavalue table when I have
> just wanted to do updates to certain metadata values, and then ran
> index-all, but I have never done inserts and deletes to this table via
> a script, and I want to make sure this will not cause any problems.
> Could some one let me know if this is safe to do?
>
>
>
> Thanks!
>
>
>
> Jose
>
>
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] inser/delete into the metadatavalue table
Andrea:
I'm running 1.4.1 and so dcvalue is a view in this version. So I don't
think I have to use this command :
SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue
Right?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrea
Bollini
Sent: Thursday, April 05, 2007 3:58 AM
To: Jose Blanco
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] inser/delete into the metadatavalue table
Hi Jose,
you can of course add metadata with a java script using DSpace API
without any problems. If you want add metadata from sql script you need
only to reset the metadata sequence at the end of your script.
SELECT setval('metadatavalue_seq', max(metadata_value_id)) FROM
metadatavalue;
SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue;
Of course you need also to run index-all at the end.
Best wishes,
Andrea
PS: deleting metadata doesn't require sequence update
Jose Blanco ha scritto:
>
> I sent this question out a few days ago, and did not hear anything.
> If some one has some info on it, could you let me know.
>
>
>
> Thanks!
>
>
>
>
>
> *From:* [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] *On Behalf Of *Jose
> Blanco
> *Sent:* Monday, April 02, 2007 12:53 PM
> *To:* dspace-tech@lists.sourceforge.net
> *Subject:* [Dspace-tech] inser/delete into the metadatavalue table
>
>
>
> I have a big chunk of items I would like to add and delete metadata
> to. Previously I have updated the metadatavalue table when I have
> just wanted to do updates to certain metadata values, and then ran
> index-all, but I have never done inserts and deletes to this table via
> a script, and I want to make sure this will not cause any problems.
> Could some one let me know if this is safe to do?
>
>
>
> Thanks!
>
>
>
> Jose
>
>
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Deleting items
Im creating a Java code for deleting all items under a collection. Sometimes when deleting an item I get a message saying: Exception: IndexReader out of date and no longer valid for delete, undelete, or setNorm operations Does Anyone know what is causing? I guess it is Lucene related? Thanks, -Mika - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Migrating data from Postgres to Oracle in DSpace 1.4.1
On Thu, 2007-04-05 at 11:39 +1000, Shaun Burriss wrote: > We are about to upgrade our DSpace installation from 1.3.1 to 1.4.1 and > also want to move our data from the Postgres database to an Oracle > database. What things should we be aware of when doing this data > migration? What are the steps involved? Hi Shaun, To be honest, migrating to an Oracle database with 1.4.1 is probably not a good idea. At the moment, the 1.4.1 release has a number of known issues with it's Oracle support - fixes for which are currently being tested with a view to release as 1.4.2. Beyond that, the existing schema definition for Oracle uses VARCHAR2(2000) in place of Postgres' TEXT columns. This means that many fields - importantly, all the metadata values and license text - is limited to a maximum of 2000 characters. It is likely that this would cause problems with any attempted conversion. Again, one of the Oracle patches allows the use of CLOB columns, and a schema patch exists that makes use of them in the key fields (for example, metadata). This schema change isn't 100% perfect, as the browse tables need to retain the use of VARCHAR2 columns for ORDERing support - although it is highly unlikely that this would cause a problem in practise. > Also, should the migration to Oracle take place before or after our > DSpace update? Changing VARCHAR2 columns to CLOBs is a rather involved process, and my advice here would be to only start using Oracle with a DSpace that supports the use of CLOBs, and to start with a schema that uses CLOB columns where necessary/possible before you migrate the data in. In practise, I would therefore suggest that you upgrade to 1.4.1 on your Postgres database, and then migrate to Oracle after 1.4.2 is released. G -- Graham Triggs Technical Architect Open Repository Tel: +44 (0)20 7631 9942 Skype: grahamtriggs This email has been scanned by Postini. For more information please visit http://www.postini.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Collection submitters
Hi Jayan, was your DSpace instance once on 1.2.*? If so, your problems might be related with: Bug: http://sourceforge.net/tracker/index.php?func=detail&aid=1638565&group_id=19984&atid=119984 Patch: http://sourceforge.net/tracker/index.php?func=detail&aid=1638565&group_id=19984&atid=119984 This will only work, if you have not modified/added admin/submitters in between. Claudia Jayan Chirayath Kurian schrieb: > Hi! > > > > (1) In Dspace 1.4.1 a collection was created and tried adding collection > submitters through edit collection interface - edit button. Clicking > "Select E-people" enabled the e-person menu. But when clicked on "add" > button, the Dspace status bar shows "error on page". Scripting is > enabled. > > > > (2) In Dspace admin tools- Groups, for a user defined group, adding an > e-person to the group deletes the e-persons existing in the group. The > Dspace status bar shows "error on page". Removing existing users is not > happening with the Administration group but cannot add new e-person to > any group including the Administration group. In this case also the > Dspace status bar shows "error on page". > > > > Please suggest. > > > > Thanks, > > Jayan > > > > > > > > > - > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > > > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Collection submitters
Hi! (1) In Dspace 1.4.1 a collection was created and tried adding collection submitters through edit collection interface - edit button. Clicking "Select E-people" enabled the e-person menu. But when clicked on "add" button, the Dspace status bar shows "error on page". Scripting is enabled. (2) In Dspace admin tools- Groups, for a user defined group, adding an e-person to the group deletes the e-persons existing in the group. The Dspace status bar shows "error on page". Removing existing users is not happening with the Administration group but cannot add new e-person to any group including the Administration group. In this case also the Dspace status bar shows "error on page". Please suggest. Thanks, Jayan - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] inser/delete into the metadatavalue table
Hi Jose,
you can of course add metadata with a java script using DSpace API
without any problems. If you want add metadata from sql script you need
only to reset the metadata sequence at the end of your script.
SELECT setval('metadatavalue_seq', max(metadata_value_id)) FROM
metadatavalue;
SELECT setval('dcvalue_seq', max(dc_value_id)) FROM dcvalue;
Of course you need also to run index-all at the end.
Best wishes,
Andrea
PS: deleting metadata doesn't require sequence update
Jose Blanco ha scritto:
>
> I sent this question out a few days ago, and did not hear anything.
> If some one has some info on it, could you let me know.
>
>
>
> Thanks!
>
>
>
>
>
> *From:* [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] *On Behalf Of *Jose
> Blanco
> *Sent:* Monday, April 02, 2007 12:53 PM
> *To:* dspace-tech@lists.sourceforge.net
> *Subject:* [Dspace-tech] inser/delete into the metadatavalue table
>
>
>
> I have a big chunk of items I would like to add and delete metadata
> to. Previously I have updated the metadatavalue table when I have
> just wanted to do updates to certain metadata values, and then ran
> index-all, but I have never done inserts and deletes to this table via
> a script, and I want to make sure this will not cause any problems.
> Could some one let me know if this is safe to do?
>
>
>
> Thanks!
>
>
>
> Jose
>
>
>
> -
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys-and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
>
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] hiding metadata from oai harvesting and search/browse indexes
Hi All, We have a number of collections in Cambridge that are have been entered as 'Dark' with no anonymous access to the items. Unfortunately, these items still show up in the search and browse listings in dspace. We have discussed a number of strategies and would like some advice: 1. Remove the collections from the lucene and browse indexes. Effectively hiding them from all users. 2. Alter browse/search to return items that the user has permission to see by adding a authorization check when building the results. This option is quite messy because it complicates the entire browse/search ui. 3. Mask meta data from unauthorized users in the browse/search results mechanism. 4. Alter the search/browse sql search to return only authorized items (non trivial). 5. Add authorization check at the Item level to mask out meta data for unauthorized users. in the Item.find(context,id) there would be a canRead() canEdit() check. Currently I vote for number 5, because it solves the oai harvesting problem, but I'm not sure of the ramifications of adding an authorization check to retrieve an Item. Thanks in advance. James Dickson - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] [Dspace-devel] DSpace 1.4.2
Maybe these quick fixes could be implemented in 1.4.2 as well: - When deleting large collections I still get Internal errors, allthough this was supposedly fixed before? Collections with smaller item counts are deleted fine. - Delete functionality for erasing all items in a collection, without destroying the collection itself. -Mika - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
