Skip to main content

Data Import Export

This module enables bulk data import and export using Excel files.

Features​

  • Excel Import: Import data from CSV or XLSX files into the system
  • Excel Export: Export system data to XLSX format
  • Download Templates: Download blank template files for import

Requirements​

  • Open Core Business Suite (Base System)

Installation​

Enable via Admin Panel​

  1. Log in as administrator
  2. Navigate to Settings > Addons
  3. Find Data Import Export and click Enable
  4. Run migrations if prompted

Enable via Command Line​

php artisan module:enable DataImportExport
php artisan migrate

Access Control​

This module is restricted to users with the following roles: Super Admin, Admin, HR Manager, or HR.

Usage​

Accessing the Module​

Navigate to Data Import/Export from the main sidebar. The main page displays the available data types that support import and/or export.

Importing Data​

  1. Select the data type you want to import
  2. Download the template file for that type
  3. Fill in the template with your data (CSV or XLSX format)
  4. Upload the completed file
  5. The system validates and imports the data

Exporting Data​

  1. Select the data type you want to export
  2. Click the export button
  3. The system generates and downloads an XLSX file with the current data

Download Templates​

For each data type that supports import, you can download a blank template file to use as a starting point. The template provides the correct column structure for the import.

How It Works​

The module uses a registry-based architecture. Available import/export types are registered by other modules in the system. Each registered type specifies whether it supports import, export, or both, along with the corresponding import/export classes. This means the available data types depend on which modules are installed and active.

Changelog: View version history

Last updated on