Skip to main content
University of Newcastle Library guides

Systematic Reviews: Managing records

A guide to systematic review searching for University of Newcastle researchers

Importing records into EndNote

Importing references from your databases searches is usually straightforward, and generally involves the following steps:

  1. Search a database
  2. Mark the records you want to save
  3. Select the database's direct export option
  4. Select the EndNote library you wish to export the records to

The table below includes details of how to import references from some of the library's databases into EndNote. For instructions on other databases not listed here, see the EndNote LibGuide.

Note: At present it is not possible to import records from JBI into EndNote.

NAME OF DATABASE PDF INSTRUCTION DEMONSTRATION
CINAHL Importing from EBSCO
Cochrane Library   Importing from OVID Databases
EMBASE Importing from OVID Databases
Informit Health Collection Importing from Informit Databases
Maternity & Infant Care Importing from OVID Databases
MEDLINE Importing from OVID Databases
MedNar   Importing from OVID Databases
Mosby's Index Importing from Mosbys Index
PsycINFO Importing from OVID Databases
Scopus Importing from Scopus
SportDiscus Importing from EBSCO
Web of Science   Importing from Web of Science

 

The transfer of records from databases into EndNote is not an exact science - problems can and do occur. It is therefore important to check the quality of records at the point of transfer.

When records are transferred into your Library the Reference Window initially displays just the transferred references (your other references will be temporarily hidden). This provides a perfect opportunity to check records for any issues.

Annotating records with database details

 

Tip

Use EndNote's Change and Move Field command to automatically add text (such as the name of the database, saved search name, or date searched) to your imported records.

This is very handy for keeping track of where records came from, and assists you if you need to return to the database for any reason later on.

Adding Text Simultaneously

 

 

Tip

Use EndNote's Groups and Group Sets command to quickly identify databases searched, then create individual groups to house results from each of the databases.

To create a Group Set (eg. the "Databases" set in the image at right):

  • Select Groups | Create Group Sets. Name the group set then press <Enter>.

Next, create each group to include in the set:

  • Select Groups | Create Groups. Name the group then press <Enter>.
  • Continue to create groups.

To add references to groups:

  • Highlight the reference in the Library Window and drag the reference to the specific group.

Checking for duplicate records

Once all databases have been searched, and records downloaded into EndNote (and a note made of the number of results retrieved from each database) you must identify and delete duplicate records.

To ensure that all duplicate records are identified and deleted:

  1. Run the EndNote Find Duplicates command (available from within EndNote, via References > Find Duplicates).

    By default EndNote will identify a record as a duplicate if it includes the same author/s, year of publication and title as another record within the Library.

 

 

 

 

2.  After running the EndNote Find Duplicates command it is essential that you follow up with a manual check of your  Library for duplicates.

Re-sort your Library Window alphabetically by title (click the Title column heading), then visually scan, identify and delete duplicated records.
 

Coding records for reviewers to work with

The following EndNote functionality may be used to assist systematic reviewers to code references, for example for inclusion or exclusion.

Use EndNote's Groups and Group Sets Command

To create a Group Set (eg. the "Excluded" set in the image at right):

  • Select Groups | Create Group Sets. Name the group set then press <Enter>.

Next, create each group to include in the set:

  • Select Groups | Create Groups. Name the group then press <Enter>.
  • Continue to create groups.

To add references to groups:

Highlight the reference in the Library Window and drag the reference to the specific group.
Groups and Sets


 

Create Customised Fields for Storing Specific Information about Records

  • Select Edit > Preferences > Reference Types from the left side of the Preferences Window.
  • Select the Reference Type (eg. Journal Article) to adjust, then Modify Reference Types
    The template for each reference may be selected from the drop down list at the top of the Modify Reference Types Window.
  • Within the Journal Article template, scroll down to one of the Custom fields, then type your inclusion/exclusion criteria in the cell to the immediate right.
  • This new field must be included within each of the Reference Type templates - select Apply to All Reference Types to apply across all templates, then OK.

 


 

Adjusting your EndNote Library Window to Display Customised Fields

To change the column headings:

  • Select Edit > Preferences, then Display fields from the left side of the Preferences Window. Select the fields to display from the 8 drop-down lists, then OK.
  • If you want to change the name of a column from the default EndNote field name, type the required text in the Heading text box.

Other issues to consider

Handling Extraneous Text Included with Downloaded Records

Records downloaded from some databases (MEDLINE, EMBASE and others) often import information into EndNote's "Type of Work/Article" field. This information usually relates to a research grant or study design, and some EndNote Output Styles (including Vancouver and APA) are formatted to include this additional information in reference list entries, resulting in references such as below:

 

Biro MA, Waldenstrom U, Pannifex JH. Team midwifery care in a tertiary level obstetric service: A randomized controlled trial.  Birth. [Clinical Trial
Comparative Study
Randomized Controlled Trial


Research Support, Non-U.S. Gov't]. 2000;27(3):168-73.


References should appear as:

Biro MA, Waldenstrom U, Pannifex JH. Team midwifery care in a tertiary level obstetric service: A randomized controlled trial. Birth. 2000;27(3):168-73.

 
Two options are available to correct  this:

  1. The EndNote Output Style can be modified to exclude the "Type of Work/Article" field from appearing in the reference list entries.
     
  2. The extraenous text can be deleted permanently from the "Type of Work/Article" field, or the text can be moved to another unused field within each record. Within EndNote click Tools > Change and Move Fields. Select Type of Work from the dropdown list, then Clear Field, then click OK. Once this action is complete, all text appearing in the Type of Work field (includes Type of Article) will be deleted.

Tools