Rolling out changes: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "Centralized_data.mdb" to "Centralized data.accdb" |
Ttenbergen (talk | contribs) m Text replacement - "Centralized data.accdb" to "Centralized_data.accdb" |
||
| Line 38: | Line 38: | ||
# update the version number for ccmdb_data in Module DB_Converter, Sub Convert_DB | # 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 | # 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 [[[[ | # 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.accdb]] (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 | ## copy ccmdb_data.mdb to [[Regional Server]]\data\master | ||
| Line 53: | Line 53: | ||
The next [[Pull]] will download the change to others. | The next [[Pull]] will download the change to others. | ||
== Rolling out a change to [[[[ | == Rolling out a change to [[[[Centralized_data.accdb]]]] == | ||
Any work on [[ | 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. | Confirm with Pagasa that she will not need the data while you are working on it. | ||
| Line 64: | Line 64: | ||
Change the date in the ''version'' table to be the date you start this round of changes on. | Change the date in the ''version'' table to be the date you start this round of changes on. | ||
Log any changes in [[[[ | Log any changes in [[[[Centralized_data.accdb]] Change Log]]. | ||
If the data structure has changed, consider if changes are consistent with | If the data structure has changed, consider if changes are consistent with | ||
| Line 74: | Line 74: | ||
Move the file back to its master directory. | Move the file back to its master directory. | ||
Finalize [[[[ | Finalize [[[[Centralized_data.accdb]] Change Log]] and let Pagasa know there was a change. | ||