James Allman | JA Technology Solutions LLC

Site Index

A visual index of every page, tool, article, and demo — click any card to jump straight to the page.

Every page, tool, article, and demo on this site is shown below with its auto-generated share card. Click any card to jump to the page. Use the Share button to grab a link to drop into a post or message.

Home

Practical support, migration, integration, and custom development for the systems your business depends on

With over 35 years of software development experience, I help organizations of all sizes support, migrate, modernize, integrate, and extend the systems their operations depend on — without unnecessary disruption.

Page

Services for business-critical systems

I provide practical technical services for organizations that rely on long-lived systems, customized workflows, and integration between operational platforms. The focus is on keeping those environments useful, maintainable, and adaptable without unnecessary disruption.

Page

Custom reporting for operational and business-critical systems

Reporting drives operations, visibility, accountability, and decision-making. I provide custom reporting services for organizations that need better outputs, reporting automation, and practical reporting improvements across long-lived business systems.

Page

Legacy system migration that protects what works

Migration is rarely just a technical conversion. Long-lived systems contain years of business rules, reporting logic, integration behavior, and custom workflows. I help organizations move to better platforms while preserving the behavior their operations depend on.

Page

Modernization that builds on what you have

Modernization does not mean starting over. It means making existing systems more maintainable, more capable, and better connected — without the risk of a wholesale replacement.

Page

System integration that connects your business

Most business environments rely on multiple systems exchanging data across operations, finance, warehousing, retail, and reporting. I help organizations connect those systems reliably — through practical, supportable data flow.

Page

Custom applications for the workflows that matter most

Some business problems cannot be solved by packaged software. When your organization needs an application tailored to how it actually operates, I design and build it — across IBM i, Java, .NET, web, and mobile platforms.

Page

ETL and data pipelines that move your business forward

Every time data moves between systems — whether it is a one-time migration or a process that runs every night — there is an ETL pipeline behind it. I build the ones that work reliably and the ones that replace the ones that do not.

Page

Database development for the systems your business depends on

Databases are the foundation of every enterprise application. I design, develop, migrate, and optimize databases across DB2, SQL Server, PostgreSQL, Informix, Microsoft Access, and other platforms — with a focus on reliability, performance, and long-term maintainability.

Page

EDI that keeps your trading partners connected

Electronic Data Interchange is the backbone of automated business-to-business transactions — purchase orders, invoices, advance ship notices, and more. I develop, support, and troubleshoot EDI systems for organizations where reliable data exchange with trading partners is critical to operations.

Page

IBM i consulting, support, reporting, and modernization

IBM i — the enterprise midrange platform previously known as the AS/400 and iSeries — continues to power critical business operations worldwide. I provide IBM i consulting for organizations that need practical help with support, reporting, integration, troubleshooting, and modernization.

Page

Linux application development and infrastructure architecture

Linux is the foundation of modern enterprise infrastructure. I build applications, design deployment architectures, and integrate Linux-based platforms with existing business systems — including IBM i, Windows, and cloud environments.

Page

Microsoft and Windows platform development

From C# and .NET application development to Excel and VBA automation, Access databases, SQL Server, and banking integrations — I build and maintain the Microsoft-based tools that business operations and finance departments depend on.

Page

Cloud architecture and deployment for modern business systems

Cloud is not a destination — it is an architecture. I design and build cloud deployments that are reliable, cost-effective, and practical for the systems your business depends on, whether that means serverless functions, containerized applications, or hybrid architectures that bridge cloud and on-premises.

Page

Grocery retail merchandising system support, reporting, and modernization

I provide practical help for organizations that depend on grocery merchandising platforms, including Grocers Support Systems (GSS), a platform I actively develop for, and similar retail management software. This includes support, enhancement, reporting, integration, and modernization-related planning.

Page

IBM i and IT consulting for Guam and the Marianas

If you run an AS/400 or IBM i system in Guam and your support options have thinned out — the local people who knew it retired, and mainland vendors quote you a 15-hour time difference before they quote you a rate — that is the gap I fill. I have supported organizations in Guam since 1995 and lived on the island for several years.

Page

GSS — Grocers Support Systems

