Hello Helix
Thanks for your reply. Maybe you could help us the following way:
1) Here is one thumbnail image from our DSpace:
http://digital.library.iadb.org/public/bitstream/handle/iadb/77379/Housing_Cycles_and_Macroeconomic_Fluctuations:_A_Global_Perspective.pdf.png?sequence=4
2) So we have the handle (iadb/77379), filename
(Housing_Cycles_and_Macroeconomic_Fluctuations:_A_Global_Perspective.pdf.png)
and the sequence (4)
3) How can we find/export the file
Housing_Cycles_and_Macroeconomic_Fluctuations:_A_Global_Perspective.pdf.png
from the DSpace assetstore to the disk?
Thanks in advance for your help on this.
Best regards
Rodrigo
From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84
Sent: Monday, November 12, 2012 4:26 PM
To: Calloni, Rodrigo
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] How to export the thumbnail bitstreams?
On Mon, Nov 12, 2012 at 10:14 PM, Calloni, Rodrigo
<rcall...@iadb.org<mailto:rcall...@iadb.org>> wrote:
> I would prefer option 2. I just need a hard-copy of the thumbnail files and
> if I can do that via SQL even better.
Warning, untested code ahead:
SELECT 'cp /dspace/assetstore/' || substr(bitstream.internal_id, 1, 2) || '/'
|| substr(bitstream.internal_id, 3, 2) || '/' || substr(bitstream.internal_id,
5, 2) || '/' || bitstream.internal_id || ' ' || bitstream.name
FROM bitstream,bundle2bitstream,bundle
WHERE bitstream.bitstream_id = bundle2bitstream.bitstream_id
AND bundle2bitstream.bundle_id = bundle.bundle_id
AND bundle.name = 'THUMBNAIL';
but it should give you the idea.
Regards,
~~helix84
Compulsory reading: DSpace Mailing List Etiquette
https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech