Rolling out changes: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "CCMDB.mdb" to "CCMDB.accdb" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
== Rolling out a change to the [[CCMDB.accdb]] == | == 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 | # 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 | # 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 | # Copy the new version to the Master directory | ||
## Open [[Regional Server]]\Programs\Master | ## Open [[Regional Server]]\Programs\Master | ||
## Rename the file ''CCMDB.accdb'' to version it, e.g. to ''CCMDB. | ## 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 | ## Move the renamed file to the ''Versions'' folder | ||
## Copy the new version of CCMDB.accdb 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 | # Roll out the changes | ||
## run the file '''[[updt_all.bat]]''' | ## run the file '''[[updt_all.bat]]''' | ||
| Line 34: | 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 [[Centralized_data. | # 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 49: | 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 [[Centralized_data. | == Rolling out a change to [[Centralized_data.accdb]] == | ||
Any work on Centralized_data. | 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 60: | 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 70: | 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. | ||
[[Category: Development Documentation]] | [[Category:Development Documentation]] | ||