What's New

• Fix Logos were being stretched out of shape. A logo's proportions were recorded once when you uploaded it, and anything saved before the light and dark versions were introduced came back as a square — so a wide logo was squashed to fit. Proportions are now measured from the image itself every time it's drawn, everywhere it appears: page headers, cover pages, certificates and client logos. Nothing needs re-uploading.
• Fix The extra paragraph you can add in Report Settings never appeared on a Detailed Test Report. It worked on the Summary Report but was silently dropped by all four cover styles. It now prints on every one of them, keeps your blank lines as real paragraph breaks, and shrinks slightly rather than overflowing if it's long.
• New The document reference is now printed on the cover page, not only in the page footers — so a client quoting it back doesn't have to hunt for it.
• New A "Tested By" block on the Banner and Editorial covers giving your company name, address, phone and email. These were previously only in footer small print; a test report is a record of who carried out the work, so they now sit beside the client's details.
• Change The Banner cover has been reworked. The company logo is roughly twice the size and properly fills the coloured band, and the client's logo has moved out of the band to sit above the client's name, at double its previous size and on white where it's far more legible.

• Change The bordered visual inspection and electrical results tables are back in each asset's detail block. They were compressed a few versions ago to fit more per page; the saving wasn't worth the loss in readability.
• Change Each block is now sized to what's actually in it and flows down the page, with a new page starting only when the next block genuinely won't fit. Previously a fixed number of blocks went on each page regardless of how tall they were, which left large bands of empty white space on most pages.

• New A client's logo now appears on every page of their report, top right, opposite your own — and on all four cover styles.
• New The logo automatically switches to its light or dark version depending on what it's sitting on, so it stays visible on the darker Banner cover.
• Fix Long company names in the report header could run underneath the client logo. The header text is now held to the space actually available.

• New Every report gets its own reference — in the form PK-20260802-A4F19C — printed on every page and shown in the preview bar, so a report someone emails back to you months later can be traced to exactly what was generated and when.
• New Reports are kept automatically, with the PDF stored privately against your account rather than only existing in your downloads folder.
• New A Report Archive you can search by reference, client or filename, and download from directly.
• Change Deleting a report never removes the record of it. The file is cleared and the deletion is stamped with who did it, when, and why, but the reference and its history are kept permanently — a reference can never be reused or quietly made to disappear.

• Fix Repair notes were vanishing from reports. A failure that was repaired and then tested again later printed no note explaining the repair, because the note was worked out from the asset's current status rather than from that specific test. On a large report this could hide the entire explanation of a failure. Notes are now tied to the test they describe.
• New "Page 3 of 12" on every report page, so a printed copy can be checked for completeness.
• Change Summary report readability: units are no longer repeated in every cell since the column headers already state them, figures are printed in black, and only failed readings are picked out in red. The Overall Status column keeps its full colour coding.
• New The report builder offers to limit a report to the last test batch when you haven't already filtered to one.

• New Four cover styles for the Detailed Test Report — Classic, Banner, Sidebar and Editorial — so a report can be made to sit alongside your own documents rather than looking generic.
• Change Report Settings is now a single dialog with three tabs — Content, Branding and Cover Page — instead of settings spread across separate places.
• Change The Beta and Stable channel addresses have moved out of Report Settings, where they never belonged, into Company Details.
• New Clickable links extended to the repaired assets table and to the failed assets list on the Summary Report cover, so you can jump straight from either to the asset itself.

• Change A line per test, grouped by room with a banner row for each, angled column headers to fit more columns on an A4 page, and a simple P, F or dash for each test with the actual reading printed beside it.
• Change A dash now marks a test that wasn't applicable, replacing the less obvious "S".

• Fix An appliance tested by protective conductor continuity rather than earth bond produced a certificate reading "No electrical test data recorded" — despite having been tested perfectly properly. Continuity and flash results are now shown like every other reading.

• Change Solid result badges and tinted callout boxes in each asset's detail block, matching how certificates already looked. The colours are taken from your own branding rather than being fixed.

• New A book-style title page on the Detailed Test Report, full visual inspection detail per asset, and a failures list on the cover you can click to jump to any of them.
• Change "Repaired" now means the test immediately before the pass was a failure. Previously any earlier failure anywhere in an asset's history was enough to mark it as repaired, which overstated how much remedial work had actually been done.

• Change Three report types, all A4 portrait — Detailed, Detailed with Photos, and Summary.
• Change Certificates are now generated from the asset itself rather than from the Reports menu, since a certificate always covers one asset and never a selection.
• New A branding studio showing a live preview of your report as you change colours, logo and header, instead of having to generate one to find out.
• Fix Saving Report Settings was wiping your branding. The save replaced the whole settings record rather than the part you'd edited, so changing anything on the Content side silently discarded your logo and colours.

