The option “Create feeds” in DiVA allows you generate lists of publications by author, organisation, subject and more.
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.
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.
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
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).
Go to the tab "Data". Click on "From Text".
Choose file to import (the one you just downloaded). Click "Import".