Web:Kemp's SharePoint Document Storage - Revision history

Jspenceratty: /* Move one test file first */

2026-05-08T18:36:03Z

Move one test file first

← Older revision		Revision as of 18:36, 8 May 2026
Line 575:		Line 575:
	===Move one test file first ===		===Move one test file first ===

	# Open a test case with at least one SQL-stored document.		Open a test case with at least one SQL-stored document.

	<ol start="37" style="list-style-type: decimal;">		<ol start="1" style="list-style-type: decimal;">
	<li><p>Select one non-critical document.</p></li>		<li><p>Select one non-critical document.</p></li>
	<li><p>Use the button that moves that file from SQL to SharePoint.</p></li>		<li><p>Use the button that moves that file from SQL to SharePoint.</p></li>

Jspenceratty: /* Recommended Prime test sequence */

2026-05-08T18:35:41Z

Recommended Prime test sequence

← Older revision		Revision as of 18:35, 8 May 2026
Line 537:		Line 537:
	=== Recommended Prime test sequence ===		=== Recommended Prime test sequence ===

	# Save the SharePoint settings in Prime but leave broad rollout disabled if your setup page has a test mode.		Save the SharePoint settings in Prime but leave broad rollout disabled if your setup page has a test mode.

	<ol start="31" style="list-style-type: decimal;">		<ol start="1" style="list-style-type: decimal;">
	<li><p>Use the Prime test button, if available. A complete test should confirm token acquisition, site access, drive access, upload, download/read, and cleanup of a test file.</p></li>		<li><p>Use the Prime test button, if available. A complete test should confirm token acquisition, site access, drive access, upload, download/read, and cleanup of a test file.</p></li>
	<li><p>Upload a small harmless test PDF or text file to a test case in Prime.</p></li>		<li><p>Upload a small harmless test PDF or text file to a test case in Prime.</p></li>

Jspenceratty: /* 7. Create the app credential used by Prime */

2026-05-08T18:35:15Z

7. Create the app credential used by Prime

← Older revision		Revision as of 18:35, 8 May 2026
Line 183:		Line 183:
	== 7. Create the app credential used by Prime ==		== 7. Create the app credential used by Prime ==

	~~# In the same app registration, open Certificates & secrets.~~		<ol start="1" style="list-style-type: decimal;">
			<li><p>In the same app registration, open Certificates & secrets.</p></li>
	<ol start="25" style="list-style-type: decimal;">
	<li><p>For a first setup, choose Client secrets > New client secret.</p></li>		<li><p>For a first setup, choose Client secrets > New client secret.</p></li>
	<li><p>Enter the description as Prime SharePoint Production Secret.</p></li>		<li><p>Enter the description as Prime SharePoint Production Secret.</p></li>
Line 201:		Line 200:

	<span id="connect-the-api-to-the-sharepoint-site"></span>		<span id="connect-the-api-to-the-sharepoint-site"></span>

	== 8. Connect the API to the SharePoint Site ==		== 8. Connect the API to the SharePoint Site ==

Jspenceratty: /* 6. Add the Microsoft Graph API permission */

2026-05-08T18:34:24Z

6. Add the Microsoft Graph API permission

← Older revision		Revision as of 18:34, 8 May 2026
Line 155:		Line 155:
	== 6. Add the Microsoft Graph API permission ==		== 6. Add the Microsoft Graph API permission ==

	~~# In the app registration, open API permissions.~~		<ol start="1" style="list-style-type: decimal;">
			<li><p>In the app registration, open API permissions.</p></li>
	<ol start="18" style="list-style-type: decimal;">
	<li><p>Choose Add a permission.</p></li>		<li><p>Choose Add a permission.</p></li>
	<li><p>Choose Microsoft Graph.</p></li>		<li><p>Choose Microsoft Graph.</p></li>
Line 181:		Line 180:

	<span id="create-the-app-credential-used-by-prime"></span>		<span id="create-the-app-credential-used-by-prime"></span>

	== 7. Create the app credential used by Prime ==		== 7. Create the app credential used by Prime ==

Jspenceratty: /* 5. Register the Prime application in Microsoft Entra ID */

2026-05-08T18:33:36Z

5. Register the Prime application in Microsoft Entra ID

← Older revision		Revision as of 18:33, 8 May 2026
Line 134:		Line 134:
	== 5. Register the Prime application in Microsoft Entra ID ==		== 5. Register the Prime application in Microsoft Entra ID ==

	~~# Open the Microsoft Entra admin center.~~		<ol start="1" style="list-style-type: decimal;">
			<li><p>Open the Microsoft Entra admin center.</p></li>
	<ol start="11" style="list-style-type: decimal;">
	<li><p>Go to App registrations.</p></li>		<li><p>Go to App registrations.</p></li>
	<li><p>Select New registration.</p></li>		<li><p>Select New registration.</p></li>
