Hi Stefanie,

On 04/11/2017 08:14 PM, Stefanie Behnke wrote:
what is the easiest way to get the number of all bitstreams in a community? The number of items in one community is 4460, and I now want to know how many bitstreams are there, if possible, ordered by mimetype.

As an alternative to the database query, you could run the "Profile bitstream formats" curation task on the community. It will give you a breakdown by format (the long format, not the mimetype). Here's the output of this task for a community in a repository I support:

Task: Profile Bitstream Formats

The task was completed successfully.

STATUS: Success, RESULT: 19 (K) Plain Text 12 (K) Item-specific license agreed upon to submission 124 (U) Unknown data format 19 (K) Joint Photographic Experts Group/JPEG File Interchange Format (JFIF) 20 (K) Adobe Portable Document Format

The formatting is a bit funny, but it basically tells us that there are 20 PDFs, 19 JPEGs (presumably the thumbnails -- hmm looks like one of the PDFs doesn't have a thumbnail?), 19 plain text files (those would be the extracted .pdf.txt files), 12 deposit licences and 124 other files. As you can see it counts all bitstreams, not just the ones in the ORIGINAL bundle.

The (K) stands for a bitstream format marked as "known" in the bitstream format registry. And don't be alarmed about my 124 "Unknown" files, those are non-public files coming from an integration with an external system.

cheers,
Andrea

-- 
Dr Andrea Schweer
Lead Software Developer, ITS Information Systems
The University of Waikato, Hamilton, New Zealand
+64-7-837 9120


--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.

Reply via email to