Re-sending data - Revision history

Ttenbergen at 18:41, 6 January 2026

2026-01-06T18:41:37Z

← Older revision		Revision as of 13:41, 6 January 2026
Line 34:		Line 34:
	=== Confirm resolution ===		=== Confirm resolution ===
	# [[pull]] the CFE		# [[pull]] the CFE
	# ~~check if there are~~ [[~~Orphans in Centralized data.accdb~~]] ~~or [[missing data]] (I think we have a page for that already)~~		# re-run [[Reconnect CFE and initial error checks]]
	# If no more data errors, then [[push]] back the CFE so collectors can [[send]].		# If no more data errors, then [[push]] back the CFE so collectors can [[send]].

	== Error Log Laptop Crashed while [[sending]] ==		== 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-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-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)		* 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.		* 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.
	~~[[User:PTorres\|PTorres]] 16:23, 3 July 2025 (CDT)~~

	== Related articles ==		== Related articles ==

Ttenbergen at 18:14, 6 January 2026

2026-01-06T18:14:01Z

← Older revision		Revision as of 13:14, 6 January 2026
Line 16:		Line 16:
	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]]
	#* this may not be the latest one since that one may have already deleted the sent files; consider the date of [[~~ssss~~]] that was restored during [[Restoring a "known good" version of the centralized data pair]]		#* 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]]'''		# '''make sure you have the latest version of [[CCMDB.accdb]]'''
	#* Go to {{Regionalserver\|Programs\Master}} and double-click on [[Copy to local.bat]]		#* Go to {{Regionalserver\|Programs\Master}} and double-click on [[Copy to local.bat]]

Ttenbergen: Text replacement - "Orphans in Centralized data.mdb" to "Orphans in Centralized data.accdb"

2025-09-29T04:25:07Z

Text replacement - "Orphans in Centralized data.mdb" to "Orphans in Centralized data.accdb"

← Older revision		Revision as of 23:25, 28 September 2025
Line 34:		Line 34:
	=== Confirm resolution ===		=== Confirm resolution ===
	# [[pull]] the CFE		# [[pull]] the CFE
	# check if there are [[Orphans in Centralized data.~~mdb~~]] or [[missing data]] (I think we have a page for that already)		# check if there are [[Orphans in Centralized data.accdb]] or [[missing data]] (I think we have a page for that already)
	# If no more data errors, then [[push]] back the CFE so collectors can [[send]].		# If no more data errors, then [[push]] back the CFE so collectors can [[send]].

Ttenbergen: Text replacement - "[[Category: " to "[[Category:"

2025-07-30T16:55:41Z

Text replacement - "[[Category: " to "[[Category:"

← Older revision		Revision as of 11:55, 30 July 2025
Line 52:		Line 52:


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

Ttenbergen: Text replacement - "#Prepare [[Centralized_data.accdb]]" to "#Prepare Centralized_data.accdb"

2025-07-23T21:43:26Z

Text replacement - "[[#Prepare Centralized_data.accdb]]" to "#Prepare Centralized_data.accdb"

← Older revision		Revision as of 16:43, 23 July 2025
Line 30:		Line 30:
	# press "OK"		# press "OK"

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

	=== Confirm resolution ===		=== Confirm resolution ===

Ttenbergen at 21:30, 23 July 2025

2025-07-23T21:30:47Z

← Older revision		Revision as of 16:30, 23 July 2025
Line 7:		Line 7:
	==== Prepare ====		==== Prepare ====
	* [[Determine which sends have failed and need to be re-sent]]		* [[Determine which sends have failed and need to be re-sent]]
	* possibly [[]]		* possibly [[Restoring a "known good" version of the centralized data pair]]]



	==== Set records to incomplete ====		==== Set records to incomplete ====
Line 18:		Line 16:
	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]]
			#* this may not be the latest one since that one may have already deleted the sent files; consider the date of [[ssss]] that was restored during [[Restoring a "known good" version of the centralized data pair]]
	# '''make sure you have the latest version of [[CCMDB.accdb]]'''		# '''make sure you have the latest version of [[CCMDB.accdb]]'''
	#* Go to {{Regionalserver\|Programs\Master}} and double-click on [[Copy to local.bat]]		#* Go to {{Regionalserver\|Programs\Master}} and double-click on [[Copy to local.bat]]
