Re: [Dspace-tech] How to purge/remove old thumbnails?

2013-09-17 Thread helix84
On Mon, Sep 16, 2013 at 11:24 PM, Alcides Carlos de Moraes Neto alcides.n...@gmail.com wrote: How should I delete these bitstreams? Set the DELETED field to 1? Yes, do that and call [dspace]/bin/dspace cleanup -v - that will actually delete the files from disk. I set the DELETED field to 1 in

Re: [Dspace-tech] How to purge/remove old thumbnails?

2013-09-16 Thread Alcides Carlos de Moraes Neto
How should I delete these bitstreams? Set the DELETED field to 1? Ats, Alcides Carlos de Moraes Neto Sometimes I think we're alone. Sometimes I think we're not. In either case, the thought is staggering. - R. Buckminster Fuller 2013/9/16 Alcides Carlos de Moraes Neto alcides.n...@gmail.com

Re: [Dspace-tech] How to purge/remove old thumbnails?

2013-09-16 Thread Alcides Carlos de Moraes Neto
I set the DELETED field to 1 in the bitstream table and deleted the matching lines from bundle2bitstream. Ats, Alcides Carlos de Moraes Neto Sometimes I think we're alone. Sometimes I think we're not. In either case, the thought is staggering. - R. Buckminster Fuller 2013/9/16 Alcides Carlos

Re: [Dspace-tech] How to purge/remove old thumbnails?

2013-09-16 Thread Alcides Carlos de Moraes Neto
Thank you helix that gave me a head start. My query got more complex because I needed to filter only thumbnails as I have some items that have .jpg files. And some of them have very generic file names, so I had to match the thumbnail to the file wihtin a specific ITEM_ID. This query will detect

Re: [Dspace-tech] How to purge/remove old thumbnails?

2013-09-15 Thread helix84
Hi Alcides, you could do something like the following SQL query. Please note that I didn't actually test it, it's just to give you the idea. SELECT bistream_id, nameFROM bitstreamWHERE name LIKE '%.jpg'AND rtrim(name, '.jpg') NOT IN (SELECT name FROM bitstream); Regards, ~~helix84 Compulsory

[Dspace-tech] How to purge/remove old thumbnails?

2013-09-13 Thread Alcides Carlos de Moraes Neto
Hello everyone, I have this situation where some entries had two PDFs, and got thumbnails generated for these PDFS. But the first PDFs of these items were removed from the entires. But the items' thumbnails in the search results did not change, they are still showing the thumbnail for the first