eNICQ 6 - "Object reference not set to an instance of an object" error when importing a file

Reported Issue: 

When importing a CSV file in eNICQ 6.1.1 the following error occurs:

eNICQ 6.1.1 error, Object reference not set to an instance of an object, ErrorCode: -2147467261



Method: Boolean ProcessInfantField(System.String, System.String, Boolean, Von.Model.ImportInfant, Von.Model.ImportInfantResults)
Source: enicq6
Message: Object reference not set to an instance of an object.
Stack Trace:
  at Von.Model.ImportInfantDataModel.ProcessInfantField(String fieldName, String value, Boolean validRow, ImportInfant infant, ImportInfantResults infantResults)


Root Cause: 

As of January 1, 2021 centers started experiencing this issue. SRGLIG (PDA Ligation) and SRGLIGWD (PDA Ligation, Where Done) were removed in 2017. As of January 1, 2021 the 2017 birth year became archived so those fields are no longer valid causing the errors eNICQ 6.1.1 users are seeing.



This only happens in eNICQ 6.1.1. Upgrading to eNICQ 6.2 would fix this issue for this and any future imports without having to change the format of your CSV files.

The other solution would be to remove the SRGLIG and SRGLIGWD fields from the file you are importing or to just not include them when creating the original files. We have updated the sample CSV and XML files with both of those fields removed.

If you are removing the fields manually in Excel there may be some changes Excel will automatically make to the data in the file which could create errors in the record upon import. For example, some field require decimal points at the end of each number. even if that number is a whole number. When you open Excel it will, by default, drop any values which end in .0 and this will create an error when that record is imported.