About Local Systems Database

A number of Danish Research Institutions with local systems (CRIS) for registering their publication outputs are data partners in this database of Danish research, observed from the local perspective based on locally curated data. The data partners contribute data as well as expertise in order to achieve the best possible result. To see a list of current as well as potential data partners, read more under the tab Data Partners.

February 2023

  • Beta release (May 2022) of the portal database with data from Danish Local Systems, which in this beta version solely includes publication metadata

  • A re-organization- and new groupings of Danish Affiliations and NORA names have been implemented. New affiliation groupings added are: Artistic Higher Education Institutions, Business Academies, Governmental Institutions, Non-Profit Organizations and GTS Institutes
  • A version 1 of a reference export (in RIS format) has been added to the other export functionalities. The reference export is still undergoing testing and improvements

Imported Data

  • Publication data 2011 to date from the 8 Danish Universities, 3 Danish Artistic Higher Education Institutions, 7 University Colleges, The Danish Center for Social Science Research and Ministry of Culture – Archives, Museums, and Royal Library Denmark

  • Some data exchange problems have been addressed which, for institutions currently using Pure as CRIS, required an update to version 5.23.1. Currently all universities, except ITU have upgraded

Data Enhancements

  • Danish affiliation names from the Danish Local Systems’ publication records are mapped to Danish Affiliations in a standardized form (NORA names) and grouped in categories like Universities, Private Research etc. This is an ongoing effort

  • Collaboration Countries are mapped into Collaboration Regions of analytical interest, like OECD, EU etc. Regions are in standardized form (NORA names)

  • Interlinking across all four databases (Matching Records in) has been implemented based on DOI-matching

  • Keywords are added based on the keywords added on the individual publication record by the data provider

Help and Guides

Imported Data

  • Some publications from the University Colleges are mapped incorrectly to the National Exchange Format, MXD. These specific publications will currently map to the publication type “Other-Unknown” and “Other-Internet Publication”. This issue is in the process of being fixed by the CRIS Software vendor.

  • While including the 8 Universities a number of issues were discovered in the transfer of data from their local systems to the portal. These have now been corrected in collaboration with the CRIS software vendor and was made available in the Pure software update version 5.23.1 (March 2022). All current data providers except ITU have now updated. Data on ‘Author Collaborations’ as well as multi affiliation is hence not yet reflected in the data from ITU

  • The different institutions have set up their web service/API from their local system in different ways, which means that only some institutions displays unpublished, submitted and in-press records in the NORA database while others do not

  • Some University Hospital publications are registered at the Universities and hence will appear as University publications

  • Moving forward we will begin the integration of data from the Esploro system of Royal Danish Defense College

  • Moving forward we will furthermore begin integration of data from other Danish Research Institutions. See under the Data Partners tab for a full list of research institutions to be included

Danish Affiliation Names

  • We collaborate with the Data Partners in order to keep securing the best possible metadata on Danish affiliation names from the CRIS systems

Export Functionality

  • A version 1 of a reference export (in RIS format) has been added to the other export functionalities. The reference export is still undergoing testing and improvements

Help and Guides

  • As we move along – and collect user feedback – more user guides, PDFs as well as videos will be added

Improving the Beta release (May 2022)

  • Processing user feedback

  • Carrying out third party usability testing

  • Fixing bugs and serious usability problems

  • Extracting and prioritizing ideas for improvements

  • Developing and testing improvements

  • Launching the Beta-2 version

Imported Data

  • Increasing the number of data providers – and the quality of the exported data

  • Start reviewing the possibility and feasibility of including patents from the Danish Local Systems

  • Start reviewing the possibility and feasibility of including datasets from the Danish Local Systems

  • Start reviewing the possibility and feasibility of including a broader range of content types from the Danish Local Systems

Data Enhancements

  • Enhance the mapping and normalization of Danish affiliation names

February 2023

