Find the outcome you need.
Start with a symptom, a platform or the thing you want working.
With JavaScript, search filters the whole collection in your browser. Without it, use the linked pages and section navigation below; query filters need JavaScript.
Showing entries 81–100 of 100 in this first collection.
Troubleshooting guide
Before you import a spreadsheet into another system: the checks that stop a failed load
Loads fail on blanks, types, dates, codes and keys. A column-by-column readiness sheet, the right CSV handling and a test on a copy catch most problems before they reach a live system.
Troubleshooting guide
Can this PDF be read as data? Check for a text layer before you plan an extraction
A PDF can hold selectable text or only a picture of each page. A two-minute test tells you which, and that decides the method, the checks and what anyone can honestly promise.
Troubleshooting guide
How to check a PDF extraction is right: count, compare, and list what could not be read
Extraction mistakes are silent. Counting rows page by page, comparing a pre-chosen sample and keeping an exceptions list shows where a spreadsheet differs from its document.
Troubleshooting guide
Filled-in PDF forms: where the answers live and when they are really gone
Answers typed into a fillable PDF are stored as named fields inside each file. Learn how to tell whether a returned form still has them, and how to decide what checkboxes and blanks become in a spreadsheet.
Troubleshooting guide
A scanned PDF cannot be searched: what text recognition can fix and how to test it
Scanning produces pictures of pages. Text recognition can add a hidden text layer, but quality depends on the scan. Test it with words you know are on known pages rather than trusting a percentage.
Platform
Xero integrations: identity, limits, accounts and currency decide whether a sync can be trusted
What Xero documents for integration builders (contacts, invoice numbers, idempotency, paging, limits, accounts, lock dates, demo company) and which failures map to which guide or outcome.
Free tool
CSV header diff: find missing, added, renamed and duplicate columns between two files
Paste two CSV header rows, or read the header of two small files in your browser, and see missing, added and likely renamed columns, duplicate and empty headers and the delimiter. Nothing is uploaded.
Free tool
Invoice rounding bench: compare per-line and total rounding, half-up and half-even
Enter invoice lines and see net, tax and gross under four rounding rules side by side, in exact whole-number minor units, with the difference between summing lines and rounding the total. Not tax or accounting advice.
Free tool
Pack and case unit-price calculator: compare supplier prices per single unit
Enter supplier price lines priced per unit, pack or case. Get the exact price per single unit, the working, and the lines whose pack basis is unclear. No floating point.
Inspectable example
Synthetic webhook test vector: why a re-formatted body makes a genuine event fail verification
Five versions of one made-up event, each shown in full with its real SHA-256 digest, show that re-formatting the body changes the hash and that a one-character change is rejected.
Troubleshooting guide
The same webhook arrives twice and runs twice? Acknowledge fast and make a repeat do nothing
Providers redeliver events that time out or fail. An endpoint that does the work before answering, with no memory of what it has seen, will run the action twice.
Inspectable example
Synthetic test vectors for a Slack events endpoint: signature, five-minute window and repeated events
Five invented requests with their computed signatures show which a verifier should accept and which it should reject, and why an event ID must be claimed before the work is queued so a repeat or a simultaneous duplicate does not run it twice.
Troubleshooting guide
Slack events hit your endpoint twice, or not at all: signature, timestamp and the three-second rule
How Slack signs events, why the raw body and a five-minute window matter, and how to reply in time without running the work twice.
Troubleshooting guide
Website form to Pipedrive: store first, match by email, create a linked lead, respect the limits
The order of calls, the API versions, the matching rule, the rate limits and the outage design for pushing a form enquiry into Pipedrive without losing it, and the lookup that keeps a lost reply from creating a second lead.
Inspectable example
Synthetic invoice reconciliation: identical net lines, two different tax totals
Three invented small-value lines show how line-level and invoice-level tax rounding can disagree even when net values and line counts match.
Inspectable example
Synthetic invoice retry matrix: source operation, attempt and target draft are different IDs
Concrete made-up references specify when a retry retains one target draft and when changed contents, a second organisation or multiple matches need a separate decision.
Collection
Invoice integration review: verify shape, representation, tax basis and repeat safety
An ordered review worksheet helps a finance owner stop at the first broken contract before requesting a bounded existing mapping repair.
Troubleshooting guide
Invoice values look right in Sheets but arrive as currency text or a date number
Separate a spreadsheet's displayed currency and date from the values a connector reads, then agree the destination types before repairing a mapping.
Troubleshooting guide
An invoice integration adds tax twice: agree whether each amount is net or gross
Name the tax basis of each mapped line and the approved tax treatment before mistaking a populated amount field for a correct invoice.
Troubleshooting guide
Invoice creation timed out: reconcile the unknown result before retrying
Distinguish a confirmed rejected creation from a lost response after a possible write, and define zero, one and conflicting-match dispositions before a replay.