@extends('layout.main') @section('content')

{{ __('Import EXCEL/CSV file only') }}

@include('shared.flash_message')
{{ __('Download Sample File') }}

The first line in downloaded sample file should remain as it is. Please do not change the order of columns in file.

The correct column order is (First Name, Last Name, Staff Id, Identity Number, Username, Email, Password, Joining Date, Gender, Date of Birth, Contact Number, Address, City, State, Zip, Country, Marital Status, Dependent, Status, Company Name, Department Name, Designation Name, Shift Name, Role Name, Basic Salary Month Year, Basic Salary Payslip, Basic Salary, Bank Account Title, Bank Account Number, Bank Name, Bank Code, Bank Branch, Include BPJS TK, Include BPJS KES, Include Tax, Position, Dispensation).

  • Date format should be (According to general settings)
  • Company, Department, Designation, Shift, Dependent and Role name must be matched with your existing data.
  • Gender must be Male / Female / Other.
  • Marital Status must be Single / Maried / Widowed / 'Divorce/Separated'
  • Status must be full-time / part-time / internship / terminated
  • Basic Salary Month Year must be following Month-Year format. e.g January-2023
  • Basic Salary Payslip must be Monthly / Hourly
  • Include BPJS TK, BPJS KES, Tax, and Dispensation must be 0 / 1 (0 for no, 1 for yes)
  • You must follow the file, otherwise you will get an error while importing the file.
@csrf
{{ __('Please select excel/csv') }} file (allowed file size 2MB)
@endsection