Line 33:		Line 32:
	If you get a duplicate error you probably didn't follow [[#Prepare [[Centralized_data.accdb]]]].		If you get a duplicate error you probably didn't follow [[#Prepare [[Centralized_data.accdb]]]].

	=== Error Log Laptop Crashed while [[sending]] ===		=== Confirm resolution ===
			# [[pull]] the CFE
			# check if there are [[Orphans in Centralized data.mdb]] or [[missing data]] (I think we have a page for that already)
			# 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 30 - Problem with S6 laptop corrupted. It took 2 hours to fix it. (S6 was [[sending]] in the office)

Ttenbergen: Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"

2025-07-23T19:52:19Z

Text replacement - "Centralized data.accdb" to "Centralized_data.accdb"

← Older revision		Revision as of 14:52, 23 July 2025
Line 2:		Line 2:

	== Steps ==		== Steps ==
	=== Prepare [[~~Centralized data~~.accdb]] - done by 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=		{{Collapsable \| always= hiding these steps so they don't confuse collectors who don't need to do these steps \| full=

Line 12:		Line 12:

	==== Set records to incomplete ====		==== Set records to incomplete ====
	#in [[~~Centralized data~~.accdb]], on {{Regionalserver\|output}}, set the [[RecordStatus field]] to '''"Incomplete"''' for the records you will re-send		#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		#* 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

Line 31:		Line 31:
	# press "OK"		# press "OK"

	If you get a duplicate error you probably didn't follow [[#Prepare [[~~Centralized data~~.accdb]]]].		If you get a duplicate error you probably didn't follow [[#Prepare [[Centralized_data.accdb]]]].

	=== Error Log Laptop Crashed while [[sending]] ===		=== Error Log Laptop Crashed while [[sending]] ===
Line 41:		Line 41:


	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.		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)		[[User:PTorres\|PTorres]] 16:23, 3 July 2025 (CDT)

Ttenbergen: Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

2025-07-23T19:44:34Z

Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

← Older revision		Revision as of 14:44, 23 July 2025
Line 31:		Line 31:
	# 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]]]].

	=== Error Log Laptop Crashed while [[sending]] ===		=== Error Log Laptop Crashed while [[sending]] ===

Ttenbergen: /* Prepare Centralized data.mdb - done by data processor */

2025-07-23T19:42:21Z

Prepare Centralized data.mdb - done by data processor

← Older revision		Revision as of 14:42, 23 July 2025
Line 5:		Line 5:
	{{Collapsable \| always= hiding these steps so they don't confuse collectors who don't need to do these steps \| full=		{{Collapsable \| always= hiding these steps so they don't confuse collectors who don't need to do these steps \| full=

	==== ~~Determine which laptops need to re-send~~ ====		==== Prepare ====
	* [[Determine which sends have failed and need to be re-sent]]		* [[Determine which sends have failed and need to be re-sent]]
			* possibly [[]]



	==== Set records to incomplete ====		==== Set records to incomplete ====

Ttenbergen: Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

2025-07-23T19:40:59Z

Text replacement - "Centralized data.mdb" to "Centralized data.accdb"

← Older revision		Revision as of 14:40, 23 July 2025
Line 2:		Line 2:

	== Steps ==		== Steps ==
	=== Prepare [[Centralized data.~~mdb~~]] - done by 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=		{{Collapsable \| always= hiding these steps so they don't confuse collectors who don't need to do these steps \| full=

Line 9:		Line 9:

	==== Set records to incomplete ====		==== Set records to incomplete ====
	#in [[Centralized data.~~mdb~~]], on {{Regionalserver\|output}}, set the [[RecordStatus field]] to '''"Incomplete"''' for the records you will re-send		#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		#* 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

Line 38:		Line 38:


	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.~~mdb~~]] and [[PHI.mdb]]. If any data got sent, those records need to be resent.		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)		[[User:PTorres\|PTorres]] 16:23, 3 July 2025 (CDT)