Hi Larry,
the basic command would be:
insert into metadatavalue (metadata_value_id, item_id,
metadata_field_id, text_value, text_lang, place)
select nextval('metadatavalue_seq'), YourValues, ...
from item where ... YourClause
E.g. you want to add
dc.audience (id=67) = Visually Impaired and Blind
to all the items of collection 70
insert into metadatavalue (metadata_value_id, item_id,
metadata_field_id, text_value, text_lang, place)
select nextval('metadatavalue_seq'), item_id, 67, 'Visually Impaired and
Blind', 'en', 1 from item where owning_collection=70;
NOTE: allways make the security copies before tampering with the
database directly.
hope that helps
Claudia
Larry Hansard schrieb:
> I need to add a few thousand metadata fields for items that are in our DSpace
> repository. Does anyone know the sql command to increment the
> metadatavalue_seq? Thanks
>
>
> Larry Hansard
> Georgia Tech
> Library Systems
> 404-894-4585
>
>
> -------------------------------------------------------------------------
> 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
