Re: [dspace-tech] Number of Items submitted per annum

[Monika Mevenkamp]

I have a small jruby script that does just that 

Have a look at  https://github.com/akinom/dspace-cli 

in particular 
https://github.com/akinom/dspace-cli/blob/master/statistics/submissions.rb 


This requires JRuby and bundler to run 
and will compile a report along the lines of 

YearMonth   #Items
201509  985
201510  8

Monika 


 
Monika Mevenkamp
mo.me...@gmail.com

http://mo-meven.tumblr.com/
http://mcmprogramming.com/mo.meven/



> On Mar 7, 2016, at 8:03 AM, Hilton Gibson  wrote:
> 
> Thanks Alex,
> 
> However due to a severe disk usage problem many of my log files are gone!
> So that option is not available to me ;-((
> 
> Cheers
> 
> hg
> 
> Hilton Gibson
> Stellenbosch University Library
> http://orcid.org/-0002-2992-208X 
> 
> 
> On 7 March 2016 at 14:39, Àlex Magaz Graça  > wrote:
> El 07/03/16 a las 12:35, Hilton Gibson escribió:
> Hi All,
> 
> DSpace 5.4, XMLUI
> 
> Is it possible to extract the total number of items submitted per month
> per annum for the entire repository? I collect SQL queries here:
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips 
> 
> 
> But the one I have does not work with DSpace 5.4.
> Does anyone have an updated version that works with DSpace 5.4?
> 
> Cheers
> 
> *Hilton Gibson*
> Stellenbosch University Library
> _http://orcid.org/-0002-2992-208X_ 
> 
> -- 
> 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 
> .
> Hi Hilton,
> 
> Instead of SQL I use something like this:
> 
> grep action.submission_complete /var/log/dspace/dspace-log-monthly-2015-*.dat
> 
> Cheers,
> Àlex
> 
> 
> -- 
> 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] Number of Items submitted per annum

[Hilton Gibson]

Thanks Alex,

However due to a severe disk usage problem many of my log files are gone!
So that option is not available to me ;-((

Cheers

hg

*Hilton Gibson*
Stellenbosch University Library
*http://orcid.org/-0002-2992-208X
*


On 7 March 2016 at 14:39, Àlex Magaz Graça  wrote:

> El 07/03/16 a las 12:35, Hilton Gibson escribió:
>
>> Hi All,
>>
>> DSpace 5.4, XMLUI
>>
>> Is it possible to extract the total number of items submitted per month
>> per annum for the entire repository? I collect SQL queries here:
>> http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips
>>
>> But the one I have does not work with DSpace 5.4.
>> Does anyone have an updated version that works with DSpace 5.4?
>>
>> Cheers
>>
>> *Hilton Gibson*
>> Stellenbosch University Library
>> _http://orcid.org/-0002-2992-208X_
>>
>> --
>> 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.
>>
> Hi Hilton,
>
> Instead of SQL I use something like this:
>
> grep action.submission_complete
> /var/log/dspace/dspace-log-monthly-2015-*.dat
>
> Cheers,
> Àlex
>

-- 
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] Number of Items submitted per annum

[Sean Carte]

On 7 March 2016 at 13:35, Hilton Gibson  wrote:

> DSpace 5.4, XMLUI
>
> Is it possible to extract the total number of items submitted per month
> per annum for the entire repository? I collect SQL queries here:
> http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips
>
> But the one I have does not work with DSpace 5.4.
> Does anyone have an updated version that works with DSpace 5.4?
>

Hi Hilton

This is what I'm using:

SELECT cm.community_id, co.collection_id, substring(mv.text_value,1,7) AS
year_month,  count(*) AS num_items_added
FROM metadatavalue mv, item it, collection co, community cm,
community2collection c2c
WHERE mv.resource_id = it.item_id
AND it.owning_collection = co.collection_id
AND co.collection_id = c2c.collection_id
AND c2c.community_id = cm.community_id
AND mv.metadata_field_id = 11
AND it.in_archive  AND text_value >= '2016-02'
AND text_value < '2016-03'  GROUP BY 1, 2, 3
ORDER BY 2;

Not quite what you're after as I have to run that for each month.

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] Number of Items submitted per annum

[Hilton Gibson]

Hi All,

DSpace 5.4, XMLUI

Is it possible to extract the total number of items submitted per month per
annum for the entire repository? I collect SQL queries here:
http://wiki.lib.sun.ac.za/index.php/SUNScholar/SQL_Tips

But the one I have does not work with DSpace 5.4.
Does anyone have an updated version that works with DSpace 5.4?

Cheers

*Hilton Gibson*
Stellenbosch University Library
*http://orcid.org/-0002-2992-208X
*

-- 
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.