XMLGuide
Fixing XML Parse Errors Fast With a Triage Routine
A tested routine for XML that will not parse: check the bytes, then the encoding, then the characters, then the structure, with an error message dictionary.
19 min read
Tag
how-to
590 posts
ExcelGuide
Getting Excel Data Into a Database Without Heartbreak
A complete method for loading Excel into PostgreSQL, MySQL, SQLite or SQL Server: read as text, stage, check counts, convert types and reload safely.
18 min read