JADU - How to export & import the Admissions Qualifications directory (Corporate & SES)

The admissions qualification directory exists on the Corporate (https://www.leeds.ac.uk) and SES (https://ses.leeds.ac.uk) sites. The front end links to view the directory on either site are:

Corporate: https://www.leeds.ac.uk/admissions-qualifications/

SES: https://ses.leeds.ac.uk/site/custom_scripts/admissions_qualifications.php

This article describes how to export the existing directory so that changes can be made in excel, and then re-imported into the directory.

Exporting the directory

The process explained below will be the same for both Corporate and SES sites, as they run the same version of JADU.

The Admissions Qualifications directory can be found by logging into either Corporate (https://production2.leeds.ac.uk/corporate/jadu/) or SES (https://production2.leeds.ac.uk/ses/jadu/) JADU, going to 'Publishing' > 'Directories', 'View: All directories', and selecting the 'Admissions qualifications' directory.

To export the directory to make bulk changes in excel, go to the 'Export' tab and ensure the export options are set as follows (remembering to tick the 'Title', 'Metadata' and 'Categories' checkboxes). Once all of the settings match those below, click on the 'Export' button.

The export will be added to the queue and will be processed by a scheduled task that runs every 10 minutes. Once the task has run, the export will be available at the bottom of the export page. Click on the filename to download the .csv file to your computer and make any changes you need to in excel.

When making changes to the file in excel, ensure that the file type is kept as csv, as this will be required to re-import the file back into the directory.

Importing the directory

To re-import the directory listings, go to the 'Import' tab on the directory. For the import of the newly amended data, the import rules should be set as follows (most of the options are left as default, but you need to tick the boxes ned to 'import categories' and 'import metadata'. We're wanting to replace whatever old data is in there with the new data, so the import action is left as 'Replace data'):

The import will be added to the queue and will be processed by a scheduled task that runs every 10 minutes. Once the task runs, the import should take place and the data in the spreadsheet should overwrite the data currently held in the directory. Double check that the number of records shown on the 'Overview' tab of the directory matches the number on the spreadsheet.