What happens if my NAPSA CSV or other excel export files do not look in the right format?

Sometimes due to a wrong setting on your windows computer, the NAPSA csv or other excel export files do not look in the right format. If you open a CSV file you see your data is not stored neatly in each excel column then your CSV settings are wrong for your Microsoft windows settings on your computer. ie you see all your text but not in the excel columns. Microsoft Excel will open .csv files, but depending on the system's regional settings, it may expect a semicolon as a separator instead of a comma, since in some languages the comma is used as the decimal separator. You can change this via control panel of your computer as follows: To fix this: Change the separator in a CSV text file Click the Windows Start menu. Click Control Panel. Open the Regional and Language Options dialog box. Click the Regional Options Tab. Note: Make sure the region is either Zambia or United Kingdom. Do not use South Africa. Click Customize / Additional settings (Win10). Type a comma, ie the , key in the new separator in the List-separator box. Click OK twice. Then restart your internet browser and redo the export of the file (eg NHIS) from Harvester online. What about Mac users? Here you need to go to settings on your Mac computer and then look for the Language and Region Settings. Make sure the region is either Zambia or United Kingdom. Do not use a region like South Africa or your CSV file will save with semicolons and not the standard comma. If the regional setting is wrong, MAC book computers will also save the CSV file with comma instead of a decimal point for the actual values eg 170,59 instead of 170.59 This is also a sign that your Region Settings are wrong. We work with decimals and not commas for numeric values! The comma must NOT be used as the decimal separator. After the regional settings are fixed, restart your internet browser and redo the export of the file (eg NHIS) from Harvester online. On an Apple computer once you have the NHIS file saved as an excel file then do the following: Make sure you have the file you want to export open in Numbers. (This is the standard Apple version of the Excel Microsoft Excel Application) 1) Choose the File and then select "Export To", then select the format you want (which will be CSV). Note: From the Export Your Spreadsheet window, you can choose a different format or set up any additional options. ... 2) Click Next. 3) Enter a name for your file and select a folder to save it to. 4) Click Export. Sometimes you may find that you still get certain columns of data, like the Employee number on the NHIS upload report, reverting to a scientific notation format where it does not show the actual number. If you literally upload the exported CSV file(without first opening the CSV file) then the upload file should work as it is. If this does not seem to work, then open the exported CSV file in Excel and then use the Excel program to save as a CSV file type. This process will often fix such "format errors" with CSV files. Also note there could be an error that is not related to the format of your upload file: If you see an error code on MTN with Status : "Creation failed" and Reason: "Row number##,,Internal error" then there may be a problem with the actual phone number of one of your employees. An "inactive cellphone number" will prevent the whole batch from completing without errors. Contact MTN and ask for them to help you identify which is the problematic cellphone number and then delete the appropriate row in a program such as "Notepad".