Re: [Dspace-tech] Question about moving a collection from one community to another
Claudia, Thank you for your advice on this question. Would it be sufficient to run index-update rather than index-init after updating the community2collection table? I would like to permit my users to run this command without halting the application server. It is my understanding that index-init should be run while the application server is suspended. Thanks, Terry On Fri, Jun 14, 2013 at 9:40 AM, Claudia Jürgen claudia.juer...@ub.tu-dortmund.de wrote: Hello Terry, then you got to fallback to manipulating the database directly (usually warning about backup etc.) If e.g. you want to move the collection with id 34 from community id 1 to community id 7 you got to run: update community2collection set community_id=7 where community_id=1 and collection_id=34; The run index-init and oai import. Hope this helps Claudia Jürgen Am 14.06.2013 15:22, schrieb Terry Brady: Thanks to all of you for the feedback. This is very helpful. I have done a little bit of experimentation with the DSpace export functionality, and I had the impression that I might lose some hierarchical information in the process. I am encouraged to hear that that information can be preserved on export. I will do some further experimentation. Terry On Fri, Jun 14, 2013 at 3:46 AM, helix84 heli...@centrum.sk wrote: On Thu, Jun 13, 2013 at 10:42 PM, Terry Brady tw...@georgetown.edu wrote: Aside from running my own SQL, is there an existing tool to accomplish such a relationship? Hi Terry, I'd look into using AIP import/export of a whole subtree. I know, it's more invasive than flipping a pointer somewhere as community-filiator does, but it's well documented (not that there would be any caveats in SQL). So here's how you can export a collection: https://wiki.duraspace.org/display/DSDOC3x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingAIPHierarchy Then you'd need to delete it and import it using the restore mode (-r) with a new parent community (-p). Make sure you try this to get familiar with it, e.g. on demo.dspace.org before you do it in production. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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 -- Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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 -- Terry Brady Applications Programmer Analyst Lauinger Information Technology 202-687-7053 -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
On Mon, Jun 17, 2013 at 3:38 PM, Terry Brady tw...@georgetown.edu wrote: Would it be sufficient to run index-update rather than index-init after updating the community2collection table? Hi Terry, I don't think you need to update the Lucene index at all, because you didn't actually change any item metadata. But I'm not 100% sure. If you're using Discovery, then you do need to run update-discovery-index - the Solr index used by Discovery does store relations. It is my understanding that index-init should be run while the application server is suspended. That's true. index-init must be done while Tomcat is down. index-update and update-discovery-index are done while Tomcat is running. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
On Mon, Jun 17, 2013 at 4:01 PM, helix84 heli...@centrum.sk wrote: On Mon, Jun 17, 2013 at 3:38 PM, Terry Brady tw...@georgetown.edu wrote: Would it be sufficient to run index-update rather than index-init after updating the community2collection table? Hi Terry, I don't think you need to update the Lucene index at all, because you didn't actually change any item metadata. But I'm not 100% sure. I think I was wrong. I looked at the index structure and there's a location field that specifies the parent. I don't see an option to reindex existing items like Discovery has (see below), so you might have to either run index-init or specify the updated items using the -i option to index-update. You can use a tool like Luke to look at the index (located in [dspace]/search) and check whether the location field is updated on a particular affected item when you run just index-update. If you're using Discovery, then you do need to run update-discovery-index - the Solr index used by Discovery does store relations. Running just update-discovery-index actually doesn't reindex existing items. When you do an external change that DSpace is not aware of, like using SQL in this case, you may need to also reindex all existing items. To do that, run update-discovery-index -f. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
Thank you for the additional suggestions. Based on some quick testing, it appears that I do need to run both index-init and update-discovery-index -f to capture the changes. Terry On Mon, Jun 17, 2013 at 10:16 AM, helix84 heli...@centrum.sk wrote: On Mon, Jun 17, 2013 at 4:01 PM, helix84 heli...@centrum.sk wrote: On Mon, Jun 17, 2013 at 3:38 PM, Terry Brady tw...@georgetown.edu wrote: Would it be sufficient to run index-update rather than index-init after updating the community2collection table? Hi Terry, I don't think you need to update the Lucene index at all, because you didn't actually change any item metadata. But I'm not 100% sure. I think I was wrong. I looked at the index structure and there's a location field that specifies the parent. I don't see an option to reindex existing items like Discovery has (see below), so you might have to either run index-init or specify the updated items using the -i option to index-update. You can use a tool like Luke to look at the index (located in [dspace]/search) and check whether the location field is updated on a particular affected item when you run just index-update. If you're using Discovery, then you do need to run update-discovery-index - the Solr index used by Discovery does store relations. Running just update-discovery-index actually doesn't reindex existing items. When you do an external change that DSpace is not aware of, like using SQL in this case, you may need to also reindex all existing items. To do that, run update-discovery-index -f. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Terry Brady Applications Programmer Analyst Lauinger Information Technology 202-687-7053 -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
On Thu, Jun 13, 2013 at 10:42 PM, Terry Brady tw...@georgetown.edu wrote: Aside from running my own SQL, is there an existing tool to accomplish such a relationship? Hi Terry, I'd look into using AIP import/export of a whole subtree. I know, it's more invasive than flipping a pointer somewhere as community-filiator does, but it's well documented (not that there would be any caveats in SQL). So here's how you can export a collection: https://wiki.duraspace.org/display/DSDOC3x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingAIPHierarchy Then you'd need to delete it and import it using the restore mode (-r) with a new parent community (-p). Make sure you try this to get familiar with it, e.g. on demo.dspace.org before you do it in production. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
Thanks to all of you for the feedback. This is very helpful. I have done a little bit of experimentation with the DSpace export functionality, and I had the impression that I might lose some hierarchical information in the process. I am encouraged to hear that that information can be preserved on export. I will do some further experimentation. Terry On Fri, Jun 14, 2013 at 3:46 AM, helix84 heli...@centrum.sk wrote: On Thu, Jun 13, 2013 at 10:42 PM, Terry Brady tw...@georgetown.edu wrote: Aside from running my own SQL, is there an existing tool to accomplish such a relationship? Hi Terry, I'd look into using AIP import/export of a whole subtree. I know, it's more invasive than flipping a pointer somewhere as community-filiator does, but it's well documented (not that there would be any caveats in SQL). So here's how you can export a collection: https://wiki.duraspace.org/display/DSDOC3x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingAIPHierarchy Then you'd need to delete it and import it using the restore mode (-r) with a new parent community (-p). Make sure you try this to get familiar with it, e.g. on demo.dspace.org before you do it in production. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Terry Brady Applications Programmer Analyst Lauinger Information Technology -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
Terry, Just be aware that if you are using SOLR based statistics you will lose the link (not the actual stats in the SOLR index) to all your previous stats for that collection as the ids will change on import. Regards, Ben -- Dr Ben Ryan Jorum Technical Manager 5.12 Roscoe Building The University of Manchester Oxford Road Manchester M13 9PL Tel: 0160 275 6039 E-mail: benjamin.r...@manchester.ac.ukhttps://outlook.manchester.ac.uk/owa/redir.aspx?C=b28b5bdd1a91425abf8e32748c93f487URL=mailto%3abenjamin.ryan%40manchester.ac.uk -- From: Terry Brady [mailto:tw...@georgetown.edu] Sent: 14 June 2013 14:22 To: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Question about moving a collection from one community to another Thanks to all of you for the feedback. This is very helpful. I have done a little bit of experimentation with the DSpace export functionality, and I had the impression that I might lose some hierarchical information in the process. I am encouraged to hear that that information can be preserved on export. I will do some further experimentation. Terry On Fri, Jun 14, 2013 at 3:46 AM, helix84 heli...@centrum.skmailto:heli...@centrum.sk wrote: On Thu, Jun 13, 2013 at 10:42 PM, Terry Brady tw...@georgetown.edumailto:tw...@georgetown.edu wrote: Aside from running my own SQL, is there an existing tool to accomplish such a relationship? Hi Terry, I'd look into using AIP import/export of a whole subtree. I know, it's more invasive than flipping a pointer somewhere as community-filiator does, but it's well documented (not that there would be any caveats in SQL). So here's how you can export a collection: https://wiki.duraspace.org/display/DSDOC3x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingAIPHierarchy Then you'd need to delete it and import it using the restore mode (-r) with a new parent community (-p). Make sure you try this to get familiar with it, e.g. on demo.dspace.orghttp://demo.dspace.org before you do it in production. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Terry Brady Applications Programmer Analyst Lauinger Information Technology -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
Hello Terry, then you got to fallback to manipulating the database directly (usually warning about backup etc.) If e.g. you want to move the collection with id 34 from community id 1 to community id 7 you got to run: update community2collection set community_id=7 where community_id=1 and collection_id=34; The run index-init and oai import. Hope this helps Claudia Jürgen Am 14.06.2013 15:22, schrieb Terry Brady: Thanks to all of you for the feedback. This is very helpful. I have done a little bit of experimentation with the DSpace export functionality, and I had the impression that I might lose some hierarchical information in the process. I am encouraged to hear that that information can be preserved on export. I will do some further experimentation. Terry On Fri, Jun 14, 2013 at 3:46 AM, helix84 heli...@centrum.sk wrote: On Thu, Jun 13, 2013 at 10:42 PM, Terry Brady tw...@georgetown.edu wrote: Aside from running my own SQL, is there an existing tool to accomplish such a relationship? Hi Terry, I'd look into using AIP import/export of a whole subtree. I know, it's more invasive than flipping a pointer somewhere as community-filiator does, but it's well documented (not that there would be any caveats in SQL). So here's how you can export a collection: https://wiki.duraspace.org/display/DSDOC3x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingAIPHierarchy Then you'd need to delete it and import it using the restore mode (-r) with a new parent community (-p). Make sure you try this to get familiar with it, e.g. on demo.dspace.org before you do it in production. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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 -- Claudia Juergen Universitaetsbibliothek Dortmund Eldorado 0231/755-4043 https://eldorado.tu-dortmund.de/ -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
Use the community-filiator tool. Take a look: https://wiki.duraspace.org/display/DSDOC18/Managing+Community+Hierarchy Hope this helps! Mark On Thu, Jun 13, 2013 at 4:42 PM, Terry Brady tw...@georgetown.edu wrote: I see that I am able to move a subcommunity to another community using the community-filiator command. This command works for me. https://wiki.duraspace.org/display/DSDOC3x/Managing+Community+Hierarchy I would also like to be able to move a collection from one community to another community. I have not been able to find a mechanism in the XMLUI or the command line interface to perform this action. Have I overlooked an existing function? According to the DSpace Functional Overview ( https://wiki.duraspace.org/display/DSDOC3x/Functional+Overview), A collection may appear in more than one community Aside from running my own SQL, is there an existing tool to accomplish such a relationship? Thanks, Terry -- Terry Brady Applications Programmer Analyst Lauinger Information Technology -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev ___ 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 -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ 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
Re: [Dspace-tech] Question about moving a collection from one community to another
Oh. Sorry. On Thu, Jun 13, 2013 at 7:25 PM, Andrea Schweer schw...@waikato.ac.nzwrote: Hi, On 14/06/13 11:06, Mark Ehle wrote: Use the community-filiator tool. Take a look: https://wiki.duraspace.org/display/DSDOC18/Managing+Community+Hierarchy On Thu, Jun 13, 2013 at 4:42 PM, Terry Brady tw...@georgetown.edu wrote: I see that I am able to move a subcommunity to another community using the community-filiator command. This command works for me. https://wiki.duraspace.org/display/DSDOC3x/Managing+Community+Hierarchy I would also like to be able to move a collection from one community to another community. I have not been able to find a mechanism in the XMLUI or the command line interface to perform this action. Have I overlooked an existing function? As Terry wrote, the community filiator works only on communities, not on collections. Writing a tool for moving a collection under a different community has been on my list as maybe someday for a while. The one time we've had to do it so far, I did so directly in the database. According to the DSpace Functional Overview ( https://wiki.duraspace.org/display/DSDOC3x/Functional+Overview), A collection may appear in more than one community I personally would be very careful with relying on that statement. cheers, Andrea -- Dr Andrea Schweer IRR Technical Specialist, ITS Information Systems The University of Waikato, Hamilton, New Zealand -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev___ 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