Export an entities publication

[Jorge Costa]

When I go into the collection that holds authors (entities) and click on an author it lists all of his publications.

When I hit export its exports all his publication as an excel sheet.

IT containts to many fields to be useful

I need it to be one of the three standard layouts for list of author publications for example:

Jinnan Wang,
Two decades of ecological wisdom and scientific progress in China,
Environmental Science and Ecotechnology,
Volume 27,
2025,
100613,
ISSN 2666-4984,
https://doi.org/10.1016/j.ese.2025.100613.
(https://www.sciencedirect.com/science/article/pii/S2666498425000912)

How do I change what is exported and its format ?

Thanks

[Jorge Costa]

Anyone able to  give me a hand with this ? Any insight please ?

[DSpace Technical Support]

Hi,

I'm not sure I understand the question.  Are you asking if the CSV export format can be changed? If that's the question, the answer is no.  The DSpace CSV export format is not customizable.  However, once you have the data exported into a CSV, you should be able to manipulate it or restructure it yourself by using CSV editing tools or Microsoft Excel or similar.

Tim

[Jorge Costa]

This is my poor , limited understanding of how this works:

When selecting an author and exporting all of his publications as csv (button on the right) , a call is made into the database and a select * is saved as csv.

I would like to limit the columns selected from said database select.

Is this not possible ?

Thanks

[DSpace Technical Support]

Hi,

No, that's unfortunately not possible unless you change the Java code in DSpace.  The format/structure of the CSV is always the same and includes all available metadata fields in DSpace as described in the documentation at https://wiki.lyrasis.org/display/DSDOC8x/Batch+Metadata+Editing#BatchMetadataEditing-CSVFormat

However, as I said, once the data is in a CSV, you can use CSV editing tools to change its structure -- removing fields you don't want, or reorganizing fields, etc.  It's just that DSpace doesn't have a way to do that for you.

Tim

[mw...@iu.edu]

On Tue, Sep 02, 2025 at 09:49:19PM +0000, DSpace Technical Support wrote:
> No, that's unfortunately not possible unless you change the Java code in DSpace. The format/structure of the CSV is always the same and includes all available metadata fields in DSpace as described in the documentation at https://wiki.lyrasis.org/display/DSDOC8x/Batch+Metadata+Editing#BatchMetadataEditing-CSVFormat
>
> However, as I said, once the data is in a CSV, you can use CSV editing tools to change its structure -- removing fields you don't want, or reorganizing fields, etc. It's just that DSpace doesn't have a way to do that for you.

For example, you can use <a
href='https://miller.readthedocs.io/en/6.13.0/'>Miller</a> (command
line) or <a href='https://www.moderncsv.com/'>Modern CSV</a>
(graphical) to transform the CSV to meet your requirements.

> Tim
>

> On Thursday, August 28, 2025 at 4:47:54 PM UTC-5 jorge...@gmail.com wrote:

> --
> All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
> ---
> 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 dspace-tech...@googlegroups.com<mailto:dspace-tech...@googlegroups.com>.
> To view this discussion visit https://groups.google.com/d/msgid/dspace-tech/12220034-0ad8-4073-a792-04f65c0d9141n%40googlegroups.com<https://groups.google.com/d/msgid/dspace-tech/12220034-0ad8-4073-a792-04f65c0d9141n%40googlegroups.com?utm_medium=email&utm_source=footer>.

--
Mark H. Wood
Lead Technology Analyst

University Library
Indiana University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
library.indianapolis.iu.edu