A DHB light surveillance user recently noted an issue when importing an MS Excel CSV file into ICNet and the date format reverting to d/mm/yyyy when imported.
To format the date correctly as 01/08/2021 when importing to SSIS from a csv file, please format the date via the following method in excel.
Highlight all 3 date columns in the spreadsheet by holding the control key and clicking the letter of the column. Once highlighted right click over the highlighted area and select format. A pop-up will show (as per screenshot). Select d/mm/yyyy from the custom category, click into the text field under Type and edit this to dd/mm/yyyy. This enforces the preceding d in the date format and correctly populates as 01-08-2021.
Save the file as a csv as per previous and import following usual processes.
The above instructions have been added as an addendum to the Data Collection Elements Document, which is hosted on the CHDB SharePoint Site under SSIS Programme -> Light Surveillance.
If there any issues with this process please raise an iSupport Ticket with the title ‘Light Surveillance – Date Format’.
If there are any Light Surveillance users missing from this email please forward this email and cc: Pip Hawker Phyllipa.Hawker@cdhb.health.nz.