• Change The client portal is now full width, with collapsible filters, a location list that narrows as you filter, and the same Asset and Inventory view toggle the main app has.
• New Reports and certificates generated on the free plan carry a short "Report made using the free version of PATKeeper" line. Pro removes it.
• Change Pricing and billing wording made clearer: the trial is free and takes no card details.

• New "Repaired" is now recognised everywhere — in the app, in the portal and on reports — rather than a repaired asset simply reading as a pass with a failure buried in its history.
• Change The rules deciding whether an asset counts as a pass, a repair or a failure now live in one shared file used by both the app and the portal. They had previously been written twice, which is precisely how the two came to disagree.

• Fix The portal was showing a different due date from the calendar. It worked the date out separately, based on the oldest asset on record, so clients with a few stale assets appeared years overdue when their next visit was actually months away.
• Change The due date and job length now come straight from the schedule — the same figures your calendar shows, including any visit you've already moved. The portal simply displays them.

• New The portal tells the client how long testing usually takes them — worked out from their own past visits, not a guess. A site that's taken four days each year is offered four days; one that's grown from one day to two is offered two.
• New The booking form asks how many days will be needed, pre-filled with that figure, and the client can adjust it.
• New Confirming a request books out the agreed number of days in your calendar, rather than assuming it matches last time.

• Fix Billing & Credits no longer mixes up your plan with the one you could upgrade to. Current Plan now describes what you're actually on; upgrading to Pro is its own section underneath.
• Fix Repeat test flags are visible without opening each asset. Flagged assets are marked on the collapsed row with a count, so you can spot them at a glance.
• New Show only repeat tests — an "only" tickbox next to the flag setting narrows the table to just the flagged tests.
• Fix The client portal loads faster. Finding a client's records was scanning every record on the account rather than going straight to them.

• Fix Only credit pack purchases count towards the licence — subscription payments don't. This is now enforced by the system rather than left to get it right each time.
• New 🧭 Import with Column Mapping in Technician's Tools. The matching step only appeared automatically for files that didn't look like a PATKeeper export — now you can choose it for any file.
• Change Photos start uploading the moment you pick them, with a thumbnail and progress, so by the time you press Save it's usually already done. Leave without saving and the photo is quietly discarded.
• New Flag possible repeat tests — a tickbox above the table highlights the same asset tested twice within 5 minutes (or 15 minutes, an hour, or the same day). They're only highlighted, never removed.
• Change The client portal now offers to arrange testing even when no retest date has been worked out yet.

• New 🔧 Asset Note in Technician's Tools — leave a note on any asset without opening its client first. Pick the client, type or scan the asset number, and its description comes up so you can be sure you've got the right one.
• New Assets that don't exist yet can be added on the spot. Spotted something on site that's never been tested? Give it a number and a description and it goes onto the client's list straight away, so your note isn't lost waiting for a test that hasn't happened.
• New These show in their own awaiting first test section — never mixed in with tested equipment — and fill in properly the moment their first real test is imported.
• New Notes and photos save in the background here too, so nothing freezes while a photo uploads.

• New The client portal now shows when testing is next due, right at the top — green when it's a way off, amber within two months, red once it's overdue.
• New Clients can suggest a date straight from their portal, with an alternative, a contact name and any notes about access. No account needed, same as the rest of the portal.
• New 🔔 Notifications in the main app, showing requests as they come in with a count on the button. Accept a date and that client's next visit is rescheduled to it automatically; decline with an optional note back.
• New Clients with a request waiting are marked with a ✏️ in the calendar, in both month and agenda views.
• New Once you've accepted, the client's portal shows the booked date rather than the overdue warning.

Accepting a date reschedules the visit the same way as moving it by hand — your test records are never altered.

• New Excel files can now be imported — .xlsx, .xls and .xlsm, alongside CSV and tester .DB files.
• New A column matching step for files that aren't PATKeeper exports. PATKeeper reads your headings, works out which of its fields each column belongs to, and shows you the match alongside real sample data from your own file so you can see it's lined up correctly before importing.
• New Anything it can't place is left unmatched rather than guessed at, and you can set any column by hand — or leave columns out entirely. Two columns can't be pointed at the same field by mistake.
• New If your spreadsheet has no client column — common when a file covers one site — you can name the client once for the whole import.
• Change Files that already look like a PATKeeper export skip the matching step and import exactly as before. Imported rows still go through the usual duplicate check.

