eNICQ 6 - "Input string was not in a correct format" error when importing infant records

Reported Issue:  

When trying to import a file of new records into eNICQ 6 the users get the error message "Input string was not in a correct format":

eNICQ import error, Input string was not in a correct format

 

 

Resolution:

  1. Check the file being imported to see if HOSPNO is present.
  2. If it isn’t, add the HOSPNO column and correct center number for each patient.
  3. Import the revised file.

Root Cause: 

This occurs with files exported from an EHR which are then converted into CSV files, but the file is missing the HOSPNO column. Adding that column to the file with the correct center number for each patient resolves the issue.