Manitoba Health "Conditioner": Difference between revisions

Line 85:

=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from TEXT ~~to NUMERIC~~=

=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from NUMERIC to TEXT=

* MHSC- "OUT" (is the file which is '''returned''' from MB Health)

* MHSC- "OUT" -is the name of the file which is '''returned''' from MB Health.

**(when we ~~sent out~~ data to MB Health, the HSC ~~column~~ of data for PHIN and DOB is justified to the ~~right (NUMERIC~~). When data file is returned from ~~MBH~~, the HSC column of data for PHIN and DOB is ~~now justified~~ to ~~left~~ (~~changed~~ to ~~TXT~~).

**when we '''send''' data to MB Health, the HSC columns of data for '''PHIN''' and DOB are '''NUMERIC''' (justified to the RIGHT).

* ~~'''For~~ MB ~~Conditioner Program to work the following~~ columns of data ~~must be checked:~~

**When data file is '''returned''' from MB Health, the HSC column of data for '''PHIN''' is '''retained as NUMERIC''' and the '''DOB''' is '''changed to TEXT''' (justified to LEFT).

~~'''~~

**MB Health columns of data for MB_PHIN and MB_DOB columns of data are both TEXT (justified to LEFT)

* "OUR" column for ~~PHIN & DOB should be justified Left~~ (~~TXT).~~

* "MHSC" column for PHIN & DOB should be justified ~~Left (TXT~~).

* '''For MB Conditioner Program to work the following columns of data must be checked''':

#the HSC column for PHIN must be changed to TEXT (justified to left).[[User:TOstryzniuk|TOstryzniuk]] 14:22, 23 June 2009 (CDT)

If conditioner doesn't run with the above fix then check the following:

#the "HSC" column for '''PHIN''' & '''DOB''' should both be TEXT (justified to the LEFT).

#"MHSC" column for MB_PHIN & MB_DOB should both be TEXT (justified LEFT).

#Header Row must be the same. (Pagasa copies header row from previous MBH OUT to current MBH OUT. Save. Exit. Now run MB Conditioner).

*NOTE: Julie's comment:

Line 102:

Line 107:

*NOTE: that if number field has a small '''green tag''' in it, click on that. It is a comment for that field. It will tell you that the number is stored as a TEXT. [[User:TOstryzniuk|TOstryzniuk]] 18:41, 23 January 2009 (CST)

~~{{Discussion}}~~

**Julie, I had a looked at the AVoutput.xls and noticed that the MH_PHIN and MH_DOB columns are also stored as TEXT? Why would they store a number as a text? How does does the MHSC Conditioner Program compare a numeric field (our DOB & PHIN) against a Text field (MH_DOB & PHIN)? [[User:TOstryzniuk|TOstryzniuk]] 20:55, 22 January 2009

*for MHSC output.xls

Line 111:

Line 114:

*2 problems:

# DOB is changed to YYYY-M-D back from the original M/D/YYYY that we sent them.

# DOB and PHIN columns are ~~formatted as~~ text ~~instead of numeric~~.

# DOB and PHIN columns of data are not sent back in consistent format. e.g. HSC PHIN is numeric and MB_PHIN is text format.

*the ACCESS "Conditioner Program" will not run if we don't restore the correct format of these columns.

Line 127:

Line 130:

#Press FINISH

B. how to change "our" PHIN column format from text ~~to numeric.~~

B. how to change "our" PHIN column format from '''numeric''' to text:

#Open MHSC_out.xls file

#Select the whole ~~DOB~~ column (this is "our" ~~DOB~~ column, not the ~~MH_DOB~~ column)

#Select the whole PHIN column (this is "our" PHIN column, not the MH_PHIN column)

#Go to DATA menu tab at top of EXCEL screen

#Select "text to column" from drop down menu

Line 141:

Line 144:

[[User:TOstryzniuk|TOstryzniuk]] 20:06, 19 November 2008 (CST)

[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED

[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED.

*Pagasa need to include steps to change PHIN column from TXT to numeric. I really need some input from Julie or Pagasa here if they feel there are changes that can be made here to help others who might have to run this program. Thanks!![[User:TOstryzniuk|TOstryzniuk]] 18:13, 23 January 2009 (CST)

==Discussion==

@@ Line 85: / Line 85: @@
-=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from TEXT to NUMERIC=
+=INSTRUCTION for changing the format of a COLUMN of data in EXCEL from NUMERIC to TEXT=
-* MHSC- "OUT" (is the file which is '''returned''' from MB Health)
+* MHSC- "OUT" -is the name of the file which is '''returned''' from MB Health.
-**(when we sent out data to MB Health, the HSC column of data for PHIN and DOB is justified to the right (NUMERIC).  When data file is returned from MBH, the HSC column of data for PHIN and DOB is now justified to left (changed to TXT).
+**when we '''send''' data to MB Health, the HSC columns of data for '''PHIN''' and DOB are '''NUMERIC''' (justified to the RIGHT).
-* '''For MB Conditioner Program to work the following columns of data must be checked:
+**When data file is '''returned''' from MB Health, the HSC column of data for '''PHIN''' is '''retained as NUMERIC''' and the '''DOB''' is '''changed to TEXT''' (justified to LEFT).
-'''
+**MB Health columns of data for MB_PHIN and MB_DOB columns of data are both TEXT (justified to LEFT)
-* "OUR" column for PHIN & DOB should be justified Left (TXT).
-* "MHSC" column for PHIN & DOB  should be justified Left (TXT).
+* '''For MB Conditioner Program to work the following columns of data must be checked''':
+#the HSC column for PHIN must be changed to TEXT (justified to left).[[User:TOstryzniuk|TOstryzniuk]] 14:22, 23 June 2009 (CDT)
+If conditioner doesn't run with the above fix then check the following:
+#the "HSC" column for '''PHIN''' & '''DOB''' should both be TEXT (justified to the LEFT).
+#"MHSC" column for MB_PHIN & MB_DOB  should both be TEXT (justified LEFT).
+#Header Row must be the same.  (Pagasa copies header row from previous MBH OUT to current MBH OUT.   Save. Exit.  Now run MB Conditioner).
 *NOTE:  Julie's comment:
@@ Line 102: / Line 107: @@
 *NOTE:  that if number field has a small '''green tag''' in it, click on that.  It is a comment for that field.  It will tell you that the number is stored as a TEXT. [[User:TOstryzniuk|TOstryzniuk]] 18:41, 23 January 2009 (CST)
-{{Discussion}}
-**Julie, I had a looked at the AVoutput.xls and noticed that the MH_PHIN and MH_DOB columns are also stored as TEXT? Why would they store a number as a text? How does does the MHSC Conditioner Program compare a numeric field (our DOB & PHIN) against a Text field (MH_DOB & PHIN)? [[User:TOstryzniuk|TOstryzniuk]] 20:55, 22 January 2009
 *for MHSC output.xls
@@ Line 111: / Line 114: @@
 *2 problems:
 # DOB is changed to YYYY-M-D back from the original M/D/YYYY that we sent them.
-# DOB and PHIN columns are formatted as text instead of numeric.
+# DOB and PHIN columns of data are not sent back in consistent format. e.g. HSC PHIN is numeric and MB_PHIN is text format.
 *the ACCESS "Conditioner Program" will not run if we don't restore the correct format of these columns.
@@ Line 127: / Line 130: @@
 #Press FINISH
-B. how to change "our" PHIN column format from text to numeric.
+B. how to change "our" PHIN column format from '''numeric''' to text:
 #Open MHSC_out.xls file
-#Select the whole DOB column (this is "our" DOB column, not the MH_DOB column)
+#Select the whole PHIN column (this is "our" PHIN column, not the MH_PHIN column)
 #Go to DATA menu tab at top of EXCEL screen
 #Select "text to column" from drop down menu
@@ Line 141: / Line 144: @@
 [[User:TOstryzniuk|TOstryzniuk]] 20:06, 19 November 2008 (CST)
-[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED
+[[User:TOstryzniuk|TOstryzniuk]] 20:49, 22 January 2009 (CST)UPDATED.
-*Pagasa need to include steps to change PHIN column from TXT to numeric. I really need some input from Julie or Pagasa here if they feel there are changes that can be made here to help others who might have to run this program. Thanks!![[User:TOstryzniuk|TOstryzniuk]] 18:13, 23 January 2009 (CST)
 ==Discussion==