Help centre · area
Bringing your records in
Import Studio, staff and contact imports and moving from another system.
6 guides, 36 answers. Search everything

Guides
- Bring a spreadsheet in with the Import StudioRead a file, say what each column means, see what would happen row by row, and only then save it.Step by step · 6 answers
- What the Import Studio can readThe kinds of file it takes, what each kind writes to, how it tells whose row is whose, and its limits.Explained · 6 answers
- Undo an import and fix the rows that were not savedUse the list of past imports to put a file back within two weeks, and to see why some rows were refused.Step by step · 6 answers
- Move your records from another systemWhat to do now that the old Arbor, Bromcom, CPOMS, Lamplight, Makerble and contacts importers are switched off.Step by step · 6 answers
- Invite many staff at once from a fileUpload a CSV of teammates and send each one an invitation email with a secure link that lasts seven days.Step by step · 6 answers
- Work through what the document import set asideLook at each document the importer could not decide about, put it right or say why it needs nothing, so nothing goes unseen.Step by step · 6 answers
Questions people ask
Who can use the Import Studio?
Managers and admins, because it writes to records for the whole service. Others are shown the one-at-a-time route instead.
More in “Bring a spreadsheet in with the Import Studio”Can I import without a spreadsheet?
Yes. Add young people one at a time from the new record page. It takes their contacts and consents in the same form.
More in “Bring a spreadsheet in with the Import Studio”What if I choose the wrong column meaning?
Go back from the check with Change the columns. Nothing has been saved at that point.
More in “Bring a spreadsheet in with the Import Studio”Why is a row in 'to look at'?
The check could not decide what it was, for example whose contact it is. Fix it in the file and bring that row in again.
More in “Bring a spreadsheet in with the Import Studio”Can I bring the same file in twice?
A file of young people is recognised row by row, so saved rows are not made twice. Contacts, goals, consents and referrals are only added, so bring in just the rows that were not saved.
More in “Bring a spreadsheet in with the Import Studio”How big can the file be?
Up to four megabytes and two thousand rows at a time. Split a bigger file and bring the parts in one after another.
More in “Bring a spreadsheet in with the Import Studio”Can it read a photograph of a form?
No. A scan or photograph has no text in it. Send the original Word document or PDF.
More in “What the Import Studio can read”Which file should I start with for a new service?
Start with the file of young people. The other kinds are added to records that already exist.
More in “What the Import Studio can read”Why was my contacts file refused for 'whose row is this'?
Each row must say which young person it is about. Add the reference code, or the name and date of birth together.
More in “What the Import Studio can read”My file has a title line above the headings. Will it work?
Yes. The page finds the heading row and tells you how many lines above it were passed over.
More in “What the Import Studio can read”How many rows can I bring in at once?
Two thousand. Split a longer file and bring the parts in one after another.
More in “What the Import Studio can read”Can I use my old system's export?
Yes, if it is a spreadsheet. Map its columns on the screen and save the mapping so the next file arrives matched.
More in “What the Import Studio can read”How long can I undo an import?
For two weeks after it was saved. The date is shown beside it. After that the records belong to the service and cannot be undone here.
More in “Undo an import and fix the rows that were not saved”What does 'left alone' mean after an undo?
Someone changed that record after the import, so the undo did not touch it. It is still saved. Look at it by hand.
More in “Undo an import and fix the rows that were not saved”How do I see why a row was not saved?
Press Show the rows that were not saved on that import. Each row names the reason.
More in “Undo an import and fix the rows that were not saved”Should I bring the whole file in again to fix a few rows?
Only for a file of young people, where saved rows are recognised. For the other kinds, bring in just the rows that were refused.
More in “Undo an import and fix the rows that were not saved”What does an undo do to the records?
It puts back what the import changed, unless someone has changed a record since. The result says how many were put back and how many were left alone.
More in “Undo an import and fix the rows that were not saved”Who can undo an import?
Managers and admins, the same people who can run one.
More in “Undo an import and fix the rows that were not saved”Why does the Arbor page say Coming soon?
The old importer is switched off. Use the Import Studio for the pupil spreadsheet. It previews everything before saving.
More in “Move your records from another system”Can I bring CPOMS incidents across?
Not by this route. The old importer recorded every past incident as a new open concern and lost its category. Ask for help instead.
More in “Move your records from another system”Can I import attendance from Arbor or Bromcom?
Not through these pages. Attendance is not imported by them.
More in “Move your records from another system”Where did the contacts upload page go?
It now sends you to the Import Studio. Choose the contacts kind there and map the columns.
More in “Move your records from another system”Who can open these pages?
Admins. Anyone else is told the admin role is needed.
More in “Move your records from another system”Can I send the file by email?
Please do not attach children's details to an email. Ask first, and a safe way to send it is arranged.
More in “Move your records from another system”Who can import staff?
Admins only. Managers do not see the upload form.
More in “Invite many staff at once from a file”How many people can I invite at once?
Up to 200 rows in a file of up to 1 MB. Split a longer list.
More in “Invite many staff at once from a file”Why did no invitations go out?
At least one row failed the checks, so none were sent. The page lists each fault with its line number.
More in “Invite many staff at once from a file”How long does an invitation last?
Seven days. After that, send a new one from the staff page.
More in “Invite many staff at once from a file”What do I put in the role column?
Use the role codes listed under Expected columns on the page. Anything else is refused.
More in “Invite many staff at once from a file”Can I use a spreadsheet instead of CSV?
Save the sheet as CSV first. The page accepts CSV files only.
More in “Invite many staff at once from a file”Who can use Import review?
Managers, DSLs and admins, when the section is switched on for them. A mentor is sent home.
More in “Work through what the document import set aside”Does dismissing an item change the record?
No. Nothing here changes a record. A dismissal only says the item needs nothing, with your note.
More in “Work through what the document import set aside”Why must I write a note to dismiss?
The next person reads it to see why nothing was done.
More in “Work through what the document import set aside”Can I undo a decision?
Yes. Open the item with Look and reopen it. It goes back to the list to look at.
More in “Work through what the document import set aside”Why can't I see some items?
Items held for the DSL are shown only to the DSL and admins.
More in “Work through what the document import set aside”What do I do with a document that could not be read?
Open the original file and add what matters to the record by hand. Then confirm the item.
More in “Work through what the document import set aside”