Re-sending data: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.mdb" to "Centralized data.accdb" |
Ttenbergen (talk | contribs) No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
== Steps == | == Steps == | ||
=== Prepare [[ | === 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= | ||
==== 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 ==== | ||
#in [[ | #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 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 [[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]] | ||
| Line 31: | Line 30: | ||
# press "OK" | # press "OK" | ||
If you get a duplicate error you probably didn't follow [[#Prepare | 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]]. | |||
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 [[ | == Error Log Laptop Crashed while [[sending]] == | ||
[[User:PTorres|PTorres]] 16:23, 3 July 2025 (CDT) | * 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 48: | Line 48: | ||
[[Category: CCMDB.accdb]] | [[Category:CCMDB.accdb]] | ||
[[Category: Data Processing]] | [[Category:Data Processing]] | ||
[[Category: Backup]] | [[Category:Backup]] | ||
[[Category: Re-sending]] | [[Category:Re-sending]] | ||