Updt all.bat: Difference between revisions

(5 intermediate revisions by the same user not shown)

Line 1:

{{Regionalserver|Programs\Master\Updt_all.bat}} is a program that is used to roll out updates and changes to the [[CCMDB.~~mdb~~]] program files from:

{{Regionalserver|Programs\Master\Updt_all.bat}} is a program that is used to roll out updates and changes to the [[CCMDB.accdb]] program files from:

*{{Regionalserver|Programs\Master\}}

to the location based folders on the:

Line 9:

A command window will display which directory/location is currently being processed.

Updt_all.bat will check if a ~~ccmdb~~.~~mdb~~ file on the server is currently open, i.e. has a corresponding ccmdb.ldb file. '''If a ccmdb.ldb is present the location will not be updated. ''' Otherwise Updt_all.bat will copy the ~~ccmdb~~.~~mdb~~ from the "master" directory to the location directory currently being processed.

Updt_all.bat will check if a CCMDB.accdb file on the server is currently open, i.e. has a corresponding ccmdb.ldb file. '''If a ccmdb.ldb is present the location will not be updated. ''' Otherwise Updt_all.bat will copy the CCMDB.accdb from the "master" directory to the location directory currently being processed.

When processing is done, the [[updt_all.bat#log | log]] is displayed. Go to the end of the file to see results of the most roll-out.

== Inner Workings ==

Updt_all.bat uses a for loop to cycle through a collection of locations (set [[Locs.bat]]) to ~~do the following:~~

Updt_all.bat uses a for loop to cycle through a collection of locations (set [[Locs.bat]]) and copies [[CCMDB.accdb]] from Master to that location.

* check if file is in use, i.e. a lock file exists

** If so, don't process the location

** If not,

*** delete ccmdb.20

*** rename ccmdb.19 to ccmdb.20, ccmdb18 to ccmdb.19, ... ccmdb.1 to ccmdb.2, ccmdb.~~mdb to ccmdb.1~~

*** copy new ccmdb.mdb from master

== Log File ==

Line 27:

Line 21:

== Log ==

* 2020-06-25 - stopped log from opening after completion, since the newest are added at the end, seeing the log doesn't help with anything

* 2019-10-02 - updated copy to copy /y to automatically overwrite files that have not been picked up yet; can't believe this never cropped up until now as a problem.

* 2019-09-18 - changed CCMDB.mdb to CCMDB.accdb

== Related articles ==

*See [[CCMDB.~~mdb~~ Change Log]] for changes that were rolled out using this file.

*See CCMDB.accdb Change [[Log]] for changes that were rolled out using this file.

Line 36:

Line 32:

[[Category:IT_Instructions]]

[[Category:Batch Files]]

[[Category:Laptop ~~location~~]]

[[Category:Laptop identifier]]

@@ Line 1: / Line 1: @@
-{{Regionalserver|Programs\Master\Updt_all.bat}} is a program that is used to roll out updates and changes to the [[CCMDB.mdb]] program files from:
+{{Regionalserver|Programs\Master\Updt_all.bat}} is a program that is used to roll out updates and changes to the [[CCMDB.accdb]] program files from:
 *{{Regionalserver|Programs\Master\}}
 to the location based folders on the:
@@ Line 9: / Line 9: @@
 A command window will display which directory/location is currently being processed.
-Updt_all.bat will check if a ccmdb.mdb file on the server is currently open, i.e. has a corresponding ccmdb.ldb file. '''If a ccmdb.ldb is present the location will not be updated. ''' Otherwise Updt_all.bat will copy the ccmdb.mdb from the "master" directory to the location directory currently being processed.
+Updt_all.bat will check if a CCMDB.accdb file on the server is currently open, i.e. has a corresponding ccmdb.ldb file. '''If a ccmdb.ldb is present the location will not be updated. ''' Otherwise Updt_all.bat will copy the CCMDB.accdb from the "master" directory to the location directory currently being processed.
 When processing is done, the [[updt_all.bat#log | log]] is displayed. Go to the end of the file to see results of the most roll-out.
 == Inner Workings ==
-Updt_all.bat uses a for loop to cycle through a collection of locations (set [[Locs.bat]]) to do the following:
+Updt_all.bat uses a for loop to cycle through a collection of locations (set [[Locs.bat]]) and copies [[CCMDB.accdb]] from Master to that location.
-* check if file is in use, i.e. a lock file exists
-** If so, don't process the location
-** If not,
-*** delete ccmdb.20
-*** rename ccmdb.19 to ccmdb.20, ccmdb18 to ccmdb.19, ... ccmdb.1 to ccmdb.2, ccmdb.mdb to ccmdb.1
-*** copy new ccmdb.mdb from master
 == Log File ==
@@ Line 27: / Line 21: @@
 == Log ==
+* 2020-06-25 - stopped log from opening after completion, since the newest are added at the end, seeing the log doesn't help with anything
+* 2019-10-02 - updated copy to copy /y to automatically overwrite files that have not been picked up yet; can't believe this never cropped up until now as a problem.
 * 2019-09-18 - changed CCMDB.mdb to CCMDB.accdb
 == Related articles ==
-*See [[CCMDB.mdb Change Log]] for changes that were rolled out using this file.
+*See CCMDB.accdb Change [[Log]] for changes that were rolled out using this file.
 {{Related Articles}}
@@ Line 36: / Line 32: @@
 [[Category:IT_Instructions]]
 [[Category:Batch Files]]
-[[Category:Laptop location]]
+[[Category:Laptop identifier]]