Grocers Support Systems (GSS) is a grocery retail merchandising platform built on IBM AS/400 (IBM i). The system manages centralized retail pricing and cost control for supermarket chains and communicates with point-of-sale devices across all store locations. GSS serves chains ranging from a handful of stores to over a hundred, with the core platform — the Scan Support and Merchandising System (SSMS) — acting as the central database and host for all merchandising, inventory, and financial operations.

Page

Custom applications for programmable handheld barcode scanners and mobile data terminals

Handheld barcode scanners and mobile data terminals run some of the most operationally critical software in a warehouse or store. I build custom applications for programmable handhelds — Symbol, Motorola, and Zebra Technologies device lineages — with direct integration to the backend systems they feed.

Page

Custom software for Zebra handheld barcode scanners and mobile computers

Zebra Technologies mobile computers are the dominant handheld platform in warehouse, distribution, and retail environments. I build custom applications for Zebra handhelds — and the secure backend services they connect to — with production experience spanning the full Symbol → Motorola → Zebra device lineage.

Page

Industry experience grounded in real operational systems

I work with organizations across industries whose systems support real operational workflows, with particular depth in grocery retail, warehousing, and the finance and accounting operations that support them.

Page

Insights

Technical perspectives on systems, modernization, integration, and the platforms that businesses depend on.

Page

See It In Action

See what modernization looks like — edit real data and watch it come to life.

Page

Free Tools

Practical tools for developers, IT professionals, and business systems teams. Everything runs in your browser — no signup, no uploads, no data leaves your machine.

Page

About James Allman

I am an independent software developer, systems architect, and technical consultant with over 35 years of software development experience. From strategy through delivery, I help organizations of all sizes support, migrate, modernize, integrate, and extend the systems their business depends on.

Page

How I Work

Whether your organization is a large enterprise or a focused operation with critical business systems, here is how I work, what to expect, and answers to the questions prospective clients ask most often.

Page

Engagement Models & Pricing

Engagements are structured around the work, not forced into a single billing model. Four models cover most situations. The right one depends on what you need — a one-off question, a defined deliverable, ongoing capacity, or embedded senior expertise for a major initiative.

Page

Contact

Send a message, schedule a call, or pick up the phone — whichever you prefer. I help with support, migration, modernization, integration, custom development, and reporting for business-critical systems.

Page

Schedule a Call

Book a phone call to discuss your project, ask questions, or explore how I can help. No obligation, no sales pitch — just a straightforward conversation.

Page

How This Site Was Built

This site is a working example of the kind of practical, maintainable, and well-engineered software I build for clients. Here is what it is made of and why.

Page

Privacy Policy

JA Technology Solutions LLC respects your privacy. This policy explains what information is collected through this website and how it is used.

Page

Terms of Use

Plain-language terms for using this website and the free tools it offers. Consulting engagements are covered separately by a written agreement.

Page

Joining the JA Technology Solutions Teams Workspace

Welcome. JA Technology Solutions uses Microsoft Teams as the primary workspace for client collaboration — chat, calls, file sharing, and ongoing project work. This page walks you through joining and getting comfortable with the basics.

Tool Category

Data & Finance Tools

Banking, accounting, healthcare, payments, and EDI file formats.

Tool Category

Retail & POS Tools

Barcodes, POS files, retail math, and fiscal calendars.

Tool Category

Grocery & Fresh Departments Tools

Meat, produce, deli, bakery, seafood, and floral department math and operations.

Tool Category

Shipping & Logistics Tools

Freight estimation, container loading, route optimization, and trade compliance.

Tool Category

Inventory & Warehouse Tools

Reorder planning, cycle counting, warehouse slotting, and cost allocation.

Tool Category

Networking Tools

Subnet math, MAC vendor lookup, email authentication, and WHOIS.

Tool Category

Development Tools

Format converters, encoders, hashes, regex, JWT, SQL, and more.

Tool Category

IBM i & Mainframe Tools

EBCDIC, packed decimal, COBOL copybook, DDS, BMS, and fixed-width.

Tool

QuickBooks Explorer

Explore and create QuickBooks Desktop QB IIF and QuickBooks Online CSV files. Parse, validate, convert, and generate — all in your browser.

