StammdatenJobs.ImportStammdaten

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

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

Parameter

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

Status

21.08.2026 04:30:06 (+910ms) Failed

An exception occurred during performance of the job.

CsvHelper.HeaderValidationException (magnostage2:13788)

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 InvokeStub_StammdatenJobs.ImportStammdaten(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+70ms Processing

Server:
magnostage2:13788
Worker:
2756fe0d

+10ms Enqueued

Triggered by recurring job scheduler

21.08.2026 04:30:05 Created