• New Buy the five-year licence directly from Billing & Credits. Whatever you've already paid — subscription months and credit packs alike — comes off the price, and you only pay the difference.
• Change Payment history is now recorded in full, so licence progress can be worked out reliably.
• New If what you've already spent covers the full price, the licence is simply granted — you're not asked to pay anything further.
• New Refunded payments are deducted from what you've accrued.

• New Credit packs come off the price of a licence. Billing & Credits shows how much of the £500 five-year licence your pack purchases have already covered, and how much is left. Spend £40 on credit packs and the licence costs you £460.
• New Credits you've already used still count. It's based on what you've spent on packs, not on credit sitting unused — so nothing is wasted by actually using them.

Refunded payments are deducted. Buying a licence doesn't accrue towards another one.

• Fix Saving a note with a photo appeared to hang. The upload and save were blocking the whole window with no indication anything was happening. Both now show a small progress panel — what's uploading, how far along — and you can dismiss it and carry on while it finishes.
• Fix The same freeze when adding a Note for Next Import is fixed the same way, and the form clears immediately so you can add the next one straight away.
• New Notes now record who wrote them, ready for accounts with more than one technician.
• Change 📅 Calendar is now its own button rather than being buried in a menu, and is named Calendar instead of Retests Due.
• Change "Reschedule to" now starts on the job's current date rather than empty.
• Change Clearer labels: Add Manual Test Record, Test Result in the filters, and Inventory / Description View.
• Change The light/dark switch is now a plain labelled button, matching the rest of the toolbar.

• New Drag a job onto any day in the month view to move it there. The day you're hovering over is highlighted as you go, and dropping it asks whether the job should stay the same number of days before anything changes.
• New Change job length from the client menu, without moving the start date — useful when a job turned out to take longer than last time.

Dragging needs a mouse. On a phone, use the client menu and Reschedule instead.

• Change Rescheduling now shifts dates rather than flattening them. Assets due across three days stay across three days — they no longer all land on one date because you moved the visit.
• New You're asked how long the job will take. Moving a visit shows how many assets are involved and how many days they currently span, and lets you change it — set 3 days and they spread evenly across three, set 0 and they all fall on one day.
• New Clients tested across several days are handled properly. If a client's assets came from more than one visit, you're asked whether to move just that visit or all of them together — moving them together shifts each by the same amount, so the gaps between visits stay as they were.
• New Swiping between months on a phone now follows your finger, with the next month sliding in as the current one moves off, instead of jumping straight to it.

• Change Clicking a client in the calendar now opens a short menu instead of a wall of asset rows — view the client, list the assets if you actually want them, or move when they're next due.
• New Delay a visit by any number of days, weeks or months. The delay counts from the current due date, not from today, so putting something back a month means exactly that.
• New Reschedule to a specific date when you already know when you're going. Either way the whole visit moves together, and it can be undone at any time to go back to the original date.
• Fix The ✕ no longer sits on top of the Close button in Retests Due — the redundant Close button has been removed.

Rescheduling never alters your test data. Due dates are still worked out from the last test and the retest interval; a moved visit is recorded separately and can be undone.

• Fix Saved notes were silently failing to attach. Matching required the asset number to be written identically, so "0135" and "135", or a stray space off the tester, meant nothing attached and nothing told you. Matching now ignores case, spacing and leading zeros, and also considers tests that came in as duplicates rather than only brand-new ones.
• New Notes are no longer attached automatically. After an import, any saved notes matching what you brought in are listed for review — tick the ones you want, edit the text before it's applied, and rotate photos that came in sideways. Anything you don't attach stays saved for next time.
• Change Menus open as a drawer from the bottom on phones. As dropdowns they were running off the edge of the screen, shunting the button sideways and dimming the page.
• Change The client switcher on phones now sits under the client name instead of floating over your data.
• Change "Custom" has been removed from the Quick range list — editing either date puts you into a custom range anyway, so it never needed to be something you picked.

• New Sort the client list by name A–Z or Z–A, most or fewest assets, most recently tested, longest since tested, or most failures. Clients with no tests yet always sort last on the date options, since there's no date to rank them by.
• New A camera button sits beside the search box for scanning an asset barcode, rather than being buried in the filters.
• Change Asset View / Inventory View has moved down next to the table, where the data it affects actually is, instead of sitting among the filters.
• Change Available Numbers now lives only in Technician's Tools and works without a client open — it has its own client picker, defaulting to whichever client you're viewing.
• Change Drag-and-drop file areas are hidden on phones, where dragging a file isn't possible. Import from the Data menu instead.

