Setting up School Data Sync, undocumented required columns?

[LRSFC_DanJ]

I've been tasked with setting up School Data Sync so we can get Teams up and running for remote working for students and staff.

 

However it seems to be choking on my School.csv?

 

My School.csv looks like this:

 

ID,DfE Number,Name,Principal Name,Principal Secondary Email,Address,City,State,Country,Postal Code,Phone
LRSFC,Cambridgeshire-8601,Long Road Sixth Form College,Yolanda Botham,[email protected],Long Road,Cambridge,Cambridgeshire,CB2 8PX,+441223631100

 

What's missing? It says it expected 11 columns but only found 10, but helpfully doesn't tell me what column is missing.

 

EDIT: it's because I'm an idiot and missed out the Country!

Edited March 24, 2020 by LRSFC_DanJ

[synaesthesia]

If you get stuck download the free app from salamander, it fills all those fields out for you ready to upload.

[LRSFC_DanJ]

If you get stuck download the free app from salamander, it fills all those fields out for you ready to upload.

Sadly it does not support our MIS system, or I would have.

[nthomas]

I would have recommended SalamanderSoft as well. What MIS are you using?

We're running lots of these per day now as we're on the DfE initiative.

[LRSFC_DanJ]

I would have recommended SalamanderSoft as well. What MIS are you using?

We're running lots of these per day now as we're on the DfE initiative.

 

We're further education so we use Unit-e by CAPITA. It's all fine now though, I've got it sorted and working. Though SDS doesn't seem to be syncing with Teams any more.