Import Assets

← Back to Assets

Bulk Import from CSV/Excel

Upload a file to import multiple assets at once.

@if (session('asset_import_errors'))

Skipped Rows

    @foreach (session('asset_import_errors') as $error)
  • Row {{ $error['row'] }}: {{ $error['message'] }}
    • @endforeach
@endif
@csrf

Instructions

  1. Download the template file below
  2. Fill in your asset data (name and category are required)
  3. Save as CSV or Excel (.xlsx, .xls)
  4. Upload the file and click Import
Download Template (CSV)

Accepted formats: CSV, XLSX, XLS (max 10MB)

@error('file')

{{ $message }}

@enderror
Cancel Import Assets

Required Columns

@if (auth()->user()?->ministry_id === null) @endif
Column Required Description
name Yes Asset name
category Yes Category name (auto-created if new)
ministry_code Yes MDA code (e.g., EDU, HLT)
asset_tag No Unique tag (auto-generated if empty)
purchase_date No Date format: YYYY-MM-DD
purchase_cost No Original purchase cost
status No active, under_maintenance, disposed
supplier_email No Existing supplier email; row is skipped if not found
warranty_status No Active, Expired, or None
warranty_expiry No Date format: YYYY-MM-DD
dynamic_attributes No JSON object, e.g. {"Condition":"New"}