Versions Compared

Old Version 8

changes.mady.by.user Yannick Paulsen

Saved on

compared with

New Version Current

changes.mady.by.user Tim Donohue

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Login as an Administrative user
  • In Sidebase, select "Export" → "Metadata".  Type in the Community/Collection name.
    • Alternatively, browse to the Community or Collection you wish to export, and then go to "Export" → "Metadata".  That Community/Collection will be preselected.
  • Click "Export".  A new Process will be created (in "Processes" menu).  Once completed, download the resulting CSV.
Warningnote
titleExporting search results to CSV was not added until DSpace 7.0 does not yet support all features3

As of In DSpace 7.03, it is not possible to export to CSV based on search results.  This feature existed in 6.x, and it is scheduled to be restored in a later 7.x release (currently 7.1). See DSpace Release 7.0 Status.

Added in DSpace 7.3:

Export search results to a CSV (similar to 6.x).When logged in

possible to Export search results to a CSV (similar to 6.x).When logged in as an Administrator, after performing a search a new "Export search results as CSV" button appears. Clicking it will export the metadata of all items in your search results to a CSV.  This CSV can then be used to perform batch metadata updates (based on the items in your search results). - Release Notes#7.3ReleaseNotes

Please see below documentation for more information on the CSV format and actions that can be performed by editing the CSV.

...

  • First, complete all editing of the CSV and save your changes
  • Login as an Administrative User
  • In sidebar, select "Import" → "Metadata" and drag & drop the CSV file" → "Metadata" and drag & drop the CSV file
Note
titleValidate a Batch Metadata CSV was not added until DSpace 7.3

As of DSpace 7.3, it is now possible to validate

Warning
titleDSpace 7.0 does not yet support all features

In DSpace 7.0, metadata import will occur immediately & results will be reported.  In 6.x, after uploading the CSV, you were first presented with a summary of the changes that were to be performed, allowing you to review and choose whether to apply them or cancel.  This "preview" feature will be restored in a later 7.x release (currently 7.1), see DSpace Release 7.0 Status.

Added in DSpace 7.3:

Validate

a Batch Metadata CSV before applying changes (similar to 6.x).  When uploading a CSV for batch updates (using "Import" menu), a new "Validate Only" option is selected by default. When selected, the uploaded CSV will only be validated & you'll receive a report of the detected changes in the CSV.  This allows you to verify the changes are correct before applying them.  (NOTE: applying the changes requires re-submitting the CSV with the "Validate Only" option deselected)  - Release Notes#7.3ReleaseNotes


Command Line Import

The following table summarizes the basics.

...

Code Block
id,collection,dc.title,project.investigator,relation.isPersonOfProject, etc,etc,etc.

Subsequent example row in the CSV export file (project entity):

Code Block
350,2292,Project title,"Smith, John::virtual::8585::600||Doe, Jane::virtual::27946::600", "d89c1eb1-2e7c-4912-a1eb-f27b17fd6848::virtual::8585::600||e3595b14-6937-47b9-b718-1972cb683943::virtual::27946::600"

...

Code Block
id,collection,dc.title,relation.isPersonOfProject, etc,etc,etc.

Subsequent example row for the CSV import file (project entity):

Code Block
350,2292,Project title, "d89c1eb1-2e7c-4912-a1eb-f27b17fd6848::virtual::8585::600||e3595b14-6937-47b9-b718-1972cb683943::virtual::+::600"

...