|
||||||||
|
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira |
||||||||
------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________ Dspace-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-devel
/rep1/postgresql/bin/psql dspace > /tmp/progress-raw << EOF
SELECT item.item_id,
metadatafieldregistry.element,
metadatafieldregistry.qualifier,
metadatavalue.text_value
FROM
item,
metadatafieldregistry,
metadataschemaregistry,
metadatavalue
WHERE
item.item_id = metadatavalue.item_id AND
metadatavalue.metadata_field_id = metadatafieldregistry.metadata_field_id AND
metadatafieldregistry.metadata_schema_id = metadataschemaregistry.metadata_schema_id AND
metadatavalue.text_value LIKE '%@%'
ORDER BY item.item_id
;
EOF
cat /tmp/progress-raw | grep "Approved for entry into archive" |sed 's/^[^(]*(\([^)]*\)) on \([-0-9]*\).*$/\1 CC \2/' > /tmp/progress-data
for year in 2011 2012 2013; do
for month in 01 02 03 04 05 06 07 08 09 10 11 12; do
for user in `cat /tmp/progress-data | tr ' ' '\012' | grep @ | sort |uniq`; do
count=`grep $year-$month /tmp/progress-data | grep $user | wc -l`
if [ $count != "0" ]; then
echo $user $year $month $count
fi
done
done
done