[Dspace-tech] Handle-assetstore

2012-07-31 Thread Alain Tschanz
Hello, How/where can I look up what handle corresponds to what directory/file in the assetstore? For example, I tried to export a collection, but I received the following error message: The task exited unexpectedly or failed. For more information, please contact the site administrator or

Re: [Dspace-tech] Handle-assetstore

2012-07-31 Thread helix84
Hi Alain, this should do the trick (I tested it only cursorily): SELECT DISTINCT handle.handle_id FROM bitstream,bundle2bitstream,item2bundle,bundle,handle WHERE handle.resource_id=item2bundle.item_id AND item2bundle.bundle_id=bundle2bitstream.bundle_id AND

Re: [Dspace-tech] Handle-assetstore

2012-07-31 Thread helix84
It should be also helpful to know the bitstream name in addition to item handle: SELECT DISTINCT handle.handle_id, bitstream.name FROM bitstream,bundle2bitstream,item2bundle,bundle,handle WHERE handle.resource_id=item2bundle.item_id AND item2bundle.bundle_id=bundle2bitstream.bundle_id AND