Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


Photo

slipstream Office 2003 SP1 & rebuild CD

* * * * * 6 votes

  • Please log in to reply
106 replies to this topic

#76
beeker

beeker

    Newbie

  • Members
  • 49 posts
Hi veger,

I'm real exited to incorporate your modifications but I didn't see your changes to sort2cabs.js in your attachment. I'm also interested in your changes for 8.3 filenames of the exported tables. Good idea about the recurcursive search - it does take a long time. I have another search function now and testing AIO script that does everything from start to finish including creating ISO. It is still premature to post it right now.
I am hoping your md5sum mod or non-recursive mod fixes my problem with Infopath KB920103.
Here is my latest version of Update_msi_tables.au3 taking into account your orca search and I think a faster search function.

Thanks.
EDIT: Fixed a bug introduced yesterday, tested and working now, new version attached.

Attached Files


Edited by beeker, 25 September 2006 - 09:22 PM.



How to remove advertisement from MSFN

#77
veger

veger
  • Members
  • 6 posts
Hi,

I accidently uploaded the original sort2cabs.js...The modified sort2cabs.js is attached now.

Working on a complete script aswell (which runs the other scripts) for Office + Visio and Proofing Tools. But Proofing Tools needs some modifications in the directory table, so I've to try a little further before I can post it.

Cheers,
Veger

Attached Files



#78
veger

veger
  • Members
  • 6 posts
Hi all,

I've been working on an automated slipstream procedure and I think I've created one (except for cleaning the working files at the end)
The attachement contains my sort directory, it should be working on any path but I haven't tried. I used the same script for Office + Visio installation and for Proofing Tools. But other combinations should work aswell (except you have to create your own install_hotfixes batch file)

