StammdatenJobs.ImportStammdaten

// Job ID: #347722
using Zgkb.Sigma.BusinessLogic.Jobs;

var stammdatenJobs = Activate<StammdatenJobs>();
stammdatenJobs.ImportStammdaten();

Parameter

CurrentCulture
"de-CH"
CurrentUICulture
"en-US"
RecurringJobId
"stammdaten-import"
Time
1788967806

Status

09.09.2026 15:30:06 (+734ms) Failed

An exception occurred during performance of the job.

CsvHelper.HeaderValidationException (magnostage2:10572)

Header with name 'MA_MOBIL_E_MERGENCY'[0] was not found. Headers: 'MIT_ANREDE_ID', 'MIT_VORNAME', 'MIT_NAME', 'MIT_PERSONALID', 'MIT_KURZZEICHEN', 'MIT_TELEFON_INTERN', 'MIT_TELEFON_EXTERN', 'MIT_TELEFON_MOBILE', 'MIT_EMAIL', 'MIT_KOSTENSTELLE', 'MIT_FUN_EXT_ID', 'MIT_RANG', 'MIT_STANDORT', 'EIN_ID', 'EIN_INSTRADIERUNG', 'EIN_BEZEICHNUNG', 'EIN_BELEGUNG', 'EIN_STELLENBEZEICHNUNG', 'UNIQUE_ID' If you are expecting some headers to be missing and want to ignore this validation, set the configuration HeaderValidated to null. You can also change the functionality to do something else, like logging the issue. IReader state: ColumnCount: 19 CurrentIndex: -1 HeaderRecord: ["MIT_ANREDE_ID","MIT_VORNAME","MIT_NAME","MIT_PERSONALID","MIT_KURZZEICHEN","MIT_TELEFON_INTERN","MIT_TELEFON_EXTERN","MIT_TELEFON_MOBILE","MIT_EMAIL","MIT_KOSTENSTELLE","MIT_FUN_EXT_ID","MIT_RANG","MIT_STANDORT","EIN_ID","EIN_INSTRADIERUNG","EIN_BEZEICHNUNG","EIN_BELEGUNG","EIN_STELLENBEZEICHNUNG","UNIQUE_ID"] IParser state: ByteCount: 0 CharCount: 275 Row: 1 RawRow: 1 Count: 19 RawRecord: MIT_ANREDE_ID;MIT_VORNAME;MIT_NAME;MIT_PERSONALID;MIT_KURZZEICHEN;MIT_TELEFON_INTERN;MIT_TELEFON_EXTERN;MIT_TELEFON_MOBILE;MIT_EMAIL;MIT_KOSTENSTELLE;MIT_FUN_EXT_ID;MIT_RANG;MIT_STANDORT;EIN_ID;EIN_INSTRADIERUNG;EIN_BEZEICHNUNG;EIN_BELEGUNG;EIN_STELLENBEZEICHNUNG;UNIQUE_ID

CsvHelper.HeaderValidationException: Header with name 'MA_MOBIL_E_MERGENCY'[0] was not found.
Headers: 'MIT_ANREDE_ID', 'MIT_VORNAME', 'MIT_NAME', 'MIT_PERSONALID', 'MIT_KURZZEICHEN', 'MIT_TELEFON_INTERN', 'MIT_TELEFON_EXTERN', 'MIT_TELEFON_MOBILE', 'MIT_EMAIL', 'MIT_KOSTENSTELLE', 'MIT_FUN_EXT_ID', 'MIT_RANG', 'MIT_STANDORT', 'EIN_ID', 'EIN_INSTRADIERUNG', 'EIN_BEZEICHNUNG', 'EIN_BELEGUNG', 'EIN_STELLENBEZEICHNUNG', 'UNIQUE_ID'
If you are expecting some headers to be missing and want to ignore this validation, set the configuration HeaderValidated to null. You can also change the functionality to do something else, like logging the issue.

IReader state:
   ColumnCount: 19
   CurrentIndex: -1
   HeaderRecord:
["MIT_ANREDE_ID","MIT_VORNAME","MIT_NAME","MIT_PERSONALID","MIT_KURZZEICHEN","MIT_TELEFON_INTERN","MIT_TELEFON_EXTERN","MIT_TELEFON_MOBILE","MIT_EMAIL","MIT_KOSTENSTELLE","MIT_FUN_EXT_ID","MIT_RANG","MIT_STANDORT","EIN_ID","EIN_INSTRADIERUNG","EIN_BEZEICHNUNG","EIN_BELEGUNG","EIN_STELLENBEZEICHNUNG","UNIQUE_ID"]
IParser state:
   ByteCount: 0
   CharCount: 275
   Row: 1
   RawRow: 1
   Count: 19
   RawRecord:
MIT_ANREDE_ID;MIT_VORNAME;MIT_NAME;MIT_PERSONALID;MIT_KURZZEICHEN;MIT_TELEFON_INTERN;MIT_TELEFON_EXTERN;MIT_TELEFON_MOBILE;MIT_EMAIL;MIT_KOSTENSTELLE;MIT_FUN_EXT_ID;MIT_RANG;MIT_STANDORT;EIN_ID;EIN_INSTRADIERUNG;EIN_BEZEICHNUNG;EIN_BELEGUNG;EIN_STELLENBEZEICHNUNG;UNIQUE_ID


   at CsvHelper.Configuration.ConfigurationFunctions.HeaderValidated(HeaderValidatedArgs args)
   at CsvHelper.CsvReader.ValidateHeader(Type type)
   at CsvHelper.CsvReader.ValidateHeader[T]()
   at CsvHelper.CsvReader.GetRecords[T]()+MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Zgkb.Sigma.BusinessLogic.Stammdaten.StammdatenImporter.readCsv[TRecord](String filename) in D:\a\zgkb-sigma\zgkb-sigma\Zgkb.Sigma.BusinessLogic\Stammdaten\StammdatenImporter.cs:line 470
   at Zgkb.Sigma.BusinessLogic.Stammdaten.StammdatenImporter.ImportOrgsAndEmployees() in D:\a\zgkb-sigma\zgkb-sigma\Zgkb.Sigma.BusinessLogic\Stammdaten\StammdatenImporter.cs:line 47
   at Zgkb.Sigma.BusinessLogic.Jobs.StammdatenJobs.ImportStammdaten() in D:\a\zgkb-sigma\zgkb-sigma\Zgkb.Sigma.Backend\Jobs\StammdatenJobs.cs:line 18
   at System.Reflection.MethodBaseInvoker.InterpretedInvoke_Method(Object obj, IntPtr* args)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+40ms Processing

Server:
magnostage2:10572
Worker:
b964bcdb

+23ms Enqueued

Triggered by recurring job scheduler

09.09.2026 15:30:06 Created