← Index · ← File index · ← Prev · Next → · 📄 source

#987: `EmployeeSalaryExcelImporter.kt`

projectforge-business/src/main/kotlin/org/projectforge/business/fibu/datev/EmployeeSalaryExcelImporter.kt Type: Spring Service (import logic)
Package: org.projectforge.business.fibu.datev
Actual Path: projectforge-business/src/main/kotlin/org/projectforge/business/fibu/datev/EmployeeSalaryExcelImporter.kt
Note: The file does not exist at the requested path (.../excelimport/...). It resides in the datev sub-package. The documentation below reflects the actual source. 123 lines · 81 code · 31 comments · 11 blank

Imports employee salaries from an Excel workbook sheet named "employeeSalaries". Maps employee records by staff number (Personalnummer), validation includes checking that the employee exists in the database.

Architecture

Dependencies

Dependency	Role
`EmployeeCache`	Fast cached lookup by staff number
`EmployeeService`	Direct database lookup if cache miss

Column Mapping (Enum: `Cols`)

Enum	Header	Validator	Target Property
`PERSONALNUMMER`	Personalnummer	NumberValidator (>=1, required, unique)	Used for employee lookup
`GESAMT_BRUTTO`	Gesamtbrutto	Validator (required)	`bruttoMitAgAnteil`

The GESAMT_BRUTTO column accepts the aliases "bruttoMitAgAnteil" and "Gesamt-".

Import Flow

Opens the sheet named "employeeSalaries" — throws UserException if not found.
Registers two columns with validators.
Analyzes the sheet with sheet.analyze(true).
Creates an ImportedSheet with warning-level logging.
Iterates data rows:
- Creates MyImportedElement for diff tracking.
- Creates EmployeeSalaryDO and fills from row via ImportHelper.fillBean().
- Looks up employee by staff number (cache first, then database). Records a validation error if not found.
- Sets year and month on the salary record.
- Adds the populated element to the imported sheet.

Diff Properties

SALARY_DIFF_PROPERTIES = ["bruttoMitAgAnteil"]

Companion Object

Contains the sheet name constant NAME_OF_EXCEL_SHEET = "employeeSalaries" and SALARY_DIFF_PROPERTIES.

Git History

868d6abb7 2025 -> 2026
312d5e61c Clean-up
63081666f Source file headers: 2024-> 2025.
1012e347a Migration stuff in progress... (all tests of all packages: OK).

#987: EmployeeSalaryExcelImporter.kt