All Danish research institutions with local systems for registering their publication outputs are potential data partners.

Currently included:

Currently on the list to be included during 2023:

The collaboration with the local systems is facilitated by The Working Group for National Database and Search Portal representing the various types of research institutions.

How to extract and download data from the Local Systems database

Data may be downloaded as XML in the same format used to harvest the local systems

-> Section MXD below

Data may be downloaded as JSON in the same format we use to build the portal
-> Section JSON Data below

 

MXD

DDF-MXD is the Danish Research Database Metadata Exchange Format for Documents. It is the only format supported for adding data to NORA Local Systems portal.

You can find a PDF documentation of the latest version of MXD at https://forskningsportal.dk/local/DDF_MXD_v1.4.3.pdf.

 

JSON Data

The JSON data is an internal representation of the MXD data. It is subset of the MXD data fields, only those which are useful and supported by the portal. It does however contain enhancements, primarily the normalisation of some of the data like Danish organisation names, locations, OAI Scope, etc.

View JSON fields description
[
       {
          "abstract"        : "",      // - Abstract text, in English if available
          "author_count"    : "",      // - Authors count, based on authors in that record
          "bfi_cno"         : "",      // - BFI conference number, old records only
          "bfi_pno"         : "",      // - BFI publisher number, old records only
          "bfi_sno"         : "",      // - BFI serial number, old records only
          "bfi_subject"     : "",      // - BFI expert group, old records only
          "dimID"           : [""],    // - List of Dimensions IDs for this record
          "event" : {
             "acronym"      : "",      // - Event acronym
             "end"          : "",      // - Event end date
             "place"        : "",      // - Event location
             "start"        : "",      // - Event start date
             "title"        : "",      // - Event full name
             "year"         : ""       // - Event year
          },
          "filters" : {                // - Filters are generally for internal indexing use but some of the detailed
                                       //   information can be generally usefull
             "altsrc"       : [""],    // - List of gobal sources in which this record can be found
             "continent"    : [""],    // - List of geographic regions of organisations collaborating to this publication
             "corpau"       : [""],    // - List of corporate authors
             "country"      : [""],    // - List of countries of organisations collaborating to this publication
             "glorg"        : [""],    // - List of global organisations collaborating to this publication. Also includes
                                       //   "All Global Affiliations" for search purpose.
             "level"        : "",      // - MXD doc_level
             "mra"          : "",      // - MXD research area (code)
             "oa"           : "",      // - The type of Open Access to this record
             "oaiscope"     : "",      // - Boolean Yes or No, defines if this record is part of OA-Indicator.
             "org" : {
                "level1"    : [""],    // - Level 1 Danish orgs for filtering only, always di
                "level2"    : [""],    // - Level 2 Danish orgs for filtering only, so far DI-HO (Hospitals),
                                       //   DI-OT (Other Research), DI-PR (Private Research), DI-SE (Specialized Research),
                                       //   DI-U (Universities), DI=UC (University Colleges).
                "level3"    : {
                   "HO"     : [""],    // - Lists of org codes, split by org types level2.
                   "OT"     : [""],
                   "PR"     : [""],
                   "SE"     : [""],
                   "U"      : [""],
                   "UC"     : [""]
                }
             },
             "review"       : "",      // - Review codes, direct from MXD
             "src"          : "",      // - Data source, direct from MXD
             "type"         : "",      // - Record type, direct from MXD
             "type-grp"     : [""]     // - Type group, based on type. So that the only active group is pub. You may also
                                       //   find dat (data), pat (patent) and all.
          },
          "id"              : "",      // - Original UUID
          "identifier"      : [
             {
                "id"        : "",      // - Some form of ID
                "type"      : ""       // - Types, so far: scopus, pmid, wos
             }
          ],
          "inetpub" : [
             {
                "access"    : "",      // - Direct from MXD
                "text"      : "",
                "uri"       : ""
             }
          ],
          "keyword"         : [""],    // - Direct from MXD
          "lang"            : "",      // - English text version of Language
          "level"           : "",      // - English text version of MXD level
          "mra"             : "",      // - English text versionof MXD MRA
          "oa_link" : [
             {
                "access"    : "",      // - Direct from MXD
                "embargo"   : "",
                "license"   : "",
                "type"      : "",
                "url"       : "",
                "version"   : ""
             }
          ],
          "oai" : {                    // - Added OA-Indicator
             "class"        : "",      // - OA-Indicator class (Blocked, Realised, Unused)
             "mra"          : "",      // - Main Research Area
             "yearPub"      : "",      // - Publication year
             "yearSub"      : ""       // - Submission year
          },
          "org" : [
             {
                "affno"     : "",      // - Affiliation number for link with person below
                "country"   : "",      // - Country code, 2 letters
                "l2"        : "",      // - NORA level 2 code (org type)
                "l2n"       : "",      // - Corresponding text in English
                "l3"        : "",      // - NORA level 3 code (org code)
                "l3nl"      : "",      // - Long English text version of l3
                "l3nn"      : "",      // - More compact version of the text
                "loc"       : [""],    // - Local country / regions
                "name"      : "",      // - Full org name
                "nora_code" : "",      // - Same as l3
                "role"      : ""       // - Can be used for "Corporate author"
             }
          ],
          "person" : [
             {
                "affno"     : "",      // - Affiliation number for link with org above
                "country"   : "",      // - Country code, 2 letters
                "locid"     : "",      // - Local ID from data provider (src)
                "name"      : "",      // - Full name
                "first"     : "",      // - First name
                "last"      : ""       // - Last name
                "orcid"     : "",      // - ORCID
                "role"      : ""       // - So far: Editor, Editor of Host Publication, Illustrator, Inventor, Other,
                                       //   Publisher, Supervisor, Translator

             }
          ],
          "pub" : {
             "doi"          : "",      // - DOI mostly document level but also sometimes higher publication level, like
                                       //   book for a book chapter.
             "edition"      : "",      // - Direct from MXD
             "eisbn"        : [""],    // - Electronic ISBN
             "eissn"        : [""],    // - Electronic ISSN
             "isbn"         : [""],    // - ISBN
             "issn"         : [""],    // - ISSN
             "issue"        : "",      // - Issue number, direct from MXD
             "journal"      : "",      // - Journal title
             "newspaper"    : "",      // - Newspaper title
             "other"        : "",      // - Other publication (Direct from MXD)
             "pages"        : "",      // - Number of pages or page range
             "place"        : "",      // - Publication place
             "publisher"    : "",      // - Publisher name
             "repno"        : "",      // - Report number
             "series"       : "",      // - Series title
             "status"       : "",      // - Publication status code (direct from MXD)
             "subtitle"     : "",      // - Sub-title
             "title"        : "",      // - Publication title
             "volume"       : ""       // - Volume
          },
          "review"          : "",      // - Review text
          "scoID"           : [""],    // - ID of corresponding Scopus record
          "sdg"             : [""],    // - List of SDG classifications
          "search" : {
             "DAF"          : [""],    // - Danish university code and text, for search purpose
             "PST"          : ""       // - Publication status text, for search purpose
          },
          "sid"             : "",      // - A combination of src and id, used internally only so far
          "src"             : "",      // - Data provider as abbreviated English text
          "title"           : "",      // - Record title
          "type"            : "",      // - Record type as Enlish text
          "wosID"           : [""],    // - ID of corresponding Clarivate record
          "year"            : "",      // - Publication year
          "yearsub"         : ""       // - Submission year
       }
    ]

 

JSON Array

If you have enough memory to parse the whole JSON at once, you can use the following extracts which are formatted as JSON arrays of records.

 

JSON Record List

For easier parsing with more limited memory, you can use the following extracts which are formatted as lists of JSON records, one per line.