Lamplight is a case management and outcome reporting system used by many UK charities. This guide shows how to plan a move from Lamplight to Affinux, a charity CRM with case management built in: what to export, how to bring it in with a dry run, and how to switch over without losing track of anyone.
We make Affinux, not Lamplight. Lamplight’s menus and options change, so check the export steps with Lamplight’s own help pages or support team. We’ll help you plan the move too.
Before you start
- Check your notice period. Lamplight’s pricing page describes a rolling contract with one month’s notice (Lamplight pricing). Check your own agreement, and plan your switch date around it.
- List what you use Lamplight for. For example: people and organisations, referrals, cases, sessions and attendance, outcome measures and reports.
- Decide what moves and what you archive. Most organisations move their people and organisations, then keep a full export of the rest as an archive.
- Pick a switch date, and tell your team which system to use from when.
Step 1: Match what you use to Affinux
| In Lamplight | In Affinux |
|---|---|
| People and organisations | People and organisations, imported from a CSV file, each with the roles they hold |
| How you label people, such as service users or volunteers | Roles you name yourself, such as people we support, volunteers or members |
| Your own fields | Custom fields, added before you import |
| Case work and referrals | Cases with assessments, a plan and goals, outcomes and closure reasons |
| Sessions and attendance | Programmes with sessions and attendance registers |
| Outcome measures | Assessments with scores, and outcome ladders |
Set up the roles, custom fields and words you need in Affinux first, so each column in your file has somewhere to go. You can rename people, roles and menus to match the words your team already uses.
Step 2: Export your records from Lamplight
Lamplight lets you build reports on its records and export them to Excel (Lamplight features). Its administrator handbook says every table can be downloaded as a CSV file (Lamplight administrator handbook).
- Export people and organisations first, with one row for each record.
- Include Lamplight’s own ID for each record. You’ll use it in Affinux to recognise people you’ve already imported.
- Keep a full copy as an archive, and store it securely. Once it’s downloaded, you are responsible for keeping it safe.
Step 3: Tidy the file
- Save it as CSV UTF-8, with the headings in the first row.
- Keep first names, last names, emails, phone numbers and postcodes in their own columns.
- Write dates as day, month, year, with the year in full, such as 25/12/2025.
- Put several roles or tags in one cell by separating them with semicolons.
The importing guide has the full list of what Affinux reads, including file sizes and phone number formats.
Step 4: Import with a dry run
Go to Settings → Data → Imports and choose Import a file.
- Match your columns to Affinux fields. You can save the mapping for your next file.
- Choose Lamplight’s ID as the column that recognises people you already have, instead of email. Then a second import updates the same people instead of creating duplicates.
- Check the dry run. Nothing is saved yet. Affinux shows how many records would be created or updated, and the reason for any row with a problem.
- Import, then fix any rows that were left out and import them again.
For 30 days after an import of people finishes, you can undo it from the import’s page.
Step 5: Switch over
- Start new work in Affinux from your switch date: new referrals, cases and sessions.
- Run a final export from Lamplight just before your access ends, and keep it with your archive.
- Check your forms and messages. If you use Affinux forms, put them on your website in place of the old referral or sign-up forms. Connect your mailboxes, WhatsApp and SMS so conversations land on the right records.
What doesn’t come across yet
- Past activity, such as a timeline of notes, sessions and calls, and attachments. A single notes column can go into each person’s Notes field.
- Donations and Gift Aid declarations.
- Each person’s communication preferences for each channel and purpose. Consent columns for marketing, contact and data processing can be imported as yes or no.
Keep your Lamplight export as your archive of this history.
Get help with the move
Email support@affinux.com with what you use Lamplight for and roughly how many records you have, and we’ll plan the move with you. We set up your workspace with you on a call, and check your first import.
By the Affinux team. Last updated 3 November 2026.