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":

Input_string_error.png

 

Root Cause: 

This seems to mostly occur with files exported from an EHR and converted into CSV files. Typically the file being imported is missing the HOSPNO column. Adding that column to the file with the correct center number for each patient resolves the issue.

Resolution or Workaround:

  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.