Re-sending data: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Ttenbergen (talk | contribs)
CCMDB_legit, admin, approved, Bureaucrats, Interface administrators, Administrators (Semantic MediaWiki), Curators (Semantic MediaWiki), Administrators
92,577 edits
PTorres (talk | contribs)
CCMDB_legit, approved
1,624 edits
No edit summary
No edit summary
 
(37 intermediate revisions by 2 users not shown)
Line 1: Line 1:
This page explains how one would re-send previously sent data. There are extra steps if this is done by the [[Data processor]]. This preetty much only needs to be done as part of [[Cleaning up a failed send]].
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 ==  
== Steps ==  
=== Steps only required for [[Data processor]] ===
=== Prepare [[Centralized_data.accdb]] - done by data processor ===
{{Collapsable | always= hiding these steps so they don't confuse collectors who don't need to do these steps | full=
 
==== 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 {{Regionalserver|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:  
Copy the backup data to the PC:  
#find a '''copy of collector's backup''' [[CCMDB data.mdb | CCMDB]] data on the Regional server, and follow [[CCMDB data.mdb restore from Regional Server]]
#find a '''copy of collector's backup''' [[CCMDB data.mdb | CCMDB]] data on the Regional server, and follow [[CCMDB data.mdb restore from Regional Server]]
# '''make sure you have the latest version of [[CCMDB.mdb]]'''
#* 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]]
#* Go to {{Regionalserver|Programs\Master}} and double-click on [[Copy to local.bat]]
# '''make sure you have the latest version of [[CCMDB.accdb]]'''
 
#* Go to {{Regionalserver|Programs\Master}} and double-click on [[Copy to local.bat]]  
=== Steps required to re-send ===
}}
==== Prepare [[Centralized data.mdb]] ====
#in [[Centralized data.mdb]], on {{Regionalserver|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


==== Re-send ====
=== Re-send ===
# Open CCMDB.mdb
This step may be done by the data collector, or it may be done by the data processor.
# Open CCMDB.accdb
# review patient list to ensure you have the version of the patients you want to resend (only applies when dealing with restored data)
# review patient list to ensure you have the version of the patients you want to resend (only applies when dealing with restored data)
# '''set the patient [[RecordStatus field]] to "complete" from "sent"'''
# '''set the patient [[RecordStatus field]] to "complete" from "sent"'''
Line 21: Line 30:
# press "OK"  
# press "OK"  


If you get a duplicate error you probably didn't follow [[#Prepare [[Centralized data.mdb]]]].
If you get a duplicate error you probably didn't follow [[#Prepare Centralized_data.accdb]].
 
=== Confirm resolution ===
# [[pull]] the CFE
# re-run [[Reconnect CFE and initial error checks]]
# If no more data errors, then [[push]] back the CFE so collectors can [[send]].
 
== Error Log Laptop Crashed while [[sending]] ==
* 2025-07-03 - 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. [[User:PTorres|PTorres]] 16:23, 3 July 2025 (CDT)
*  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.  


== Related articles ==
== Related articles ==
Line 27: Line 48:




[[Category: CCMDB.mdb]]
[[Category:CCMDB.accdb]]
[[Category: Data Processing]]
[[Category:Data Processing]]
[[Category: Backup]]
[[Category:Backup]]
[[Category: Re-sending]]
[[Category:Re-sending]]

Latest revision as of 13:41, 6 January 2026

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

Set records to incomplete

  1. 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

Additional step if Data processor is sending

Copy the backup data to the PC:

  1. find a copy of collector's backup CCMDB data on the Regional server, and follow CCMDB data.mdb restore from Regional Server
  2. make sure you have the latest version of CCMDB.accdb

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. re-run Reconnect CFE and initial error checks
  3. If no more data errors, then push back the CFE so collectors can send.

Error Log Laptop Crashed while sending

  • 2025-07-03 - 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)
  • 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.
Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Re-sending_data&oldid=168350"