[dspace-tech] Re: ORCID Integration: Admin Edit Item

[Stefanie Behnke]

Am Donnerstag, 29. September 2016 16:35:30 UTC+2 schrieb Stefanie Behnke:
>
> Dear all,
>
> I am using Dspace 5.5 with xmlui Mirage theme.
> I have enabled Orcid Integration as described in 
> https://wiki.duraspace.org/display/DSDOC5x/ORCID+Integration.
>
> Author lookup in the submission form does work, but when I want to edit an 
> item I am missing the "Lookup Button".
> I can only see what is shown in the attached image. What I am doing wrong?
>
>
> Any help is appreciated.
>
> Best regards
> Stefanie
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] ORCID Integration: Admin Edit Item

[Christian Scheible]

Hi Stefanie,

have you tried clicking on the litle lock image first?
After that it should be possible to start the lookup.

Best Regards
Christian

On 29.09.2016 16:35, Stefanie Behnke wrote:

Dear all,

I am using Dspace 5.5 with xmlui Mirage theme.
I have enabled Orcid Integration as described in 
https://wiki.duraspace.org/display/DSDOC5x/ORCID+Integration.


Author lookup in the submission form does work, but when I want to 
edit an item I am missing the "Lookup Button".

I can only see what is shown in the attached image. What I am doing wrong?


Any help is appreciated.

Best regards
Stefanie
--
You received this message because you are subscribed to the Google 
Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to dspace-tech+unsubscr...@googlegroups.com 
.
To post to this group, send email to dspace-tech@googlegroups.com 
.

Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.


--
You received this message because you are subscribed to the Google Groups "DSpace 
Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.


smime.p7s
Description: S/MIME Cryptographic Signature

Re: [dspace-tech] SQL to get all authors in a community?

[Terry Brady]

Fyi, DSpace 6 will have a mechanism to send this type of query in through
the REST api.

https://demo.dspace.org/rest/static/reports/query.html?query_field[]=dc.contributor.author_op[]=exists_val[]=[]=7740c113-f0c1-4b76-bdec-32fcc9e23f01=100=0=parentCollection%2Cmetadata=none_fields[]=dc.contributor.author

(You will need to accept the security warning at demo.dspace.org in order
to view the query form and results).

See
https://wiki.duraspace.org/display/DSDOC6x/REST+Based+Quality+Control+Reports

Terry

On Thu, Sep 29, 2016 at 8:25 AM, Luiz dos Santos  wrote:

> Thanks Hardy and Helix84, that page is so nice!
>
> Luiz Claudio Santos
> http://luizclaudiosantos.me/
>
> On Thu, Sep 29, 2016 at 11:21 AM, Hardy Pottinger <
> hardy.pottin...@gmail.com> wrote:
>
>> Hi, because not so many people know about this handy resource, I'll just
>> jump in to say this page by Helix84 is fantastically useful for answering
>> these sorts of SQL questions;
>>
>> https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace
>>
>> Even if you don't define the functions, the SQL contained on this page is
>> useful.
>>
>> --Hardy
>>
>> On Thu, Sep 29, 2016 at 8:12 AM, Alan Orth  wrote:
>>
>>> Hi,
>>>
>>> I want to generate a list of authors in a certain community and its
>>> collections. My goal is to do some batch cleanups of the names.
>>> Normally I just select all the distinct text_value fields for the
>>> metadata field I'm interested in, like here for 3
>>> (dc.contributor.author):
>>>
>>> dspace=# select distinct text_value from metadatavalue where
>>> resource_type_id=2 and metadata_field_id=3;
>>>
>>> But I don't understand DSpace's database schema well enough to limit
>>> that to a certain community and its collections.
>>>
>>> Can anyone help? This is DSpace 5 + PostgreSQL.
>>>
>>> --
>>> Alan Orth
>>> alan.o...@gmail.com
>>> https://englishbulgaria.net
>>> https://alaninkenya.org
>>> https://mjanja.ch
>>> "In heaven all the interesting people are missing." ―Friedrich Nietzsche
>>> GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "DSpace Technical Support" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to dspace-tech+unsubscr...@googlegroups.com.
>>> To post to this group, send email to dspace-tech@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/dspace-tech.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech+unsubscr...@googlegroups.com.
>> To post to this group, send email to dspace-tech@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Terry Brady
Applications Programmer Analyst
Georgetown University Library Information Technology
http://georgetown-university-libraries.github.io/

