Hi Alan, I believe you'd need to do a complete re-index (with -b flag) in this scenario. But, that same concept should work in 4.0 or above.
It's also worth noting that, rather than doing this at the DB level (which can be a tad dangerous, unless you know what you are doing), you could also just "bulk move items" from one Collection to another using the "Batch Metadata Editing" tool: https://wiki.duraspace.org/display/DSDOC4x/Batch+Metadata+Editing#BatchMetadataEditing-EditingCollectionMembership The concept in bulk moving items would be something like this: 1) Recreate the Collection in it's new location 2) Visit the Old Collection, and "Export Metadata" from that Collection (generating a CSV of all Item metadata) 3) Edit the CSV, changing the "collection" column to point at the *new* Collection (created in #1) 4) Upload the CSV using the "Import Metadata" Administrative tool. Verify that DSpace detects those changes, and save it. At this point, all Items in "Old Collection" will be moved in bulk to "New Collection". You can then delete the "Old Collection". - Tim On 3/18/2015 4:11 AM, Alan Orth wrote: > Hi, > > I'm wondering how to move a collection to a new community in DSpace > versions >= 4.0. In the past, with DSpace 3.x, I would simply[0] find > the resource_id for the collection, its parent, and the new parent, then > update the relationships in SQL: > > UPDATE community2collection SET community_id=$NEW_PARENT WHERE > community_id=$OLD_PARENT and collection_id=$COLLECTION; > > Assuming I update Solr afterwards using`dspace index-discovery` is that > sufficient? Is it perhaps required to do a complete re-index with the -b > flag? > > Thanks, > > Alan > > [0] For finding the resource_id of each handle: > > SELECT resource_id FROM handle WHERE handle = '123456789/11287'; > > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming The Go Parallel Website, sponsored > by Intel and developed in partnership with Slashdot Media, is your hub for all > things parallel software development, from weekly thought leadership blogs to > news, videos, case studies, tutorials and more. Take a look and join the > conversation now. http://goparallel.sourceforge.net/ > > > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
