Just Launched: You can now import projects and releases from Google Code onto SourceForge
We are excited to release new functionality to enable a 1-click import from Google Code onto the Allura platform on SourceForge. You can import tickets, wikis, source, releases, and more with a few simple steps. Read More
Q1. We need to create to a new Dublin Core (DC) metadata field, dc.description.fulltext. How do we go about it?
Q2. We need to insert a metadata entry, dc.description.fulltext=Yes for every record in a community (say, DB ID=3) How do we go about it?
National Institute of Education (Singapore) http://www.nie.edu.sg
DISCLAIMER : The information contained in this email, including any attachments, may contain confidential information.
This email is intended only for the use of the addressee(s) listed above. Unauthorised sight, dissemination or any other
use of the information contained in this email is strictly prohibited. If you have received this email by fault, please
notify the sender and delete it immediately.
if you have Discovery enabled and you want to make a query which will
select all items that have a fulltext (i.e. a bistream in the TEXT bundle),
you can just use this Solr query in the DSpace search box: "fulltext:*"
This will also correctly restrict search results to the current
If this is not the usage you have in mind, you can do this:
On Wed, Dec 26, 2012 at 7:41 AM, LIBRIS Reference (LIBRIS) <
> Q1. We need to create to a new Dublin Core (DC) metadata field,
dc.description.fulltext. How do we go about it?
Just use the administrator's interface to add the field (Registries -
> Q2. We need to insert a metadata entry, dc.description.fulltext=Yes for
every record in a community (say, DB ID=3) How do we go about it?
1) back up your database
2) look up the metadata field name (element and qualifier columns) in the
metadatafieldregistry table and find its metadata_field_id
3) use this code to insert the values (FIELD_ID is the value you found in
2), ITEM_ID is the internal ID of the item to which you want to add
INSERT INTO metadatavalue (item_id, metadata_field_id,
text_value)VALUES (ITEM_ID, FIELD_ID, 'Yes')
Code is untested, from the top of my head. Remember to back up!
Compulsory reading: DSpace Mailing List Etiquette