• New A client list now sits down the left once you're working in a client, showing every client with their record count and the current one highlighted. Switching is one click instead of a trip back to the client grid.
• New Collapse it to a narrow strip of initials when you want the room for your data — the app remembers which way you left it.
• New On phones it works differently. A sidebar would swallow a phone screen, so instead there's a bar along the bottom showing the client you're in; tap it and the list slides up as a sheet within thumb reach, with a search box for accounts with a lot of clients.
• New Search the client list directly from the sidebar or sheet, and jump back to the full client grid from the bottom of either.

• Fix The export wizard now offers every client on your account, whatever you currently have filtered or selected. Exporting two clients at once no longer means clearing your filters first.
• New 🔧 Technician's Tools menu, gathering Note for Next Import, Available Numbers and Scan Asset in one place instead of spread across the interface.
• New ℹ️ About menu with What's New, the Privacy Policy and the version number.
• Change Quick range: "Custom" and "All time" are now separate options — they were one entry doing two different things. All time explicitly clears the dates. Today and Last calendar year have been added.
• Change The retest interval and the calendar tickbox are now grouped together under a Retest calendar heading in Edit Client, rather than sitting loose among the address fields.
• Change Removed the record count line beneath the PATKeeper name.

• New 📅 Retests Due, under the Data menu. Every asset you hold is placed on a calendar according to when it next needs retesting, worked out from its most recent test.
• New Three ways to look at it. Year shows all twelve months at a glance with a count against each, and flags months containing overdue work. Month is a full calendar grid — click any day to see exactly what's due on it. Agenda is a running list, month by month, with anything overdue pulled to the top.
• New A retest interval on each client. Clients differ — one site may be on twelve months where another is on three — so you can now set an interval per client in New Client and Edit Client. It overrides whatever interval is recorded against the individual assets, and each entry in the calendar shows which of the two it used.
• New Overdue, due-within-30-days and scheduled are colour-coded throughout, and every list shows how long until an asset falls due — or how long it's been overdue.
• New Filter the whole calendar to a single client, and see a count of any assets that have no retest interval set at all, so they don't quietly go missing.

