Re: [dspace-community] Metadata finding

[Javier Fernandez]

Thanks for the help.

On Thu, Feb 14, 2019 at 7:20 AM Claudia Jürgen <
claudia.juer...@tu-dortmund.de> wrote:

> Hello Javier,
>
> there are a lot of ways you can achieve this:
>
> Database Query
> 5.x and below
> select item_id from  item where in_archive=true and item_id not in
> (select item_id from metadatavalue where
> metadata_field_id=YOUR-METADATA-FIELD-ID) ;
> 6.x
> select uuid from item where in_archive=true and uuid not in (select
> dspace_object_id from metadatavalue where where
> metadata_field_id=YOUR-METADATA-FIELD-ID) ;
>
> Solr Query
> query for item with not dc.contributor.author
> "-dc.contributor.author:* AND search.resourcetype:2
>
> Curation Task
> see https://wiki.duraspace.org/display/DSPACE/CurationSystem
>
> Batch Metadata Editing
> see
> https://wiki.duraspace.org/display/DSPACE/Batch+Metadata+Editing+Feature
>
> OAI
> Create your own oai context with a filter for those item
>
> Hope this helps
>
> Claudia Jürgen
>
>
>
> Am 13.02.2019 um 20:39 schrieb Javier Fernandez:
> > Hello, people.
> >
> > I need help. I'm having problems with our repository metadata harvesting.
> > There are some items that are missing some metatada fields. What I need
> > help with is the following: how do I find (other than checking each item
> > one by one) which items lack a certain metadata field?
> >
> > Thanks in advance.
> >
>
> --
> Claudia Juergen
> Eldorado
>
> Technische Universität Dortmund
> Universitätsbibliothek
> Vogelpothsweg 76
> 44227 Dortmund
>
> Tel.: +49 231-755 40 43
> Fax: +49 231-755 40 32
> claudia.juer...@tu-dortmund.de
> www.ub.tu-dortmund.de
>
> Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie
> ist ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für
> diese E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender
> und vernichten Sie diese Mail. Vielen Dank.
> Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen
> ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher
> Schriftform (mit eigenhändiger Unterschrift) oder durch Übermittlung eines
> solchen Schriftstücks per Telefax erfolgen.
>
> Important note: The information included in this e-mail is confidential.
> It is solely intended for the recipient. If you are not the intended
> recipient of this e-mail please contact the sender and delete this message.
> Thank you. Without prejudice of e-mail correspondence, our statements are
> only legally binding when they are made in the conventional written form
> (with personal signature) or when such documents are sent by fax.
>
> --
> All messages to this mailing list should adhere to the DuraSpace Code of
> Conduct: https://duraspace.org/about/policies/code-of-conduct/
> ---
> You received this message because you are subscribed to the Google Groups
> "DSpace Community" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dspace-community+unsubscr...@googlegroups.com.
> To post to this group, send email to dspace-community@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-community.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-community+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-community@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.

Re: [dspace-community] Metadata finding

[Claudia Jürgen]

Hello Javier,

there are a lot of ways you can achieve this:

Database Query
5.x and below
select item_id from  item where in_archive=true and item_id not in
(select item_id from metadatavalue where
metadata_field_id=YOUR-METADATA-FIELD-ID) ;
6.x
select uuid from item where in_archive=true and uuid not in (select
dspace_object_id from metadatavalue where where
metadata_field_id=YOUR-METADATA-FIELD-ID) ;

Solr Query
query for item with not dc.contributor.author
"-dc.contributor.author:* AND search.resourcetype:2

Curation Task
see https://wiki.duraspace.org/display/DSPACE/CurationSystem

Batch Metadata Editing
see https://wiki.duraspace.org/display/DSPACE/Batch+Metadata+Editing+Feature

OAI
Create your own oai context with a filter for those item

Hope this helps

Claudia Jürgen



Am 13.02.2019 um 20:39 schrieb Javier Fernandez:

Hello, people.

I need help. I'm having problems with our repository metadata harvesting.
There are some items that are missing some metatada fields. What I need
help with is the following: how do I find (other than checking each item
one by one) which items lack a certain metadata field?

Thanks in advance.



--
Claudia Juergen
Eldorado

Technische Universität Dortmund
Universitätsbibliothek
Vogelpothsweg 76
44227 Dortmund

Tel.: +49 231-755 40 43
Fax: +49 231-755 40 32
claudia.juer...@tu-dortmund.de
www.ub.tu-dortmund.de

Wichtiger Hinweis: Die Information in dieser E-Mail ist vertraulich. Sie ist 
ausschließlich für den Adressaten bestimmt. Sollten Sie nicht der für diese 
E-Mail bestimmte Adressat sein, unterrichten Sie bitte den Absender und 
vernichten Sie diese Mail. Vielen Dank.
Unbeschadet der Korrespondenz per E-Mail, sind unsere Erklärungen 
ausschließlich final rechtsverbindlich, wenn sie in herkömmlicher Schriftform 
(mit eigenhändiger Unterschrift) oder durch Übermittlung eines solchen 
Schriftstücks per Telefax erfolgen.

Important note: The information included in this e-mail is confidential. It is 
solely intended for the recipient. If you are not the intended recipient of 
this e-mail please contact the sender and delete this message. Thank you. 
Without prejudice of e-mail correspondence, our statements are only legally 
binding when they are made in the conventional written form (with personal 
signature) or when such documents are sent by fax.

--
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups "DSpace Community" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-community+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-community@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.

RE: [dspace-community] Metadata finding

[Fitchett, Deborah]

The easiest way I can think of would be to export the metadata for each of your 
communities, open it in Excel, find the metadata field you’re interested in 
(listed along the top row), then use Excel’s functionality to filter that 
column by blanks.

Instructions for exporting metadata in eg version 5.* are at 
https://wiki.duraspace.org/display/DSDOC5x/Batch+Metadata+Editing#BatchMetadataEditing-WebInterfaceExport

(If you have a lot of communities so this would be onerous, and you’re 
confident with postgres and the database structure, you could alternatively run 
a query directly against the database. It’d be a fairly complex one though; I 
think in most cases using the export option would be easier.)

Deborah

From: dspace-community@googlegroups.com  On 
Behalf Of Javier Fernandez
Sent: Thursday, 14 February 2019 8:40 AM
To: DSpace Community 
Subject: [dspace-community] Metadata finding

Hello, people.

I need help. I'm having problems with our repository metadata harvesting. There 
are some items that are missing some metatada fields. What I need help with is 
the following: how do I find (other than checking each item one by one) which 
items lack a certain metadata field?

Thanks in advance.
--
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: 
https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups 
"DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
dspace-community+unsubscr...@googlegroups.com.
To post to this group, send email to 
dspace-community@googlegroups.com.
Visit this group at 
https://groups.google.com/group/dspace-community.
For more options, visit 
https://groups.google.com/d/optout.



"The contents of this e-mail (including any attachments) may be confidential 
and/or subject to copyright. Any unauthorised use, distribution, or copying of 
the contents is expressly prohibited. If you have received this e-mail in 
error, please advise the sender by return e-mail or telephone and then delete 
this e-mail together with all attachments from your system."

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-community+unsubscr...@googlegroups.com.
To post to this group, send email to dspace-community@googlegroups.com.
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.