425-298-5498 (Seattle, WA)

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] Re: Changing messages.xml in xmlui

[Andrea Schweer]

  
  
Hi,

On 09/30/2016 08:05 AM, Donald Bynum
  wrote:


  On Thursday, September 29, 2016 at 2:49:16 PM
UTC-4, Donald Bynum wrote:

  
This is driving me nuts.  I want to change the content
  of various strings in the messages.xml file in the xmlui
  application.  I have edited the following:


dspace/source/modules/xmlui/target/xmlui-5.5/i18n/messages.xml


Then I repackage with mvn -U clean package
Then redeploy with ant update


All I end up with is the original messages.xml in the
  webapps/xmlui/i18n folder.


Obviously, I am editing the wrong source file.  Could
  someone please tell me which source messages.xml file I
  should be editing in order to get my changes in the build.
  



Before someone points me to the documentation, I have
  looked there.  This is where I think I need some guidance.  In
  the docs iit states I should go to the messages.xml source
  file located at:



  [dspace-source]/dspace/modules/xmlui/src/main/webapp
 
However, all I see in that folder is a file named
  ".gitignore"
  


You need to copy
[dspace-src]/dspace-xmlui/src/main/webapp/i18n/messages.xml to
[dspace-source]/dspace/modules/xmlui/src/main/webapp/i18n, then edit
the copy (alternatively, edit the first file in place). See
https://wiki.duraspace.org/display/DSDOC5x/Localization+L10n#LocalizationL10n-Wheretofindthemessagecatalog
but I agree it isn't super clear there that you should copy that
file to the modules directory. See also
https://wiki.duraspace.org/display/DSDOC5x/Advanced+Customisation
for general information on customising DSpace and note the
explanation of the "quick build" vs "full build" there --
essentially if you edit the file in [dspace-src]/dspace-xmlui
directly you will need to use the full build option from then on.

Never edit anything in "target" directories, those are generated /
overwritten when you run mvn.

cheers,
Andrea

-- 
Dr Andrea Schweer
Lead Software Developer, ITS Information Systems
The University of Waikato, Hamilton, New Zealand
+64-7-837 9120
  




-- 
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] Changing messages.xml in xmlui

[Donald Bynum]

This is driving me nuts.  I want to change the content of various strings 
in the messages.xml file in the xmlui application.  I have edited the 
following:

dspace/source/modules/xmlui/target/xmlui-5.5/i18n/messages.xml

Then I repackage with mvn -U clean package
Then redeploy with ant update

All I end up with is the original messages.xml in the webapps/xmlui/i18n 
folder.

Obviously, I am editing the wrong source file.  Could someone please tell 
me which source messages.xml file I should be editing in order to get my 
changes in the build.


-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] Re: embed piwik iframe into page-structure.xsl

[Hernán Lagos]

Dear

You must check the special entities: 
http://www.htmlhelp.com/reference/html40/entities/special.html.
Change *&* by ** 
Example:



http://openaccess.iyte.edu.tr/piwik/index.php?module=Widgetize**
action=iframe**widget=1**moduleToWidgetize=UserCountryMap**
actionToWidgetize=realtimeMap**idSite=1**period=day**
date=yesterday**disableLink=1**widget=1" scrolling="no" 
frameborder="0" marginheight="0" marginwidth="0">



Regards

Hernán Lagos
http://prodigioconsultores.com