• New Export wizard. CSV and .DB exports now open a wizard instead of a fixed summary. Keep everything in your current filters or selection, or tick individual clients and locations — with a record count beside each — to narrow the export without touching your filters.
• New Only the latest test for each asset. One tick exports the current state of the register rather than the full test history. The running total, asset count, date range and filename all update live as you change the scope.
• Fix Modals now scroll correctly on phones. Long popups — Asset Details in particular — were sized against the full screen height rather than the visible area, so the bottom of the panel (including the Technician's Helper) sat underneath the browser's address bar with no way to reach it. Every modal now measures against the visible viewport and scrolls properly.
• Fix The .DB export's warning about which test groups carry verified limit data now recalculates as you change the export scope, instead of describing the records you started with.

• Fix Welcome credits are now granted on sign-up. New accounts are meant to get 100,000 credits for their first month, to bring existing test data across without it counting against a monthly allowance. That allocation was configured but never actually issued, so new accounts started with nothing. It now arrives automatically with the account.
• Fix Welcome credits are now spendable. They were being issued into a separate pool that imports couldn't draw from — so the balance showed, but nothing could use it. They're ordinary credits now, and are always spent first, before your monthly or topped-up credits.
• Fix Several security improvements to how account and credit data is protected.

Credits are still tracked only — imports record what they would have cost, but nothing is charged or blocked.

• New Settings → "💳 Billing & Credits" — current plan status, renewal/cancellation date, Test Credit balance broken down by monthly vs. purchased, next expiry, Welcome Import Credits remaining, credit packs with effective price-per-credit, and recent activity.
• New Subscribe to Pro, buy a credit pack, or open Stripe's Customer Portal — all three wired to the real Edge Functions built earlier, verified against a real balance query showing the actual 500 credits already on this account.

• New Every import now quietly records how many credits it would have used, while the credit system is being built out. Nothing about the import itself changes — it always proceeds regardless of the result, and any failure in the tracking call is only ever logged, never shown or allowed to interrupt a real import.

Not enforced yet, by design — this is purely observational until the billing system is ready to go live.

• New Asset Details now has a "🔧 Technician's Helper" section — a note and/or photo attached permanently to that specific asset, shown every time it comes up. Unlike a Note for Next Import, this never gets consumed — it's a standing tip, not a one-off.
• New A small 🔧 icon now shows next to the Asset ID in the main table whenever a helper exists, with the note as a hover tooltip — visible at a glance without opening the asset.
• New Renaming an asset's ID correctly carries its helper along with it, rather than leaving it stranded under the old ID.

• New "🔦 Note for Next Import" (next to Scan Asset) lets you jot a note or attach a photo against an asset ID — e.g. "fuse replaced" — while it's still on your mind, even though no test has been imported for it yet. It doesn't create a test record on its own; it just waits.
• New The next time a test for that same asset gets imported (any client/location, CSV or .db), the waiting note and/or photo is automatically merged into it — filling in Notes and the photo only if the imported test doesn't already have them, never overwriting real device data.
• New If the same asset gets multiple new tests in one import, each waiting note is matched to a different one rather than the same note being applied twice.

• New Report & Certificate Settings now has fields for a Stable site URL and a Beta site URL. Once both are set, the Settings footer shows which channel you're currently on (Stable/Beta badge) and a "Switch to..." link to the other one.
• New A single line near the top of the file (APP_CHANNEL) marks which channel a given copy of this file is — flip it to 'beta' before deploying a build to a separate beta URL.

This is the in-app half of the feature — it doesn't host anything or decide what's "stable" on its own. You'd still deploy two actual copies of this file to two URLs yourself, and choose when to promote a beta build to the stable one; this just gives the app a way to know which is which and link between them.

• New The public client portal now shows the same translated descriptions as the main app, wherever they're used — the shared-data function was extended to also send your Abbreviations dictionary, since the portal is a separate, unauthenticated view that couldn't otherwise see it. Search there now matches translated text too, not just the raw original.

• Fix Typing an abbreviation that already has a translation was auto-filling Full text and correctly enabling Save — but landing on already-saved data isn't itself a change worth saving. Save now stays disabled in that case, and only enables once something's genuinely edited from there.
• New Changing or clearing the Abbreviation field now clears Full text too, rather than leaving a stale translation from whatever was previously typed sitting there.
• New Full text now has its own live suggestions too, drawn from your existing translations — helps catch cases where the same underlying item might otherwise get worded slightly differently across a few abbreviations.

• New Type or select a raw description that already has a translation, and the Full text field auto-fills with it — the button relabels to "Save" and a note explains this will update the existing entry rather than create a duplicate. Clear the field or type something new and it reverts to "Add" automatically.
• New Added a → between the two fields, making the "translates from this, into this" relationship clearer at a glance.

• Fix Opening Abbreviations from Settings did nothing at all — a classic mistake where the button handler was wired directly to the modal function, so the click event itself got passed in as if it were a description to look up, crashing silently before anything could show. Fixed by explicitly discarding the event instead of passing it through.
• Changed The 🔤 Abbreviation button in Asset Details now opens a small, focused popup — just that asset's description and a single field for its translation — rather than the full management modal. Saving returns straight back to Asset Details instead of leaving you in the abbreviations list.

• Fix The Add/Edit form's two text fields could visually overlap in narrower views — caused by a site-wide minimum input width fighting against the form's layout. Both fields now shrink properly to fit.
• New Report & Certificate Settings has a new option: "Show the originally recorded description alongside a translated one" — off by default, since most reports won't need it. Certificates always show the translated version; ticking this also notes the original raw text next to it.
• New Asset Details has a "🔤 Abbreviation" button right next to the Description field — jumps straight to editing that description's translation if one already exists, or pre-fills a new one ready to fill in if it doesn't.

• Fix The Edit form's buttons weren't sized consistently and could push the modal into horizontal scrolling — "Save" now stays a single line at the same height as everything else, and the row wraps properly instead of overflowing.
• Fix Inventory View now groups assets by their translated description, not the original raw text — so "13IEC", "13 IEC", and "13a iec" (all translating to the same thing) now correctly merge into one group instead of three separate ones.
• Fix Search was only checking the raw stored description, not the translated version — so searching "15A" wouldn't find "153M" once it translates to "3M 15A Cable". Now checks both, so a search matches whichever form — raw or translated — you actually typed.

• New Abbreviations dictionary — Settings → 🔤 Abbreviations lets you define translations like "134W" → "13A 4Way Extension Lead", applied across every client. Lists show the translated version; the raw text is never changed, still shown when you open the asset directly, and is exactly what gets exported. Includes a suggestions list showing your most common untranslated descriptions, ranked by how often they appear, so you don't have to think of them all from memory.
• Changed The Reports dropdown moved from the very top of the page down to sit between the stats cards and the import drop zone — closer to the data it actually acts on, rather than a reach to the top of the screen every time.
• Changed Notes and repair codes from the tester (often ALL CAPS on the device) now display in normal sentence case everywhere they're shown — tables, certificates, summary reports. Only applied for display; the raw text is untouched underneath and unaffected on export.

• Fix The device records exactly which visual inspection item failed (Case, Plug, Lead, Switch, Socket, Environment, Suitability, or Other) as a bitmask in a field this app was never reading — confirmed by checking real failed visual tests in genuine device files, where it carries real, non-zero data. Every failed visual inspection was showing all 8 items as "Checked" with no way to tell which one was actually the problem. Now decoded on import and correctly shown per-item on the certificate, and encoded back out correctly on export too.

⚠️ The order the 8 items map to their bits was inferred from the order already used on the certificate table, not confirmed against official documentation — round-trips correctly either way, but worth checking one test you remember the specifics of to confirm the right item is actually being named.

• New Settings → "🗑️ Delete All Data (Clean Slate)" permanently removes every client and test record — including logos, share links, saved documents, attached photos, and group specification data. Three separate confirmations: real counts shown up front, typing "DELETE ALL" to proceed, and one final explicit check before anything happens.
• New Cleans up thoroughly, not just the visible data — storage files (saved PDFs, test photos) are removed too, not left behind as orphaned files nobody can see or reclaim.

Deliberately scoped to client and test data only — company details and report/certificate settings are your own app configuration, not "client data," and are left untouched.

• Fix Stopped interpreting time for identity entirely. Every record — however it enters the app (.db import, CSV import, manual entry, a correction made in Edit Record) — now gets a raw timestamp assigned exactly once, from whatever the source actually said, and never recomputed or reinterpreted afterward. Export always writes that same stored value back out, never a freshly-derived one. Identity compares that hard-recorded value directly.
• Fix Existing records that predate this (which is most of an older account) get one assigned automatically on next load, locked in from whatever they currently show — a one-time, permanent assignment, not an ongoing correction.

One boundary worth knowing plainly: a record whose stored time was already wrong before this fix existed keeps that wrong value locked in — there's no way to recover the true original after the fact. That specific record could still show as a duplicate if compared against a genuinely fresh pull of the exact same old test straight from the device. Re-importing PATKeeper's own data, or anything going forward, doesn't have this problem.

• Fix The actual, decisive problem, found by checking a real re-import: a meaningful share of this account's already-stored data has a time value baked in from before the BST conversion bug was fixed, and there's no reliable way to tell, after the fact, which stored records were affected and which were always correct. That means exact-time matching could never be trustworthy against this account's existing data, no matter how identity was computed on the way in — which is why the raw-timestamp approach, and the export-marker refinement of it, kept breaking on real files. Removed entirely. Identity is now asset + serial + date + client, with no time component at all — the BST bug only ever shifted the hour, never the day, for the overwhelming majority of tests, so date alone is far more robust against data that predates the fix.

Known, accepted trade-off: two genuine tests of the same asset on the same day (e.g. a fail, fix, and retest) will now be treated as one. Given the choice between that narrow edge case and the mass duplication this was actually causing, this is the right side to land on.

• New Every .db export is now marked as having come from PATKeeper. On import, a file carrying that mark is treated cautiously (date+time identity, as in v1.12.2) since some of its timestamps may not be genuine device originals — but a file with no such mark has definitely never passed through PATKeeper's export, so its timestamps are trusted as real device values again, immune to any future change in how time gets displayed.

⚠️ This only helps files exported from now on — a file already downloaded before this update has no way to carry the new mark, so it'll still be treated as fully genuine and could reproduce the same issue if re-imported. If you want to verify this fix, export a fresh copy first and test with that, rather than re-using an older exported file.

• Fix v1.11.3's "raw device timestamp" identity broke on real data: most accounts have older records with no genuine device-original timestamp, and PATKeeper's own export has to compute *something* to put in that field regardless. Re-importing that export then treated PATKeeper's own recomputed value as an untouchable original, permanently mismatching it against what's already stored — exactly what caused thousands of false "new" records on a real re-import. Identity is now based on date and time again (read consistently by the same fixed, stable logic every time) rather than a timestamp that isn't always genuinely original. Confirmed directly against a real account export before shipping this, rather than reasoning about it in the abstract.

• New Importing now offers an optional cutoff date before showing the full preview — set it and everything dated before that cutoff is excluded outright, rather than just being flagged as a duplicate. Useful when re-importing a file that's a mix of data already in your account and newer tests added since (e.g. a .db that started life as an export from this app, then had more tests added on the tester itself).

• Fix The record-ID migration added in v1.11.3 ran before the client list was shown, with no error handling and no progress feedback — on an account with a lot of records, the full re-sync it triggers could take real time, and if anything went wrong there was nothing to show for it except a loading spinner that never went away. It now runs after the app is already usable, wrapped so a failure can never block anything else, with a toast instead of nothing while it works.

Sorry — this was a genuine mistake, putting a heavy, unprotected background task directly in the startup path. Please reload; the app should show your client list immediately now, with the cleanup happening quietly afterward.

• Fix v1.11.1's timezone fix changed how test time gets displayed from a .db file — correctly, but it also meant a test already imported before that fix would compute a slightly different identity than the same test re-imported after it, since identity was built from the displayed (interpreted) time rather than the raw source value. A test's identity is now based on asset, serial number, the device's raw untouched timestamp, and client — not the human-readable time derived from it — so identity stays stable regardless of how display logic is interpreted, while two genuinely different tests on the same day (e.g. a fail, fix, and retest) still correctly count as two separate tests, not one.
• Fix Automatically cleans up any duplicates the earlier bug created — on first load after this update, existing records are checked against the corrected identity rule, and anything that collapses onto the same test gets deduplicated and re-synced, with a confirmation of how many were removed.

Sorry for the trouble here — v1.11.1 fixed a real display bug but introduced a worse one in the process. This should self-resolve automatically without needing to manually delete anything via Import History. Records with no raw device timestamp (CSV import, manual entry) fall back to their entered date/time as before, since those were never affected by this issue in the first place.

• Fix The tester's own DateTime values appear to store wall-clock time directly rather than a true UTC timestamp. Reading them back using the browser's local time (which reapplies the UK's BST offset on top of a value that shouldn't need it) added a spurious extra hour whenever BST was in effect. Both directions — reading a device's .db file, and writing one back out — now read/write those values at face value, with no seasonal shift.

Verified the fix direction against a real DateTime value from T280726.DB — confirmed which reading matched what you reported as correct.

• New Report & Certificate Settings, Company Details, Edit Record, Edit Client, and Asset Details all now disable their Save button until you've genuinely changed something — greyed out and unclickable on open, enabling the moment you edit a field, upload a logo/photo, or pick a different location.
• Fix Picking a location from Asset Details' dropdown wasn't registering as a change at all (it set the field directly without firing a normal input event) — fixed as part of this, so it's now correctly detected everywhere that matters, not just for the Save button.

• New If an asset's description changes at any point across its test history, that's now flagged clearly wherever the history matters most: a ⚠️ badge next to the description in the main table, a full warning with every change listed in Asset Details, and a heads-up in the import preview before anything's even brought in.
• New The reasoning is explicit rather than silent: a description change can be an ordinary correction, but it's also exactly what you'd see if a numbered sticker got moved onto a different physical item — so it's surfaced for a human decision, not auto-resolved either way.

• New "🔢 Available Numbers" on a client's page shows exactly which plain-numbered asset ID ranges are already in use, and which ranges are free — e.g. "4000 – 4180 (181 numbers)" available, alongside what's occupied, so picking a number for new equipment doesn't risk clashing with an existing tag.

Only considers asset IDs that are plain numbers (e.g. "4021") — IDs with letters (e.g. "BB200189") follow their own separate scheme and aren't part of this.

• New Importing a .db file exported by a genuine PAT tester now also captures its real IndividualTestSpecification data (the exact limit, duration, subtype, and repetition per test type for each group) — previously only the pass/fail limit value was kept, and the rest silently discarded.
• Fix Exporting now writes those real captured values back for any group they exist for, instead of leaving the table empty. A group with no captured data (never imported from a genuine source file) still gets nothing written — no reconstruction, no guessing, only real data that's actually been seen.

Verified directly against a real PAT420 export before shipping this — the capture query was run against an actual device file and its output checked against the file's real contents.

• Fix The table that tells a PAT tester what limit to apply per test type for a given group (IndividualTestSpecification) was being created in every exported file but never had a single row written into it — so the tester had nothing to read and silently fell back to its own built-in defaults. Now populated from the limits already present on the imported test data, scanning every row of a group (not just whichever one happens to create it) so a limit that's missing on one test but present on another within the same group is still picked up.
• Fix The Load (VA) test's limit was hardcoded to 0 on every individual result too, despite the field being tracked elsewhere — now correctly uses the actual recorded VA passband.

• Changed PDF report import has been removed entirely — asset ID/description wrapping, page-footer noise, and inconsistent column layouts across different reports made it more fragile than it's worth. CSV and .DB import are unaffected. Import History stays, and continues tracking every CSV/.DB import as an undoable batch.
• Fix .DB export: an asset's test group was being treated as part of what makes it a distinct asset, rather than a property recorded on it. If the same physical asset's class/group was ever recorded even slightly differently across different tests (common when data's been imported from more than one source over time), it was silently split into multiple duplicate assets in the exported file, each with fragmented test history.
• Fix Same underlying issue for test groups themselves — a group was being identified by four fields at once, three of which are only ever populated for records that came from a genuine source database. Anything entered by hand or imported from CSV has those blank, which was splitting the same conceptual group (e.g. "Class 1 Earthed") into several duplicate TestGroup rows. Now identified by description alone, which is always populated.

• New PDF import now reads Visual, Polarity, Earth Continuity, Insulation, Load, and Leakage for each test, not just the overall pass/fail — so imported certificates carry the same detail as ones entered directly in the app.
• Changed Reads each column adaptively rather than with one rigid pattern, since this report's own format wasn't fully consistent between rows (a result letter followed by a number in most cases, but a bare number with no letter in others) — handled per-column instead of assuming one fixed shape for the whole row.

⚠️ This part is newer and less proven than the rest of PDF import — worth deliberately checking a few imported assets' readings against the original PDF before trusting them for certificates going out to clients.

• Fix The last known open issue: rows whose asset ID wraps onto its own line (e.g. "4A02", "KC1Q") were importing with a slightly wrong ID, since the wrapped part was being discarded. It's now held onto and rejoined with the row that follows, so the full original ID (e.g. "LOC009ASB4D4A02") is reconstructed correctly instead of losing a piece of it.

No specific known bugs currently outstanding for PDF import — still worth treating as experimental for report layouts not yet seen, per the general note on v1.5.0.

• New Drop a PDF PAT report in alongside CSV/.DB files and PATKeeper will read asset ID, description, location, date, and pass/fail straight out of the document text.
• New Since a PDF can't reliably tell us which client it belongs to, you're asked to confirm the client name for each PDF straight after it's read — before anything is shown in the import preview.
• Changed Deliberately does not attempt to import individual electrical readings (earth continuity, insulation, etc.) from PDFs — the column layout for those varies even within a single report, so guessing at them risked silently importing wrong readings. Asset identity and pass/fail history import reliably; detailed readings don't, from PDF sources only.

⚠️ This is a first version built from one example report and hasn't been tested against real-world PDF variations yet — worth trying carefully and reporting back anything that parses incorrectly.

• New Company Details and Edit Client both now accept two logo uploads — one for light backgrounds, one for dark. Only have one? Upload it once and it's used everywhere, same as before.
• New The correct variant is chosen automatically: dark-background logos on certificate headers (which are always a dark band), light-background logos on cover pages and summary reports (always white), and in the app itself it follows whichever theme — light or dark — you're currently using, switching instantly if you toggle it.
• Fix Renaming a client used to only carry their legacy logo across, silently losing anything else on their profile — fixed to carry everything.

• New Attach a photo to any test record (Edit Record → Photo) — stored securely per account, separate from your synced data so ordinary edits stay fast.
• New A new "Certificates — with Photos" report alongside the standard one, which embeds each asset's photo. The standard Certificates and Summary Report stay lean and photo-free, so routine paperwork never balloons in size.
• New "Room" is now shown in the main data list (both views) and in the Summary Report and Failed Assets tables — previously only captured, never displayed.
• New Client tiles on the select-client page now show that client's logo, or their initials (e.g. "TFT" for Tobacco Factory Theatre) if they don't have one.
• Changed The Asset View / Inventory View switch now shows both labels at once, with the active one highlighted — no more guessing what you're switching to.
• Changed Replaced the redundant "Clients" stat (always 1, since only one client is ever shown) with a genuinely useful count of unique assets.
• Changed Filters now collapse into a drawer on mobile, behind a "🔍 Filters" toggle, instead of always taking up screen space.

• New The client portal's asset detail popup now explains why a test failed in plain English, the same as certificates already do — not just a red "Fail" badge with no context.
• Changed Asset View / Inventory View is now a proper toggle switch, matching the light/dark mode control, instead of a button that changed its own label.
• New "Last test batch" — a smart quick-range option that looks at a client's actual test dates and automatically finds their most recent round of testing, rather than you having to guess or work it out by hand.

• Fix Fixed a bug where the app would occasionally jump back to the client-selection screen unprompted — caused by background session-refresh events being treated as a fresh sign-in and forcing a reset.
• Fix Saving no longer re-uploads your entire dataset on every single change. Editing one client, moving a test, or uploading a logo now only syncs the records actually affected — previously any save re-synced everything, which is what was causing long pauses on accounts with a lot of data.
• Fix Uploading a new client logo no longer touches that client's test records at all — it's a separate, much smaller update now.
• Changed The four things loaded on startup (records, company details, report settings, client logos) now load in parallel instead of one after another, and there's a proper loading indicator on first load instead of an empty-looking page.
• Changed Certificates and reports now refer to the formal standard name — In-Service Inspection & Testing of Electrical Equipment (PAT) — and the retest field is labelled as a risk-assessed interval rather than a fixed "frequency", in line with the 5th Edition IET Code of Practice.
• New Version numbers and this changelog.