In this guide you will find information on how you can add DOAJ journals to your JST tool. There are two options available, the first is to add a link to DOAJ on your search page and the second is to import a list of DOAJ journals in to your JST.

Adding as a link

1. To add a link to DOAJ on your Public Journal Search Page first of all click on Branding either on the Main Dashboard or from the sidebar.
2. You will now arrive at the Branding page where you can make your customisations. On the Text tab you will need to go to Content & Information to find the Extra details, links, or notices (URLs must start with https://) text box.
   
3. n the Extra details, links, or notices (URLs must start with https://) box write the text you would like displayed e.g. Find diamond journals at DOAJ
   
4. Then add a link by highlighting the text and clicking on the link icon
   
5. Enter the URL to your webpage e.g. https://www.doaj.org, it must begin with https://, and click Save
   
6. Then make sure to go to the top of the Branding page and click Save 
   This will now appear immediately on your Public Search page
   
   

Importing a DOAJ list

A few things to note before importing DOAJ into your JST:

• The DOAJ list is regularly updated - several times a week - with additions and withdrawals
• The DOAJ is a large file and contains 20,000 journals
• Importing the full list will greatly increase the number of journals included within your JST. There may also be duplication of titles where open access titles are in a publisher agreement AND listed within DOAJ.
• Depending on what journals you would like to show within your JST you may need to sort through the DOAJ file to determine which journals should be imported. E.g. Only journals with No APC.

Getting the list ready

1. You can download a CSV of all DOAJ Journals from https://doaj.org/docs/public-data-dump/
2. Make any changes you want to the file. Here are a few examples of changes you may like to make:
   1. Removing journals you do not want to show with in JST
   2. Changing column names to ensure it is imported correctly e.g. Publisher to Imprint
   3. Adding missing columns to ensure it is imported correctly e.g. Publishing Model
   4. Removing unnecessary columns
3. As it is a CSV you will need to covert it to a xlsx format to ensure it imports correctly. You can do this by opening a new workbook in Excel-> click Get Data -> From file -> Text/CSV -> Select file and click Import. This should automatically detect the format as File Origin: Unicode (UTF-8); Delimiter: Comma. Then click Load
4. You can then save the file as a .xlsx

Adding a New Agreement

1. Go to the Agreements page either from the Main Dashboard or the Side Bar
2. Click on Add an Agreement
   
    
3. You will now need to fill in all the fields before you will be able to create the agreement
   1. Publisher
      1. Begin typing DOAJ and select from the dropdown
         
4. Agreement Name
   Insert the name of your agreement. Note that this information will not be displayed in your Public Journal Search Page, it is just for you, the library, to help manage your agreements.
   
5. Payment Option
   Add the payment information for the agreement by selecting one of the options from the Payment Default dropdown menu. 
   
   Note: If there is a payment option within the import list, the import will be used. This is used as a default when it is missing from import list
6. Agreement URL
   Add the Agreement URL (must start with https://), this is the website where the researcher will be directed to from the Who Pays icon when they want to get further information on the agreement. This could be to your Website, Open Access form or another webpage. You can also enter an email address for Contact Us
   
    
7. Description
   Optional to add a description, this is seen only internally
   
8. Notes
   Option to add notes for example to keep track of changes and share comments between colleagues
   
   1. Start Date and End Date
      Add in the start and end dates of the publisher agreement. Either type in the date or click to open the calendar.
      
   2. Licenses
      The default license or licenses applied if missing from import list
      

9. Then click on Choose file to upload
   Here you must upload your journal list in a .xlsx format. Please see below table of what information must/can be included within your journal list upload. For further information regarding import lists see our guide here

   Field	Essential/Recommended/Optional	Notes
   Journal Title	Essential
   Publishing Model	Essential
   Imprint	Recommended	If not included it will use the Publisher Name as default
   Journal URL	Recommended
   Electronic ISSN	Recommended	Recommend having at least one issn (e.g. EISSN or PISSN)
   Print ISSN	Recommended	Recommend having at least one issn (e.g. EISSN or PISSN)
   License	Recommended	Recommend having this within the Excel but can also select a default license within the agreement
   Subject Areas	Optional

10. Then press Create.
    
    Note: If the Create button is Greyed out and is not responding make sure all fields are filled in and you have selected a file
    
11. You will now have been taken to the Edit agreement page. Here you can see the fields you would have seen on the create as well as the list of journals imported.
12. The Journals will now be available within your search immediately if the dates are current dates

Note: If it is missing essential data within the import error messages will appear to inform you these need to be fixed before proceeding

You can scroll to the Uploaded Journals. Journals will be highlighted and have a icon to indicate it is missing essential information.

You can also sort journals with missing information by clicking the box next to Only show entries with missing data

Once here you should be able to see which fields are missing, in this example the publishing model is missing.

In the above example we can see:

• The Journal URL is missing ->Check file that there is a column for Journal URL and contains URLS
• The Imprint is set to DOAJ as it did not find a column with the imprint for the journals. ->Check file that there is a column for Imprint and is populated
• The Publishing Model is missing ->Check that there is a column for Publishing Model and is populated with Open Access