Brian: Thanks! Yes, this makes sense. Thank you very much.
George Kozak Digital Library Specialist Cornell University Library Information Technologies (CUL-IT) 501 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 -----Original Message----- From: Brian Freels-Stendel [mailto:bfre...@unm.edu] Sent: Thursday, October 20, 2011 2:56 PM To: George S Kozak; dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Turning an item into a collection 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
