[Dspace-tech] Generating a list of bitstream URLs
Hi... I am not sure if this has been addressed before, but I would like to generate a list of bitstream URLS for certain collections in DSpace. For instance, an item: http://ecommons.library.cornell.edu/handle/1813/29648 has a bitstream: Brutsaert_Parlange_Symposium_Photo_Album_10Aug12Reduced.pdf with a URL of /bitstream/1813/29648/2/Brutsaert_Parlange_Symposium_Photo_Album_10Aug12Reduced.pdfview-source:http://ecommons.library.cornell.edu/bitstream/1813/29648/2/Brutsaert_Parlange_Symposium_Photo_Album_10Aug12Reduced.pdf I have SQL scripts that will get me the handles for an item and the bitstream names, so, I can almost build the URL to the bitstream. The only missing piece for me is the bitstream number (2, 3, etc.). Is there a way from the SQL tables to determine this? George Kozak Digital Library Specialist Cornell University Library Information Technologies (CUL-IT) 501 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Generating a list of bitstream URLs
On Tue, Aug 14, 2012 at 2:29 PM, George S Kozak g...@cornell.edu wrote: I have SQL scripts that will get me the handles for an item and the bitstream names, so, I can almost build the URL to the bitstream. The only missing piece for me is the bitstream number (“2”, “3”, etc.). Is there a way from the SQL tables to determine this? Hi George, it's the sequence_id column in the bitstream table. Will you manage it from here? Regards, ~~helix84 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Generating a list of bitstream URLs
Helix84: Thanks! I should have recognized that, but for some reason, it slipped past me! George Kozak Digital Library Specialist Cornell University Library Information Technologies (CUL-IT) 501 Olin Library Cornell University Ithaca, NY 14853 607-255-8924 -Original Message- From: ivan.ma...@gmail.com [mailto:ivan.ma...@gmail.com] On Behalf Of helix84 Sent: Tuesday, August 14, 2012 8:38 AM To: George S Kozak Cc: dspace-tech@lists.sourceforge.net Subject: Re: [Dspace-tech] Generating a list of bitstream URLs On Tue, Aug 14, 2012 at 2:29 PM, George S Kozak g...@cornell.edu wrote: I have SQL scripts that will get me the handles for an item and the bitstream names, so, I can almost build the URL to the bitstream. The only missing piece for me is the bitstream number (“2”, “3”, etc.). Is there a way from the SQL tables to determine this? Hi George, it's the sequence_id column in the bitstream table. Will you manage it from here? Regards, ~~helix84 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech