Data Utilities

Data Utilities

Deactivated Elements Impact Report

Deactivated Elements Impact Report Video

Element Replacement

Element Replacement Video

Combine Person Wizard

Combine Person Wizard Video

Data Extract History

Data Extract Utility

Data Extract Utility Client (Pull Method) Update

Setting Up the Data Extract Client to Utilize the Pull Delivery Mode

OneRoster CSV Extract Configuration

--Academic Sessions
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterAcademicSessions] 
@TYPE = 'bulk'
GO
 
--Categories
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterCategories] 
@TYPE = 'bulk'
GO
 
--Classes
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterClasses] 
@TYPE = 'bulk'
GO
 
--Courses
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterCourses] 
@TYPE = 'bulk'
GO
 
--Demographics
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterDemographics] 
@TYPE = 'bulk'
GO
 
--Enrollments
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterEnrollments] 
@TYPE = 'bulk'
GO
 
--LineItems
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterLineItems] 
@TYPE = 'bulk'
GO
 
--Manifest
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterManifest] 
@TYPE = 'bulk'
GO
 
--Orgs
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterOrgs] 
@TYPE = 'bulk'
GO
 
--Results
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterResults] 
@TYPE = 'bulk'
GO
 
--Users
DECLARE @RC INT
DECLARE @TYPE VARCHAR(10)
DECLARE @days INT
EXECUTE @RC = [dbo].[extract_V1P1OneRosterUsers] 
@TYPE = 'bulk'
GO

Data Extract Zip Tool

Data Health Check Report