James Allman | JA Technology Solutions LLC
Development Tools
Tools for everyday development, debugging, and data wrangling. Convert between formats (JSON, XML, YAML, CSV, fixed-width, delimiters), decode JWTs, test regex, format SQL, generate hashes and UUIDs, build cron expressions, and more.
Check Digit Validator
Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.
Data & FinanceEBCDIC to ASCII Converter
Convert between EBCDIC and ASCII for IBM i, AS400, and mainframe systems. Fixed-length records, line ending options, CP037 reference.
DevelopmentPacked Decimal / COMP-3 Converter
Decode and encode packed decimal (COMP-3), zoned decimal, and trailing overpunch for IBM i and mainframe systems.
DevelopmentDDS Screen Explorer
Paste IBM i DDS display file source and see the screen rendered with authentic 5250 green-screen and modern preview.
DevelopmentDDS to SQL / SQL to DDS Converter
Convert between IBM i DDS physical file definitions and SQL CREATE TABLE statements in both directions.
DevelopmentBMS Screen Explorer
Paste mainframe BMS (CICS/3270) screen definitions and see the screen rendered with green-screen and modern preview.
DevelopmentCOBOL Copybook Explorer
Explore COBOL copybook structures with interactive tree view, field layout, SQL conversion, JSON Schema generation, sample data decoding, and visual hex ruler.
DevelopmentData Diff & Compare
Compare two datasets with key-field joining. Supports CSV, TSV, JSON, XML, YAML, and Excel with automatic dot-notation flattening for nested structures.
DevelopmentFile Compare & Merge
Compare two text or code files with line-level diff and intra-line word/character highlighting. Side-by-side, unified, and inline views. JSON structural mode. Unified-patch export and apply.
DevelopmentData Profiler
Profile CSV data with column-level statistics, value distribution charts, quality matrix, and drill-down column detail.
DevelopmentParquet File Explorer
View and explore Apache Parquet files entirely in your browser. See schema and metadata, browse data with filtering, export to CSV/JSON/Excel, or convert files to Parquet.
Data & FinanceJSON ↔ CSV
Convert between JSON and CSV formats. Paste, upload, or load sample data. Download or copy the result.
DevelopmentXML ↔ JSON Converter
Convert between XML and JSON formats. Handles attributes, CDATA, arrays, and nested elements.
DevelopmentYAML ↔ JSON Converter
Convert between YAML and JSON formats. Handles multiline strings, anchors, and flow syntax.
DevelopmentXML Formatter
Format, pretty-print, minify, and validate XML with syntax highlighting and well-formedness checking.
DevelopmentSQL Formatter
Pretty-print SQL queries with proper indentation and keyword uppercasing. Supports common SQL dialects.
DevelopmentRegex Tester & Builder
Test regex patterns with real-time match highlighting. Built-in pattern builder and syntax reference.
DevelopmentJWT Explorer
Decode, inspect, and build JWTs. View claims, check expiration, and create HMAC-signed tokens.
DevelopmentCron Expression Builder
Build and decode cron expressions visually. 12 presets, 5-field editor, and human-readable descriptions.
DevelopmentBase64 Encode/Decode
Encode text to Base64 or decode Base64 to text. Supports UTF-8.
DevelopmentHash Generator
Generate SHA-256, SHA-384, SHA-512, and SHA-1 hashes from text using Web Crypto.
DevelopmentTimestamp Converter
Convert Unix epoch timestamps to human-readable dates and back. Timezone support.
DevelopmentUUID Generator
Generate v4 UUIDs. Single or bulk generation up to 100. Copy individual or all.
DevelopmentURL Encode/Decode
Percent-encode or decode URLs and query parameters. Component and full-URL modes.
DevelopmentColor Converter
Convert between Hex, RGB, and HSL color formats. Live preview swatch and ready-to-use CSS output.
DevelopmentJSON Converter
Convert JSON arrays of objects to CSV, Excel, XML, YAML, and 7 other formats.
DevelopmentXML Converter
Extract repeating-element data from XML and convert to CSV, Excel, JSON, and 8 other formats.
DevelopmentYAML Converter
Convert YAML (array of objects, or a top-level mapping containing one) to CSV, Excel, JSON, and 8 other formats.
DevelopmentHTML Table Converter
Extract HTML <table> data and convert it to CSV, Excel, JSON, and 8 other formats.
DevelopmentSQL INSERT Converter
Extract rows from SQL INSERT statements and convert them to CSV, Excel, JSON, and 8 other formats.
DevelopmentMarkdown Table Converter
Convert GitHub Flavored Markdown tables to CSV, Excel, JSON, and 8 other formats.
DevelopmentMarkdown Preview
Live side-by-side markdown editor and rendered preview. Supports headers, lists, code, links, and more.
DevelopmentCard Number Validator
Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.
Data & FinanceConnection String Builder
Build JDBC, ADO.NET, and ODBC connection strings with a browsable property reference for 8 database platforms and 18 drivers.
DevelopmentCSV to SQL Generator
Convert CSV data to SQL CREATE TABLE and INSERT statements with automatic type detection and dialect-specific output.
DevelopmentWSDL/SOAP Explorer
Parse WSDL 1.1 files and explore SOAP services, operations, bindings, messages, and inline XSD types.
DevelopmentXSD/XML Schema Explorer
Parse XML Schema (XSD) files and explore element hierarchies, complex and simple types, restrictions, and generate sample XML.
DevelopmentJSON Schema Validator
Validate JSON documents against JSON Schema definitions with detailed error reporting and skeleton generation.
DevelopmentAll tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.
Other Tool Categories
Data & Finance
Banking, accounting, healthcare, payments, and EDI file formats.
Retail & POS
Barcodes, POS files, retail math, and fiscal calendars.
Grocery & Fresh Departments
Meat, produce, deli, bakery, seafood, and floral department math and operations.
Shipping & Logistics
Freight estimation, container loading, route optimization, and trade compliance.
Inventory & Warehouse
Reorder planning, cycle counting, warehouse slotting, and cost allocation.
Networking
Subnet math, MAC vendor lookup, email authentication, and WHOIS.
IBM i & Mainframe
EBCDIC, packed decimal, COBOL copybook, DDS, BMS, and fixed-width.