Local Authority Report - Capita One Export (B2B Open Student Export)

This report is an .xml file that can be automatically scheduled and shared with your local authority, or manually generated whenever you need.

Top Tip: If you can't automate the export, you'll need to ask your LA to email api@arbor-education.com to begin the setup process for your school.

Setting up the report schedule

Go to School > Data > Export > Capita One Export. 

Click into the Regular Scheduled Exports tab and click either Attendance or Full Export.



In the slide over, select how often the report should run, then click Save Changes.

  • Not Set - Change this back to Not Set to cease the schedule.
  • Daily
  • Last day of the week - last day of the school week, so if Friday is an inset day, it will run on Thursday.
  • Last day of the month - last good school day of the month.
  • Last day of the term - last good school day of the term.



You can then see when it's next scheduled to run.



You can also see the completed exports, and when it will run next on the Completed Exports tab.



Can we generate an Ad Hoc report?

Click into the Ad Hoc Scheduled Reports tab and click +Add.



In the slide over, choose:

  • The export type of Attendance or Full Export.
  • The time and date when the report should be generated.

Please note that it will not be sent until after 5:30pm (or the following day, if you schedule the report for after 5:30pm).



If you need to download the file, click on the export from the Completed Exports tab.




What time is data generated and sent?

Your scheduled reports will be generated at a randomly selected time between 4 and 5pm.

Once the reports are generated, they will be sent at or a little after 5.30pm (depending on the efficiency of the Capita One B2B software).

What data is included in the file?

By default, the Capita One Export only includes attendance for the current academic year. It also:

  • will include all students who have been enrolled at some point in the current Academic Year
  • only contains the student’s enrolment history for your school
  • uses the new format of multiple reasons for exclusions

If your school has academised, students’ entry dates reflect your school’s new opening date.

I can't schedule the report

If you aren't able to schedule reports, and your page looks like the screenshot below (missing the middle tabs), please contact your LA.

They will need to get in contact with us by emailing api@arbor-education.com.

We will then send them a form to complete with their endpoint and credential details.

Once your LA has sent this information to us, we'll enable your scheduling functionality.

This cannot be completed by schools, it must be completed by the LA.



You can still generate an ad hoc report by clicking +Add.



Click the export to download it. You'll then need to send it to your LA.



Can we output enrolment notes?

Go to the General Settings tab and click into this field. Change the slide over, then click Save Changes.

  • If Use destination school only for Destination is selected, we will use the student's destination school, as recorded in their educational history.
  • If the other option is selected, we will use the note recorded against the student's school enrolment as the output for the 'Destination' node in the export. We will also use the destination school as above, but as the character limit for this field in the Capita One export is 60 characters, we may not be able to fit both the note and the destination school in. In that case, the note would take preference.


Was this article helpful?
15 out of 18 found this helpful
I'm still stuck!



Article is closed for comments.