Manual: Create feeds in DiVA

These lists can be generated in many formats, depending on what you wish to do with the data – you can find a list of available formats on the last page of this document. This manual shows how to generate a list in CSV, Comma Separated Values, in order to work with the data in Excel.

Search

Go to the Create feeds option in DiVA.  

Create feeds (DiVA Umu)

Create query and limit the search

Create a query and limit your search by desired parameters. Unless you specify, the search will cover all options - should you for example not choose a specific "Publication type", the search covers all publication types.

The fields with an arrow to the right provides you with a drop-down menu with options. The fields for "Person", "Organisation" and "Category" offer you preformulated options as you type. The fields "Organisation" and "Category" also provide the option to browse through the alternatives.

Choose format and sort order

Feeds can be generated and sorted in different formats. Which format to choose depends on how you want to work with the information you are exporting. A list of available formats can be found at the bottom of the page.

For this guide we make use of the CSV format, in order to get a comma separated metadata output. This is the preferred format for working with data in software such as Excel or Power BI.

The number of rows (i.e. number of metadata posts/units) are pre-set to 50, but can be adjusted to a maximum of 9 999. Number of rows are typed in manually.

If a data format is chosen where the fields of information are preselected in a way that fits your purpose, proceed directly to "Create link" 

In order to select fields for yourself, choose the format "CSV (choose columns)" and then click on the link "Choose CSV columns" that is activated beneath the drop-down list.

Specify fields

The field "Persistent identifier" is pre-checked and mandatory, but all other fields are electable. The fields correlate to the metadata fields that are used to describe publications in DiVA.

Create feed link

In order to create your feed link, click "Create link".

If you realise that you need to make changes, the "Create link" button doubles as and "Update link" button.

Copy the generated link (click on the link text and use Ctrl+C or right click and Copy). Paste it into the adress bar in your browser and press Enter.

Depending on your browser settings, the file is either downloaded directly to your "Downloaded files" or you are given the option to Open or Save the file – if so, choose the Save-option and Save in a convenient location. 

To open the import

Once you have the file saved, you can open and sort it with a compatible software, for example Excel, Power BI or a plain text editor such as Notepad.

To open the file in Excel

1. Open a new sheet in Excel and make sure the marker is located in the cell where you wish to start filling in the imported values (top left corner). 
2. Go to the tab "Data". Click on "From Text".
3. Choose file to import (the one you just downloaded). Click "Import".
4. Tick "Delimited". Select File origin: 65001 : Unicode (UTF-8). Click "Next".
5. As delimiter, choose "Comma". Click "Next", then "Finish".
6. If the marker is located where the imported values should start being filled in, click "OK".

Now the import should be visible, with the values separated into fields in Excel.

Feed formats

Suitable for web publication

• Mods – Creates an XML-file with all the available information in the records, and structured according to MODS scheme.
• Atom – An alternative to RSS. Creates a limited XML suitable for feeds.
• RSS – Creates a RSS feed from the search.
• HTML-div and HTML-table – Creates HTML-files, built with div tags and table.
• ETDMS - Electronic Thesis and Dissertation Metadata Standard

Formats for standardised reference lists in text format

• APA
• Vancouver
• CSL-JSON

Formats for reference managing software

• EndNote
• RIS

CSV (Comma Separated Values) - a suitable format for importing lists into statistical programs, such as Excel. 

• CSV 1 – Persistent identifier, publication type, contents, language, title, year, project, date, series, ISSN (series), ISBN, keywords, subject, host publication, PMID (columns)
• CSV 2 - Persistent identifier, author, author number (order), department code (internal), research group (one author by row)
• CSV 3 - Persistent identifier, all authors
• CSV 4 - Persistent identifier, last author, department code (internal), research group
• CSV 5 - recordID, title, year, journal, ISSN, volume, issue, author, department
• CSV all metadata (csvall) – an older version of All bibliographic information
• CSV all metadata 2 (csvall2) – a newer version of All bibliographic information, since new fields were added to DiVA
• CSV (Choose columns) – Choose from all available fields

The manual in pdf

It is possible to print or save the page as a pdf by using the print option of the webbrowser.