CSV import to L-Gate
Upload a OneRoster ZIP by hand or on a schedule, with a dry run to preview the result before anything is written.
1Roster, the L-Gate Rostering Service, moves school, class, teacher, and student data between L-Gate and other education systems using the OneRoster standard. Import CSV files with smart matching, export bulk or delta files on a schedule, and keep every municipality’s roster current without manual re-entry.

OneRoster CSV packages come in, are matched to L-Gate, and are written in. In the other direction, L-Gate data goes out as standard OneRoster files, to Azure Blob Storage or a download.
Upload a OneRoster ZIP by hand or on a schedule, with a dry run to preview the result before anything is written.
Match academic years, schools, classes, and users to L-Gate automatically, then review and correct by hand.
Export full rosters or only the changes since last time, including records marked to be deleted.
Run imports, exports, and L-Gate synchronization automatically, with an operation log and notifications.
Deliver files to Blob Storage on a schedule or once, without needing a SAS key.
Local accounts, Microsoft accounts, or local accounts with one-time passwords, with role-based access.
Choose a OneRoster ZIP (1.1, 1.2, or 1.2.1), bulk or delta, and filter by role: school admins, teachers, students.
Academic years, schools, classes, and users are matched to L-Gate, automatically where possible.
Assign classes to first-time users, set a common password if needed, and check skipped users.
Confirm and write. New users can sync straight away through the SSO Sync API.
School data is never perfectly clean. 1Roster’s matching rules handle the differences that usually break an import.
PANTONA’s QA team tests every screen and every import and export scenario, across all three OneRoster versions, with daily scheduled test drives on multiple test tenants.
| Test area | Items passed | Failed |
|---|---|---|
| Screens and UI (login, municipalities, schedules, import, sync, Blob Storage) | 2,172 | 0 |
| Login, users, and roles | 39 | 0 |
| Tenant management and synchronization | 49 | 0 |
| Blob Storage settings | 9 | 0 |
| Manual and scheduled export | 232 | 0 |
| Bulk and delta file validation | 323 | 0 |
| Manual and scheduled import | 450 | 0 |
Tell us about your municipality, schools, and current systems, and we’ll show you how 1Roster can help.