When you follow these steps it might work :P
1 Copy files form installation cds to your harddisc (no need for admin install or the unhide the CABs)
2 Extract sort.zip to the sort directory
3 Compile AutoIt scripts.
3 Copy/download servicepacks and/or hotfixes
4 Extract them into a directory called 'unpacked' which should be next to the sort directory (in the directory containing the CAB files)
5 Change install_hotfixesXXX.bat for the forfixed you just downloaded
6 Change the PIDs in slipstreamXXX.bat (XXX depends on the program(s) you're going to slipstream)
7 Open a Command Promp and go to the sort directory
8 Type 'complete.bat' and check the syntax. (eg for Proofing tools I used 'complete.bat PTK "C:/Proofing Tools 2003"')
9 Drink coffee!

Notes:
- Proofing Tools needs a table alteration after slipstreaming the Serivce Pack. Therefore I created the script fix_tables_PTK.au3. This can be done for other 'post slipstreaming' purposes aswell. The 'PTK' in fix_tables_PTK.au3 is the first argument when complete.bat is called. So it's possible to create own scripts to run after slipstreaming everything. When no script is found it just gets skipped.
- It's nice to have a big command prompt so you can review the process after you're done dinking coffee. So it's possible see errors and stuff, since the script don't stop when errors occur.

I'm not likey to create a script to copy the files from the cd(s) to a directory or to create a script to clean the files afterwards. But eel free to change the scripts for your own needs, but please create a post here so other (including me :P) can make use of them!

I'll be around to answer questions if things won't work as they should!
Bye,
Veger

Attached Files

  • Attached File  sort.zip   104.07KB   135 downloads


#79
beeker

beeker

    Newbie

  • Members
  • 49 posts
Hi Veger,

I incorporated some of your tweaks in my package: fix Orca filenames truncated to 8.3, look for orca at the default location, add non-recursive option to Search functions, auto generate files and folders, md5 update to sort2cabs.js. Nice job! Thanks.

I succeeded in slipstreaming SP2 and all updates into Office 2003 AIO CD using the "beef stew" method and still fits on a single CD. I won't remember how to do this next time so I automated as much as possible.
- added a function to modify Media table for Infopath KB920102
- Project has two unique files (README.HTM, OCLNCORE.OPC) that are backed up and restored, the rest are overwritten when copied over.
- My setup.exe files are all identical so overwriting them was ok.
- All original setup.ini files are copied from CD to HD at the end. This restores personalization:
[Options]
USERNAME=MYNAME
COMPANYNAME=HOME
PIDKEY=xxxxxxxxxxxxxxxxxxxxxxxxx

FYI, Beyond Compare is an excellent GUI tool for comparing files and folders during testing.

To recap what's needed:
- AutoIt v3.2
- ORCA (try Shark's file repository)
- MSI 3.1 installed
- WSH 5.6 installed
- Office 2003 AIO CD
- appropriate administrative updates
- revised scripts attached to this post (beefstew.zip)
- md5sum.exe and makecab.exe go in your %WINDIR%\System32 folder (I used the versions at
Reduce Size of Your 5 in 1 Office 2003 SP1/SP2 CD by 36MB)
- cabarc.exe (optional) I modified sort2cabs.js to use cabarc if found (for better compression), otherwise makecab and settings.ddf will be used like Marek722's original.

NOTE: This method requires that the AIO CD stay in the drive throughout the whole process.
1. Install Orca.
2. Store all extracted admin updates (*.MSP) to folders on hard disk.
3. Extract the updates.cmd file from the attached beefstew.zip and modify it according to the updates you are applying. (I painfully tried every msp on every msi to see what was applicable the first time around)
- modify the path to msp files to where you store your admin updates (*.MSP)
- modify the PIDKEY="" with your value
- rem the pause statement at the end if you want fully unattended operation
4. Install AutoIt v3.2 and compile Update_msi_tables.au3
5. Create a working directory like x:\office2003\sort\ and put the following scripts there:
- sort2cabs.js (from beefstew.zip)
- settings.ddf (from beefstew.zip)
- OfficeAIO.au3 (from beefstew.zip)
- copycabs.cmd (from beefstew.zip)
- updates.cmd (from step 3)
- Update_msi_tables.exe (from step 4)
6. Double-click OfficeAIO.au3 to start the process.

The OfficeAIO.au3 and sort2cabs.js scripts perform their activities relative to the folder they are in. OfficeAIO.au3 asks you for the source CD drive of your AIO CD and then proceeds to perform all of Marek722's steps except writing a new CD. There's a bit of error checking and there's a progress bar for activities that take a long time so you won't think the script is hung. It has message boxes at various steps along the way that you can comment out for fully unattended operation once you trust the script is doing its job.

You may need to tweak the scripts for your own situation as quirks pop up.
Attached are the scripts I used (ran overnight successfully). I hope you find this useful.

Enjoy.

EDIT Oct 5, 2006:
Modified OfficeAIO.au3 to make it more universal for AIO or single App CD. Tested successfully on Proofing Tools CD. Also added function to modify the PTK Directory.idt table per Veger's note, added PTKupdates.cmd to perform the following PTK updates:
PTK2003SP2-KB887618: 2003PTKSP2ff.msp
KB912440: MSCTF.msp
ptk-KB913571: PTKff.msp

Darn! Fixed a bug with my Orca search, so replaced zip file again. Sorry to those who downloaded before this edit.

EDIT: Nov 1, 2006 (major fixes)
- added two more hooks in sort2cabs.js

1. Before creating a CAB file, it looks for a cmd file for that CAB file and runs the cmd file before creating the new CAB. Also modified OfficeAIO.au3 to create these cmd files to put the correct SETUP.INI file in SKU....CAB files and the correct OCLNCORE.OPC file in O9561....CAB files.
2. Before it calculates CAB MD5, looks for a file called copycabs.cmd and runs that cmd file to replace 11 Project Std CABs with equivalent Project Pro CABs. This reduces size of AIO CD by about 29 meg.
- modified updates.cmd file to get rid of MSP updates that are superceded by more recent updates, included PTK updates and is now universal i.e. works on single CD or AIO CD.
- modified Update_msi_tables.au3 script to import up to 7 tables instead of 4, added a couple of message boxes for troubleshooting, reduced sleep times to speed up the process, added a while loop to make sure the Import Window is active before selecting files so it doesn't miss any on a slow PC, added a ContinueLoop statement so it won't get stuck if the tables folder doesn't exist.
- modified OfficeAIO.au3 script to properly backup and restore README.HTM and OCLNCORE.OPC to the proper applications, added a section to put the correct SETUP.INI file in the proper SKU....CAB file and the correct OCLNCORE.OPC file in O9561....CAB files, completely changed the fix for Infopath KB920103 to modify File.idt instead of Media.idt - old method made incorrect changes to Media.idt, modified the command that runs sort2cabs.js so the output gets logged to file for troubleshooting, changed some text in message boxes.

Attached Files


Edited by beeker, 01 November 2006 - 07:05 PM.


#80
beeker

beeker

    Newbie

  • Members
  • 49 posts
Hi Veger,

I'm having a problem with Proofing Tools CD, sort2cabs.js displays "failure opening file to be stored in cabinet" (for YS561417.CAB I think), and I'm wondering if it has something to do with why you created fix_tables_PTK.au3.

Did you have a similar problem?

By the way, my PC is real slow (400Mhz) and I have to modify your fix_tables_PTK.au3 to work in my situation:
I Replced:
ControlSetText( "Open", "", "Edit1", @scriptdir & "\PTK\Directory.idt" )
With:
While 1
  If ControlCommand("Open","","Edit1","IsEnabled","") Then ExitLoop
WEnd
ControlCommand("Open","","Edit1","EditPaste",@ScriptDir & "\PTK\Directory.idt")

I also had to modify my OfficeAIO.au3 script to be more universal so that it works on Proofing Tools CD also. I'll edit my previous post to include my latest version.

Thanks,

#81
veger

veger
  • Members
  • 6 posts
Hi beeker,

I created fix_tables_PTK.au3 to use the method described in Post #29 to solve problems with the directory table. (Some directorielocations are changed with the serive pack)

Although the fix described wasn't correlty (I just remembered) since the missing files are stored somwhere else, so fix_tables_PTK.au3 isn't exactly the same as described in Post #29 but I modified it like this:

directory:
CWUBI86HelpMidFolder.3630F825_EED5_11D3_91FE_00AA0059F9F6
change defaultdir to:
.:WUBI86
directory:
WordBreakerFolder.31D1FCD7_F3CA_4A73_B34D_CA95CAEAB62E
change defaultdir to:
. (instead of WORDBRKR)

Had forgotten about that, so i didn't mention it before...

Hopefully it helps,
Veger

#82
beeker

beeker

    Newbie

  • Members
  • 49 posts

directory:
CWUBI86HelpMidFolder.3630F825_EED5_11D3_91FE_00AA0059F9F6
change defaultdir to:
.:WUBI86
directory:.
WordBreakerFolder.31D1FCD7_F3CA_4A73_B34D_CA95CAEAB62E
change defaultdir to:
. (instead of WORDBRKR)


Veger, that solved my problem perfectly. Thanks!

I updated my OfficeAIO.au3 script in previous post again to include an AutoIt function so the whole process is unnattended.

Much appreciated, Beeker.

#83
dork0900

dork0900
  • Members
  • 1 posts
Have you guys ever noticed after integrating the service pack, all the hotfixes, and having officeupdate.microsoft.com show 0 updates available, that for some reason windowsupdate.com still shows the updates you already have installed?

Is this an integration issue? Or is it just a problem with windowsupdate.com not detecting things right?

Thanks!

Edited by dork0900, 13 October 2006 - 04:00 AM.


#84
veger

veger
  • Members
  • 6 posts
Yeah have seen this aswell nad it's kinda annoying, but I haven't come to a solution for it.
I thought someone posted this as well and said it has to do sometihng with the windowsupdate.com not detecting updates correctly.

#85
beeker

beeker

    Newbie

  • Members
  • 49 posts
I finished testing new features and bug fixes to my beef stew AIO scripts. I put the new beefstew.zip file on my original Post of Oct 2. You'll see the list of changes in the EDIT on that posting.

Successfully tested updating a CD that was previously updated by the same scripts.

I've been reducing the size of my AIO quite a bit too.
By integrating copycabs.cmd with sort2cabs.js I saved about 29 meg. (see description on my Oct 2 Post).

I also performed a one-time manual edit for Project Pro and Std that saves another 20 meg. Instructions are in the attached ProjectMerge.txt file. Microsoft updates can be applied to Project afterwards without having to re-do this edit.

Enjoy,

Beeker

Attached Files



#86
Unsure

Unsure
  • Members
  • 2 posts
Hello:

I hope this thread is still active.

I have downloaded the scripts, applications, and batch files, and followed the various versions of instructions and I keep encountering problems.

My latest problem is: right after creating .CAB files, sort2cabs.js goes into resequencing .xml files (as far as I understand). From what I could gather from the script, it calls md5sum.exe to do this. Each time I attempt to run the script, near the end I always get the same error:

xml files found: acc11,excel11,fp11,inf11,onote11,outl11,outls11,owc10,owc11,ppt
11,pro11,pub11,std11,stdp11,word11
modifying acc11
modifying excel11
modifying fp11
modifying inf11
modifying onote11
modifying outl11
modifying outls11
modifying owc10

Error: Access is denied.

I read somewhere that md5sum.exe does not work on Windows XP, so I tried running the script on a Windows 2000 box, and came up with the same results. I've checked the permissions on the .xml files in x:\office2003\sort and there are no permissions set (or rather, no restrictions were set).

Please help! (**prays that this thread is still active :unsure: **)

Edited by Unsure, 19 December 2006 - 04:59 PM.


#87
yingkit2007

yingkit2007
  • Members
  • 1 posts

4. Copy XML files located at X:\office2003\FILES\SETUP to X:\office2003\sort. Now edit X:\office2003\sort\tabledirs.lst and X:\office2003\sort\xmlfiles.lst to match your need. tabledirs.lst lists all directories containing the exported tables from the msi packages (existence is checked in sort2cabs.js) and xmlfiles.lst lists all xml to edit (correct md5sums).


After I extract those 5 tables by orca, but i cannot see "tabledirs.lst" and "xmlfiles.lst" existed in "X:\office2003\sort\", how can i do?

#88
Unsure

Unsure
  • Members
  • 2 posts


4. Copy XML files located at X:\office2003\FILES\SETUP to X:\office2003\sort. Now edit X:\office2003\sort\tabledirs.lst and X:\office2003\sort\xmlfiles.lst to match your need. tabledirs.lst lists all directories containing the exported tables from the msi packages (existence is checked in sort2cabs.js) and xmlfiles.lst lists all xml to edit (correct md5sums).


After I extract those 5 tables by orca, but i cannot see "tabledirs.lst" and "xmlfiles.lst" existed in "X:\office2003\sort\", how can i do?

You create xmlfile.lst and tabledirs.lst yourself using Notepad and saving the file as a .lst file.

Tabledirs.lst:
Basically, whatever directory names you used to export your tables to, you list in the file. Tabledirs.lst should look something like this:

acc11
excel11
fp11
inf11
onote11
outl11
outls11
owc10
owc11
ppt11
pro11

xmlfiles.lst:
Similar list as above, but all you do is list the xml files located in /files/setup.

If you read the above posts, Beeker actually has combined a package that pretty much does everything, including creating the .lst files
http://www.msfn.org/...o...1225&st=60#

#89
skonvols2k

skonvols2k
  • Members
  • 4 posts
Hi, i have successfully integrated in my office 2003 pro for students (so no admin setup allowed) the service pack 3.
after installation without problem and all programs works fine (showing SP3 in about) i tried to install office2003-KB936677-FullFile-ITA.exe (junk mail filter of september) it's stop due a problem of version (update it isn't made for version installed). instead installing same update via microsoft update works fine.

does anyone know why this problems?
TNX

Edited by skonvols2k, 19 September 2007 - 04:10 AM.


#90
MagicAndre1981

MagicAndre1981

    after Windows 7 GA still Vista lover :)

  • Patrons
  • 5,758 posts
  • OS:Vista Ultimate x86
  • Country: Country Flag

