May I suggest to use update-handle-prefix? On Fri, Aug 28, 2009 at 11:16 AM, Lewatle Phaladi<lewatle.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
