erp-excel-importer

Parse Excel and CSV files into the CIC ERP system via Supabase.

Updated Jan 26, 2026

Search Tags:#supabase #excel #data entry #csv #erp #import

Ready to run

npx skills add https://github.com/anhnq-lab/cic-erp-contract --skill erp-excel-importer

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: erp-excel-importer
Source: https://github.com/anhnq-lab/cic-erp-contract/tree/main/.agent/skills/erp-excel-importer
Command: npx skills add https://github.com/anhnq-lab/cic-erp-contract --skill erp-excel-importer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the process of importing data from Excel or CSV files into the CIC ERP system, reducing manual data entry and potential errors.

Core Features & Use Cases

Data Parsing: Reads data from Excel (.xlsx, .xls) and CSV files.
Column Mapping: Maps Vietnamese column headers to standardized entity fields.
Validation: Implements rules for required fields, data types, and formats.
Upsert to Supabase: Inserts or updates data in the Supabase database, handling duplicates.
Use Case: Importing a list of new products from an Excel sheet into the ERP system, ensuring all necessary fields like 'code', 'name', and 'price' are correctly mapped and validated before insertion.

Quick Start

Use the erp-excel-importer skill to import data from the attached file 'products.xlsx'.

Frequently Asked Questions about erp-excel-importer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I import Excel data into an ERP system via Supabase?▼

To import Excel data into an ERP system via Supabase, you can parse .xlsx or .xls files, map Vietnamese headers, validate data, and upsert records to prevent duplicates. This handles the entire process from file parsing to database insertion.

Can I import CSV files into CIC ERP without manual data entry?▼

Yes, you can import CSV files into CIC ERP without manual data entry. The process reads data from CSV files, maps column headers to standardized entity fields, and performs database upserts to streamline data entry and reduce potential errors.

Does the Excel import process support Vietnamese column headers?▼

Yes, the Excel import process supports Vietnamese column headers. It automatically maps Vietnamese column headers from your Excel or CSV files to standardized entity fields before validating the data and inserting it into the Supabase database.

How do I prevent duplicate records when importing Excel data to Supabase?▼

To prevent duplicate records when importing Excel data to Supabase, the process uses an upsert mechanism. This inserts new data or updates existing records in the database, ensuring duplicates are handled correctly during the ERP data import.

What is the best way to validate data before importing an Excel sheet into an ERP?▼

The best way to validate data before importing an Excel sheet into an ERP is to use a process that implements rules for required fields, data types, and formats. It also offers preview capabilities to check data before upserting it.

Why does my Excel import into ERP fail when required fields are missing?▼

Your Excel import into ERP fails when required fields are missing because the process implements strict validation rules for required fields, data types, and formats. It features robust error handling to stop incomplete data from being upserted.