El martes, 27 de septiembre de 2016, 9:16:23 (UTC-3), Mesut Güngör escribió:
>
> I am trying to embed piwik realtime visitor map into dspace home page 
> (page-structure.xsl)
> First i get the iframe embed link from piwik and paste it into the 
> http://www.html2xsl.com/index.php site to convert the 
> html code into xsl structure. i get the following.
>
> *The IFRAME embed code i get from PIWIK*
>
> http://openaccess.iyte.edu.tr/piwik/index.php?module=Widgetize=iframe=1=UserCountryMap=realtimeMap=1=day=yesterday=1=1
>  
> "
>  
> scrolling="no" frameborder="0" marginheight="0" 
> marginwidth="0">
>
> converted to xsl and give it a template name and call it in 
> page-structure.xsl as below
>
>
>  
>
>
>  
>
> 
> widgetIframe
> 
> 100%
> 350
>  name="src">*http://openaccess.iyte.edu.tr/piwik/index.php?module=Widgetize=iframe=1=UserCountryMap=realtimeMap=1=day=yesterday=1=1
>  
> *
> 
> no
> 0
> 0
> 0
> 
> 
>
>  
>
>
> if i visit the page it gives the following error
>
> org.xml.sax.SAXParseException: The reference to entity "*action*" must 
> end with the ';' delimiter.
>
>
> This action word is in the IFRAME URL. 
> How should i write this src url not to get error ? I have also tried to 
> encode the url with url encoder but not luck it also did not work. 
>
> Thanks. 
>
>
>
>
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] 20 million item repository with dspace

[DSquare Technologies]

Hi Thomas,

Since you are talking about newspapers, do you pages in terms of millions or 
number of newspapers, Also what kind of concurrent user load is expected? 

We did couple of implementations and DSpace optimization In past where we need 
to manage similar kind of data load I.e. 10 - 25 million and some may scale up 
further in future and this consisting of newspapers, scanned documents audio 
version etc.

In our case concurrent users are expected to go in multiple of 100s. 
Unfortunately these implementation s belong to courts and defense sectors hence 
can not produce internet link. But we will be happy to see how we can exchange 
inputs on this with each other. 

Thanks,
Rajendran
Director 
DSquare Technologies
supp...@d2t.co

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] SQL to get all authors in a community?

[Hardy Pottinger]

Hi, because not so many people know about this handy resource, I'll just
jump in to say this page by Helix84 is fantastically useful for answering
these sorts of SQL questions;

https://wiki.duraspace.org/display/DSPACE/Helper+SQL+functions+for+DSpace

Even if you don't define the functions, the SQL contained on this page is
useful.

--Hardy

On Thu, Sep 29, 2016 at 8:12 AM, Alan Orth  wrote:

> Hi,
>
> I want to generate a list of authors in a certain community and its
> collections. My goal is to do some batch cleanups of the names.
> Normally I just select all the distinct text_value fields for the
> metadata field I'm interested in, like here for 3
> (dc.contributor.author):
>
> dspace=# select distinct text_value from metadatavalue where
> resource_type_id=2 and metadata_field_id=3;
>
> But I don't understand DSpace's database schema well enough to limit
> that to a certain community and its collections.
>
> Can anyone help? This is DSpace 5 + PostgreSQL.
>
> --
> Alan Orth
> alan.o...@gmail.com
> https://englishbulgaria.net
> https://alaninkenya.org
> https://mjanja.ch
> "In heaven all the interesting people are missing." ―Friedrich Nietzsche
> GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] ORCID Integration: Admin Edit Item

[Stefanie Behnke]

Dear all,

I am using Dspace 5.5 with xmlui Mirage theme.
I have enabled Orcid Integration as described in 
https://wiki.duraspace.org/display/DSDOC5x/ORCID+Integration.

Author lookup in the submission form does work, but when I want to edit an 
item I am missing the "Lookup Button".
I can only see what is shown in the attached image. What I am doing wrong?


Any help is appreciated.

Best regards
Stefanie

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] SQL to get all authors in a community?

[Sean Carte]

On 29 September 2016 at 15:53, Alan Orth  wrote:

> Thanks for the quick replies! Tom's solution is nice because you can
> specify the handles instead of the internal IDs. I thought I was going to
> have to figure out which collections each the community had, but it's
> simpler to just list them since there are only ten or so.


Yes, very nice. And also much more elegant in the use of subqueries rather
than joins.

Sean
--

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] SQL to get all authors in a community?

[Alan Orth]

Thanks for the quick replies! Tom's solution is nice because you can
specify the handles instead of the internal IDs. I thought I was going to
have to figure out which collections each the community had, but it's
simpler to just list them since there are only ten or so.

Thanks again,

On Thu, Sep 29, 2016 at 4:27 PM, Tom Desair  wrote:

