32:I[51060,["/_next/static/immutable/chunks/3w2-tt8ecm9mz.js","/_next/static/immutable/chunks/2i9bgs6t6hfua.js","/_next/static/immutable/chunks/0z-q5l1xa28vs.js","/_next/static/immutable/chunks/0kwz_u4_tz_5s.js","/_next/static/immutable/chunks/41l3031ny9poo.js"],"Helpful"] 33:I[58681,["/_next/static/immutable/chunks/3w2-tt8ecm9mz.js","/_next/static/immutable/chunks/2i9bgs6t6hfua.js","/_next/static/immutable/chunks/0z-q5l1xa28vs.js","/_next/static/immutable/chunks/0kwz_u4_tz_5s.js","/_next/static/immutable/chunks/41l3031ny9poo.js"],"TableOfContents"] 34:I[26800,["/_next/static/immutable/chunks/3w2-tt8ecm9mz.js","/_next/static/immutable/chunks/2i9bgs6t6hfua.js","/_next/static/immutable/chunks/0z-q5l1xa28vs.js","/_next/static/immutable/chunks/0kwz_u4_tz_5s.js","/_next/static/immutable/chunks/41l3031ny9poo.js"],"TrendingSidebar"] 31:T1000,

A template insert script for syncing ProSolution student data into Navigate. It takes data from the NavigateStudentsExport view and inserts new students that are not already in the Navigate database.

What the script does

This is a template insert script ([ProSolutionReports].[dbo].[Navigate_StudentInsert]) which takes data from the NavigateStudentsExport view. The script checks if a Student Details ID is currently in Navigate's database:

If it finds the ID, it ignores that student.
If it does not, it inserts the new student.

Version: 1.0 | Created by: Navigate | Created date: 22/03/25 (Initial Development).

Before you run it

Replace [Insert your specific college schema here] with your specific college schema name.
Change the source view name [ProSolutionReports].[dbo].[vNavigateStudentsExport] if needed for your environment.
DateAdded must not be null.
DateUpdated and DateProcessed are for Navigate use — do not add data to these fields.

Template insert script

INSERT INTO [NAVIGATE].[Navigate_ExternalFeeds].[Insert your specific college schema here].[tblUsers] (
	[StudentNumber]
     ,[StudentFirstName]
     ,[StudentSurname]
     ,[StudentEmail]
     ,[StudentUsername]
     ,[TutorFirstName]
     ,[TutorSurname]
     ,[TutorEmail]
     ,[Attribute1]
     ,[Attribute1Code]
     ,[Attribute2]
     ,[Attribute2Code]
     ,[Attribute3]
     ,[Attribute3Code]
     ,[Attribute4]
     ,[Attribute4Code]
     ,[Attribute5]
     ,[Attribute5Code]
     ,[Attribute6]
     ,[Attribute6Code]
     ,[ExternalID]
     ,[DateAdded]
	 ,[DateUpdated]
	 ,[DateProcessed]
     ,[Active]
	 ,[EHCPStatus]
)
SELECT
	[StudentNumber]
	,[StudentFirstName]
	,[StudentSurname]
	,[StudentEmail]
	,[StudentUsername]
	,[TutorFirstName]
	,[TutorSurname]
	,[TutorEmail]
	,[Attribute1]
	,[Attribute1Code]
	,[Attribute2]
	,[Attribute2Code]
	,[Attribute3]
	,[Attribute3Code]
	,[Attribute4]
	,[Attribute4Code]
	,[Attribute5]
	,[Attribute5Code]
	,[Attribute6]
	,[Attribute6Code]
	,[ExternalID]
	,[DateAdded]
	,[DateUpdated]
	,[DateProcessed]
	,[Active]
	,[EHCPStatus]
