[Dspace-tech] handle-server setup (psql)
Hi As my [dspace]/dspace/bin/update-handle-prefix gives error, I also come with an idea of modifying the handle table and change 123456789/ handle prefix I tried on one collection it worked, but I need an SQL statement that will update only 123456789 and leave other value, If you can check the values in handle table and specifically handle column start with prefix and followed by id like 123456789/7135 SQL statement that can alter our prefix (123456789) only in that column and leaves the id (/7135) I was using the statement : Table name is handle Column name is also handle dspace= UPDATE handle SET handle = '85642/7178' WHERE handle = '123456789/7178'; that worked for updating single item, we need to update them simultaneously. Regards Lewatle -Original Message- From: Kim Shepherd [mailto:k...@waikato.ac.nz] Sent: Thu 8/27/2009 10:22 PM To: Lewatle Phaladi; dspace-tech@lists.sourceforge.net Subject: RE: [Dspace-tech] handle-server setup Hi Lewatle, In your [dspace]/bin directory, there is a script called update-handle-prefix If, for example, your new handle is 858585: [dspace]/bin/update-handle-prefix 123456789 858585 This will update the old handles with a default handle prefix without bothering your new, correct items/collections/communities. Cheers, Kim From: Lewatle Phaladi [mailto:lewatle.phal...@wits.ac.za] Sent: Friday, 28 August 2009 1:42 a.m. To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] handle-server setup Hi All I was setting up handle server for my University, and everything went well in such a way that changes apply only for new submissions, if we submit or import a file the file will take a new prefix not default like 123456789, What we really need is to change the default handle prefix e.g 123456789 to all our previous stored digital files and even to the new imported or submited file. Regards Lewatle This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. htmlpfont face = verdana size = 0.8 color = navyThis communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary./font/p/html -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] handle-server setup (psql)
May I suggest to use update-handle-prefix? On Fri, Aug 28, 2009 at 11:16 AM, Lewatle Phaladilewatle.phal...@wits.ac.za wrote: Hi As my [dspace]/dspace/bin/update-handle-prefix gives error, I also come with an idea of modifying the handle table and change 123456789/ handle prefix I tried on one collection it worked, but I need an SQL statement that will update only 123456789 and leave other value, If you can check the values in handle table and specifically handle column start with prefix and followed by id like 123456789/7135 SQL statement that can alter our prefix (123456789) only in that column and leaves the id (/7135) I was using the statement : Table name is handle Column name is also handle dspace= UPDATE handle SET handle = '85642/7178' WHERE handle = '123456789/7178'; that worked for updating single item, we need to update them simultaneously. Regards Lewatle -Original Message- From: Kim Shepherd [mailto:k...@waikato.ac.nz] Sent: Thu 8/27/2009 10:22 PM To: Lewatle Phaladi; dspace-tech@lists.sourceforge.net Subject: RE: [Dspace-tech] handle-server setup Hi Lewatle, In your [dspace]/bin directory, there is a script called update-handle-prefix If, for example, your new handle is 858585: [dspace]/bin/update-handle-prefix 123456789 858585 This will update the old handles with a default handle prefix without bothering your new, correct items/collections/communities. Cheers, Kim From: Lewatle Phaladi [mailto:lewatle.phal...@wits.ac.za] Sent: Friday, 28 August 2009 1:42 a.m. To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] handle-server setup Hi All I was setting up handle server for my University, and everything went well in such a way that changes apply only for new submissions, if we submit or import a file the file will take a new prefix not default like 123456789, What we really need is to change the default handle prefix e.g 123456789 to all our previous stored digital files and even to the new imported or submited file. Regards Lewatle This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] handle-server setup
Hi All I was setting up handle server for my University, and everything went well in such a way that changes apply only for new submissions, if we submit or import a file the file will take a new prefix not default like 123456789, What we really need is to change the default handle prefix e.g 123456789 to all our previous stored digital files and even to the new imported or submited file. Regards Lewatle htmlpfont face = verdana size = 0.8 color = navyThis communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary./font/p/html -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] handle-server setup
Hi Lewatle, In your [dspace]/bin directory, there is a script called “update-handle-prefix” If, for example, your new handle is 858585: [dspace]/bin/update-handle-prefix 123456789 858585 This will update the old handles with a default handle prefix without bothering your new, correct items/collections/communities. Cheers, Kim From: Lewatle Phaladi [mailto:lewatle.phal...@wits.ac.za] Sent: Friday, 28 August 2009 1:42 a.m. To: dspace-tech@lists.sourceforge.net Subject: [Dspace-tech] handle-server setup Hi All I was setting up handle server for my University, and everything went well in such a way that changes apply only for new submissions, if we submit or import a file the file will take a new prefix not default like 123456789, What we really need is to change the default handle prefix e.g 123456789 to all our previous stored digital files and even to the new imported or submited file. Regards Lewatle This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorized signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Handle Server Setup Problem
I've done this beore and it worked OK. Now I'm having a problem and need help. [EMAIL PROTECTED]:~$ /data/dspace/bin/make-handle-config Writing simple Handle server configuration Error setting up the server: java.lang.NullPointerException java.lang.NullPointerException at net.handle.server.SimpleSetup.responseToPrompt(SimpleSetup.java:930) at net.handle.server.SimpleSetup.getContactPhone(SimpleSetup.java:608) at net.handle.server.SimpleSetup.main(SimpleSetup.java:303) /data/dspace/bin/make-handle-config: 2007-03-20 19:18:59,644 INFO org.dspace.core.ConfigurationManager @ DSpace logging installed using log4j.properties^J/data/dspace/handle-server/config.dct: cannot open rm: 2007-03-20 is a directory /data/dspace/bin/make-handle-config: /tmp/handleconfig20023: cannot open [EMAIL PROTECTED]:~$ - 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.phpp=sourceforgeCID=DEVDEV ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech