Re: [dspace-tech] Question about thumbnails

2017-01-31 Thread George Kozak 
Thanks, Terry!
***
George Kozak
Digital Library Specialist
Cornell University Library - IT
218 Olin Library
Cornell University
Ithaca, NY 14853
607-255-8924 <(607)%20255-8924>
g...@cornell.edu

On Tue, Jan 31, 2017 at 11:33 AM, Terry Brady 
wrote:

> I used to have queries that could perform this check, but I phased them
> out with the database changes in DSpace 5.
>
> Here are some hints for the query. This is untested, but it will get you
> there.
>
> select from item i
> join item2bundle i2b on i.item_id=i2b.item_id
> join bundle b on i2b.bundle_id=b.bundle_id
> join metadatavalue bunmv on
>   b.bundle_id=bmv.resource_id
>   and bmv.resource_type_id=1
>   and bmv.text_value='THUMBNAIL'
> join metadatafieldregistry bunmfr on
>   bunmfr.metadata_field_id=bunmv.metadata_field_id
>   and bunmfr.element='title'
>   and bunmfr.qualifier is null
> join bundle2bitstream b2b on b2b.bundle_id=b.bundle_id
> join bitstream bit on bit.bitstream_id=b2b.bitstream_id
>
> An easier approach would be to run the filter-media command line option
> against your repo and then scan the output for errors.
>
> You can specify only to create thumbnails.  By default, it will not
> recreate thumbnails that already exist.
>
> https://wiki.duraspace.org/display/DSDOC5x/Mediafilters+
> for+Transforming+DSpace+Content
>
> On Tue, Jan 31, 2017 at 8:00 AM, George Kozak  wrote:
>
>> I am wondering if there is a SQL query that would tell me if an item is
>> missing a Thumbnail?  I have a of of items that are submitted to our
>> repository, and outside of checking all of the recent submissions using
>> "browse by",  I was wondering if there was a quick and easy way to look for
>> missing thumbnails in postgres.
>> PS: I am using DSpace 5.5 (XMLUI/modified Mirage2)
>> --
>> ***
>> George Kozak
>> Digital Library Specialist
>> Cornell University Library - IT
>> 218 Olin Library
>> Cornell University
>> Ithaca, NY 14853
>> 607-255-8924 <(607)%20255-8924>
>> g...@cornell.edu
>>
>> --
>> 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 <(425)%20298-5498> (Seattle, WA)
>



-- 
***
George Kozak
Digital Library Specialist
Cornell University Library - IT
218 Olin Library
Cornell University
Ithaca, NY 14853
607-255-8924
g...@cornell.edu

-- 
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] Question about thumbnails

2017-01-31 Thread Terry Brady 
I used to have queries that could perform this check, but I phased them out
with the database changes in DSpace 5.

Here are some hints for the query. This is untested, but it will get you
there.

select from item i
join item2bundle i2b on i.item_id=i2b.item_id
join bundle b on i2b.bundle_id=b.bundle_id
join metadatavalue bunmv on
  b.bundle_id=bmv.resource_id
  and bmv.resource_type_id=1
  and bmv.text_value='THUMBNAIL'
join metadatafieldregistry bunmfr on
  bunmfr.metadata_field_id=bunmv.metadata_field_id
  and bunmfr.element='title'
  and bunmfr.qualifier is null
join bundle2bitstream b2b on b2b.bundle_id=b.bundle_id
join bitstream bit on bit.bitstream_id=b2b.bitstream_id

An easier approach would be to run the filter-media command line option
against your repo and then scan the output for errors.

You can specify only to create thumbnails.  By default, it will not
recreate thumbnails that already exist.

https://wiki.duraspace.org/display/DSDOC5x/Mediafilters+for+Transforming+DSpace+Content

On Tue, Jan 31, 2017 at 8:00 AM, George Kozak  wrote:

> I am wondering if there is a SQL query that would tell me if an item is
> missing a Thumbnail?  I have a of of items that are submitted to our
> repository, and outside of checking all of the recent submissions using
> "browse by",  I was wondering if there was a quick and easy way to look for
> missing thumbnails in postgres.
> PS: I am using DSpace 5.5 (XMLUI/modified Mirage2)
> --
> ***
> George Kozak
> Digital Library Specialist
> Cornell University Library - IT
> 218 Olin Library
> Cornell University
> Ithaca, NY 14853
> 607-255-8924 <(607)%20255-8924>
> g...@cornell.edu
>
> --
> 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.

[dspace-tech] Question about thumbnails

2017-01-31 Thread George Kozak 
I am wondering if there is a SQL query that would tell me if an item is
missing a Thumbnail?  I have a of of items that are submitted to our
repository, and outside of checking all of the recent submissions using
"browse by",  I was wondering if there was a quick and easy way to look for
missing thumbnails in postgres.
PS: I am using DSpace 5.5 (XMLUI/modified Mirage2)
-- 
***
George Kozak
Digital Library Specialist
Cornell University Library - IT
218 Olin Library
Cornell University
Ithaca, NY 14853
607-255-8924
g...@cornell.edu

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