Hi.

We have a need to add a new metadata field (a unique identifier) to many records in our DSpace (1.4.2) database. Basically, we will have a list of DOI-identifier pairs, and for each item matching the DOI, we'll want to add a new identifier field with the identifier value.

Can anyone offer me a clue as to how I do this? I.e. what SQL code do I need to create a new metadata field for an item?

I can see that I need to INSERT into METADATAVALUE, but .. where do I get METADATA_VALUE_ID?


Cheers,
Steve

--

Stephen Thomas,
Senior Systems Analyst,
University of Adelaide Library
UNIVERSITY OF ADELAIDE SA 5005 AUSTRALIA
Phone: +61 8 830 35190
Fax: +61 8 830 34369
Email: [EMAIL PROTECTED]
URL: http://www.adelaide.edu.au/directory/stephen.thomas
CRICOS Provider Number 00123M

P please consider the environment before printing.

This email message is intended only for the addressee(s) and contains information that may be confidential and/or copyright. If you are not the intended recipient please notify the sender by reply email and immediately delete this email. Use, disclosure or reproduction of this email by anyone other than the intended recipient(s) is strictly prohibited. No representation is made that this email or any attachments are free of viruses. Virus scanning is recommended and is the responsibility of the recipient.

begin:vcard
fn:Steve Thomas
n:Thomas;Steve
org:University of Adelaide;Barr Smith Library
adr:;;South Australia;;;5005;Australia
email;internet:[EMAIL PROTECTED]
title:Senior Systems Analyst
tel;work:+61 8 830 35190
tel;fax:+61 8 8303 4369
tel;cell:0402069087
x-mozilla-html:TRUE
url:http://www.adelaide.edu.au/directory/stephen.thomas
version:2.1
end:vcard

-------------------------------------------------------------------------
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to