> If you do not want to relay on the owning collection and use the
> collection handle, you can do this:
>
> select distinct text_value
> from metadatavalue
> where metadata_field_id = (select metadata_field_id from 
> metadatafieldregistry where element = 'contributor' and qualifier = 'author')
> AND resource_type_id = 2 AND
>   resource_id IN (select item_id from collection2item where collection_id 
> IN
> (select 
> resource_id from handle where handle in ('123456789/3', '123456789/4')));
>
>
>
> [image: logo] Tom Desair
> 250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
> Esperantolaan 4, Heverlee 3001, Belgium
> www.atmire.com
> 
>
> 2016-09-29 15:24 GMT+02:00 Sean Carte :
>
>>
>>
>> On 29 September 2016 at 15:12, Alan Orth  wrote:
>>
>>> Hi,
>>>
>>> I want to generate a list of authors in a certain community and its
>>> collections. My goal is to do some batch cleanups of the names.
>>> Normally I just select all the distinct text_value fields for the
>>> metadata field I'm interested in, like here for 3
>>> (dc.contributor.author):
>>>
>>> dspace=# select distinct text_value from metadatavalue where
>>> resource_type_id=2 and metadata_field_id=3;
>>>
>>> But I don't understand DSpace's database schema well enough to limit
>>> that to a certain community and its collections.
>>>
>>> Can anyone help? This is DSpace 5 + PostgreSQL.
>>>
>>
>> Hi Alan
>>
>> How about something like this:
>>
>> SELECT i.item_id AS item_id, i.owning_collection AS collection,
>> d.text_value AS date, a.text_value AS author
>> FROM metadatavalue d, metadatavalue a, item i
>> WHERE d.resource_id = a.resource_id AND d.resource_id = i.item_id
>> AND i.discoverable = 't' AND i.in_archive = 't' AND i.withdrawn = 'f'
>> AND d.metadata_field_id = 11
>> AND a.metadata_field_id = 3
>> AND d.text_value >= '2016-01' AND d.text_value < '2016-10'
>> AND i.owning_collection = 11;
>>
>> Sean
>> --
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech+unsubscr...@googlegroups.com.
>> To post to this group, send email to dspace-tech@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Alan Orth
alan.o...@gmail.com
https://englishbulgaria.net
https://alaninkenya.org
https://mjanja.ch
"In heaven all the interesting people are missing." ―Friedrich Nietzsche
GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] SQL to get all authors in a community?

[Tom Desair]

If you do not want to relay on the owning collection and use the collection
handle, you can do this:

select distinct text_value
from metadatavalue
where metadata_field_id = (select metadata_field_id from
metadatafieldregistry where element = 'contributor' and qualifier =
'author')
AND resource_type_id = 2 AND
  resource_id IN (select item_id from collection2item where collection_id IN

(select resource_id from handle where handle in ('123456789/3',
'123456789/4')));



[image: logo] Tom Desair
250-B Suite 3A, Lucius Gordon Drive, West Henrietta, NY 14586
Esperantolaan 4, Heverlee 3001, Belgium
www.atmire.com


2016-09-29 15:24 GMT+02:00 Sean Carte :

>
>
> On 29 September 2016 at 15:12, Alan Orth  wrote:
>
>> Hi,
>>
>> I want to generate a list of authors in a certain community and its
>> collections. My goal is to do some batch cleanups of the names.
>> Normally I just select all the distinct text_value fields for the
>> metadata field I'm interested in, like here for 3
>> (dc.contributor.author):
>>
>> dspace=# select distinct text_value from metadatavalue where
>> resource_type_id=2 and metadata_field_id=3;
>>
>> But I don't understand DSpace's database schema well enough to limit
>> that to a certain community and its collections.
>>
>> Can anyone help? This is DSpace 5 + PostgreSQL.
>>
>
> Hi Alan
>
> How about something like this:
>
> SELECT i.item_id AS item_id, i.owning_collection AS collection,
> d.text_value AS date, a.text_value AS author
> FROM metadatavalue d, metadatavalue a, item i
> WHERE d.resource_id = a.resource_id AND d.resource_id = i.item_id
> AND i.discoverable = 't' AND i.in_archive = 't' AND i.withdrawn = 'f'
> AND d.metadata_field_id = 11
> AND a.metadata_field_id = 3
> AND d.text_value >= '2016-01' AND d.text_value < '2016-10'
> AND i.owning_collection = 11;
>
> Sean
> --
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] SQL to get all authors in a community?

