« September 2010 | Main | November 2010 »

October 21, 2010

SQL to find DSPACE collection info given item handle

Collection name

Collection name for item handle 94921

SELECT collection.name FROM collection, collection2item, item, handle WHERE collection2item.item_id=item.item_id AND collection2item.collection_id=collection.collection_id AND handle.resource_id=item.item_id AND handle = 94921 ;

Collection handle

Collection handle for item handle 94921

SELECT handle FROM handle WHERE resource_type_id=3 AND resource_id=(SELECT collection.collection_id FROM collection, collection2item, item, handle WHERE collection2item.item_id=item.item_id AND collection2item.collection_id=collection.collection_id AND handle.resource_id=item.item_id AND handle = 94921) ;

October 12, 2010

examples of provenance field in DSPACE

When we move from DSPACE to drupal/fedora we will need
 handle 	                            Provenance
36676	 Made available in DSpace on 2007-03-07T16:00:37Z (GMT). No. of bitstreams: 1 sp02fe01.pdf: 51451 bytes, checksum: 6731d24ea9ea1130f75f334af1254c47 (MD5)   Previous issue date: 2002
36675	 Made available in DSpace on 2007-03-07T16:00:37Z (GMT). No. of bitstreams: 1 sp02fe01.pdf: 51451 bytes, checksum: 6731d24ea9ea1130f75f334af1254c47 (MD5)   Previous issue date: 2002
36674	 Made available in DSpace on 2007-03-07T16:00:37Z (GMT). No. of bitstreams: 1 sp02fe01.pdf: 51451 bytes, checksum: 6731d24ea9ea1130f75f334af1254c47 (MD5)   Previous issue date: 2002
36673	 Made available in DSpace on 2007-03-07T16:00:39Z (GMT). No. of bitstreams: 1 sp02in01.pdf: 38798 bytes, checksum: c50744342b737b0150f9e7daba133471 (MD5)   Previous issue date: 2002
36672	 Made available in DSpace on 2007-03-07T16:00:39Z (GMT). No. of bitstreams: 1 sp02in01.pdf: 38798 bytes, checksum: c50744342b737b0150f9e7daba133471 (MD5)   Previous issue date: 2002
36671	 Made available in DSpace on 2007-03-07T16:00:39Z (GMT). No. of bitstreams: 1 sp02in01.pdf: 38798 bytes, checksum: c50744342b737b0150f9e7daba133471 (MD5)   Previous issue date: 2002
36670	 Made available in DSpace on 2007-03-07T16:00:40Z (GMT). No. of bitstreams: 1 sp02cl01.pdf: 220515 bytes, checksum: fc81cbb5e1d3ff157bc1ec8ee07142b1 (MD5)   Previous issue date: 2002
36669	 Made available in DSpace on 2007-03-07T16:00:40Z (GMT). No. of bitstreams: 1 sp02cl01.pdf: 220515 bytes, checksum: fc81cbb5e1d3ff157bc1ec8ee07142b1 (MD5)   Previous issue date: 2002
36668	 Made available in DSpace on 2007-03-07T16:00:40Z (GMT). No. of bitstreams: 1 sp02cl01.pdf: 220515 bytes, checksum: fc81cbb5e1d3ff157bc1ec8ee07142b1 (MD5)   Previous issue date: 2002
36667	 Made available in DSpace on 2007-03-07T16:00:41Z (GMT). No. of bitstreams: 1 sp02de01.pdf: 43516 bytes, checksum: b2c54432266049e04b14a9e5e6a4c6df (MD5)   Previous issue date: 2002
36666	 Made available in DSpace on 2007-03-07T16:00:41Z (GMT). No. of bitstreams: 1 sp02de01.pdf: 43516 bytes, checksum: b2c54432266049e04b14a9e5e6a4c6df (MD5)   Previous issue date: 2002
36665	 Made available in DSpace on 2007-03-07T16:00:41Z (GMT). No. of bitstreams: 1 sp02de01.pdf: 43516 bytes, checksum: b2c54432266049e04b14a9e5e6a4c6df (MD5)   Previous issue date: 2002
36664	 Made available in DSpace on 2007-03-07T16:00:42Z (GMT). No. of bitstreams: 1 sp02fl01.pdf: 89644 bytes, checksum: 4c353f2db94dde10910d36d3610ac68e (MD5)   Previous issue date: 2002
36663	 Made available in DSpace on 2007-03-07T16:00:42Z (GMT). No. of bitstreams: 1 sp02fl01.pdf: 89644 bytes, checksum: 4c353f2db94dde10910d36d3610ac68e (MD5)   Previous issue date: 2002
36662	 Made available in DSpace on 2007-03-07T16:00:42Z (GMT). No. of bitstreams: 1 sp02fl01.pdf: 89644 bytes, checksum: 4c353f2db94dde10910d36d3610ac68e (MD5)   Previous issue date: 2002
36661	 Made available in DSpace on 2007-03-07T16:00:42Z (GMT). No. of bitstreams: 1 sp02ba02.pdf: 149756 bytes, checksum: eb35a6d44da3a3645a71315c46c419bf (MD5)   Previous issue date: 2002
36660	 Made available in DSpace on 2007-03-07T16:00:42Z (GMT). No. of bitstreams: 1 sp02ba02.pdf: 149756 bytes, checksum: eb35a6d44da3a3645a71315c46c419bf (MD5)   Previous issue date: 2002
36659	 Made available in DSpace on 2007-03-07T16:00:42Z (GMT). No. of bitstreams: 1 sp02ba02.pdf: 149756 bytes, checksum: eb35a6d44da3a3645a71315c46c419bf (MD5)   Previous issue date: 2002
36658	 Made available in DSpace on 2007-03-07T16:00:43Z (GMT). No. of bitstreams: 1 sp02up01.pdf: 542678 bytes, checksum: a06c46cbfda686890c712bf5de083026 (MD5)   Previous issue date: 2002
36657	 Made available in DSpace on 2007-03-07T16:00:43Z (GMT). No. of bitstreams: 1 sp02up01.pdf: 542678 bytes, checksum: a06c46cbfda686890c712bf5de083026 (MD5)   Previous issue date: 2002
36656	 Made available in DSpace on 2007-03-07T16:00:43Z (GMT). No. of bitstreams: 1 sp02up01.pdf: 542678 bytes, checksum: a06c46cbfda686890c712bf5de083026 (MD5)   Previous issue date: 2002
36655	 Made available in DSpace on 2007-03-07T16:00:44Z (GMT). No. of bitstreams: 1 sp02ho01.pdf: 149243 bytes, checksum: 2db5cfebc10b0cd148ce1e06e2149851 (MD5)   Previous issue date: 2002
36654	 Made available in DSpace on 2007-03-07T16:00:44Z (GMT). No. of bitstreams: 1 sp02ho01.pdf: 149243 bytes, checksum: 2db5cfebc10b0cd148ce1e06e2149851 (MD5)   Previous issue date: 2002
36653	 Made available in DSpace on 2007-03-07T16:00:44Z (GMT). No. of bitstreams: 1 sp02ho01.pdf: 149243 bytes, checksum: 2db5cfebc10b0cd148ce1e06e2149851 (MD5)   Previous issue date: 2002
36652	 Made available in DSpace on 2007-03-07T16:00:45Z (GMT). No. of bitstreams: 1 sp02va01.pdf: 102387 bytes, checksum: cb7f7c54b0b7713a7e8df1ee749db762 (MD5)   Previous issue date: 2002
36651	 Made available in DSpace on 2007-03-07T16:00:45Z (GMT). No. of bitstreams: 1 sp02va01.pdf: 102387 bytes, checksum: cb7f7c54b0b7713a7e8df1ee749db762 (MD5)   Previous issue date: 2002
36650	 Made available in DSpace on 2007-03-07T16:00:45Z (GMT). No. of bitstreams: 1 sp02va01.pdf: 102387 bytes, checksum: cb7f7c54b0b7713a7e8df1ee749db762 (MD5)   Previous issue date: 2002
36649	 Made available in DSpace on 2007-03-07T16:00:46Z (GMT). No. of bitstreams: 1 sp02sh01.pdf: 188489 bytes, checksum: bff2872ec0b4de423a55bc5684796153 (MD5)   Previous issue date: 2002
36648	 Made available in DSpace on 2007-03-07T16:00:46Z (GMT). No. of bitstreams: 1 sp02sh01.pdf: 188489 bytes, checksum: bff2872ec0b4de423a55bc5684796153 (MD5)   Previous issue date: 2002
36647	 Made available in DSpace on 2007-03-07T16:00:46Z (GMT). No. of bitstreams: 1 sp02sh01.pdf: 188489 bytes, checksum: bff2872ec0b4de423a55bc5684796153 (MD5)   Previous issue date: 2002

provenance.xls