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