Donator

this is a bug with the sp3.

first integrate the msp from the junk mail filter and next integrate the Sp3. After installing the new version import this reg:

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\7040110900063D11C8EF10054038389C\Patches\F498D7EF7BACEF540865443F52234A30]
"MSI3"=dword:00000001
"State"=dword:00000001
"Uninstallable"=dword:00000001
"LUAEnabled"=dword:00000000
"PatchType"=dword:00000000
"Installed"="20070918"
"DisplayName"="Update for Outlook 2003: Junk E-mail Filter (KB936677): OUTLFLTR"
"MoreInfoURL"="http://support.microsoft.com/kb/936677"

Source:
http://www.german-nl...m...ost&p=89547

#91
skonvols2k

skonvols2k
  • Members
  • 4 posts

this is a bug with the sp3.

first integrate the msp from the junk mail filter and next integrate the Sp3. After installing the new version import this reg:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Installer\UserData\S-1-5-18\Products\7040110900063D11C8EF10054038389C\Patches\F498D7EF7BACEF540865443F52234A30]
"MSI3"=dword:00000001
"State"=dword:00000001
"Uninstallable"=dword:00000001
"LUAEnabled"=dword:00000000
"PatchType"=dword:00000000
"Installed"="20070918"
"DisplayName"="Update for Outlook 2003: Junk E-mail Filter (KB936677): OUTLFLTR"
"MoreInfoURL"="http://support.microsoft.com/kb/936677"

