What do I do if I see the 'duplicate record' error when i upload to NHIMA?

What do I do if I see the 'duplicate record' error when I upload to NHIMA? Check first that you have upload the exported CSV file directly. ie you have not been editing the csv file before uploading to NHIMA. Use the EXCEL export button to create an .XLSX fle and then 'Save As' filetype .CSV for direct upload to NHIMA. Once you have saved the excel file as CSV(Comma delimited.csv), do not re-save the CSV file before uploading. ie Do NOT open your exported csv file and re-save before uploading as your upload file won't work". This is due to the fact that re saving a CSV file in excel sometimes causes the format to change. For example the long NHI numbers in "Column D" might revert to Scientific notation and all look the same! If you do open your CSV file in excel and you see the numbers for NHI for each employee are showing in Scientific notation, do not be concerned. If you put your cursor on one of the numbers (by selecting any cell in "Column D" in excel) and then you look at the formula bar above, you will notice that it actually is storing the number correctly because the formula bar will show the actual 14 digit Number. (The display is just in Scientific notation) If you want to verify then right-click the file and open with Notepad and then you can see the true CSV format that the NHI system wants. When you open the text file you can easily see if they are all unique NHI numbers and not duplicates. Note: You may also check your CSV file by opening the actual CSV file and putting your cursor on the NHA member ID field (eg cell D1). Then press the "down-arrow key" and move through all your data rows and you will be able to check in the display area of excel (the formula bar above) for the actual numbers and they should be 14 digits. This is how Excel actually stores those numbers.