Tool

BAI2 File Explorer

Parse BAI2 bank statement files into structured views with type code lookup, transaction details, and CSV export.

Tool

NACHA/ACH File Explorer

Parse ACH payment files into readable records. View entries, totals, and export to CSV or JSON.

Tool

Positive Pay Generator

Generate Positive Pay fraud prevention files from check data. Chase, BofA, Wells Fargo, and generic formats.

Tool

BAI2 File Generator

Generate BAI2 bank statement test files with configurable accounts, transactions, and auto-calculated control totals.

Tool

OFX/QFX Explorer

Parse OFX and QFX bank statement files. View account info, transactions, and balances. Export to CSV.

Tool

SWIFT MT Explorer

Parse SWIFT MT financial messages (MT103, MT940, MT700). Block structure, field lookup, and transaction tables.

Tool

Business Day Calculator

Count business days between dates or add/subtract business days. Includes US holiday awareness and payment term shortcuts.

Tool

Depreciation Calculator

Calculate asset depreciation schedules using straight-line, declining balance, sum-of-years-digits, or MACRS methods.

Tool

Check Digit Validator

Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.

Tool

Barcode Explorer

Generate, scan, and decode barcodes in 15+ formats. Camera scanning, image upload, batch detection, and CSV export.

Tool

Margin & Markup Calculator

Convert between margin %, markup %, cost, and selling price. Includes profit calculation and reference table.

Tool

Retail Fiscal Calendar (4-5-4)

Map any date to its NRF 4-5-4 retail fiscal year, quarter, period, and week number.

Tool

EOQ Calculator

Compute the Economic Order Quantity that minimizes total annual inventory cost.

Tool

Safety Stock Calculator

Calculate safety stock and reorder point from demand and lead-time variability at any service level.

Tool

ABC Analysis Tool

Upload SKUs with annual value and get Pareto-sorted A/B/C tiers with CSV and Excel export.

Tool

Shipment Cost Allocator

Allocate shared freight, duty, and fees across PO lines by weight, volume, value, or equal basis.

Tool

Pallet Pattern Generator

Generate and compare pallet stacking patterns — column, interlock, pinwheel, mixed orientation — with mixed-SKU layer packing and multi-SKU layer stacking.

Tool

Reorder Point Dashboard

Combine EOQ, safety stock, and reorder point across your SKU portfolio with CSV upload and below-ROP alerts.

Tool

Cycle Count Planner

Generate ABC-driven cycle count schedules with configurable frequencies, daily capacity, and working days.

Tool

Warehouse Slotting Simulator

Assign SKU slot positions by pick velocity with hot/warm/cold zones and golden-zone scoring.

Tool

HS/HTS Tariff Code Lookup

Search Harmonized System (HS) and US HTS tariff codes at the 4-digit heading and 6-digit subheading level.

Tool

NMFC Freight Class Estimator

Calculate density in lb/cu ft and get a density-based LTL freight class estimate.

Tool

Pallet & Container Calculator

Calculate cases per pallet and pallets per container with weight and cube utilization checks.

Tool

Route & Stop Optimizer

Optimize delivery stop order with interactive map visualization. Nearest-neighbor + 2-opt heuristic for up to 500 stops.

Tool

Dimensional Weight Calculator

Compare dimensional weight across UPS, FedEx, and USPS with billable weight analysis.

Tool

Freight Rate Estimator

Estimate LTL, parcel, and truckload freight costs with class-based rates, dimensional weight, and accessorials.

Tool

Shipping Box Calculator

Find the optimal box size from standard carrier catalogs based on your item dimensions and weight.

Tool

Bill of Lading Generator

Generate a standard straight bill of lading with shipper, consignee, commodity lines, and print-ready output.

Tool

Container Loading Planner

Pack mixed pallets into containers with first-fit-decreasing bin packing, stacking, and weight checks.

Tool

Pallet Label Generator

Generate 4×6 GS1 pallet labels with SSCC-18 barcodes, ship-to, PO, gross weight, and case count — print single or batch.

Tool

Landed Cost Calculator

Compute per-unit landed cost with freight, duty, insurance, and fees — single SKU or multi-line shipment.

