Re-sending data: Difference between revisions

(44 intermediate revisions by 3 users not shown)

Line 1:

~~For a collector or data processor to~~ re-send ~~a patient~~, ~~you need to do~~ the ~~following:~~

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.

# [[~~Data processor~~]] ~~needs~~ to ~~edit~~ [[~~CFE]] to set the patients~~ to be re-sent ~~to have~~ [[~~RecordStatus~~]] = ~~Incomplete~~

== Steps ==

# '''~~Processor only~~'''~~: download~~ the ~~newest version~~ of the ~~CCMDB.mbd (can use~~ [[Copy to ~~local.bat]])~~

=== Prepare [[Centralized_data.accdb]] - done by data processor ===

# '''~~Processor only~~'''~~: if processor is one resending~~, ~~perform~~ [[CCMDB data.mdb restore from Regional Server]] ~~for location to re-send~~

{{Collapsable | always= hiding these steps so they don't confuse collectors who don't need to do these steps | full=

# ~~Open~~ CCMDB.~~mdb~~ and ~~set the patient~~ [[~~RecordStatus field~~]] ~~to "complete" from "sent"~~

# ~~look at~~ patient list to ensure you have the version of the patients you want to resend

==== 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:

#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]]

#* 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 {{Regionalserver|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.

# 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)

# '''set the patient [[RecordStatus field]] to "complete" from "sent"'''

# Press the Send Records button

# press "OK" and type in your own First Name_RESEND, example: Suzie_Resend

# press "OK."

# press "OK"

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 ==

[[Category: CCMDB.~~mdb~~]]

[[Category:CCMDB.accdb]]

[[Category: Data Processing]]

[[Category:Data Processing]]

[[Category: Backup]]

[[Category:Backup]]

[[Category: Re-sending]]

[[Category:Re-sending]]

@@ Line 1: / Line 1: @@
-For a collector or data processor to re-send a patient, you need to do the following:
+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.
-# [[Data processor]] needs to edit [[CFE]] to set the patients to be re-sent to have [[RecordStatus]] = Incomplete
+== Steps ==
-# '''Processor only''': download the newest version of the CCMDB.mbd (can use [[Copy to local.bat]])
+=== Prepare [[Centralized_data.accdb]] - done by data processor ===
-# '''Processor only''': if processor is one resending,  perform [[CCMDB data.mdb restore from Regional Server]] for location to re-send
+{{Collapsable | always= hiding these steps so they don't confuse collectors who don't need to do these steps | full=
-# Open CCMDB.mdb and set the patient [[RecordStatus field]] to "complete" from "sent"
-# look at patient list to ensure you have the version of the patients you want to resend
+==== 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:
+#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]]
+#* 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 {{Regionalserver|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.
+# 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)
+# '''set the patient [[RecordStatus field]] to "complete" from "sent"'''
 # Press the Send Records button
 # press "OK" and type in your own First Name_RESEND, example: Suzie_Resend
-# press "OK."
+# press "OK"
+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}}
-[[Category: CCMDB.mdb]]
+[[Category:CCMDB.accdb]]
-[[Category: Data Processing]]
+[[Category:Data Processing]]
-[[Category: Backup]]
+[[Category:Backup]]
-[[Category: Re-sending]]
+[[Category:Re-sending]]