skills.rest
gmedia
gmediaOFFICIAL
Explore all skills by this author →
WebsiteGitHub

Feature Import Excel

Automate Excel data imports into CRUD modules with validation, FK mapping, and upserts.

4|1|Updated Sep 25, 2025
Search Tags:#automation#laravel#backend-architecture#upsert#excel-import#data-import#foreign-key
One-click install
npx skills add https://github.com/gmedia/erp --skill feature-import-excel
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Feature Import Excel
Source: https://github.com/gmedia/erp/tree/main/.agent/skills/feature-import
Command: npx skills add https://github.com/gmedia/erp --skill feature-import-excel

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It simplifies the tedious task of importing data from Excel files into existing CRUD modules, with proper FK mapping and upsert behavior.

Core Features & Use Cases

  • Importer class: uses Laravel-Excel to validate, map FK lookups, and upsert rows efficiently.
  • Action & Form Request: orchestrate the upload, validation, and reporting of results.
  • Frontend Import UI: provides a drag-and-drop dialog, template download, and a live result summary.
  • End-to-end testing: Pest tests and Playwright e2e tests ensure reliability across scenarios.

Quick Start

Create an Excel-based import workflow to add or update records in an existing CRUD module.

Frequently Asked Questions about Feature Import Excel

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

FAQPage Schema
How do I automate Excel data import into Laravel CRUD modules with foreign key mapping?▼

Automating Excel data import into Laravel CRUD modules involves using an Importer class to validate spreadsheet rows, map foreign key lookups, and upsert records efficiently. This backend architecture orchestrates uploads, validation, and reporting of imported, skipped, and error records.

What is the best way to upsert Excel spreadsheet rows into an ERP-style backend system?▼

Upserting Excel rows into an ERP-style backend requires a 4-part import architecture: an Importer class for validation and FK mapping, an Action and Form Request for orchestration, and a Controller for routing. This ensures robust file upload handling and reports imported, skipped, and error records.

Does this Excel import approach provide a frontend UI for file uploads and result reporting?▼

Yes, the Excel import approach includes a frontend UI featuring a drag-and-drop dialog for file uploads, a template download option, and a live result summary. This interface connects to the backend architecture to display imported, skipped, and error records directly to users.

Can I use Laravel-Excel to validate and map foreign keys during a spreadsheet data import?▼

Yes, you can use Laravel-Excel within a dedicated Importer class to validate incoming rows and perform foreign key mapping. The system upserts the validated data into existing CRUD modules while tracking imported, skipped, and error records for comprehensive reporting.

How do you test Excel file upload workflows and upsert operations in a Laravel backend?▼

Testing Excel file upload workflows and upsert operations is handled through end-to-end Pest tests and Playwright e2e tests. These tests ensure reliability across various import scenarios, validating the robust file upload handling and accurate reporting of imported, skipped, and error records.

Related Skills

Explore More Software Engineering Skills→
AdemKaoAdemKao

laravel-migration

Create Laravel migrations with columns, indexes, and foreign keys.

Community
Intermediate
forcedotcomforcedotcom
803

implementing-ui-bundle-file-upload

Upload files from React UI bundles to Salesforce with progress tracking.

Official
Intermediate
pphatdevpphatdev

full-stack-erp-testing

Automate Laravel/Pest backend and Nuxt/Vitest frontend tests for multi-tenant ERP.

Community
Advanced
pulumipulumi
63

pulumi-cdk-to-pulumi

Convert AWS CDK Cloud Assemblies to Pulumi TypeScript programs using cdk2pulumi.

Official
Advanced