Date change bug: Difference between revisions

(11 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. --[[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.)

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

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

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

** Med_Date_Repair - contains all Med batches sent to date

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

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

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

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

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

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

== Summary ==

Line 19:

Line 46:

== Discussion ==

~~{{discussion}}~~

* Has anyone else had any weird occurrences with dates since the last roll-out? [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)

**I have noticed that some of my admit dates have changed. When I look at the profile the next day I notice that the date is either a day earlier or a day later than what I originally entered. I thought I was just making a lot of entry errors but now I think it is a glitch. I correct the date and hopefully the ones I sent are OK. I checked with Pagasa a few random ones which seem OK. The output files had already been deleted so I couldn't view my sent files. Anyway when Pagasa cross references the tiss, these errors will be evident. --[[User:LKolesar|LKolesar]] 11:16, 28 July 2011 (CDT)

Line 33:

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

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

}}

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

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

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

** 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'''.~~

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

*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~~.

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

~~[[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. --[[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.)
+* check that dates are correct for '''all patients currently on your laptop'''
+* check over all the files Pagasa has uploaded on Regional Server to:
+** CC_Date_Repair - contains all the ICU batches sent to date
+** Med_Date_Repair - contains all Med batches sent to date
+* fix any admit, transfer or discharge dates that are incorrect in these sent files
+* Let [[p:Julie Mojica]] know by EMAIL, when you have completed all corrections for your location
+** let her know which files (if any) you corrected so that Pagasa doesn't have to re-append files that had no errors.
+* 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.
+--[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)
+--- updated by [[User:Ttenbergen|Ttenbergen]] 16:31, 29 July 2011 (CDT)
 == Summary ==
@@ Line 19: / Line 46: @@
 == Discussion ==
-{{discussion}}
 * Has anyone else had any weird occurrences with dates since the last roll-out? [[User:Ttenbergen|Ttenbergen]] 10:35, 28 July 2011 (CDT)
 **I have noticed that some of my admit dates have changed. When I look at the profile the next day I notice that the date is either a day earlier or a day later than what I originally entered.  I thought I was just making a lot of entry errors but now I think it is a glitch.  I correct the date and hopefully the ones I sent are OK.  I checked with Pagasa a few random ones which seem OK.  The output files had already been deleted so I couldn't view my sent files.   Anyway when Pagasa cross references the tiss, these errors will be evident.  --[[User:LKolesar|LKolesar]] 11:16, 28 July 2011 (CDT)
@@ Line 33: / 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]]
-== The Plan to FIX Admit, transfer &amp; Discharge Date errors ==
+}}
-DATE errors could be present from any files sent from July 13.11 to date. (admit, transfer, discharge).
-*'''Error likely started in files opened in viewer on or after July 25 so data sent before this date is likely not affected.
-* Pagasa has put ALL the SENT csv files on the Regional Server from July 13.11 to date.
-** 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'''.
-**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.
-*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.
---[[User:TOstryzniuk|TOstryzniuk]] 15:46, 28 July 2011 (CDT)
-[[Category:Bugs]] [[Category:IT_Instructions]]