Migrate to AccessPoint

Bring your whole caseload — requests, assessments, incidents, complaints, requestors, risks, vendors, and documents — closed history and in-progress files alike. Statuses, due dates, and responsive documents carry over, so there's no cutover day: your open cases just keep moving. A guided, validated Excel import, documents staged through your own tenant's storage, and no ETL project anywhere in sight.

Never Locked In — In Either Direction

Migration is scary when the destination is a one-way door. AccessPoint's isn't — three things are true from the day you deploy, whether or not you ever migrate anything.

You own the database

Every AccessPoint table lives in the Azure SQL database in your own tenant's subscription — you own it and you host it. Standard Azure export, backup, and query tooling all work against it, no vendor involvement required.

Documents live in your storage

Case documents, response packages, and case audit exports are ordinary files in your own tenant's Azure Storage account — inside your governance boundary, always.

Export is one click away

The Export tab produces a business-readable Excel workbook of your whole caseload and registers, any time you want one. Your data arrives with you — and it can leave with you.

The Migration Path

End to end from Settings → Data import & export — no developer, no ETL tool, no vendor engagement.

Export what you have

Any report or export that reaches Excel is enough — your legacy system's built-in reports, or the spreadsheet you track requests in today. You don't need a database extract, and you don't need your old vendor's help.

Download the AccessPoint tenant-generated template

AccessPoint generates the import template from your tenant, so its Reference tab and in-cell dropdowns already carry your configured request types, stages, and codes. Fill one row per record — requests, assessments, incidents, and complaints, plus tabs for your requestor directory, register-level risks, and vendor register — with your old identifiers in the Legacy reference column, so when correspondence arrives quoting the old file number, or an in-progress case is still known by it, a search finds the case instantly.

Validate before anything imports

Uploading imports nothing by itself — it produces a per-tab validation report: what would be created, what would be skipped, and any row-level errors. Download the error report to get your own workbook back with an Errors column appended, fix, and re-upload. Imports are create-only, so re-running a corrected file is always safe.

Stage your documents

Copy legacy case files into the pre-provisioned migration-staging container in your own tenant's storage account — AzCopy for volume, drag-and-drop or the panel's own upload for smaller sets — folder-per-case, listed on the workbook's Documents tab. Add an optional MD5 hash per file and the importer verifies it against the staged copy: chain of custody, checked by machine. Staged files auto-delete after 60 days, so nothing sensitive lingers outside the document lifecycle.

Import — and continue without missing a beat

The import runs in the background, and day one looks like this: closed history is searchable, reportable, and provenanced — and your in-progress cases are simply there, with their stage, their due dates, and their responsive documents intact, ready for your team to keep working. There's no cutover window and no parallel running. Arrival itself is deliberately quiet — no notifications fire, no reviews spawn, nothing recomputes; supplied dates are stored exactly as given — and every record carries an Imported audit-trail entry, with documents riding the same conversion and indexing pipeline as native uploads.

No cutover required

The import carries each case's status, due dates, and responsive documents — not just a closed-file archive. In-progress cases arrive mid-stride and your team continues them in AccessPoint the next morning, so there's no freeze window, no parallel running, and no "finish everything in the old system first."

Rehearse before you commit

The Export tab's workbook deliberately mirrors the import template — so an export taken from one tenant validates cleanly as an import into another. Its Documents manifest even follows the same folder-per-case staging convention, so copying the files across makes the whole export re-import as-is. Rehearse the migration against a test tenant before touching production, or use the same mechanics to consolidate two tenants into one.

Keep your case numbers

Old identifiers always persist as searchable legacy references. Need the old number to remain the official one — a published disclosure log, say? Supply it and it's kept verbatim; if it matches your configured numbering format, the sequence even advances so new cases continue cleanly after it.

Migration Questions

Can we import our historical FOI or ATIP requests into AccessPoint?

Yes — along with your assessments, incidents, complaints, requestor directory, register-level risks, and vendor register. Settings → Data import & export generates an Excel template pre-filled with your tenant's own type codes and stage values; you fill one row per record, upload, and read a per-row validation report before anything imports. Historical requests keep their original identifiers as legacy references, and legacy case files migrate through a staging container in your own tenant's Azure storage.

Can we migrate cases that are still in progress, or only closed history?

Both, in the same pass. The import carries each case's status and stage, its key dates including the due date, and its responsive documents — so an open request arrives mid-stride, exactly where it stood, and your team continues it in AccessPoint. That means no cutover day: you don't freeze intake, run two systems in parallel, or wait for the old caseload to close out. And because the old file numbers persist as searchable legacy references, correspondence that arrives quoting them still finds the right case instantly.

Do we need a developer or an ETL tool to migrate?

No. The whole path is a spreadsheet exercise: any report or export from your old system that reaches Excel is enough as source material, the import template's dropdowns already carry your configured codes, and validation happens in the panel with a fix-and-reupload error workbook. Most offices run their own migration; if you'd rather have it done with you, migration and onboarding services are available.

What happens to deadlines and notifications on imported records?

Arrival is deliberately quiet: no notifications are sent, no reviews spawn, and nothing recomputes — the dates you supply are stored exactly as given, since a migrated determination is a record, not something AccessPoint second-guesses. For an in-progress case that means the due date you import is the due date your team sees, and the file continues from there. Every imported record carries an Imported audit-trail entry, so provenance stays visible forever.

How do legacy case documents migrate?

Through the pre-provisioned migration-staging container in your own tenant's Azure storage account — nothing to provision, it ships with the deployment template. Stage files folder-per-case with AzCopy for volume (or drag-and-drop for smaller sets), list each file on the workbook's Documents tab, and optionally include an MD5 content hash: when both the manifest and the staged file carry one, the importer verifies them and rejects a mismatch — an optional chain-of-custody check. Imported files ride the same conversion and indexing pipeline as native uploads, and staged files auto-delete after 60 days so sensitive records never linger outside the document lifecycle.

Can we keep our old case numbers?

Your old identifiers always come along in the Legacy reference column, searchable forever. By default AccessPoint generates fresh IMP-prefixed numbers so it stays the single numbering authority — but if your register or a published disclosure log requires the old number to remain official, supply it and it's kept verbatim. A supplied number that matches your configured numbering format even advances the sequence, so newly created cases continue cleanly after it.

Is it safe to re-run an import after fixing errors?

Always. Uploading a workbook imports nothing by itself — it produces a validation report showing what would be created, skipped, or rejected, per tab. Imports are strictly create-only: a row matching an existing case is skipped without touching that record. Download the error report to get your own workbook back with an Errors column appended, fix, and re-upload as many times as it takes.

What if we ever want to leave AccessPoint?

Then the same panel works in reverse — and that's the point. The Export tab produces a business-readable Excel workbook of your requests, assessments, incidents, complaints, requestors, risks, and vendors any time you want one, and because the database and documents live in your own tenant, standard Azure tooling works against them with no vendor involvement. The exit being easy is exactly why the entrance is safe.

The full technical walkthrough lives in the Data Import & Export guide — or have it done with you through migration & onboarding services.