FROM
(
SELECT
		vSE.[StudentNumber] As [StudentNumber]
      ,vSE.[StudentFirstName] As [StudentFirstName]
      ,vSE.[StudentSurname]   As [StudentSurname]
      ,vSE.[StudentEmail]     As [StudentEmail]
      ,vSE.[StudentUsername]  As [StudentUsername]
      ,vSE.[TutorFirstName]   As [TutorFirstName]
      ,vSE.[TutorSurname]     As [TutorSurname]
      ,vSE.[TutorEmail]       As [TutorEmail]
      ,vSE.[Attribute1]       As [Attribute1]
      ,vSE.[Attribute1Code]   As [Attribute1Code]
      ,vSE.[Attribute2]       As [Attribute2]
      ,vSE.[Attribute2Code]   As [Attribute2Code]
      ,vSE.[Attribute3]       As [Attribute3]
      ,vSE.[Attribute3Code]   As [Attribute3Code]
      ,vSE.[Attribute4]       As [Attribute4]
      ,vSE.[Attribute4Code]   As [Attribute4Code]
      ,vSE.[Attribute5]       As [Attribute5]
      ,vSE.[Attribute5Code]   As [Attribute5Code]
      ,vSE.[Attribute6]       As [Attribute6]
      ,vSE.[Attribute6Code]   As [Attribute6Code]
      ,vSE.[StudentNumber]    As [ExternalID]
      ,GETDATE()              As [DateAdded] -- Must not be null.
	  ,NULL                   As [DateUpdated] -- Navigate use, do not add data here.
	  ,NULL                   As [DateProcessed] -- Navigate use, do not add data here.
      ,vSE.[Active]           As [Active]
	  ,vSE.[EHCPStatus]       As [EHCPStatus]
FROM [ProSolutionReports].[dbo].[vNavigateStudentsExport] vSE --Change name if needed
LEFT JOIN [NAVIGATE].[Navigate_ExternalFeeds].[Insert your specific college schema here].[tblUsers] as Nav
on vSE.[ExternalID] = Nav.[ExternalID]
WHERE Nav.[ExternalID] IS NULL --Where not in Navigate database.

Source document attached below.

2e:[false,["$","div",null,{"className":"space-y-4","children":[["$","a",null,{"href":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301379","target":"_blank","rel":"noopener noreferrer","className":"inline-flex items-center gap-2 px-5 py-2.5 text-white text-sm font-medium rounded-lg transition-colors","style":{"background":"#0F6E56"},"children":[["$","svg",null,{"width":20,"height":20,"viewBox":"0 0 24 24","fill":"none","stroke":"currentColor","strokeLinecap":"round","strokeLinejoin":"round","aria-hidden":true,"strokeWidth":2,"className":"$undefined","children":[["$","path",null,{"d":"M18 13v6a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V8a2 2 0 0 1 2-2h6"}],["$","polyline",null,{"points":"15 3 21 3 21 9"}],["$","line",null,{"x1":"10","y1":"14","x2":"21","y2":"3"}]]}],"Open / Download"]}],false]}],false,["$","div",null,{"className":"article-body","dangerouslySetInnerHTML":{"__html":"$31"}}]] 2f:["$","$L32",null,{"slug":"prosolution-student-insert-script-template","role":"staff"}] 30:["$","aside",null,{"className":"mt-12 lg:mt-0","children":["$","div",null,{"className":"lg:sticky lg:top-24 space-y-10","children":[["$","$L33",null,{}],["$","$L34",null,{"title":"You may also like","items":[{"id":"e249ed75-2e43-4659-8936-efcdba38d409","title":"Creating the SQL Server Agent Job for Student Export","slug":"creating-the-sql-server-agent-job-for-student-export","type":"guide","categorySlug":"mis-data","roles":["staff"],"tags":["Server_Agent_Job_Creation"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301353","thumbnail":"/category-artwork/2026-09-30/staff-mis-data.png","summary":"A SQL Server Agent script that creates a scheduled job to export student data to Navigate every night at midnight. The job runs the update and insert stored procedures in sequence. What the job does The script creates a SQL Server Agent job","videoGuide":false,"theme":"Students","popularity":0,"updatedAt":"2026-06-12T13:07:23Z"},{"id":"1cf98013-26e6-4fb0-93cb-5f6905478897","title":"MIS Guide: Connecting Your College MIS to Navigate via SQL","slug":"mis-guide-connecting-your-college-mis-to-navigate-via-sql","type":"pdf","categorySlug":"mis-data","roles":["staff"],"tags":["T Levels"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301367","thumbnail":"/category-artwork/2026-09-30/staff-mis-data.png","summary":"A complete guide for MIS and data teams (Pro Solution) on connecting your college MIS to Navigate via SQL, managing import tables, and building reports. Contents Connecting to SQL - whitelisting college IP, connecting college MIS to SQL, en","videoGuide":false,"theme":"SQL & integrations","popularity":0,"updatedAt":"2026-08-11T14:36:56Z"},{"id":"4e079ade-6fe1-4952-917a-a7a85c034f47","title":"Sample SQL Script for EBS","slug":"sample-sql-script-for-ebs","type":"form","categorySlug":"mis-data","roles":["staff"],"tags":["Sample SQL Script for EBS"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301414","thumbnail":"https://static.wixstatic.com/media/c23afe_34e50e9c8a8c4a8f9d9a20b0db9173f2~mv2.jpeg","summary":"This is a sample SQL script for colleges integrating EBS with Navigate. It shows how to build a feed of active learners and their tutors from EBS, and how a scheduled SQL job keeps the Navigate tblUsers table in sync each day. Key points Na","videoGuide":false,"theme":"SQL & integrations","displayFormat":"Script","popularity":0,"updatedAt":"2026-06-12T13:07:27Z"},{"id":"5a534349-fcc2-4de3-bc16-3cc86b6d653a","title":"Sample Linked Server Script","slug":"sample-linked-server-script","type":"form","categorySlug":"mis-data","roles":["staff"],"tags":["Sample Linked Server Script"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301368","thumbnail":"https://static.wixstatic.com/media/c23afe_a9ac0f51367a40a9b6f2ddb569c4e05a~mv2.jpeg","summary":"A sample SQL script for adding Navigate as a linked server, allowing your college MIS to connect to the Navigate external feeds database. Replace USERNAME_HERE and PASSWORD_HERE with your own connection credentials before running the script","videoGuide":false,"theme":"SQL & integrations","displayFormat":"Script","popularity":0,"updatedAt":"2026-06-12T13:07:24Z"},{"id":"6aa6403b-1cbf-47a5-b43b-50afd2b4a9b4","title":"ProSolution Student Export View (Template)","slug":"prosolution-student-export-view-template","type":"form","categorySlug":"mis-data","roles":["staff"],"tags":["StudentExport_View"],"media":"https://navigatehelp.freshdesk.com/support/solutions/articles/47001301415","thumbnail":"https://static.wixstatic.com/media/77f784_c5929cdc5fe843b29cccd604efce906a~mv2.png","summary":"This is a template Navigate view for colleges running ProSolution. It provides the basic student, tutor and attribute data required for Navigate's external database, and is intended as a starting point that you adapt to your own college's d","videoGuide":false,"theme":"Students","popularity":0,"updatedAt":"2026-06-12T13:07:27Z"}],"role":"staff"}]]}]}]