Rolling out changes: Difference between revisions

(9 intermediate revisions by 2 users not shown)

Line 1:

Changes to the master version of [[CCMDB.~~mdb~~]] needs to be tracked in the [[Log|Change Log]] and rolled out to all locations.

Changes to the master version of [[CCMDB.accdb]] needs to be tracked in the [[Log|Change Log]] and rolled out to all locations.

== Rolling out a change to the [[CCMDB.~~mdb~~]] ==

== Rolling out a change to the [[CCMDB.accdb]] ==

This includes changes to the [[s-tables]], the graphical interface and the programming/logic.

This includes changes to the [[s-tables]], the graphical interface and the programming/logic. Usually all collectors are considered testers, but if special testing is desired, [[Beta testing]] can be used.

# Check at the top of [[Log]] to make sure no one else has un-rolled changes; if they are, coordinate with them

# Make sure the change is documented at the top of [[Log]], individual changes can be marked minor; mark as not rolled out yet at top of heading

Line 8:

# Copy the new version to the Master directory

## Open [[Regional Server]]\Programs\Master

## Rename the file ''CCMDB.~~mdb~~'' to version it, e.g. to ''CCMDB.~~mdb.pre_2010~~-01-03''; this will also prevent opening it accidentally since it removes the file association with Microsoft Access

## Rename the file ''CCMDB.accdb'' to version it, e.g. to ''CCMDB.accdb_pre_2010-01-03''; this will also prevent opening it accidentally since it removes the file association with Microsoft Access

## Move the renamed file to the ''Versions'' folder

## Copy the new version of CCMDB.~~mdb~~ to the Master directory

## Copy the new version of CCMDB.accdb to the Master directory

### open C:\ccmdb_program\ in explorer

### copy ccmbd.accdb

### open regional server\programs\master in explorer

### paste ccmdb.accdb

# Roll out the changes

## run the file '''[[updt_all.bat]]'''

Line 17:

Line 21:

== Rolling out a change to [[CCMDB_data.mdb]] ==

'''This process only works if the laptop is attached to the network the first time CCMDB.~~mdb~~ is started after the new version is downloaded. Data collectors need to be alerted of this. '''

'''This process only works if the laptop is attached to the network the first time CCMDB.accdb is started after the new version is downloaded. Data collectors need to be alerted of this. '''

This includes changes to the data structure that collected data is stored in, i.e. the [[l-tables]].

When [[CCMDB.~~mdb~~]] starts the form [[Main Form (CCMDB.~~mdb~~)|Main Form]] is opened. It's open event triggers a call to VBA function Database_Starter() in module Global_, which in turn calls function '''DB_Converter''' module DB_Converter, which checks if the current version of the [[CCMDB_data.mdb]] is as stated in that code; if not it copies down a new version and transfers the data.

When [[CCMDB.accdb]] starts the form [[Main Form (CCMDB.accdb)|Main Form]] is opened. It's open event triggers a call to VBA function Database_Starter() in module Global_, which in turn calls function '''DB_Converter''' module DB_Converter, which checks if the current version of the [[CCMDB_data.mdb]] is as stated in that code; if not it copies down a new version and transfers the data.

Of course this '''needs to be changed to accommodate the change in the data necessitated the change in the first place'''.

Line 30:

Line 34:

# update version in table A_Info

# close and '''don't copy to server yet'''

# open [[CCMDB.~~mdb~~]] and [[Log]]

# open [[CCMDB.accdb]] and [[Log]]

# change version in version table if not already done

# update the version number for ccmdb_data in Module DB_Converter, Sub Convert_DB

# check to make sure your specific change doesn't require other changes to DB_Converter

# consider whether the change will have an impact on the send queries or the structure of [[Centralized_data.~~mdb~~]] and fix if necessary

# consider whether the change will have an impact on the send queries or the structure of [[Centralized_data.accdb]] and fix if necessary

# Roll both [[CCMDB.~~mdb~~]] (see above) and [[CCMDB_data.mdb]] concurrently

# Roll both [[CCMDB.accdb]] (see above) and [[CCMDB_data.mdb]] concurrently

## copy ccmdb_data.mdb to [[Regional Server]]\data\master

## add date to the end of the name as in existing file

Line 49:

Line 53:

The next [[Pull]] will download the change to others.

== Rolling out a change to [[Centralized_data.~~mdb~~]] ==

== Rolling out a change to [[Centralized_data.accdb]] ==

Any work on Centralized_data.~~mdb~~ has to happen outside the [[Sending_Patients#Data_Collector_Sending_Frequency | send window]].

Any work on [[Centralized_data.accdb]] has to happen outside the [[Sending_Patients#Data_Collector_Sending_Frequency | send window]].

Confirm with Pagasa that she will not need the data while you are working on it.

Line 60:

Line 64:

Change the date in the ''version'' table to be the date you start this round of changes on.

Log any changes in [[~~Centralized data~~.~~mdb~~ Change Log]].

Log any changes in [[Centralized_data.accdb]] Change Log]].

If the data structure has changed, consider if changes are consistent with

* [[CCMDB_data.mdb]]

* the ''Send_centralized_*'' queries in [[CCMDB.~~mdb~~]]

* the ''Send_centralized_*'' queries in [[CCMDB.accdb]]

Compact/Repair the file.

Line 70:

Line 74:

Move the file back to its master directory.

Finalize [[~~Centralized data~~.~~mdb~~ Change Log]] and let Pagasa know there was a change.

Finalize [[Centralized_data.accdb]] Change Log]] and let Pagasa know there was a change.

[[Category: Development Documentation]]

[[Category:Development Documentation]]