Tool

SIL File Explorer

Parse SIL (Standard Interchange Language) files into structured tables with CSV and JSON export.

Tool

EDI File Parser

Upload or paste any EDI file — parsed into labeled segments with export to CSV, JSON, and SIL.

Tool

EDI 810 Invoice Builder

Enter invoice details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 810 invoice ready to submit to a trading partner.

Tool

EDI 850 Purchase Order Builder

Enter PO details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 850 purchase order ready to send to a supplier.

Tool

EDI 856 Advance Ship Notice Builder

Build a valid X12 EDI 856 advance ship notice — nested HL shipment/order/item loops, carrier and BOL details, and one-click pre-fill from a prior 850.

Tool

EDI 997 Functional Acknowledgment Builder

Paste any inbound X12 document — the tool lists each transaction set so you can mark it accepted or rejected, then download a valid 997 ready to transmit.

Tool

EDI 855 Purchase Order Acknowledgment Builder

Paste the inbound 850 — the tool pre-fills every line as accepted, then you mark the ones that change quantity, price, or ship date, or reject the ones you can't fulfill.

Tool

EDI 820 Remittance Advice Builder

Tell the payee which invoices you're paying. Load 810s to populate invoice entries, set action codes and amounts, and download a valid 820.

Tool

X12 Segment Reference

Searchable EDI X12 segment and element dictionary with 43 segments, 27 transaction sets, and qualifier codes.

Tool

HL7 Message Explorer

Parse HL7 v2.x healthcare messages with segment descriptions, field labels, and message type identification.

Tool

FHIR Resource Explorer

Parse HL7 FHIR JSON resources with resource-specific rendering. Supports Patient, Observation, Bundle, and more.

Tool

ISO 8583 Explorer

Parse ISO 8583 payment card messages with MTI breakdown, bitmap visualization, and data element parsing.

Tool

CSV & Delimited Text Converter — CSV, TSV, Pipe, Excel

Convert CSV, TSV, pipe-delimited, custom-delimiter text, and Excel files into CSV, TSV, pipe, JSON, JSONL, Excel, YAML, XML, Markdown table, HTML table, or SQL INSERT statements.

Tool

EBCDIC to ASCII Converter

Convert between EBCDIC and ASCII for IBM i, AS400, and mainframe systems. Fixed-length records, line ending options, CP037 reference.

Tool

Packed Decimal / COMP-3 Converter

Decode and encode packed decimal (COMP-3), zoned decimal, and trailing overpunch for IBM i and mainframe systems.

Tool

DDS Screen Explorer

Paste IBM i DDS display file source and see the screen rendered with authentic 5250 green-screen and modern preview.

Tool

DDS to SQL / SQL to DDS Converter

Convert between IBM i DDS physical file definitions and SQL CREATE TABLE statements in both directions.

Tool

BMS Screen Explorer

Paste mainframe BMS (CICS/3270) screen definitions and see the screen rendered with green-screen and modern preview.

Tool

COBOL Copybook Explorer

Explore COBOL copybook structures with interactive tree view, field layout, SQL conversion, JSON Schema generation, sample data decoding, and visual hex ruler.

Tool

Fixed-Width ↔ CSV

Convert between fixed-width text files and CSV. Editable column definitions with name, start, and length.

Tool

Data 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.

Tool

File 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.

Tool

Data Profiler

Profile CSV data with column-level statistics, value distribution charts, quality matrix, and drill-down column detail.

Tool

Parquet 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.

Tool

JSON ↔ CSV

Convert between JSON and CSV formats. Paste, upload, or load sample data. Download or copy the result.

Tool

XML ↔ JSON Converter

Convert between XML and JSON formats. Handles attributes, CDATA, arrays, and nested elements.

Tool

YAML ↔ JSON Converter

Convert between YAML and JSON formats. Handles multiline strings, anchors, and flow syntax.

Tool

XML Formatter

Format, pretty-print, minify, and validate XML with syntax highlighting and well-formedness checking.

Tool

SQL Formatter

Pretty-print SQL queries with proper indentation and keyword uppercasing. Supports common SQL dialects.

Tool

