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

0•

Database Management

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

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

010 GitHub stars

02Automated CSV and XLSX parsing with file type and date format detection

03Three-tier history architecture including change logs, entity snapshots, and organizational snapshots

04Extensible base classes for creating domain-specific importers with custom validation

05Batch processing support to group related database operations under a single ID

06Integrated change detection engine to identify field-level modifications

Use Cases

01Building comprehensive audit trails for sensitive database records to track 'who changed what and when'

02Generating point-in-time snapshots for organizational structures to facilitate historical reporting

03Implementing bulk data upload features for employee or attendance management systems

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add takashi-matsumura/box-frame data-management

For use in Claude.ai and ChatGPT

Download Skill