@@ Line 1: / Line 1: @@
-Changes to the master version of [[CCMDB.mdb]] needs to be tracked in the [[Log|Change Log]] and rolled out to all locations.
+Changes to the master version of [[CCMDB.accdb]] needs to be tracked in the [[Log|Change Log]] and rolled out to all locations.
-== Rolling out a change to the [[CCMDB.mdb]] ==
+== Rolling out a change to the [[CCMDB.accdb]] ==
-This includes changes to the [[s-tables]], the graphical interface and the programming/logic.
+This includes changes to the [[s-tables]], the graphical interface and the programming/logic. Usually all collectors are considered testers, but if special testing is desired, [[Beta testing]] can be used.
 # Check at the top of [[Log]] to make sure no one else has un-rolled changes; if they are, coordinate with them
 # Make sure the change is documented at the top of [[Log]], individual changes can be marked minor; mark as not rolled out yet at top of heading
@@ Line 8: / Line 8: @@
 # Copy the new version to the Master directory
 ## Open [[Regional Server]]\Programs\Master
-## Rename the file ''CCMDB.mdb'' to version it, e.g. to ''CCMDB.mdb.pre_2010-01-03''; this will also prevent opening it accidentally since it removes the file association with Microsoft Access
+## Rename the file ''CCMDB.accdb'' to version it, e.g. to ''CCMDB.accdb_pre_2010-01-03''; this will also prevent opening it accidentally since it removes the file association with Microsoft Access
 ## Move the renamed file to the ''Versions'' folder
-## Copy the new version of CCMDB.mdb to the Master directory
+## Copy the new version of CCMDB.accdb to the Master directory
+### open C:\ccmdb_program\ in explorer
+### copy ccmbd.accdb
+### open regional server\programs\master in explorer
+### paste ccmdb.accdb
 # Roll out the changes
 ## run the file '''[[updt_all.bat]]'''
@@ Line 17: / Line 21: @@
 == Rolling out a change to [[CCMDB_data.mdb]] ==
-'''This process only works if the laptop is attached to the network the first time CCMDB.mdb is started after the new version is downloaded. Data collectors need to be alerted of this. '''
+'''This process only works if the laptop is attached to the network the first time CCMDB.accdb is started after the new version is downloaded. Data collectors need to be alerted of this. '''
 This includes changes to the data structure that collected data is stored in, i.e. the [[l-tables]].
-When [[CCMDB.mdb]] starts the form [[Main Form (CCMDB.mdb)|Main Form]] is opened. It's open event triggers a call to VBA function Database_Starter() in module Global_, which in turn calls function '''DB_Converter''' module DB_Converter, which checks if the current version of the [[CCMDB_data.mdb]] is as stated in that code; if not it copies down a new version and transfers the data.
+When [[CCMDB.accdb]] starts the form [[Main Form (CCMDB.accdb)|Main Form]] is opened. It's open event triggers a call to VBA function Database_Starter() in module Global_, which in turn calls function '''DB_Converter''' module DB_Converter, which checks if the current version of the [[CCMDB_data.mdb]] is as stated in that code; if not it copies down a new version and transfers the data.
 Of course this '''needs to be changed to accommodate the change in the data necessitated the change in the first place'''.
@@ Line 30: / Line 34: @@
 # update version in table A_Info
 # close and '''don't copy to server yet'''
-# open [[CCMDB.mdb]] and [[Log]]
+# open [[CCMDB.accdb]] and [[Log]]
 # change version in version table if not already done
 # update the version number for ccmdb_data in Module DB_Converter, Sub Convert_DB
 # check to make sure your specific change doesn't require other changes to DB_Converter
-# consider whether the change will have an impact on the send queries or the structure of [[Centralized_data.mdb]] and fix if necessary
+# consider whether the change will have an impact on the send queries or the structure of [[Centralized_data.accdb]] and fix if necessary
-# Roll both [[CCMDB.mdb]] (see above) and [[CCMDB_data.mdb]] concurrently
+# Roll both [[CCMDB.accdb]] (see above) and [[CCMDB_data.mdb]] concurrently
 ## copy ccmdb_data.mdb to [[Regional Server]]\data\master
 ## add date to the end of the name as in existing file
@@ Line 49: / Line 53: @@
 The next [[Pull]] will download the change to others.
-== Rolling out a change to [[Centralized_data.mdb]] ==
+== Rolling out a change to [[Centralized_data.accdb]] ==
-Any work on Centralized_data.mdb has to happen outside the [[Sending_Patients#Data_Collector_Sending_Frequency | send window]].
+Any work on [[Centralized_data.accdb]] has to happen outside the [[Sending_Patients#Data_Collector_Sending_Frequency | send window]].
 Confirm with Pagasa that she will not need the data while you are working on it.
@@ Line 60: / Line 64: @@
 Change the date in the ''version'' table to be the date you start this round of changes on.
-Log any changes in [[Centralized data.mdb Change Log]].
+Log any changes in [[Centralized_data.accdb]] Change Log]].
 If the data structure has changed, consider if changes are consistent with
 * [[CCMDB_data.mdb]]
-* the ''Send_centralized_*'' queries in [[CCMDB.mdb]]
+* the ''Send_centralized_*'' queries in [[CCMDB.accdb]]
 Compact/Repair the file.
@@ Line 70: / Line 74: @@
 Move the file back to its master directory.
-Finalize [[Centralized data.mdb Change Log]] and let Pagasa know there was a change.
+Finalize [[Centralized_data.accdb]] Change Log]] and let Pagasa know there was a change.
-[[Category: Development Documentation]]
+[[Category:Development Documentation]]