JPClient: Japan
1Roster / L-Gate Rostering Service · OneRoster

OneRoster data
exchange for L-Gate.

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 1.1 · 1.2 · 1.2.1Bulk and deltaScheduled sync
L-Gate Rostering Service login screen, with user ID, password, and Microsoft account sign-in
3,274QA tests passed · 0 failed
3OneRoster versions: 1.1, 1.2, 1.2.1
2Data modes: bulk and delta
3,274QA test items passed
0Failed test items
How it works

How the data moves.

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.

School and district systemsOneRoster CSV package
  • manifest.csv
  • orgs.csv
  • users.csv
  • classes.csv
  • courses.csv
  • enrollments.csv
  • academicSessions.csv
1RosterMatch · validate · schedule
ImportExportSync
L-GateSchools, classes, and users written directly
Azure Blob StorageScheduled or one-time file delivery
DownloadExport files to your computer
Key features

Main features.

01

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.

02

Smart matching

Match academic years, schools, classes, and users to L-Gate automatically, then review and correct by hand.

03

Bulk and delta export

Export full rosters or only the changes since last time, including records marked to be deleted.

04

Schedules

Run imports, exports, and L-Gate synchronization automatically, with an operation log and notifications.

05

Azure Blob Storage

Deliver files to Blob Storage on a schedule or once, without needing a SAS key.

06

Secure sign-in

Local accounts, Microsoft accounts, or local accounts with one-time passwords, with role-based access.

Import steps

Import steps.

01
Step 1

Upload

Choose a OneRoster ZIP (1.1, 1.2, or 1.2.1), bulk or delta, and filter by role: school admins, teachers, students.

02
Step 2

Match

Academic years, schools, classes, and users are matched to L-Gate, automatically where possible.

03
Step 3

Review

Assign classes to first-time users, set a common password if needed, and check skipped users.

04
Step 4

Write to L-Gate

Confirm and write. New users can sync straight away through the SSO Sync API.

Smart matching

Matching rules.

School data is never perfectly clean. 1Roster’s matching rules handle the differences that usually break an import.

  • Ignores full-width and half-width, uppercase and lowercase differences
  • Matches schools by partial name
  • Supports boards of education as managing organizations
  • Uses preferred display names when provided
  • Keeps homeroom classes and main teachers
  • Matches users across different organizations
  • Can match by organization and class only, without user data
  • Writes a user master identifier (UUID) for each user
Formats and options

Formats and options.

OneRoster versions1.1 · 1.2 · 1.2.1
Data modesBulk (full) and delta (changes only), with to-be-deleted records
ImportManual or scheduled, with dry run and role filter
ExportManual or scheduled, to Azure Blob Storage or download
Sign-inLocal account · Microsoft account · local account with one-time password (OTP)
EnvironmentWindows 10/11 · Google Chrome or Microsoft Edge
Quality assurance

Test results.

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.

3,274test items passed
0failed
3OneRoster versions covered
Dailyscheduled import and export test drives
Test areaItems passedFailed
Screens and UI (login, municipalities, schedules, import, sync, Blob Storage)2,1720
Login, users, and roles390
Tenant management and synchronization490
Blob Storage settings90
Manual and scheduled export2320
Bulk and delta file validation3230
Manual and scheduled import4500
1Roster

Need roster data in L-Gate?

Tell us about your municipality, schools, and current systems, and we’ll show you how 1Roster can help.