Delivery Center

Take accepted files through the delivery pipeline — prepare, convert, load into SQL, and generate delivery files.

How Delivery works

Every extracted file is a clean Excel workbook. Delivery turns those workbooks into business-ready outputs, in four stages that mirror the production workflow — run them in order:

  1. STAGE 1

    Prepare (Excel)

    Deduplicates and cleans the extracted workbook.

  2. STAGE 2

    Convert (CSV)

    Generates the §-delimited CSV built for fast bulk loading.

  3. STAGE 3

    Load (SQL)

    Bulk-uploads the CSVs into your database.

  4. STAGE 4

    Deliver (DAT)

    Produces the tab-delimited .dat delivery file.

Everything runs locally on this computer — no data leaves your machine. Stage outputs are filed into Documents\CyberInci with a separate folder per format (Excel, CSV, DAT), so nothing gets mixed up. The SQL stage converts to the §-delimited CSV first, then bulk-loads it (MySQL uses the LOAD DATA fast path) — and can create the table for you if it doesn't exist yet; your database credentials are used for that one upload and never stored. Already have extracted workbooks from elsewhere? Use "Import Excel" to bring them in without re-extracting.

1 · Choose accepted files (0 available)

No accepted files yet. Extract some documents first — or use Import Excel above to bring in workbooks that were already extracted elsewhere.

2 · Run the delivery stages

STAGE 1

Prepare (Excel)

Deduplicates and cleans the extracted workbook.

Removes exact duplicate rows and repeated values inside cells (';' lists), strips control characters and normalizes whitespace. Output: a delivery-grade Excel.

STAGE 2

Convert (CSV)

Generates the §-delimited CSV built for fast bulk loading.

Transliterates accents, cleans every cell, drops rows without a DOCID and de-duplicates — the exact format LOAD DATA INFILE ingests at maximum speed.

STAGE 3

Load (SQL)

Bulk-uploads the CSVs into your database.

MySQL uses the LOAD DATA INFILE fast path; PostgreSQL, SQLite, SQL Server and Oracle are supported too. Credentials are used once and never stored.

STAGE 4

Deliver (DAT)

Produces the tab-delimited .dat delivery file.

Concatenates DOCID columns, removes final duplicates and writes UTF-8 (BOM) tab-delimited output — the format your delivery systems expect.

3 · Notification roster (unique individuals)

Collapse the selected files into the distinct people to notify — the same person across spellings, typos and files is merged into one, matched on SSN, email, or name + date-of-birth/phone.

ExtractReviewPrepareConvertLoad SQLDeliver DATRoster