Why won't my data load after I edited a CSV file (which I opened it in Excel)?
When doing a manual upload, if you open (unzip) the CSV files that you downloaded from HMIS, you will need to change the format of the date fields. If you unzip, then rezip and save the file, whether or not you change any of the data, the reports will not populate. The reason is that CSV files, when opened in Excel and saved will automatically be reformatted to the wrong date format.
To format the column(s) containing dates, click the column to select it, right click and choose "Format Cells". Click on "Custom" and then enter in "yyyy-mm-dd hh:mm:ss" as shown in the image below, and then click "OK". Once all dates have been formatted, save the file, rezip the files together, and re-attempt the upload.
NOTE: When zipping CSV files, make sure you are selecting the actual files and not the folder that the files reside in.