Line 153:		Line 152:

	<span id="add-the-microsoft-graph-api-permission"></span>		<span id="add-the-microsoft-graph-api-permission"></span>

	== 6. Add the Microsoft Graph API permission ==		== 6. Add the Microsoft Graph API permission ==

Jspenceratty: /* Manual Graph smoke test */

2026-05-08T18:31:53Z

Manual Graph smoke test

← Older revision		Revision as of 18:31, 8 May 2026
Line 555:		Line 555:
	{\| class="wikitable"		{\| class="wikitable"
	\|-		\|-
	! # Confirm the permission exists on the target site.~~<br />~~		<pre>! # Confirm the permission exists on the target site.
	Invoke-MgGraphRequest -Method GET -Uri "https://graph.microsoft.com/v1.0/sites/$siteId/permissions" \|~~<br />~~		Invoke-MgGraphRequest -Method GET -Uri "https://graph.microsoft.com/v1.0/sites/$siteId/permissions" \|
	ConvertTo-Json -Depth 10~~<br />~~		ConvertTo-Json -Depth 10
	~~<br />~~
	# Confirm the drive is visible to the admin session.~~<br />~~		# Confirm the drive is visible to the admin session.
	Invoke-MgGraphRequest -Method GET -Uri "https://graph.microsoft.com/v1.0/drives/$driveId" \|~~<br />~~		Invoke-MgGraphRequest -Method GET -Uri "https://graph.microsoft.com/v1.0/drives/$driveId" \|
	Select-Object id, name, webUrl		Select-Object id, name, webUrl
			</pre>
	\|}		\|}


	<span id="move-existing-sql-stored-documents-to-sharepoint"></span>		<span id="move-existing-sql-stored-documents-to-sharepoint"></span>

Jspenceratty: /* 8. Connect the API to the SharePoint Site */

2026-05-08T18:29:57Z

8. Connect the API to the SharePoint Site

← Older revision		Revision as of 18:29, 8 May 2026
Line 204:		Line 204:

	On a Windows machine, open Windows PowerShell ISE. Make sure you can see the Script Pane (View🡪Show Script Pane is checked). In the script pane—typically on the top with a blank line numbered one—copy and paste the following script and save this as a ps1 file:		On a Windows machine, open Windows PowerShell ISE. Make sure you can see the Script Pane (View🡪Show Script Pane is checked). In the script pane—typically on the top with a blank line numbered one—copy and paste the following script and save this as a ps1 file:
			<div class="mw-collapsible mw-collapsed">
			'''Show PowerShell script'''
	<pre>		<pre>
	# ============================================================		# ============================================================
Line 465:		Line 466:
	Write-Host "Prime values copied to clipboard."		Write-Host "Prime values copied to clipboard."
	</pre>		</pre>
			</div>


	Replace the four values at the top, including $tenantId, $appClientId, $appClientSecret, and $sharePointHostName. The $tenantId and $appClientId entries come from the API registration. The $appClientSecret comes from the API client secret gathered before. The $sharePointHostName comes from the beginning of the URL to your new SharePoint site.		Replace the four values at the top, including $tenantId, $appClientId, $appClientSecret, and $sharePointHostName. The $tenantId and $appClientId entries come from the API registration. The $appClientSecret comes from the API client secret gathered before. The $sharePointHostName comes from the beginning of the URL to your new SharePoint site.

Jspenceratty: /* 8. Connect the API to the SharePoint Site */

2026-05-08T18:26:58Z

8. Connect the API to the SharePoint Site

Show changes

Jspenceratty: /* Then use Move All for the case */

2026-05-08T18:20:56Z

Then use Move All for the case

← Older revision		Revision as of 18:20, 8 May 2026
Line 738:		Line 738:
	=== Then use Move All for the case ===		=== Then use Move All for the case ===

	<ol start="42" style="list-style-type: decimal;">		<ol start="1" style="list-style-type: decimal;">
	<li><p>Use Move All SQL Files to SharePoint only after the one-file test succeeds.</p></li>		<li><p>Use Move All SQL Files to SharePoint only after the one-file test succeeds.</p></li>
	<li><p>Run it on one case first, not the whole database.</p></li>		<li><p>Run it on one case first, not the whole database.</p></li>

Jspenceratty: /* Then use Move All for the case */

2026-05-08T18:20:43Z

Then use Move All for the case

← Older revision		Revision as of 18:20, 8 May 2026
Line 736:		Line 736:
	<span id="then-use-move-all-for-the-case"></span>		<span id="then-use-move-all-for-the-case"></span>

	== Then use Move All for the case ==		=== Then use Move All for the case ===

	<ol start="42" style="list-style-type: decimal;">		<ol start="42" style="list-style-type: decimal;">
Line 753:		Line 753:

	<span id="ongoing-maintenance"></span>		<span id="ongoing-maintenance"></span>

	== 12. Ongoing maintenance ==		== 12. Ongoing maintenance ==