Source:
http://www.german-nl...m...ost&p=89547


TNX
but i didn't try to integrate the junk filter.... i want integrate only sp3
but this bug regards only the junk filter ?? or any future post-sp3 update can be done only via Microsoft update?

Edited by skonvols2k, 19 September 2007 - 07:31 AM.


#92
Siginet

Siginet

    Windows XP PowerPacker Creator

  • Members
  • PipPipPipPipPip
  • 738 posts
I finally was able to make this work for SP3. Man... this method really needs to be simplified. beeker, vegar and others have done great at simplifying it a bit. But it is still pretty confusing. :blink: After I release v1.5 of the integrator I plan on taking a crack at making this method very simple. The hardest part for me will be converting the sort2cabs.js to Autoit code... but looking through the file it looks very possible. Once I convert that then I will convert all of the batch files into autoit and implement it into my Office Integrator GUI. ;) This by far is the BEST way to integrate Hotfixes and Servicepacks into an office installation disk. I just got my Office disk down from about 1.5 GB to 722 MB. That is a significant difference. But the time it took for me to trial and error this was crazy. :wacko: I am not a newbie to code... so for it to be this hard for me... I am either a lot dumber than I thought... ;) or... most people who try this give up.

The main thing I don't like about all of this is having to use orca to pop up windows and automate things. It leaves so much room for errors. :( Does anyone know of a way to silently perform orca stuff? I think I saw a commandline tool a while back but I don't remember where.

