[Dspace-tech] email errors

2015-05-14 Thread Bill Tantzen
All, DSpace 4.3, RHEL6 VERY occasionally, I see warnings in the space log thrown by exceptions in notifyGroupOfTask() and notifyOfReject(). In these cases, the exception's getMessage() is null, so no explanation is available... Additionally, in every case, the addressees DO receive

Re: [Dspace-tech] access to page spins

2015-05-14 Thread Tim Donohue
Hi Jose, Just as a reference, DSpace 5.1 recommends: * Maven 3.0.5 * PostgreSQL 9 or above https://wiki.duraspace.org/display/DSDOC5x/Installing+DSpace It is possible DSpace 5.1 will work on older versions, but it is not tested on these older versions. Also, just an FYI, Postgres 8.4 is

Re: [Dspace-tech] Batch move item between collections

2015-05-14 Thread Tim Donohue
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

Re: [Dspace-tech] Batch move item between collections

2015-05-14 Thread helix84
As Tim noted, complex changes can now be done using filtering in Excel as you can currently only export collections. This would be unpractical with with large result sets (over 10k items). Once this feature gets in, you will be able to export any search query (so you can search based on metadata

[Dspace-tech] DSpace community and collectionnumber of publications summary

2015-05-14 Thread allybitebo
Hello, I am a new bee in this Dspace software i managed to configure Dspace 5.1 on windows and now i am in the position to customize it but my question is how to display number of publication in the given community or sub community or collections? example in a collage of engineering community

Re: [Dspace-tech] spider ip recognition

2015-05-14 Thread Anthony Petryk
Hi again, Unfortunately, the documentation for the stats-util command is incorrect. Specifically this line: -i or --delete-spiders-by-ip: Delete Spiders in Solr By IP Address, DNS name, or Agent name. Will prune out all records that match spider identification patterns. Running “stats-util

Re: [Dspace-tech] flyway migration error

2015-05-14 Thread Tim Donohue
Hi all, Just a note to say I've now logged this as a bug: https://jira.duraspace.org/browse/DS-2577 In that ticket, I've tracked down the area of the code that makes the assumption on the name of a PostgreSQL constraint (but it makes that assumption based on the default PostgreSQL naming

Re: [Dspace-tech] access to page spins

2015-05-14 Thread Jose Blanco
Thank you both very much!! I just checked AuthorizeManager.java and I had created an infinite look when I merged. It is working now!! -Jose On Thu, May 14, 2015 at 10:14 AM, Tim Donohue tdono...@duraspace.org wrote: Hi Jose, Just as a reference, DSpace 5.1 recommends: * Maven 3.0.5 *

Re: [Dspace-tech] flyway migration error

2015-05-14 Thread Brian Freels-Stendel
Good morning, This is a problem from way back, see: http://sourceforge.net/p/dspace/mailman/message/28781652/. If I remember right, it was because In The Beginning, the constraints weren't being given names, so they were auto-generated by the db engine. For those of us with old databases,

Re: [Dspace-tech] flyway migration error

2015-05-14 Thread Tim Donohue
Digging into this Constraint naming issue a bit more, it looks like in PostgreSQL you can look up constraints (on columns) by name from the key_column_usage view: http://www.postgresql.org/docs/9.4/static/infoschema-key-column-usage.html So, it seems reasonable to change the code to simply

Re: [Dspace-tech] flyway migration error

2015-05-14 Thread Tim Donohue
Hi Brian, I definitely think a dump of what your constraints look like could be useful. We definitely want to avoid this being a recurring problem in any flyway migrations involving contraints. As noted in my previous message, you also might want to simply query your

Re: [Dspace-tech] flyway migration error

2015-05-14 Thread Peter Dietz
Virtual Beer for all as well. I've just ran into this, (Tim pointed me to it from IRC). My version of the SQL, wrapping in a transaction, to be safe, is: BEGIN; ALTER TABLE metadatavalue DROP CONSTRAINT $1; ALTER TABLE metadatavalue ADD CONSTRAINT metadatavalue_item_id_fkey FOREIGN KEY(item_id)

[Dspace-tech] [Fwd: DSpace community and collectionnumber of publications summary]

2015-05-14 Thread allybitebo
Hello, I am a new bee in this Dspace software i managed to configure Dspace 5.1 on windows and now i am in the position to customize it but my question is how to add new publication type like conference or masters or phd thesis in the input form type field. Please any help or proper directions to

Re: [Dspace-tech] spider ip recognition

2015-05-14 Thread Monika C. Mevenkamp
Anthony Since dspace 4 you can filter by userAgent see https://wiki.duraspace.org/display/DSDOC5x/SOLR+Statistics+Maintenance#SOLRStatisticsMaintenance-FilteringandPruningSpiders I have not used this myself and am not sure whether these filters are applied as crawlers access content - or

Re: [Dspace-tech] flyway migration error

2015-05-14 Thread Tim Donohue
Hi Brian, Thanks, actually that spreadsheet is very useful. It shows that this problem is one we may repeat in the future, as that DB has several non-standard names for constraints: $1, $2, all the way through $7. I'll take your advice and try a 4.x - 5.x upgrade after renaming that

[Dspace-tech] Publish Faculty Articles in DSPACE instance

2015-05-14 Thread Monika C. Mevenkamp
Princeton University has had an Open Access mandate in place since fall of 2011. Slowly but surely we are getting to the point of following through by collecting articles in the form of citation metadata and article documents. At the moment we hope to work with Symplectic for citation

Re: [Dspace-tech] Publish Faculty Articles in DSPACE instance

2015-05-14 Thread Richard Rodgers
Hi Monika: A few remarks inline. Thanks, Richard On May 14, 2015, at 5:30 PM, Monika C. Mevenkamp moni...@princeton.edu wrote: Princeton University has had an Open Access mandate in place since fall of 2011. Slowly but surely we are getting to the point of following through by collecting

Re: [Dspace-tech] Batch move item between collections

2015-05-14 Thread Olivier Nicole
Thanks Tim, 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. But I know SQL more than I know Excel :) If

[Dspace-tech] Tomcat servlet engine is not running, but pid file exists.

2015-05-14 Thread Vimal Kumar V.
Dear Friends, I have finished dspace installation successfully. Dspace page not loading. I checked Tomcat status, it says, service tomcat7 status * Tomcat servlet engine is not running, but pid file exists. Please guide me, what the things to do run the dspace. Regards, -- Vimal Kumar V.

[Dspace-tech] Import multiple records (from csv file) using batch import feature

2015-05-14 Thread Bhavesh Patel
Dear All, We want to import the multiple records (from csv file) in one collection using batch import features on DSpace 5. We have also physical file for each records. Please let us know how to import using csv file. DSpace version : 5.1 OS : CentOS 6.5 Thanks Regards, ​​ Bhavesh Patel

Re: [Dspace-tech] Import multiple records (from csv file) using batch import feature

2015-05-14 Thread Hilton Gibson
Hi Bhavesh Perhaps this will help: http://wiki.lib.sun.ac.za/index.php/SUNScholar/Metadata/Batch_Edit Cheers hg *Hilton Gibson* Ubuntu Linux Systems Administrator Stellenbosch University Library http://staff.lib.sun.ac.za/~hgibson/docs/cv/cv.html On 14 May 2015 at 09:07, Bhavesh Patel

Re: [Dspace-tech] Help for dspace backup/restore

2015-05-14 Thread Emmanuel Wilson
hello all.using database + assetstore restore method i tried this.*pg_dump/psql* backup: pg_dump -U username -f backup.sql database_name restore: psql -d database_name -f backup.sql it works something like import.alter table, create table etc. i restarted tomcat.but only

Re: [Dspace-tech] Help for dspace backup/restore

2015-05-14 Thread Andrea Schweer
Hi, you probably just need to reindex for discovery [dspace]/bin/dspace index-discovery -bo cheers, Andrea On 14/05/15 19:14, Emmanuel Wilson wrote: hello all.using database + assetstore restore method

Re: [Dspace-tech] ORA-00903: invalid table name error while submission.

2015-05-14 Thread Carlos Alonso Vega
Hi Vineet, It is a bug in the sources. There is an issue reported about this (https://jira.duraspace.org/browse/DS-2555) Some of the sql queries on dspace-api/src/main/java/org/dspace/content/Collection.java has a public. qualifier before table names (ie FROM public.eperson) In Oracle