Date change bug: Difference between revisions

(8 intermediate revisions by 2 users not shown)

Line 1:

Hazel from the Vic just reported (Thanks for letting me know! [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after [[Log#ver_2011-07-25 |ver_2011-07-25]] went out. This may be related to the buttons I added to the date fields in [[[[Log#ver_2011-07-13 |ver_2011-07-13]]

{{Collapsable

| always= this was only relevant at the time, CCMDB was changed to prevent the accidental click that messed this up

| full=

Hazel from the Vic just reported (Thanks for letting me know! [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after [[Log#ver_2011-07-25 |ver_2011-07-25]] went out. This may be related to the buttons I added to the date fields in [[Log#ver_2011-07-13 |ver_2011-07-13]]

Apparently Hazel sent data Jul 27, and when she looked at the data this morning some of the dates had changed. Some of them had changed to dates that our error checker should not have let through, which is even more concerning.

Line 7:

Line 11:

** I moved the dates over to the right by a few pixels so they no longer overlap with the binocular buttons. Rolled out as [[CCMDB.mdb_Change_Log_2011#ver_2011-07-29]]

**'''Let me know if this appears to still be a problem.'''

*'''Let me know if this appears to still be a problem.'''

***Good work!! That is great. ~~Staff will still have to check their send files and dates currently on laptop back to July 13th to date since buttons for dates were added on July 13th.~~ --[[User:TOstryzniuk|TOstryzniuk]] 16:16, 29 July 2011 (CDT)

*Good work!! That is great. --[[User:TOstryzniuk|TOstryzniuk]] 16:44, 29 July 2011 (CDT)

== The Plan to FIX Admit, transfer & Discharge Date errors ==

IMPORTANT: Please do the following to fix the fall-out of this bug:

* '''make sure you download ver 2011-07-29 or newer using news-and-backup'''(you see the version date by the reset button on your main screen when you open CCMDB.)

~~DATE errors could be present from any files sent from July 13.11 to date. (admit, transfer, discharge).~~

* check that dates are correct for '''all patients currently on your laptop'''

* check over all the files Pagasa has uploaded on Regional Server to:

*'''~~Error likely started in files opened in viewer~~ on ~~or after July 25 so data sent before this date is likely not affected.~~

** CC_Date_Repair - contains all the ICU batches sent to date

** Med_Date_Repair - contains all Med batches sent to date

* Pagasa has ~~put ALL the SENT csv files~~ on ~~the~~ Regional Server ~~from July 13.11~~ to ~~date.~~

* fix any admit, transfer or discharge dates that are incorrect in these sent files

** CC_Date_Repair - contains all the ICU batches sent to date.

** Med_Date_Repair - contains all Med batches sent to date.

*~~DATA COLLECTORS~~: ~~Please check~~ all your ~~sent CSV files on the Regional Server against your paper ADMIT LOG. '''Also, for any data SENT or ADDED to laptop ON or AFTER the roll out of version on July 25.11,''' check '''all dates'''.~~

* Let [[p:Julie Mojica]] know by EMAIL, when you have completed all corrections for your location

**~~For any data files <u>send</u> BEFORE July 25th, do a random check of dates. It is likely these~~ files ~~are not be affected.~~

** let her know which files (if any) you corrected so that Pagasa doesn't have to re-append files that had no errors.

*Make any ~~required DATE corrections '''directly on the CSV file on the Regional Server''~~'.

*~~Let JULIE know by EMAIL, when you~~ have completed ~~all corrections for your location~~.

* Pagasa will re-append and overwrite erroneous data into the master database repository.

* Pagasa will not correct these DATE errors manually. The Collectors will have to fix the CSV files on Regional Server.

* TISS will be scanned in after all correction to DATES are completed.

*Pagasa will re-append and overwrite erroneous data into the master database repository.

--[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)

*Pagasa will not correct these DATE errors manually. The Collectors will have to fix the CSV files on Regional Server.

--- updated by [[User:Ttenbergen|Ttenbergen]] 16:31, 29 July 2011 (CDT)

*TISS will be scanned in after all correction to DATES are completed.

--[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)

== Summary ==

Line 56:

Line 59:

* OK, can make an error happen if I enter a date that would be rejected (e.g. dis. dt before adm. dt) manually (no buttons), and then click the exit door without exiting the field first. For me that error means I can't exit at all, so I am not sure if that would be how bad data gets in... [[User:Ttenbergen|Ttenbergen]] 10:58, 28 July 2011 (CDT)

* I think it was a problem with the order in which the program writes and checks values. I made some changes and '''hope that the problem is resolved with [[CCMDB.mdb_Change_Log_2011#ver_2011-07-28]]'''. Please do a News&backup to download, and '''let me know if this problem persists.''' [[User:Ttenbergen|Ttenbergen]] 12:45, 28 July 2011 (CDT)

*problem not resolved in July 28 version.

*problem seemed to be resolved in July 29 version. [[CCMDB.mdb_Change_Log_2011#ver_2011-07-29]]

}}

[[~~Category:Bugs]] [[Category:IT_Instructions~~]]

@@ Line 1: / Line 1: @@
-Hazel from the Vic just reported (Thanks for letting me know! [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after [[Log#ver_2011-07-25 |ver_2011-07-25]] went out. This may be related to the buttons I added to the date fields in [[[[Log#ver_2011-07-13 |ver_2011-07-13]]
+{{fixed bug}}
+{{Collapsable
+| always= this was only relevant at the time, CCMDB was changed to prevent the accidental click that messed this up
+| full=
+Hazel from the Vic just reported (Thanks for letting me know! [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)) that she has had dates change on their own after [[Log#ver_2011-07-25 |ver_2011-07-25]] went out. This may be related to the buttons I added to the date fields in [[Log#ver_2011-07-13 |ver_2011-07-13]]
 Apparently Hazel sent data Jul 27, and when she looked at the data this morning some of the dates had changed. Some of them had changed to dates that our error checker should not have let through, which is even more concerning.
@@ Line 7: / Line 11: @@
 ** I moved the dates over to the right by a few pixels so they no longer overlap with the binocular buttons. Rolled out as [[CCMDB.mdb_Change_Log_2011#ver_2011-07-29]]
-**'''Let me know if this appears to still be a problem.'''
+*'''Let me know if this appears to still be a problem.'''
-***Good work!!  That is great.  Staff will still have to check their send files and dates currently on laptop back to July 13th to date since buttons for dates were added on July 13th.  --[[User:TOstryzniuk|TOstryzniuk]] 16:16, 29 July 2011 (CDT)
+*Good work!!  That is great. --[[User:TOstryzniuk|TOstryzniuk]] 16:44, 29 July 2011 (CDT)
 == The Plan to FIX Admit, transfer &amp; Discharge Date errors ==
+IMPORTANT: Please do the following to fix the fall-out of this bug:
+* '''make sure you download ver 2011-07-29 or newer using news-and-backup'''(you see the version date by the reset button on your main screen when you open CCMDB.)
-DATE errors could be present from any files sent from July 13.11 to date. (admit, transfer, discharge).
+* check that dates are correct for '''all patients currently on your laptop'''
+* check over all the files Pagasa has uploaded on Regional Server to:
-*'''Error likely started in files opened in viewer on or after July 25 so data sent before this date is likely not affected.
+** CC_Date_Repair - contains all the ICU batches sent to date
+** Med_Date_Repair - contains all Med batches sent to date
-* Pagasa has put ALL the SENT csv files on the Regional Server from July 13.11 to date.
+* fix any admit, transfer or discharge dates that are incorrect in these sent files
-** CC_Date_Repair - contains all the ICU batches sent to date.
-** Med_Date_Repair - contains all Med batches sent to date.
-*DATA COLLECTORS: Please check all your sent CSV files on the Regional Server against your paper ADMIT LOG. '''Also, for any data SENT or ADDED to laptop ON or AFTER the roll out of version on July 25.11,''' check '''all dates'''.
+* Let [[p:Julie Mojica]] know by EMAIL, when you have completed all corrections for your location
-**For any data files <u>send</u> BEFORE July 25th, do a random check of dates. It is likely these files are not be affected.
+** let her know which files (if any) you corrected so that Pagasa doesn't have to re-append files that had no errors.
-*Make any required DATE corrections '''directly on the CSV file on the Regional Server'''.
-*Let JULIE know by EMAIL, when you have completed all corrections for your location.
+* Pagasa will re-append and overwrite erroneous data into the master database repository.
+* Pagasa will not correct these DATE errors manually. The Collectors will have to fix the CSV files on Regional Server.
+* TISS will be scanned in after all correction to DATES are completed.
-*Pagasa will re-append and overwrite erroneous data into the master database repository.
+--[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)
-*Pagasa will not correct these DATE errors manually. The Collectors will have to fix the CSV files on Regional Server.
+--- updated by [[User:Ttenbergen|Ttenbergen]] 16:31, 29 July 2011 (CDT)
-*TISS will be scanned in after all correction to DATES are completed.
---[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)
 == Summary ==
@@ Line 56: / Line 59: @@
 * OK, can make an error happen if I enter a date that would be rejected (e.g. dis. dt before adm. dt) manually (no buttons), and then click the exit door without exiting the field first. For me that error means I can't exit at all, so I am not sure if that would be how bad data gets in... [[User:Ttenbergen|Ttenbergen]] 10:58, 28 July 2011 (CDT)
 * I think it was a problem with the order in which the program writes and checks values. I made some changes and '''hope that the problem is resolved with [[CCMDB.mdb_Change_Log_2011#ver_2011-07-28]]'''. Please do a News&backup to download, and '''let me know if this problem persists.''' [[User:Ttenbergen|Ttenbergen]] 12:45, 28 July 2011 (CDT)
+*problem not resolved in July 28 version.
+*problem seemed to be resolved in July 29 version. [[CCMDB.mdb_Change_Log_2011#ver_2011-07-29]]
+}}
-[[Category:Bugs]] [[Category:IT_Instructions]]