Assuming you want to do this on all bitstreams in your system that have a
particular format you can do the following:
SELECT * FROM BITSTREAMFORMATREGISTRY;
choose the format you want to work with and pick the number from the
BITSTREAM_FORMAT_ID column. then assuming you want to work with format_id 2
SELECT * FROM BITSTREAM WHERE BITSTREAM_FORMAT_ID = 2 AND DESCRIPTION = NULL;
this should give you the list of your bitstreams - check whether this seems
correct
then
UPDATE BITSTREAM SET description=‘Access flutist' WHERE BITSTREAM_FORMAT_ID = 2
AND DESCRIPTION = NULL;
COMMIT;
If you truly want to work on all bitstreams without a description skip the
WHERE clause
UPDATE BITSTREAM SET description=‘Access flutist’ ;
COMMIT;
Monika
________________
Monika Mevenkamp
phone: 609-258-4161
Princeton University, Princeton, NJ 08544
On Apr 16, 2015, at 7:22 AM, Michelangelo M M Viana
<mvi...@pucrs.br<mailto:mvi...@pucrs.br>> wrote:
Hi,
Can someone tell me what is the proper SQL command to update bitstream
description of items in DSpace (5.1) PostGreSQL dabatase, especially when it is
empty (null)? Or even a way to do that using dspace executable (command line)?
We generated items to be imported with the content file without a bitstream
description, having only “filename.pdf [tab] bundle:ORIGINAL”, so bitstreams
were imported without their description (empty, null).
To “fix” that we are manually editing the imported items and typing the
bitstream description (Eg, all of them will have the text: “Access fulltext”),
however many items were imported (+5000), and it is a very boring task.
Thanks in advance for your help,
Michelangelo
Michelangelo Mazzardo Marques Viana | Support and Development
Coordinator of Libraries Systems. Librarian CRB-10/1306
Pontifical Catholic University of Rio Grande do Sul - PUCRS
Ir. Jose Otao Central Library | Porto Alegre, RS, Brazil
+55(51) 3353.4371| mvi...@pucrs.br<mailto:mvi...@pucrs.br> |
http://www.pucrs.br/biblioteca
____________________________________________________________________
Central Library Virtual Tour: http://www.pucrs.br/biblioteca/visitavirtual
Find us on Facebook: http://www.facebook.com/bibliotecapucrs
Follow us on Twitter: https://twitter.com/bibliotecapucrs
Know our spaces on Flickr: http://www.flickr.com/bibliotecapucrs
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net<mailto:DSpace-tech@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
