Add Applicants (New and existing students) via ATF, import spreadsheet or manually

There are three ways to add applicants, found below. Only complete one for each student.

Please note that:

  • we do not currently support importing ADT files, so please ask your LA for an ATF instead. If you would like to add your thoughts on our Roadmap, log them here.
  • you can see our guidance on using CTFs here: Can we add applicants using a CTF?

 

You reach the Applicants section by going to Students > All Students > Applicants

This will bring you to the Intake Seasons Dashboard. The Intake Season relates to the academic year that these applicants will be joining your school. Before adding any applicants you have to set up the Intake Season first. For instructions on how to do this read our article on Setting Up the Intake Season. 

Click on Applicants on the left-hand side. The applicants' table will show if the applicants have been enrolled, rejected, withdrawn or newly created.

 

Option 1 - ATF (Applicant Transfer File)

An Applicant Transfer File (ATF) is a standard format for sending student data to schools, often used when a student begins at a new school. 

Step 1 - Import your file

To Import an ATF into Arbor go to School > Data > Import > ATF Import. Click on the +Add in the top right-hand corner.

import_a_new_ATF.png

 

In the slide over, click Browse to select the ATF file from your computer, then click on the green Upload ATF button.

When you click Upload ATF, You will then be taken to the Import Overview (Shown in the section below).   

select_ATF_to_import.png

Step 2 - Check the import

Once you import your file you'll see the names have a red x, meaning that the applicants have not yet been fully imported.

check_the_ATF_import.png

 

If you click on a student, you can specify an intake season if this will be different to the rest of the other students.

You can also map them to an applicant if they already exist in the intake season. You won't be able to map the import to an existing student, for example if you are adding a Reception intake and one of the students already attends your Nursery.

If both the original student and the importing student have the same UPN, they will be automatically matched.

select_applicant_to_map_to.png

 

If there is no existing applicant to match them to, you can either leave the Update student field blank and click Import applicant, or you can click Cancel to close the slide over and import all the applicants in bulk (shown in the next section). 

not_importing_the_student.png

Step 3 - Finish the import

To import the students in bulk, click the Import All Students button.

Screenshot 2023-07-25 at 12.14.19.png

 

Select the intake season to import them into, then confirm the import.

select_the_intake_season.png

 

You'll receive a notification in the top right of your screen to let you know when the import has been completed.

completed_ATF_import_notification.png

 

If you refresh your page, you'll see all the students have been imported and new applicants have been created.

These students will now appear in the Applicants section.  

successfully_imported_applicants.png

Step 4 - Check for and delete any duplicates

To check if you've created any duplicate applicants you can see which students already exist on Arbor.

  1. Go to Students > Enrolment > Year Groups. Click the year group to see a list of the existing enrolled students. 
  2. If you have accidentally created a duplicate applicant and they are already a student on the system, you'll need to delete the duplicate applicant. For example, if you've been given an ATF for reception students that include students that already attend your nursery.
  3. Just go to Students > All Students > Applicants. Select the intake season then go to Applicants from the left-hand side. Click the applicant's name that you want to delete.
  4. Click Edit in the slide over, then on the next slide over click the red Delete Application and Student button.

You can then just promote the existing students as part of Step 3. Year Groups and Registration Forms of the New School Year Setup process.

Screenshot_2021-02-16_at_14.46.06.png

delete_application_and_student.png

Deleting enrolled applicants

If you have already enrolled applicants and have duplicates, you'll need to follow the instructions in this article to remove them.

 

I cannot import Applicants from the ATF?

This could be caused because of a missing Intake Season. You can find out how to create one by following our guide: Creating an Intake Season. Once this has been set up, you should be able to import the Applicants using the ATF.

Can we remove the ATF?

Please see our guidance here: Can we delete an ATF we've imported?

 

Option 2 - Manually adding applicants

Manually add new applicants or add applications for existing students

From the Applicants page, click +Add in the top right-hand corner of the table.

A pop up will show where you select if the applicant is already a student or is a new student.

When clicking on Create Application for Existing student a slide over will display a drop-down with students name, choose the student and fill in any other information you want to add in the slide over and then click on Save Changes.

When clicking on Create Application for New Student a slide over will load, add the details of the new applicant and click on Save Changes. You will also be asked to create Guardian Details for this new student so make sure you have this information to hand!

Registration Forms and Year Groups when adding an applicant

Please note that you will not be able to put an expected year group and registration form if you are adding applicants for the next academic year. This is because the year groups and registration forms have not yet been set up as part of the new school year setup process. This part of Arbor will become available on May 1st, along with the supporting guidance.

Screen_Shot_2018-11-06_at_09.12.18.png  

 

 

Error message when adding applicants

This could be because you will need the Admissions: Administer All Students and Guardians: Administer All Students permissions to add an applicant and to add guardian details to that applicant.

If you are getting the error message after adding the details for the applicant, the applicant may still be added to the intake season without the Guardian details.

Do I have to add a guardian?

You don't have to add a guardian. You can see more on this here: Do I have to add guardian details when I add an applicant?

 

Option 3 - Uploading Applicants

Step 1 - Download the template

Go to Applicant Uploads and click the green button to download the template. Download the Template.

Open the template from your computer.

Screenshot_2020-04-16_at_10.36.12.png

 

Your spreadsheet will then open in your computer, where you can add in the information. Please do not edit the file by adding more columns.  

Registration Forms and Year Groups in the Applicant Spreadsheet

Please note that you will not be able to put an expected year group and registration form for each applicant into the Applicant Spreadsheet. This is because the year groups and registration forms have not yet been set up as part of the new school year setup process. This part of Arbor will become available on May 1st, along with the supporting guidance.

Required fields

Please note that these fields are required to prevent an error when importing: Student Legal First and Last Names, Sex and Date of Birth. You'll also need to include the guardian relationship or the guardians won't be able to be created.

Screenshot   

Step 2 - Check your students

To help avoid creating duplicate applicants, make sure you check whether the student already exists in Arbor before uploading the spreadsheet. For example, if you've been given a list of reception students that include students that already attend your nursery. 

Make sure to not include any students you already have at your school, as you can just promote these students as part of Step 3. Year Groups and Registration Forms of the New School Year Setup process.

Take a look at the student names you're about to import, and compare it to your existing student lists in the Students > Enrolment > Year Groups section. Click the year group to see a list of the existing students.

Step 3 - Upload the template

Return to the Applicant Uploads page and click +Add to upload your template and confirm and import your Applicants.

Screenshot

Screenshot

Screenshot_2023-02-07_at_08.50.45.png

Step 4 - Delete any duplicates

If you have accidentally created a duplicate applicant and they are already a student on the system, you'll need to delete the duplicate applicant.

  1. Just go to Students > All Students > Applicants. Select the intake season then go to Applicants from the left-hand side. Click the applicant's name that you want to delete.
  2. Click Edit in the slide over, then on the next slide over click the red Delete Application and Student button.

If you have already enrolled applicants and have duplicates, you'll need to follow the instructions in this article to remove them.

edit_applicant.png

delete_applicant_button.png

 

Can I add more columns to upload?

Please see our guidance on this here: Can I import additional fields in the applicant upload spreadsheet?

Add information missed in the import

If you've forgotten to include certain details in the report, you can:

If you have a lot of information to add, or you didn't add guardians at all, we'd recommend deleting the applicants and re-importing: Delete or merge a student profile

Was this article helpful?
7 out of 13 found this helpful
I'm still stuck!

Comments

0 comments

Article is closed for comments.