[Sean Carte]

On 29 September 2016 at 15:12, Alan Orth  wrote:

> Hi,
>
> I want to generate a list of authors in a certain community and its
> collections. My goal is to do some batch cleanups of the names.
> Normally I just select all the distinct text_value fields for the
> metadata field I'm interested in, like here for 3
> (dc.contributor.author):
>
> dspace=# select distinct text_value from metadatavalue where
> resource_type_id=2 and metadata_field_id=3;
>
> But I don't understand DSpace's database schema well enough to limit
> that to a certain community and its collections.
>
> Can anyone help? This is DSpace 5 + PostgreSQL.
>

Hi Alan

How about something like this:

SELECT i.item_id AS item_id, i.owning_collection AS collection,
d.text_value AS date, a.text_value AS author
FROM metadatavalue d, metadatavalue a, item i
WHERE d.resource_id = a.resource_id AND d.resource_id = i.item_id
AND i.discoverable = 't' AND i.in_archive = 't' AND i.withdrawn = 'f'
AND d.metadata_field_id = 11
AND a.metadata_field_id = 3
AND d.text_value >= '2016-01' AND d.text_value < '2016-10'
AND i.owning_collection = 11;

Sean
--

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] SQL to get all authors in a community?

[Alan Orth]

Hi,

I want to generate a list of authors in a certain community and its
collections. My goal is to do some batch cleanups of the names.
Normally I just select all the distinct text_value fields for the
metadata field I'm interested in, like here for 3
(dc.contributor.author):

dspace=# select distinct text_value from metadatavalue where
resource_type_id=2 and metadata_field_id=3;

But I don't understand DSpace's database schema well enough to limit
that to a certain community and its collections.

Can anyone help? This is DSpace 5 + PostgreSQL.

-- 
Alan Orth
alan.o...@gmail.com
https://englishbulgaria.net
https://alaninkenya.org
https://mjanja.ch
"In heaven all the interesting people are missing." ―Friedrich Nietzsche
GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

[dspace-tech] Re: impossible d'envoyer des émails par dspace

[Chergui Zohra]

Le dimanche 10 avril 2016 12:29:17 UTC+2, HADJ KOUIDER a écrit :
>
> Bonjour,
>
> Nous avons installé dspace vesrion 5.4, nous avons rencontré un problèmes 
> pour la création des comptes, impossible d'envoyer des émails par dspace
>
> Veuillez nous aider  pour regler ce problème
>
> Voici les messages d'erreurs
>
> 1- Lors de la réinitialsation de mot de passe voilà le message d'erreur 
> affcihé :
> Réinitialisation de mote de pasee 
>
> Désolé, un erreur est produit avec le courriel.
>
> 2- lors de lancement de la commande :
>
> /var/dspace/bin/dspace test-email
>
> About to send test email:
>  - To: n.hadj...@ensa.dz 
>  - Subject: DSpace test email
>  - Server: *nom du serveur messagerie*
>
> Error sending email:
>  - Error: javax.mail.MessagingException: Could not connect to SMTP host: 
> 193.194.70.19 , port: 25;
>   nested exception is:
> java.net.ConnectException: Connection refused
>
> Please see the DSpace documentation for assistance.
>
> 3- voici le fichier dspace.cfg
>
>  
>
> # Email settings ##
>
> # SMTP mail server
>
> mail.server = mon serveur messagerie
>
> # SMTP mail server authentication username and password (if required)
>
> mail.server.username = mon compte
>
> mail.server.password = mot de passe
>
> # SMTP mail server alternate port (defaults to 25)
>
> mail.server.port = 25
>
> # From address for mail
>
> mail.from.address = mon compte
>
> # Name of a pre-configured Session object to be fetched from a directory.
>
> # This overrides the Session settings above. If none can be found, then 
> DSpace
>
> # will use the above settings to create a Session.
>
> #mail.session.name =mon compte
>
> # Currently limited to one recipient!
>
> feedback.recipient = mon compte
>
> # General site administration (Webmaster) e-mail
>
> mail.admin = mon compte
>
> # Recipient for server errors and alerts
>
> alert.recipient =
>
> # Recipient for new user registration emails
>
> registration.notify =
>
> mail.charset = UTF-8
>
> mail.allowed.referrers = localhost
>
> mail.extraproperties = mail.smtp.socketFactory.port=465, \
>
> mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory, \
>
> mail.smtp.socketFactory.fallback=false
>
> #mail.server.disabled = false
>
> mail.ssl.enable = true
>
> Avec mes sicnères remerciements
> -- 
> *Mme HADJ KOUIDER*
> * Responsable du centre de calcul*
> * ENSA*
>

