Make sure you can get your customer data back out
7 min read
By Lumina Software
- Custom software
- Operations
- Service business
- Vendor management
- Data ownership
Most service businesses run on four or five outside systems: a scheduling tool, a job or field service system, a phone and texting provider, an invoicing tool, and maybe a CRM. Each one holds a piece of the customer record. Names, addresses, gate codes, service history, open quotes, call recordings, notes from the last visit.
Ask the owner how they would get all of that out if one of those vendors raised prices, got acquired, or shut down, and the answer is usually a pause. Most people have never tried. They assume there is an export button somewhere and that it gives them everything.
Sometimes it does. Often it gives them a spreadsheet of names and phone numbers and nothing else. This post covers how to check, before you need to, that you can get your own customer data out of every system you depend on.
Why this matters before anything goes wrong
The time to find out what an export contains is when nothing is on fire. Once a vendor has announced a shutdown, or the contract is ending in two weeks, or the account is suspended over a billing dispute, you are testing the export under pressure with no room to fix what it leaves out.
Exports also matter for ordinary reasons. Moving to a better tool. Connecting a new system that needs your history. Building custom software that pulls everything into one place. Answering a customer who asks what you have on file about them. Every one of these starts with getting the data out in a form something else can read.
And the data is the part of the business that cannot be rebuilt. Software can be replaced in a few weeks. Ten years of service history, notes about which customers have a dog in the yard, and the record of what was installed at each address cannot.
Run the export once, on purpose
Pick one system and do a full export today. Do not read the help article about it. Actually run it and open the files.
Then look at what came back with a few questions in mind:
- Is everything there? Compare a handful of records in the export against what you see on screen. Check the customers with the longest history, not the newest ones.
- Are the notes included? Free text notes, internal comments, and technician notes are the fields most often left out.
- Is history included? A list of current customers is not the same as a list of every job, visit, and invoice tied to each one.
- Are attachments included? Photos, signed forms, and call recordings often live in a separate place and need a separate request, if they can be exported at all.
- Can you tell what links to what? If jobs and customers come out in separate files, there needs to be an ID that connects them. Without it, you have two lists that cannot be joined back together.
- Is the format usable? A spreadsheet or a standard data file can be imported elsewhere. A stack of PDFs, one per customer, mostly cannot.
Write down what was missing. That list is the real answer to "can we get our data out."
Know the different ways out
There is usually more than one way to get data out of a system, and they give different results.
The export button in the settings is the easiest and often the most limited. It is built for a quick spreadsheet, not a full copy.
A reporting or custom report tool can sometimes pull fields the standard export skips. It is worth checking whether you can build a report that includes notes and history and then export that.
An API, the interface one system uses to talk to another, usually reaches the most data. It takes someone technical to use, but it can pull records, history, and attachments in a way that keeps the links between them. Check whether your plan includes API access. Some vendors only offer it on higher tiers.
A request to the vendor is the last option. Some vendors will produce a full data export on request, sometimes for a fee, sometimes only when you are leaving. Find out whether they do this and how long it takes before you need it.
For each system, note which of these exist and which one gives you the most complete copy.
Read the contract for the leaving part
Most service agreements say something about data when the account ends. Look for a few specific things:
- How long after cancellation your data stays available.
- Whether you can still log in to export after the account is cancelled or past due.
- Whether there is a fee for a full export.
- Whether the vendor deletes data after a set period, and whether they notify you first.
If the contract says your data is deleted thirty days after cancellation, that is a deadline you want to know about well before you cancel. If it says access ends the moment a payment fails, that is a reason to keep the card on file current and to have a recent export on hand anyway.
When you are choosing a new system, ask these questions during the sales call. A vendor who cannot clearly explain how you leave is telling you something.
Keep a recent copy
Once you know how to export from each system, do it on a schedule. Monthly is enough for most small businesses. Store the files somewhere the business controls, in a shared folder that more than one person can reach, and not on a single laptop.
This is not a replacement for the vendor's own backups. It is a copy that does not depend on the vendor at all. If an account gets locked, a vendor has an outage, or someone deletes a batch of records by mistake, you still have last month's version of your customer list, service history, and notes.
Treat the exported files with the same care as the live system. They contain names, addresses, phone numbers, and sometimes access details like gate codes. Limit who can open the folder and delete old copies on a set schedule rather than keeping every month forever.
Fill the gaps you found
The first export usually turns up a few things that cannot be gotten out cleanly. There are a few ways to handle each one.
If notes are left out of the export, check whether the API or a custom report includes them. If neither does, consider moving the most important details, like access instructions or equipment installed, into fields that do export.
If attachments cannot be exported in bulk, find out whether they can be downloaded one at a time, and decide which ones actually matter. Signed agreements and installation photos are usually worth keeping. Most of the rest is not.
If one system has no real export at all, that is worth raising at the next renewal. It may also be the system to replace first when the time comes, since it is the one holding your data hostage.
When custom software is part of the picture, a common approach is to pull from each outside system on a schedule into one database the business owns. That gives one place to search, one place to back up, and one copy that does not change when a vendor changes its export. It is more work to set up, and it is not the right first step for everyone, but it removes most of the risk described here.
The short version
Every outside system you use holds a piece of your customer record, and the export button rarely gives you all of it. Run a full export from each system now and compare it against what you see on screen. Check for notes, history, attachments, and the IDs that link records together. Learn which ways out each vendor offers, from the export button to the API to a direct request. Read the contract for what happens to your data when the account ends. Keep a monthly copy somewhere the business controls, and fix the gaps the first export reveals before a vendor change forces the issue.
Written by Lumina Software. Have a question? Book a call