Hi George, here an addition. Some metadata fields are critical because alls DSpace-Objects have metadata, i.e. Communities and Collections, too. Especially fields like dc.title are also used for Communities and Collections metadata.
Best regards, Paul -------- Weitergeleitete Nachricht -------- Betreff: Re: [dspace-tech] Finding out if a metadata field is used Datum: Wed, 3 Jan 2018 08:34:49 +0100 Von: Paul Münch <[email protected]> Organisation: Universitätsbibliothek Marburg An: George Kozak <[email protected]> Hi George, I don't know if there is a DSpace tool but every metadata to dspace-object relation is hold in database. So a SQL query is all you need. You only have to know the "metadata_field_id". This is stored in the "metadatafieldregistry" table. Either you looking in the Admin UI for metadata-registry or you use a SQL-Query like this: "SELECT metadata_field_id FROM metadatafieldregistry WHERE element='title' AND qualifier='alternative';" (= field_id 71). With this ID you can query the "metadatavalue" table, e.g. "SELECT COUNT(*) FROM metadatavalue WHERE metadata_field_id = 71;" Best regards, Paul Am 02.01.2018 um 21:36 schrieb George Kozak: > Hi... > We are using DSpace 5.5 (going to 6.2). A Metadata Librarian at my > site asked if I could find out how many times a certain DC metadata > field was being used in DSpace instance. Has anyone ever queried the > system for that particular information, and if so, could you share > with me how to do that :-) ? > Thanks! > > -- > *************************** > George Kozak > Digital Library Specialist > Cornell University Library - IT > 218 Olin Library > Cornell University > Ithaca, NY 14853 > 607-255-8924 > [email protected] <mailto:[email protected]> > -- > You received this message because you are subscribed to the Google > Groups "DSpace Technical Support" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. -- Philipps-Universität Marburg | UB Digitale Dienste | Wilhelm-Röpke-Straße 6 | 08A09 Tel. 06421/28-24624 | -- -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
signature.asc
Description: OpenPGP digital signature