*bonjour;*
je suis ingénieur en informatique a univ Mostaganem , nous avons rencontré 
le même problème comment l'avez vous régler.??? 

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-tech] 20 million item repository with dspace

[Alan Orth]

"Normal" infrastructure issues aside—disk, RAM, CPU, etc—I'd say that
the handle server would be the "Y2K" type issue to be concerned about.
I don't think anyone definitively knows the limit of the handle
server. In May last year I asked about this:

https://groups.google.com/d/msg/dspace-tech/3iPnsHbhCf8/M07NqUoEBwAJ

Regards,

On Thu, Sep 29, 2016 at 3:39 AM, Bruno Nocera Zanette
 wrote:
> That is a LOT of items! How many requests per day/hour/... do you expect to
> have? Is it in the same proportion of items?
>
> I believe that the real problem is the quantity of requests, once the items
> will only be another row into the database. But to query over them will be a
> real challenge for Dspace!! Specially because it's not build to be
> distributed on the cloud.
>
> Keep us up to date with this, plz!
>
> Em qua, 28 de set de 2016 às 13:04, Terry Brady 
> escreveu:
>>
>> I believe that 20 million items would be a record for a DSpace repository.
>>
>> At Georgetown, we have more than 500,000 items.  A majority of these items
>> contain only metadata which may have simplified the issue for us.  We have
>> found DSpace to scale very nicely so far.
>>
>> I believe that the University of Cincinnati also has a very large DSpace
>> instance.
>>
>> You may want to cross-post this question to the dspace-general list to
>> reach a wider audience.
>>
>> Terry
>>
>> On Tue, Sep 27, 2016 at 11:14 PM, Thomas Adeyinka 
>> wrote:
>>>
>>> Hi guys. I looking to setup a repository which will contain close to 20
>>> million items.. mostly old news papers (scanned) images and videos. I am
>>> considering using dspace for this project for my institution. Does dspace
>>> have the capacity to take over 20 million items (all things equal) what
>>> database and hardware configuration would be recommended for such a project.
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "DSpace Technical Support" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an
>>> email to dspace-tech+unsubscr...@googlegroups.com.
>>> To post to this group, send email to dspace-tech@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/dspace-tech.
>>> For more options, visit https://groups.google.com/d/optout.
>>
>>
>>
>>
>> --
>> Terry Brady
>> Applications Programmer Analyst
>> Georgetown University Library Information Technology
>> http://georgetown-university-libraries.github.io/
>> 425-298-5498 (Seattle, WA)
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "DSpace Technical Support" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to dspace-tech+unsubscr...@googlegroups.com.
>> To post to this group, send email to dspace-tech@googlegroups.com.
>> Visit this group at https://groups.google.com/group/dspace-tech.
>> For more options, visit https://groups.google.com/d/optout.
>
> --
> Bruno Nocera Zanette
> +55 41 9992-2508
>
> --
> You received this message because you are subscribed to the Google Groups
> "DSpace Technical Support" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-tech+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-tech@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-tech.
> For more options, visit https://groups.google.com/d/optout.



-- 
Alan Orth
alan.o...@gmail.com
https://englishbulgaria.net
https://alaninkenya.org
https://mjanja.ch
"In heaven all the interesting people are missing." ―Friedrich Nietzsche
GPG public key ID: 0x8cb0d0acb5cd81ec209c6cdfbd1a0e09c2f836c0

-- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-tech@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-tech.
For more options, visit https://groups.google.com/d/optout.