add-csv-importer

What problem does it solve?

Building bulk import scripts is slow and error-prone, especially when you need validation, deduplication, dry runs, and per-row error reporting.

Core Features & Use Cases

• Scaffolded bulk CSV importer: Generates a ready-to-run Python import script for importing entities from a CSV with clear CLI options.
• Validation and normalization hooks: Establishes patterns for validating required headers and normalizing key fields (e.g., whitespace and case).
• Deduplication + optional upsert: Supports skipping duplicates by dedup key or updating existing records with an --update-existing flag.
• Dry-run safety and reporting: Adds --dry-run to preview actions and writes an import results CSV (created/updated/skipped/error) to reports/.
• Resilient batch processing: Uses per-row exception handling with rollback so one bad row doesn’t break the entire import.

Quick Start

Use the add-csv-importer skill to generate an import script for your target entity and CSV mapping, then run the produced script with dry-run first to verify results before importing.