Hi Sten,
you can do such changes on db level. Make sure to have a dump of your
database first.
In order to add dc.description to all items in one collection execute:
insert into metadatavalue (metadata_value_id, item_id,
metadata_field_id, text_value, text_lang) select
nextval('metadatavalue_seq'), item_id, METADATAFIELDID, 'TEXT FOR
DESCRIPTION', 'LANGAGUE' from item where owning_collection=YOURCOLLECTIONID;
assuming you want to add
"This resource has be peer reviewed"
to all items in the
Collection with collection_id 1
and the
metadata_field_id of dc.description is 26
the command would be
insert into metadatavalue (metadata_value_id, item_id,
metadata_field_id, text_value, text_lang) select
nextval('metadatavalue_seq'), item_id, 26, 'This resource has be peer
reviewed', 'en' from item where owning_collection=1;
Hope that helps
Claudia Jürgen
Sten Christensen schrieb:
> Hi all
>
> Is there a away to update the data within a specific metadata element
> across a specified collection without API? I have a collection of 350
> items and I need to change the text within the description element. The
> text will be the same across all items.
>
> I thought I saw something about this on the list some time ago but could
> not find reference to it in the archive.
>
> Thanks
> Sten
>
>
> Sten Christensen
>
> Sydney eScholarship Repository Coordinator
> University of Sydney Library F03
> Camperdown NSW 2006
> Ph: +61 2 9351 7407
> Fax: +61 2 9114 0620
> Mob: 0434368895
> email: [EMAIL PROTECTED]
> web: http://ses.library.usyd.edu.au/
>
>
>
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
