StammdatenJobs.ImportStammdaten

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

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

Parameter

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

Status

17.08.2026 15:30:05 (+767ms) Failed

An exception occurred during performance of the job.

CsvHelper.HeaderValidationException (magnostage2:9864)

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 467
   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 22
   at System.RuntimeMethodHandle.InvokeMethod(ObjectHandleOnStack target, Void** arguments, ObjectHandleOnStack sig, BOOL isConstructor, ObjectHandleOnStack result)
   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)

+13ms Processing

Server:
magnostage2:9864
Worker:
ba6705e7

+7ms Enqueued

Triggered by recurring job scheduler

17.08.2026 15:30:04 Created