Reading 03 / Records & portability
Can you take useful
records with you?
An export button is a starting point. The more useful question is whether the exported information can be understood and used somewhere else.
Decide what needs to survive the move
For a hypothetical booking system, a list of names and dates may not be enough. Notes, attachments, time zones, and cancellation status can all affect how a record is interpreted. Make a short inventory of the information needed for continuing work before testing an export.
Separate material that must remain usable from material kept only as a historical reference. Those needs may call for different formats. A readable document can be helpful for reference, while a structured table may be needed to load records into another application.
Try a small export and inspect it
Choose a few representative records, including one with an attachment and one with an unusual value. Open the exported files using the tools that will actually be available to the next person. Check dates, special characters, long notes, and empty fields rather than relying on the number of downloaded rows.
Look for relationships as well as individual values. A contact and an appointment may be exported into separate tables linked by an identifier. If that identifier disappears during editing, the files may still open but no longer describe the same information correctly.
Keep an export separate from a backup plan
An export is a copy produced at a particular moment. It may omit settings, permissions, change history, or files stored elsewhere. A backup plan needs to explain what can be restored, how recent it will be, and who is responsible for doing it.
Ask the provider which export formats and recovery options are included in the actual plan. Keep copies in an approved location with suitable access controls. Creating extra files without knowing who can read them can introduce a new problem while trying to solve an old one.
Close the old system carefully
Before cancelling an account, confirm that the required records have arrived, attachments can be opened, and an authorized person has checked the result. Keep a note of what moved and what did not. Follow the provider's account-closure instructions and any applicable retention requirements; do not assume that cancelling billing immediately deletes every stored copy.