"Header field count does not match row field count" error when importing eNICQ 5 data into eNICQ 6

A few centers are reporting an issue when trying to import the data from eNICQ 5 into eNICQ 6. The error message on the Import Log says "Header field count does not match row field count".

image001.png

We are currently working on a solution for this but in the meantime we currently have a workaround that has been successful in addressing the issue.

1. Open the CSV file as a spreadsheet using Excel or other similar program
2. Scroll to the right until you see the last Header (centers that are VLBW only will be column "FU" with ROPANTIVEGF for the header but for centers certified for Expanded Data it will be column GS with the header NICU_ADMSN)
3. Right click on the column just after the last header (if I'm correct about your last header in the step above it will be column FV which should have no header)
4. Select Delete from the menu

screenshot.png


5. Save the file.
6. You will probably get a message which says your file "may contain features that are not compatible with CSV (Comma delimited). Do you want to keep the workbook in this format?" Click the Yes button.

screenshot2.png
7. Close the file. If it asks if you want to save it you can select "Don't Save" since it was already saved in the step above.
8. Try importing it again. 

 

Have more questions? Submit a request

Comments

  • Avatar
    Ted Kreider

    Status update: This issue was reviewed by our development team. The conclusion was that the fault in the file was due to eNICQ 5, which will not be subject to further rework. This work-around topic is the intended solution for the eNICQ 5 to eNICQ 6 migration.

    Please contact our support team immediately if this solution is insufficient to solve a migration issue, or if you are encountering this issue post-migration.