What file formats does the importer support?

The BaseImporter class supports both CSV and XLSX files, featuring automatic detection and built-in support for parsing Western and Japanese calendar dates.

Is it possible to group multiple changes together?

Yes, the framework uses a batchId system (typically a UUID) to group related modifications, making it easier to track changes resulting from a single operation.

How does the history management system differ from simple logging?

Unlike simple logging, this framework uses a 3-tier model that tracks individual field changes, creates full JSON snapshots of entities, and maintains aggregate snapshots for organizational states.

How do I implement a new data importer using this skill?

You can extend the BaseImporter class, define your interface for the CSV/XLSX rows, and implement the processData and importToDatabase methods to handle your specific business logic.

Data Import and History Management

Name: Data Import and History Management
Author: Takashi-Matsumura

byTakashi-Matsumura

Database Management

Streamlines complex data ingestion from CSV and XLSX files while implementing a robust three-tier history management framework for audit trails.

About

This skill provides a standardized architecture for handling large-scale data imports and historical tracking within Claude Code environments. It leverages a BaseImporter class to automate file parsing, type detection, and validation for CSV and XLSX files. Beyond ingestion, it implements a sophisticated change-detection engine that maintains data integrity through a three-tier history model: detailed change logs, individual entity snapshots, and aggregate organizational snapshots. It is particularly useful for developers building enterprise-grade applications that require strict audit trails and the ability to track state changes over time.

Key Features

0 GitHub stars
Automated CSV and XLSX parsing with file type and date format detection
Three-tier history architecture including change logs, entity snapshots, and organizational snapshots
Extensible base classes for creating domain-specific importers with custom validation
Batch processing support to group related database operations under a single ID
Integrated change detection engine to identify field-level modifications

Use Cases

Building comprehensive audit trails for sensitive database records to track 'who changed what and when'
Generating point-in-time snapshots for organizational structures to facilitate historical reporting
Implementing bulk data upload features for employee or attendance management systems

About

Key Features

0 GitHub stars
Automated CSV and XLSX parsing with file type and date format detection
Three-tier history architecture including change logs, entity snapshots, and organizational snapshots
Extensible base classes for creating domain-specific importers with custom validation
Batch processing support to group related database operations under a single ID
Integrated change detection engine to identify field-level modifications

Use Cases

Building comprehensive audit trails for sensitive database records to track 'who changed what and when'
Generating point-in-time snapshots for organizational structures to facilitate historical reporting
Implementing bulk data upload features for employee or attendance management systems