Thanks

#93
galileo

galileo

    Newbie

  • Members
  • 12 posts
@siginet:

I have been following several Office slipstream threads/procedures and I agree with you - this approach seems to be one of the better - and - one of the more convoluted due to the number of individual steps. I have seen your Office Integrator and am looking forward to seeing you develop it further after you put the finishing touches on V1.5 of Integrator (Great job there especially).

A clean clear "simple" (KISS) tool is still needed on the Office slipstream front...

#94
mikesw

mikesw

    Advanced Member

  • Members
  • PipPipPip
  • 365 posts
take a look at this other slipstreamer for office

http://www.msfn.org/...100#entry729948

#95
galileo

galileo

    Newbie

  • Members
  • 12 posts
thx..already been there and have had some issues with it....left a message for mara- this morning....

#96
cerellean

cerellean
  • Members
  • 1 posts
I can not download sort2cabs.js

#97
NagatoYuki

NagatoYuki
  • Members
  • 1 posts
The Only Problem for slipstreaming Office 2003 SP3...

creating Q3561416.CAB:

Microsoft ® Cabinet Tool - Version 1.00.0601 (03/18/97)
Copyright © Microsoft Corp 1996-1997. All rights reserved.

Creating new cabinet '..\Q3561416.CAB' with compression 'LZX:21':
-- adding ..\FILES\PFILES\MSOFFICE\OFFICE11\1028\PPMAIN10.AW
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\BADNWS_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\BROCHR_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\BUSPLN_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\FINANC_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\GENRIC_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\MKTPLN_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\PRJOVR_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\STATUS_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\SELL_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\1028\STRATG_S.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\BALANCE.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\COMPASS.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\CRAYON.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\CURTAIN.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\DIGITDOT.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\EDGE.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\FADGRID.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\FIREWORK.POT
-- adding ..\FILES\PFILES\MSOFFICE\TEMPLATE\PDESIGNS\GLASS.POT
FCIAddFile() failed: code 8 [Failure compressing data]



#98
LordWarlock

LordWarlock

    Junior

  • Members
  • Pip
  • 68 posts

The main thing I don't like about all of this is having to use orca to pop up windows and automate things. It leaves so much room for errors. :( Does anyone know of a way to silently perform orca stuff? I think I saw a commandline tool a while back but I don't remember where.

This might be useful - Windows Installer Scripting Examples, there is also other info, actually a lot of info, msi is quite complex. All the scripts are in the Windows SDK, unfortunately, I don't know about any commandline tool able to do the same thing.

#99
Gremo

Gremo

    Member

  • Members
  • PipPip
  • 101 posts

I can not download sort2cabs.js


me too...anyone can upload it again?

#100
Gremo

Gremo

    Member

  • Members
  • PipPip
  • 101 posts
i can't believe nobody has ort2cabs.js :whistle:




2 user(s) are reading this topic

0 members, 2 guests, 0 anonymous users



How to remove advertisement from MSFN