Hi Olivier, On 5/13/2015 9:36 PM, Olivier Nicole wrote: > Thank you Tim, > >> My guess would be that you may need to reindex. Since you moved the >> objects manually in the database tables, the browse/search indexes may >> not be fully aware of the move. Assuming you are using Discovery, you'd >> likely need to run >> >> [dspace]/bin/dspace index-discovery -b > > That did it. > > Out of mere curiosity, where are the indexes stored?
The indexes are stored in Apache Solr (under the [dspace]/solr/ subdirectories). By default they get updated automatically when you make changes from the User Interface (or other DSpace tools). But if you manually change things in the database itself, Solr won't see those changes, which would require you to reindex. > >> In the future, if you ever encounter the need to move items between >> Collections, I'd recommend using the Batch Metadata Editing tool. It has >> the ability to change the Collection(s) associated with any Items, and >> it will also automatically trigger a reindex for any item updates. The >> information on changing a Collection in the Batch Metadata Editing tool >> is here: >> >> https://wiki.duraspace.org/display/DSDOC4x/Batch+Metadata+Editing#BatchMetadataEditing-EditingCollectionMembership > > But does that allow complexs SQL request to select the list of items > that will be modified? Using the Batch Metadata Editing Tool you can actually make Collection changes in a CSV file, using the tools like Excel. So, yes, you can make complex changes. But, you'd be using Excel to find the items to move, instead of SQL. When you upload the changed/updated spreadsheet, DSpace will also prompt you to show you which changes you've made, to ensure they look correct (so it's an extra safety check) If you would rather make SQL level changes, it's still possible. But, keep in mind it's inherently "dangerous" if you are not very careful. Obviously, DSpace cannot monitor what you are doing at the database level, so there's the danger of accidental corruption or deletions. But, what you use is obviously up to you. - Tim ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
