TweetFollow Us on Twitter

Rolling out Microsoft Office Updates

Volume Number: 22 (2006)
Issue Number: 12
Column Tag: Patch Panel

Rolling out Microsoft Office Updates

Repackaging updates for fun and sanity

by John C. Welch

Hello Again

Well, it's been a while since my particular brand of loquaciousness has graced the pages of MacTech, but like boomerangs and bad pennies, here I am. In this month's installment of Patch Panel, I'm going to chat with you about a subject near and dear to all our hearts; Rolling out updates to Microsoft Office. By "near and dear" I mean, "met with much eye-rolling and groaning". This has nothing to do with Microsoft Office itself. Regardless of your opinion of the suite, the fact is, it's something that most Mac administrators have to support. One of the time honored tediums of the administrator's life is that of rolling out the update. This is something that can either be relatively easy, or a tedious process that makes you wish we could revert back to the good old days of stone tablets and chisels.

Some History

Waaaaay back in the dark ages, (okay, back before OS X), there was nothing as organized as the current Apple installer. Oh, Apple had an installer, but it was not nearly as easy to deal with as the current Mac OS X version. So, sensing an opportunity, several companies came out with their own products, one of the biggest being Installer VISE, from MindVision. (http://www.mindvision.com). VISE had a number of advantages over the others, including not just Windows support, but actual acceptance on that platform. This of course, made it rather attractive to a number of companies, including Adobe. Now, while Microsoft had, and indeed, still has their own Windows installer(s), the rest of VISE's feature set made it a good fit for the Mac BU.

Current Issues

So now you have a setup where if something can be installed via an Apple Installer, or direct copy, the administrator's job is simple. If you use Apple Remote Desktop, and it's an Apple Installer, you let Apple Remote Desktop handle it, or copy it over and run the installer command via SSH. If it's a direct copy, then you, well, copy it. Simple, easy, and even allowing for some of the issues with Apple's installer, elegant. With Apple Remote Desktop 3's AppleScript support, I don't even directly interact with Apple Remote Desktop to install these two kinds of items. I just drop them in specific folders and let folder actions handle them. It's pretty sweet, and lets me not waste a lot of time with installing files on clients.

However, when you hit a VISE installer, which is what the Mac BU still uses for Office updates, that system breaks, and hard. You have to either manually install it on each machine, or you have to repackage it. Since the former just is not happening unless you have a very small number of machines, we of course, will look at the latter. (Note: While I'm really only talking about Office 2004, this all should work just peachy with Office v.X)

Figuring Out What to Install

As I said before, to most tools, VISE installers are opaque. You can see the file, but you can't crack it open and see what's in it, what's going to be installed where, etc. You also can't have a tool like Apple Remote Desktop just install it. Luckily, Microsoft, bless their little IT-centric hearts, gives you a couple of ways to figure this out. The first, best method is via their updater logs. If you look in the Microsoft Office 2004 folder after an update, you'll see a folder called "Updater Logs". Inside that folder, you'll find a text file for each of the updates you've applied to that system. The updater file lists every file that was installed on the system.

Now, before you just run off and blindly use this, by "each file" I mean just that. If it installed ten files inside a bundle, then you get ten entries. Now, you can directly follow the log line for line, but that's kind of the silly way to do it. Instead, read the file, and use it to get the minimum number of files and packages you actually have to care about. Some of the lines are obvious like the ones for the main apps, (this is on my own drive, so it follows my own... unique... filing system. Normally, the Office 2004 folder is in the root of your Applications folder):

Installed Aurora:Applications:Word Processing:Microsoft Office 2004:Microsoft Entourage

Installed Aurora:Applications:Word Processing:Microsoft Office 2004:Microsoft Excel

Installed Aurora:Applications:Word Processing:Microsoft Office 2004:Microsoft PowerPoint

Installed Aurora:Applications:Word Processing:Microsoft Office 2004:Microsoft Word

So, we can see it installed new copies of each of the four main applications. Okay, that's easy. But then we see a bunch of lines like the following:

Created the Folder: Aurora:Applications:Word

Processing:Microsoft Office 2004:Office:Microsoft Cert

Manager.app

Created the Folder: Aurora:Applications:Word

Processing:Microsoft Office 2004:Office:Microsoft Cert

Manager.app:Contents

Installed Aurora:Applications:Word Processing:Microsoft Office

2004:Office:Microsoft Cert Manager.app:Contents:Info.plist

And this goes on for about 30 lines. Does this mean you have to now deal with 30 separate files? Nope. It means you deal with one: The Microsoft Cert Manager.app, which lives in the "Office" folder inside of the main Microsoft Office folder. This can be kind of tedious to parse, although since Microsoft is thankfully consistent in how it does this, you can script this parsing out fairly easily. However, there is an easier way, one that all administrators will of course already know about, and that is the Read Me file.

With every update, the Mac BU has a Read Me file that lists out the files which are updated, and their new versions. (For those of you who are Britannica fans, this is the Macropaedia, whereas the installer log is the Micropaedia.) So rather than parsing through the Updater Log file to figure out what was installed, you can just use the Read Me to see what was installed. It's much simpler. Now, the Read Me won't tell you the specific locations of the files, so it's not a complete replacement for the Updater Log, but that's not a huge issue, depending on how you build your updater.

Building Your Updater

So, we now have two lists of files, one detailed, one not. Now, how do you build the updater? Well, the answer is, "Whatever works best for you". No, I'm not trying to be smarmy, it's just that there are a lot of ways to do this. If you use Apple Remote Desktop, as I do, then you can just do a drag of the files to a list of destination clients, and chose "Same Relative Location" as the destination, like in the screenshot below:


Copy Items Dialog from Apple Remote Desktop 3

Drag all the files you need to copy over, pick "Same relative location", click on copy, and watch the fun. (Yes, I realize none of my targets are currently running or running ARD). You can of course, with Apple Remote Desktop 3, AppleScript this, via Copy Items task. Just set the "location" property to "same relative location" in the properties for the task. You could even set up a Folder Action that would always copy whatever you dropped into it to the Same relative location, and be even lazier. That of course is my preferred method. Life's too short to watch file copies. If you aren't using Apple Remote Desktop, or you prefer using Apple Installer packages, you can use Apple's PackageMaker tool to bundle up the update into an install package, and then use that via Apple Remote Desktop or your tool of choice. (There's a PackageMaker article in this very issue, so I'll not get into using PackageMaker, as it would be redundant.)

If you like using Apple's Installer packages, but are not thrilled with PackageMaker, then a third party option is to use Iceberg, (http://s.sudre.free.fr/Software/Iceberg.html). Iceberg is billed as a better way to make Apple Installer packages, and in general I've found that to be true. The only issue with Iceberg is that it requires the use of a daemon that runs as root. If that's not an issue for you, Iceberg is worth checking out. I also find the documentation on Iceberg's site to be solid as well, always a welcome touch for an installer builder.

Please don't think that these are the only options out there. When you're talking about straight file copies, which is what updating Office is, once you install it on an initial system, there are as many ways to roll this out as there are ways to copy files. If you're thinking "that's a lot of ways", well, you're right. Once you know where to look for the correct information, then how you get the copies onto the end user system is totally up to you, and your normal workflow.

Two Caveats

There are of course some things to keep in mind that could trip you up. (You knew there would be, nothing's ever that simple.) First, the main applications in Office, namely Word, PowerPoint, Excel, and Entourage are traditional dual fork applications. That is, they have a resource fork. That's probably not going to change until the next release of office, still known by its nom du code as "Office 12". So, when you're copying Office updates, you really want to make sure that whatever method you use doesn't do bad things to resource forks. Otherwise, the applications will break, and your users may do bad things to you.

The other thing to watch out for is the Microsoft Database Daemon. This is a daemon that runs whenever one of the main Office applications is running, or it runs at login if the user is an Entourage user and has set events or tasks with reminders. If you update the Microsoft Database Daemon while it's running, and there are changes made to it, then the end users, particularly Entourage users could get odd messages that might lead them to think their Entourage database died. That would make them flustered and stern, especially if they find out later that it was just an update doing this. Since the daemon only runs within a user login context, the obvious solution is to not run the update until the users have logged out. If this isn't possible, then I'd highly recommend adding a post install action that restarts the daemon.

Conclusion

If this all seems pretty simple, well, it is. While the Mac BU really, really, really needs to move to Apple Installer packages sooner than later, their laudable habit of providing detailed installer logs, and updated file lists in the update readmes makes what could be an onerous task into one that's just mildly tedious and annoying. As long as you keep my warnings about resource forks and the Database Daemon in mind, rolling out Microsoft Office updates shouldn't be hard at all.

Bibliography and References

Microsoft Macintosh Business Unit: various Read Me's and updater log files.

Apple Computer: Documentation for Apple Remote Desktop and PackageMaker

Stéphane Sudre: Documentation for Iceberg


John Welch (jwelch@bynkii.com) is Unix/Open Systems administrator for Kansas City Life Insurance, (http://www.kclife.com/) a columnist for Datamation, (http://itmanagement.earthweb.com/columns/appleent/) and the "GeekSpeak" segment producer for Your Mac Life, (http://www.yourmaclife.com/). He has over fifteen years of experience at making Macs work with other computer systems. John specializes in figuring out ways in which to make the Mac do what nobody thinks it can, showing that the Mac is a superior administrative platform, and teaching others how to use it in interesting, if sometimes frightening ways. He also does things that don't involve computery on occasion, or at least that's the rumor.

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

NetShade 8.3 - Browse privately using an...
NetShade is an anonymous proxy and VPN app+service for Mac. Unblock your Internet through NetShade's high-speed proxy and VPN servers spanning 17 countries. NetShade masks your IP address as you... Read more
Adobe Animate CC 2020 20.0.1 - Animation...
Animate CC 2020 is available as part of Adobe Creative Cloud for as little as $20.99/month (or $9.99/month if you're a previous Flash Professional customer). Animate CC 2020 (was Flash CC) lets you... Read more
Adobe Acrobat DC 19.021.20058 - Powerful...
Acrobat DC is available only as a part of Adobe Creative Cloud, and can only be installed and/or updated through Adobe's Creative Cloud app. Adobe Acrobat DC with Adobe Document Cloud services is... Read more
Adobe Acrobat Reader 19.021.20058 - View...
Adobe Acrobat Reader allows users to view PDF documents. You may not know what a PDF file is, but you've probably come across one at some point. PDF files are used by companies and even the IRS to... Read more
Adobe Flash Player 32.0.0.303 - Plug-in...
Adobe Flash Player is a cross-platform, browser-based application runtime that provides uncompromised viewing of expressive applications, content, and videos across browsers and operating systems.... Read more
Adobe InDesign CC 2019 15.0.1 - Professi...
InDesign CC 2019 is available as part of Adobe Creative Cloud for as little as $20.99/month (or $9.99/month if you're a previous InDesign customer). Adobe InDesign CC 2019 is part of Creative Cloud.... Read more
Adobe Lightroom Classic 9.1 - Import, de...
You can download Lightroom for Mac as a part of Creative Cloud for only $9.99/month with Photoshop, included as part of the photography package. The latest version of Lightroom gives you all of the... Read more
Shredo 1.2.7 - $6.99
Shredo is a beautiful, functional file-shredding and privacy scan utility. It permanently shreds files, folders, and external volumes' contents to keep information secure and impossible for anyone to... Read more
Visual Studio Code 1.41.0 - Cross-platfo...
Visual Studio Code provides developers with a new choice of developer tool that combines the simplicity and streamlined experience of a code editor with the best of what developers need for their... Read more
calibre 4.6.0 - Complete e-book library...
Calibre is a complete e-book library manager. Organize your collection, convert your books to multiple formats, and sync with all of your devices. Let Calibre be your multi-tasking digital librarian... Read more

Latest Forum Discussions

See All

King's Throne, the hugely ambitious...
King's Throne: Game of Lust is a deeply immersive medieval-set idle RPG which sees you playing as an ambitious prince, and sole heir to your father's kingdom. On a seemingly ordinary night whilst wandering the king's castle, you make the shocking... | Read more »
Abyssrium Pole is an upcoming aquarium b...
FleroGames' upcoming Abyssrium Pole has recently hit one million pre-registers, which is very impressive, particularly for a fairly casual looking game. Those who have pre-registered will receive 1000 Pearl when the game launches on 8th January... | Read more »
Two Spies is pretty fun, but it's h...
Two Spies just dropped on the App Store this week, and it looks pretty neat. The game has two players capturing various cities across Europe, with the goal of eventually spotting and striking the other spy down. It may be simple-looking, but after... | Read more »
Two Spies is a turn-based game for iOS t...
There aren't too many games that feature pass and play multiplayer and there are even less where you can only play against people you know, even when playing online. But Two Spies does both of those things and you can get it for iOS right now. [... | Read more »
Solve your way through new low-poly puzz...
The best escape-the-room games don’t just test your creative problem-solving skills – they look great, too. Released in October this year by Antler (the developer of the succesful VR puzzle SVRVIVE: The Deus Helix), Krystopia offers everything you... | Read more »
Get ready for an epic adventure with Pea...
Following a hugely successful pre-registration campaign, Pearl Abyss' much-hyped MMORPG, Black Desert Mobile, has finally arrived for iOS and Android. With some of the most impressive visuals on mobile, a vast open world to explore, an in-depth... | Read more »
Elder Scrolls: Blades has ditched chest...
Elder Scrolls: Blades started out as one of the most hyped mobile games of 2019, boasting some impressive visuals and no shortage of promise. Our hopes were somewhat dashed when it eventually launched and we all became privy to its mishandled... | Read more »
Hands-On with the Pocket City December U...
At the end of last month, Codebrew Games announced an update coming to their popular city-builder, Pocket City some time this month. In this update is the promise of expanding your city out into other regions, enacting policies, and more. The full... | Read more »
Black Desert Mobile is available for pre...
Pearl Abyss' stunning open-world MMORPG, Black Desert Mobile, is set to launch for iOS and Android on December 11th at 12 AM PST (8 AM UTC). However, those looking to get in early and test out the in-depth character customisation will be able to... | Read more »
Extraordinary Ones, NetEase's innov...
NetEase's inventive 5v5 anime MOBA, Extraordinary Ones, has now opened for pre-registration ahead of its global launch in early 2020. The game seems to have received a fairly warm reception from fans after its soft-launch earlier in the year,... | Read more »

Price Scanner via MacPrices.net

Apple Watch Series 3 models on sale at Amazon...
Amazon has Apple Watch Series 3 GPS models on sale for $20 off MSRP, starting at only $179. Their prices are the lowest available for these models from any Apple reseller. Choose Amazon as the seller... Read more
Sunday AirPods Sale: Amazon drops prices to a...
Amazon has new 2019 Apple AirPods on sale today ranging up to $30 off MSRP, starting at $139. Shipping is free: – AirPods Pro: $249 $0 off MSRP – AirPods with Wireless Charging Case: $168.95 $30 off... Read more
Holiday 2019 sale: 11″ iPad Pros for up to $2...
Amazon has new Apple 11″ iPad Pros in stock today and on sale for up to $200 off Apple’s MSRP as part of their Holiday 2019 sale. These are the same iPad Pros sold by Apple in its retail and online... Read more
B&H has 12.9″ WiFi iPad Pros on sale for...
B&H Photo has new 12.9″ WiFi iPad Pros on sale for up to $150 off Apple’s MSRP as part of their Holiday 2019 sale. Overnight shipping is free to many addresses in the US: – 12.9″ 64GB WiFi iPad... Read more
Find the best Holiday 2019 prices on Apple’s...
Our Apple award-winning price trackers are the best place to look for the best deals and lowest prices on Apple gear this 2019 Holiday shopping season. Scan our price trackers for the latest... Read more
13″ 2.4GHz/256GB Silver MacBook Pro on sale f...
Amazon has the Silver 13″ 2.4GHz/256GB 4-Core Touch Bar MacBook Pro on sale for $1499.99 shipped. Their price is $300 off Apple’s MSRP, and it’s the lowest price currently available for a 13″ 2.4GHz... Read more
Sams Club one day sales event December 14th:...
Through midnight Saturday night (December 14th), Sams Club online has several Apple Watch Series 5 models on sale for $40 off MSRP as part of their One Day sales event. Choose free shipping or free... Read more
Total Wireless offers iPhone 6S models for as...
Total Wireless has Apple 32GB iPhone 6S models available starting at $99: – 32GB iPhone 6S: $99.99 – 32GB iPhone 6S Plus: $149.99 A no-contract Total Wireless prepaid plan is required with your... Read more
Get a 4 or 6-core Mac Mini for up to $170 off...
B&H Photo has 4-Core and 6-Core Mac minis on sale for up to $170 off Apple’s standard MSRP as part of their Holiday 2019 sale. Overnight shipping is free to many US addresses: – 3.6GHz Quad-Core... Read more
Amazon restocks base 13″ 1.4GHz MacBook Pro f...
Amazon has restocked the base 13″ 1.4GHz/128GB Space Gray MacBook Pro for $1099.99 shipped. Their price is $200 off Apple’s MSRP, and it’s the cheapest price available for a new MacBook Pro. Amazon... Read more

Jobs Board

*Apple* Mobility Sales Professional - Best B...
**750138BR** **Job Title:** Apple Mobility Sales Professional **Job Category:** Store Associates **Store NUmber or Department:** 000471-Mt Vernon-Store **Job Read more
*Apple* Engineering Specialist (ITC ) - Gene...
…Suitability clearance, per contract requirements. Currently, we are seeking an Apple Engineering Specialist in Washington, DC The responsibilities for candidates in Read more
Senior *Apple* Endpoint Engineer - Leidos (...
…Medicaid Service (CMS) End User environment. Perform specific duties as an Apple Endpoint Engineer in support of the infrastructure operations, hardware, software Read more
Perioperative - RN - ( *Apple* Hill Surgical...
Perioperative - RN - ( Apple Hill Surgical Center) Tracking Code 59281 Job Description Monday - Friday - Part Time - Days Possible Saturdays General Summary: Under Read more
Lead DevOps Engineer - *Apple* - Theorem, L...
Job Summary Apple is looking for a seasoned Lead DevOps Engineer that can lead multiple projects and teams while delivering high quality and performant solutions in Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.