Hi George, I'm rather conservative about this sort of thing, so I may take a longer route than is necessary. But here's what I'd try:
-Create new sub-community -Create new collections -Create new items inside the appropriate (new) collections -Delete old items and collection -Update handle.handle, replacing new collection handles with old item handles and new sub-community handle with old collection handle (be sure to also update handle.resource_type_id (sub-community = 4, collection = 3) and resource_id (available from the community and collection tables) Then re-index, of course, or all kinds of ugliness will explode. As always, backup the db, and test on a not-production server, in case I missed a step. B-- >>> On 10/20/2011 at 12:30 PM, in message <80e7a9b9f3ffc3438ef3b5ad26c299a1adb...@mbxa-02.exchange.cornell.edu>, George S Kozak <g...@cornell.edu> wrote: > Hi... > > I have a collections which has items that contain multiple PDF bitstreams. > We are thinking of breaking these items up so that I have multiple items > with a single bitstream, to make searching easier for the user. I know how > to do that, but the other thing I have been asked to do, I am not so sure > about. > > I was asked to take the existing collection and turn it into a sub-community > with the same handle as the original collection. Also, to take the existing > items and turn them into collections with the same handles as the original > items. > > So, if a I have a collection: "Cornell Reports" with handle 1813/7754 and an > item: "Cornell Reports Vol. 1, No. 1 - No. 4, 1967" with handle 1813/7755, I > would like to create a sub-community called "Cornell Reports" with the handle > 1813/7754 and a collection called "Cornell Reports Vol. 1, No. 1 - No. 4, > 1967" with the handle 1813/7755. > > Can I do that in postgres? I am not sure how to link an old handle to a new > collection or to move a collection into the community table and an item into > the collection table. Any suggestions? > > George Kozak > Digital Library Specialist > Cornell University Library Information Technologies (CUL-IT) > 501 Olin Library > Cornell University > Ithaca, NY 14853 > 607-255-8924 ------------------------------------------------------------------------------ The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