Regex Tester & Builder

Test regex patterns with real-time match highlighting. Built-in pattern builder and syntax reference.

Tool

JWT Explorer

Decode, inspect, and build JWTs. View claims, check expiration, and create HMAC-signed tokens.

Tool

Cron Expression Builder

Build and decode cron expressions visually. 12 presets, 5-field editor, and human-readable descriptions.

Tool

Base64 Encode/Decode

Encode text to Base64 or decode Base64 to text. Supports UTF-8.

Tool

Hash Generator

Generate SHA-256, SHA-384, SHA-512, and SHA-1 hashes from text using Web Crypto.

Tool

Timestamp Converter

Convert Unix epoch timestamps to human-readable dates and back. Timezone support.

Tool

UUID Generator

Generate v4 UUIDs. Single or bulk generation up to 100. Copy individual or all.

Tool

URL Encode/Decode

Percent-encode or decode URLs and query parameters. Component and full-URL modes.

Tool

Color Converter

Convert between Hex, RGB, and HSL color formats. Live preview swatch and ready-to-use CSS output.

Tool

JSON Converter

Convert JSON arrays of objects to CSV, Excel, XML, YAML, and 7 other formats.

Tool

Excel Converter

Convert Excel workbooks to CSV, JSON, XML, and 8 other formats. Multi-sheet picker, Force Text columns.

Tool

XML Converter

Extract repeating-element data from XML and convert to CSV, Excel, JSON, and 8 other formats.

Tool

YAML Converter

Convert YAML (array of objects, or a top-level mapping containing one) to CSV, Excel, JSON, and 8 other formats.

Tool

HTML Table Converter

Extract HTML <table> data and convert it to CSV, Excel, JSON, and 8 other formats.

Tool

SQL INSERT Converter

Extract rows from SQL INSERT statements and convert them to CSV, Excel, JSON, and 8 other formats.

Tool

Markdown Table Converter

Convert GitHub Flavored Markdown tables to CSV, Excel, JSON, and 8 other formats.

Tool

Markdown Preview

Live side-by-side markdown editor and rendered preview. Supports headers, lists, code, links, and more.

Tool

Subnet Calculator

Calculate network ranges, masks, host counts, and CIDR notation for IPv4 subnets.

Tool

IPv6 Subnet Calculator

Calculate IPv6 prefixes, expanded and compressed notation, network and host portions, and total addresses.

Tool

IP Address Converter

Convert IPv4 addresses between dotted, decimal, hex, octal, and binary representations.

Tool

CIDR Range & Overlap Tool

Detect overlaps between CIDR blocks, merge adjacent ranges, and check IP containment.

Tool

MAC Address Tool

Format, validate, and look up vendor for MAC addresses across all common notations.

Tool

Email Auth Checker

Check SPF, DMARC, DKIM, MX, and BIMI records for any domain in one place.

Tool

WHOIS Lookup

Look up domain and IP ownership using the modern RDAP protocol — registrar, expiry, name servers, ASN.

Tool

DNS Lookup

Query any DNS record type (A, AAAA, MX, TXT, NS, SOA, CAA, SRV, PTR) directly from your browser.

Tool

DNS Propagation Check

Query Cloudflare, Google, OpenDNS, and NextDNS in parallel and flag any resolver whose answer differs from the majority.

Tool

Reverse DNS + FCrDNS Checker

Look up the PTR record for an IP and verify the round-trip (FCrDNS) — important for mail server reputation.

Tool

DNSBL Check

Check an IPv4 address against 12 public DNS blacklists in parallel and see exactly which lists flagged it.

Tool

ASN Lookup

Look up ASN, AS name, announced prefix, country, and registry for any IPv4 or IPv6 address.

Tool

HTTP Header Inspector

Fetch any URL and see its response headers, redirect chain, and a full security-header audit (HSTS, CSP, X-Frame-Options, and more).

Tool

SSL Certificate Checker

Check HTTPS reachability and certificate history for any hostname via Certificate Transparency logs.

Tool

IBAN Validator

Validate IBAN check digits and decode country and BBAN structure using the ISO 13616 mod-97 algorithm.

Tool

Amortization Calculator

