Import a previous year's ILR file

Historical import lets you bring in ILR files from previous collection years. It's an extra option that isn't switched on by default. This article explains how to get it switched on, how to import a previous year's file, and what to do if a file is refused.

To import a file for the current collection year, see Import an ILR file with data import.

Before you start

Check

What you need

Historical import Switched on for your organisation. See Switch on historical import below.
Roles Manage Tenant Settings, Manage ILR and ILR QA. You need all three.
File type One ILR file in .xml format per import.
Years One collection year per file. Aptem takes the collection year from the file header, not the file name.

Switch on historical import

Speak to your Customer Success Manager. They arrange for historical import to be switched on and agree the earliest collection year you can import. Once it's switched on, you can import files from that year onwards.

Import a previous year's ILR file

You import a previous year's file in much the same way as a current-year file. The main difference is that FIS checks aren't available for some older years.

  1. Navigate to Tenant settings and select Data import.
  2. Select your ILR file (.xml), or drag it into the upload area.
  3. Wait for the file checks. Aptem checks the UKPRN and the collection year in the file header. If the file can't be imported, the upload stops, a message explains why, and nothing from the file is processed.
  4. Review which learners already exist.
  5. Run FIS checks if they're available for the file's year. FIS checks can run for 2023/24 to 2026/27. For earlier years, Run FIS Checks is unavailable, but you can still import the file.
  6. Review the results. If you want a copy of the deduplication summary, export it now.
  7. Select Next to see the final summary, then confirm to start the import.
  8. Wait for the import to finish, then select Finish.

If FIS checks aren't available, the data won't be checked against the FIS validation rules before it's imported. Check the file carefully before you confirm the import.

After the import

The import runs in the background, so you don't need to stay on the page. You get a notification in the bell when it finishes. If you've signed out, you'll see it next time you sign in.

Imported learners are added to an ILR import programme and an ILR import group, both named "ILR import" followed by the collection year and batch ID. You're added to the group automatically, so you can see the learners straight away. Other admins need the group added to their profile to see them.

Aims with dates outside the file's collection year are automatically included in that year's batch. Aims from previous years aren't added to learners' live programmes.

You can only export the deduplication summary until the import completes. For more about the reports, see Understand data import results and import history.

Why a file might be refused

Reason

What to do

Historical import isn't switched on for your organisation. Speak to your Customer Success Manager.
The file is older than the earliest year agreed for your organisation. Speak to your Customer Success Manager if you need to import that year.
The file is for a future collection year. The message says "Aptem can't import files for this collection year yet". Check the collection year in the file header.
The collection year in the file header is missing or not valid. The message says "This is not a valid ILR file". Check the file header, then upload the file again.
The UKPRN in the file header doesn't match your organisation or any of your training organisations. Check the file is for the right provider.

Files refused because historical import isn't switched on, or because the file is too old, don't appear in your import history. Files for a future collection year appear in your import history as Failed.

Questions

My previous year's file was refused. Why?
Historical import isn't switched on for your organisation, or the file is older than the earliest year agreed for you. Speak to your Customer Success Manager.

Can I import several years in one file?
No. Each file must cover one collection year. Upload a separate file for each year.

Does the file name need to show the collection year?
No. Aptem reads the collection year from the file header, not the file name.

Was this article helpful?
0 out of 0 found this helpful