Re-sending data

This page explains how one would re-send previously sent data. There are extra steps if this is done by the Data processor, which are masked by the collapsible below.

Steps

Prepare Centralized_data.accdb - done by data processor

hiding these steps so they don't confuse collectors who don't need to do these steps

Prepare Determine which sends have failed and need to be re-sent possibly Restoring a "known good" version of the centralized data pair] Set records to incomplete in Centralized_data.accdb, on Regional Server\​output\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\output , set the RecordStatus field to "Incomplete" for the records you will re-send this would be done by the Data processor, so if a Data collector needs to re-send they need to contact the Data processor to do this; make sure you provide the Service/Location and Pat_ID of the patients Additional step if Data processor is sending Copy the backup data to the PC: find a copy of collector's backup CCMDB data on the Regional server, and follow CCMDB data.mdb restore from Regional Server this may not be the latest one since that one may have already deleted the sent files; consider the date of Centralized_data.accdb that was restored during Restoring a "known good" version of the centralized data pair make sure you have the latest version of CCMDB.accdb Go to Regional Server\​Programs\Master\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Programs\Master and double-click on Copy to local.bat

Re-send

This step may be done by the data collector, or it may be done by the data processor.

1. Open CCMDB.accdb
2. review patient list to ensure you have the version of the patients you want to resend (only applies when dealing with restored data)
3. set the patient RecordStatus field to "complete" from "sent"
4. Press the Send Records button
5. press "OK" and type in your own First Name_RESEND, example: Suzie_Resend
6. press "OK"

If you get a duplicate error you probably didn't follow #Prepare Centralized_data.accdb.

Confirm resolution

1. pull the CFE
2. check if there are Orphans in Centralized data.accdb or missing data (I think we have a page for that already)
3. If no more data errors, then push back the CFE so collectors can send.

Error Log Laptop Crashed while sending

• 2025 06 30 - Problem with S6 laptop corrupted. It took 2 hours to fix it. (S6 was sending in the office)
• 2025 06 09 - Problem with H7 laptop corrupted. It took a day to fix (Pagasa sent records)
• 2025 02 14 - Problem with S8 laptop corrupted. It took a day to fix (Pagasa sent records)
• 2024 11 18 - Problem with H3 and S9 corrupted both laptops sending at the same time.

Laptop crashed while sending / Breaking out of a frozen program /Lccmdb and ldb files system of problems. To fix, we need to restore from backup Centralized_data.accdb and PHI.mdb. If any data got sent, those records need to be resent. PTorres 16:23, 3 July 2025 (CDT)