Calculate loan amortization schedules with monthly payment, principal/interest breakdown, and extra payment analysis.

Tool

MICR Line Decoder

Parse the MICR E-13B line from a check to extract routing number, account number, check number, and amount.

Tool

Card Number Validator

Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.

Tool

Connection String Builder

Build JDBC, ADO.NET, and ODBC connection strings with a browsable property reference for 8 database platforms and 18 drivers.

Tool

CSV to SQL Generator

Convert CSV data to SQL CREATE TABLE and INSERT statements with automatic type detection and dialect-specific output.

Tool

GS1 Application Identifier Parser

Parse GS1-128 and DataMatrix Application Identifier strings into structured, human-readable fields with validation.

Tool

WSDL/SOAP Explorer

Parse WSDL 1.1 files and explore SOAP services, operations, bindings, messages, and inline XSD types.

Tool

XSD/XML Schema Explorer

Parse XML Schema (XSD) files and explore element hierarchies, complex and simple types, restrictions, and generate sample XML.

Tool

JSON Schema Validator

Validate JSON documents against JSON Schema definitions with detailed error reporting and skeleton generation.

Tool

Meat Cutting Test Calculator

Calculate cutting test yields, cost allocation, and pass/fail against target yields for beef, pork, and poultry primals.

Tool

Shrink & Waste Calculator

Calculate inventory shrink, known waste, COGS, and gross profit by department with industry benchmark comparison.

Tool

Bakery Scaling & Yield Calculator

Scale baking formulas with bakers' percentages, work back from finished-product targets, and account for baking loss.

Tool

Produce Shrink & Rotation Calculator

Track produce lot aging by category shelf life, project shrink, and time markdowns optimally — lot-by-lot, not dollar totals.

Tool

Deli Prepared Foods Recipe-to-Retail Calculator

Roll up ingredient costs with yields, add labor and packaging, and price prepared foods to a target margin.

Tool

Seafood Case-Pack & Yield Calculator

Calculate whole-fish-to-fillet yield by species, factor ice and packaging, and cost the saleable pound.

Tool

Floral Department Turn & Freshness Calculator

Count stems from wholesale receipts, compose bouquets, track vase life, and time markdowns on aging floral inventory.

Tool

Multi-Vendor Receiving Dock Scheduler

Schedule vendor deliveries by dock capacity, truck cube, and time window — resolves conflicts and produces a daily schedule.

Tool

Price-Per-Unit Comparator

Compare product prices normalized to a common unit across weight, volume, or count. Find the best value instantly.

Tool

PLU Code Lookup

Search all IFPS produce PLU codes by number or commodity name with organic code conversion and category filters.

Tool

Case Pack / Inner Pack Calculator

Calculate order quantities, days of supply, reorder points, and shelf facings from case pack and movement data.

Tool

Department Labor Scheduler

Calculate weekly labor hours and budgets by department from sales forecasts, labor targets, and hourly rates.

Tool

Shelf Label Generator

Generate retail shelf labels with barcodes, unit pricing, sale and produce templates, and batch Avery sheet printing.

Tool

Large Sign Generator

Create professional sale signs, endcap headers, and department markers with custom fonts, colors, layouts, and paper sizes.

Article

IBM i: The Platform Decision-Makers Should Understand

A practical overview for business leaders evaluating, maintaining, or modernizing IBM i environments.

Article

ETL: The Invisible Backbone of Enterprise Data

How data actually moves between the systems your business depends on, and what goes wrong when it is not done well.

Article

EDI 101: What Business Leaders Need to Know

A plain-language guide to Electronic Data Interchange — what it is, why it matters, and how to tell when it's not working the way it should.

Article

Linux: The Foundation Your Business Already Depends On

Why the platform that runs most of the internet matters for your business, and what goes wrong when it is not managed well.

Article

Understanding BAI2 Files: A Guide for Treasury and IT Teams

Everything you need to know about the banking industry's standard cash reporting format — from file structure to automation.

Article

HL7 vs FHIR: What You Need to Know

A practical guide to healthcare data exchange standards — what works, what's changing, and how to make smart integration decisions.

Article

RPG: The Language Behind Your Business Logic

What decision-makers need to know about the programming language that powers their IBM i applications.

Article

When Your Spreadsheet Should Have Been a Database

Why the most dangerous application in your organization might be the one nobody thinks of as software.

Article

EBCDIC and ASCII: A Practical Guide to Mainframe Data Conversion

What EBCDIC is, how it differs from ASCII, where conversions go wrong, and how to handle real-world mainframe data with confidence.

Article

POS Item File Sync: Keeping Stores in Sync with the Host

Why multi-store POS item files drift, what automated audit reports reveal, and how synchronization keeps every register accurate.

Article

Automating Enterprise Firewall Deployment: Lessons From the Field

Why mass firewall rollouts need the same rigor as software releases — and what vendor APIs make possible.

Article

ISO 8583 Explained: How Payment Card Messages Work

The international standard behind every card swipe, dip, and tap — and what developers need to know about it.

Article

RPG Modernization: Options Beyond Java Migration

The migration question is more nuanced than vendors suggest. Here are the real options, tradeoffs, and a practical framework for deciding.

Article

Microsoft Access, Excel, and VBA: The Tools Your Finance Team Depends On

What decision-makers need to know about the Microsoft tools that quietly run critical business processes.

Article

Data Migration Testing: Why Record-Level Comparison Matters

Row counts match. Reports look right. But until you compare every record field by field, you don't know what the migration actually did to your data.

Article

Building Handheld Scanner Applications That Last a Decade

From Symbol and Motorola to Zebra: what makes a programmable handheld application survive decades of continuous production use.

Article

EDI X12: What's Inside an 850, 810, and 856

A developer-level walkthrough of the three transaction sets at the center of every EDI trading relationship — and the segments that trip people up.

Article

Java: The Enterprise Language That Keeps Delivering

Why the platform that powers enterprise software across every industry remains one of the most practical choices for business applications.

Article

Off-the-Shelf vs Custom Software: When Standard Falls Short

Why the software that works for everyone may not work well enough for the processes that set your business apart.

Article

Retail Shrink: The Operational Controls That Actually Work

Why inventory loss keeps climbing, where the real exposure is, and what practical technology and process changes reduce it.

Article

EDI Compliance Mandates: What Retailers Expect and How to Deliver

The wave of tightened EDI requirements from major retailers, the chargebacks that follow non-compliance, and the practical steps that prevent them.

Article

PCI DSS 4.0: Practical Compliance for Smaller Businesses

The March 2025 deadline has passed. Here is what changed, what matters most, and how smaller businesses can get compliant without enterprise budgets.

Article

AI in Enterprise: Practical Patterns Beyond the Hype

What AI integration actually looks like in business systems, where it delivers real value, and how to tell the difference between substance and spectacle.

Article

Integrating Itasca Magic CGO with a Regional Grocery Chain

What it takes to connect Upshop Inventory 360 to the host merchandising platform, warehouse, and perpetual inventory for a growing multi-store operation.

Article

ENCOR (ISS45) Enhanced Promotions: A Field Guide for Grocery and Retail Technology Leaders

What the platform supports, the promotional patterns it makes possible, and how to bring more of them to life across your fleet.

Article

ENCOR (ISS45) Transaction Log Analytics: Sales, Shrink, and Fraud Detection

What's inside the log, the patterns it reveals when parsed, and how to surface them across your fleet.

$Grocery Fresh Departments: The Math That Moves Margin share card$

Article

Grocery Fresh Departments: The Math That Moves Margin

Six operational tools for meat, produce, deli, bakery, seafood, and floral — and why small percentage shifts in these departments outsize their share of sales.

Article

Comparing Data Files: Choosing the Right Tool

How to pick between record-level and line-level comparison — and get messy spreadsheets into a shape the tools can actually read.

Demo

Business Intelligence Dashboard

Edit live data, analyze with grouping and filters, and visualize across multiple chart types.

Demo

EDI Made Useful

See raw EDI purchase orders and invoices parsed into readable documents and usable data formats.

Demo

Modernization in Action

Side-by-side task comparison showing the productivity advantage of modern interfaces.

Share cards are regenerated at build time from the site content. Showing 187 of 187.