[whakamaru]

Need help
I have used SP2 on all MS Office apps and when I run newsort2cabs.js I get the following error

sorting files...
md5sum: ..\FILES\PFILES\MSOFFICE\VISIO11\1033\SETUP.CHM: No such file or directory

Error: [object Error]

I have run the whole script without Visio2003 and it all works perfectly.

[alhaddar]

What do you need:
- ORCA
- MSI 3.1 installed
- WSH 5.6 installed

where I get this files


pls help

thanks

alhaddar

[Siginet]

OK... it's been a long time since I messed with doing this. I see now that the download for sort2cab.zip is broken.

I got newsort2cab.zip... but it isn't working for me.

I forget what the tabledirs.lst and xmlfiles.lst files should look like.


currently I have them both looking like this:

OWC10
OWC11
PRO11

Is that correct?

I keep getting an error settings.ddf not found.

also... I am trying to add the 3 latest updates. I have allready used this method on my source. Is it possible I am having these issues because it is previously slipstreamed using this very method?

[colornokia]

Sort2cab

[whakamaru]

I am having trouble getting this hotfix slipstreamed.

Update for Outlook 2003 (KB913807) (English version)

I have slipstreamed SP2 and these hotfixes in the following order

Security Update for Excel 2003 (KB905756)
Security Update for PowerPoint 2003 (KB916518)
Security Update for Word 2003 (KB917334)
Update for Office 2003 (KB907417)
Update for Outlook 2003 (KB913807) (English version)
Update for Outlook 2003 Junk Email Filter (KB917149)


When I have completed the installation of Office 2003 and run the MS Office update it says that the Update for Outlook 2003 (KB913807) (English version) needs to be installed.

Can some one point me in the right direction on this please.

[beeker]

Great procedure marek722! After doing one CD I decided to help automate some tasks.

With a lot of googling and trial and error, I made some AutoIt scripts for the Orca parts.
I picked up Orca at Shark's file repository, Thanks Shark007!
For the last part of marek722's Step 3, use the attached Export_msi_tables.au3 script to create the subdirectories for every msi and it runs Orca to extract the 5 tables to the appropriate directories.

I run the following cmd file called start_script.cmd after Step 3:

@echo off
ECHO.
ECHO   Copying the xml files from ..\FILES\SETUP\
COPY /Y ..\FILES\SETUP\*.xml .
ECHO   Creating xmlfiles.lst and tabledirs.lst files
DIR /B *.xml > xmlfiles.lst
DIR /B /AD > tabledirs.lst
cscript sort2cabs.js
pause
ECHO.
ECHO   Copying the updated xml files to ..\FILES\SETUP\
XCOPY /Y /R /U /I *.xml ..\FILES\SETUP\
ECHO.
ECHO Now restore the backed up ini files in ..\FILES\SETUP\
ECHO and delete all files that were NOT originally on the office cd.
ECHO.
pause

That covers steps 4 and 5 (don't need tabledirs.lst and xmlfiles.lst anymore because they're created automatically).
Use the AutoIt script called Update_msi_tables.au3 (attached) to run Orca and import the new tables into the msi packages (that covers step 6).

Now I need help with the js code to call this AutoIt script from marek722's sort2cabs.js where it pauses with: update MSI files with the new tables and press <enter> to continue ...

I also plan to use benase's fix for Max compression (Post #15) and tCP's batch to delete unwanted files (Post #20). With benase's fix for Max compression, we don't need the settings.ddf file anymore.

Note: The start_script.cmd file and AutoIt scripts go in the same "sort" directory as sort2cabs.js
Thanks for sharing everyone!

Attached File(s)

•  Update_msi_tables.au3 (5K)
  Number of downloads: 59
•  Export_msi_tables.au3 (4.79K)
  Number of downloads: 56

This post has been edited by beeker: 04 September 2006 - 07:48 PM

[beeker]

whakamaru, on Jun 23 2006, 08:24 AM, said:

When I have completed the installation of Office 2003 and run the MS Office update it says that the Update for Outlook 2003 (KB913807) (English version) needs to be installed.

Did you apply both msp's (OUTLOOKff.msp and OLKINTLff.msp) to OUTLS11.MSI ?

[beeker]

Oh joy, I got the sort2cabs.js script to call the AutoIt script by copying some of marek722's existing code for oExec (don't understand it all, but) and adding an If statement.
(now I'm hooked on all this coding stuff but my wife's angry)

With AutoIt installed, all you have to do is right click on the "Update_msi_tables.au3" file and choose "Compile script". Now we can call the "Update_msi_tables.exe" file from marek722's script sort2cabs.js with the following modification:
In the "// main" section I added a variable declaration:
var oExec
and where he had the following two lines:
WScript.StdOut.Write("\nNow update your MSI files with the new tables and press <enter> to continue ...");
WScript.StdIn.ReadLine();

I wrapped the following code around it:
// update MSI files manually, or use compiled AutoIt script if available
arRun = "Update_msi_tables.exe"
if (fso.FileExists(arRun)) {
WScript.Echo("\nRunning " + arRun + " to update msi files");
oExec = wsh.Exec(arRun);
while (oExec.Status != 1) {
WScript.Sleep(100); // too large? ...
// following is simply sick! ... ReadAll produces buffer overflow ... Read waits for LF, too! ...
while (!oExec.StdOut.AtEndOfStream) WScript.StdOut.Write(oExec.StdOut.Read(40)); // >1 for faster looping
while (!oExec.StdErr.AtEndOfStream) WScript.StdErr.Write(oExec.StdErr.Read(1));
}
} else {
WScript.StdOut.Write("\nNow update your MSI files with the new tables and press <enter> to continue ...");
WScript.StdIn.ReadLine();
}
This doesn't break the existing functionality if you don't have the AutoIt script.
Attached is a version with these modifications plus the mod from post #15.

I'll be trying some more automation later this week (when the wife is asleep).

EDIT: 24 Sep 2006 - Modified sort2cabs.js again so that it uses cabarc (better compression) as first choice if it exists in %windir%\System32, otherwise use makecab and settings.ddf like marek722's original sort2cabs.js Added Veger's fix for md5sum also, Thanks.

Attached File(s)

•  sort2cabs.js (18.4K)
  Number of downloads: 106

This post has been edited by beeker: 24 September 2006 - 06:13 PM

[NiGHTsC]

Can someone tell me how to do this for SP2?
I just got this SP2 version "Microsoft.Office.2003.Pro.SP2.English.AIO.5.in.1.DVD.v3-MANiacs.iSO"

Quote

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).

I extract the ISO and I didn't see any XML files in \FILES\SETUP\, there's only 1 file and it's SETUP.INI

Quote

5. Open a command line (cmd) and change path to X:\office2003\sort. Start sort2cabs using folling syntax:CODEcscript sort2cabs.js
for successful completion md5sum.exe and makecab.exe should be placed in a directory listed in the path variable! ok, time for a cup of coffee

I'm using WinXP SP2, I put "makecab.exe" and "md5sum.exe" in C:\Windows\System32, but I got an error after runing sort2cabs.js
-----------------------------------------------------------------------
G:\MS\OFFICE03SP2\sort>cscript sort2cabs.js
Microsoft ® Windows Script Host Version 5.6
Copyright © Microsoft Corporation 1996-2001. All rights reserved.

directories found:
sorting files...
sorting cabs...
renumbering...

Replacing some CAB Files

Error: [object Error]
-----------------------------------------------------------------------

Quote

I successfully slipstreamed SP2 following marek722's tutorial but I still cannot install the two subsequent updates KB907417 and KB905648 either manually or from Office Update. Is anyone else able to install these?

Update: Ok, this has something to do with I'm installing Office 2003 on Windows Server 2003. I ran the same Office install on a vmware XPSP2 and had no problems installing all office updates. Just by quick inspection, I noticed in XP the service "Office Source Engine" is manual but started before doing the update from Office Update. With Server 2003 the service wasn't started but the updates still failed even after starting the service.

I was going to see if I could use Server as my workstation, but it seems not feasible for me because of this and a couple other minor issues. Anyway it was worth a try, back to XP...

jimanny, can you tell me how did you slipstream SP2?
I got some problems after Step4.
Thank you.

This post has been edited by NiGHTsC: 12 September 2006 - 12:38 PM

[NiGHTsC]

Help please, I have to burn my Office CD, but it's 900MB ><
Thank you.

[ffyy2]

-deleted by ffyy2-

This post has been edited by ffyy2: 19 September 2006 - 01:59 AM

[ggg]

can anyone please post again (here or on rapidshare) sort2cabs.js ?
link is down,and the rapidshare link posted by colornokia has expired.

[beeker]

If you downloaded my modified sort2cabs.js above, then you'll need cabarc.exe in your system path, otherwise you'll get the Error: [object Error] that NiGHTsC experienced.

If you don't want to use cabarc.exe then you can edit sort2cabs.js as follows:
// oExec = wsh.Exec("cabarc -m lzx:21 n ..\\" + i + " @" + i + ".ddf");
oExec = wsh.Exec("makecab /D CabinetNameTemplate=..\\" + i + " /F settings.ddf /F " + i + ".ddf");

I'm testing a fully automated "beef stew" SP2 + Hotfix update of the AIO CD right now using autoit. It's almost there but when I install the finished CD, Infopath stops because it can't find a file in a cab, all the other apps are ok though.

I can share another script for now. I used this script to copy the original setup.ini files from AIO CD to HD working directory and to remove folders and files that don't exist on the AIO CD. It asks for the location of your source CD and Destination working directory on your HD before continuing. There's a couple of message boxes before each step that you can just comment out if you don't want to be asked.

Attached File(s)

•  OfficeCleanUp.au3 (6.15K)
  Number of downloads: 55

[veger]

First very nice guide marek722! It's working smoothly.

Second very nice AutoIT scripts beeker! Saves a lot of time when using them! Only need a script to slipstream the hotfixes and it's completely automated!
Would it also possible to enhance the cleanup script to have multiple cds (or cdimages)?

Some notes to help others who may experience the same kind of problems I did:
- When exporting the tables with Orca (2.0.3790.0) the filenames are truncated to 8.3 length. So make sure you rename them properly otherwise sort2cabs can't find them and error seen in post #71 will occur. Maybe this can be included in Export_msi_tables.au3?

- Not using an admin install as a base seems to work fine (with both office and visio combine onto 1 cd). While installing you still need to enter the PID code and the local cache seems to work fine. Only using Windows Update isn't working properly since the slipstreamed updates aren't recognised. This isn't a real problem since these updates can be hidden. Getting new updates from the site works fine.

- When the admin install isn't used, it seems to be possible to update your slipstreamed install with new hotfixes and run sort2cab again. But I haven't tested this thourougly yet.

This post has been edited by veger: 23 September 2006 - 06:18 AM

[veger]

I did some scripting after all to automate the process even more...

I've Export_msi_tables.au3 quite a lot:
- Finding orca.exe took some time since my Program Files is quite big. So it now will look for orca at the default intallation location. And after that it will scan Program Files like it did.
- Modified the _FileSearch() function since it always did recusive searching and would find a installer package in the FILES directory. This did break some things. The function can be used recursive or normal (using an extra argument).
- The dirs PRO11, OWC11, ... are created automaticly (or cleaned if running from an old setup)
- The files xmlfiles.lst and tabledir.lst are generated automaticly depending on the installer files found.
- The 8.3 filenames of the exported tables are converted to their realnames (only if they're in 8.3 format)
- Speed up the orca process by lowering the sleep times a little

Furthermore I updated sort2cab.js (beekers version) to solve a problem with calculating md5 sums. Sometimes the output wasn't grabbed correctly. To prevent this there's a check whether the output stream is empty instead of whether the md5sum.exe application status is changed. This also allows to remove the sleep() so calculating the sums is somewhat faster aswell. To find the problem I added some try...catch structures, these are still present to give a more readable feedback.

And finally I've create a nice bat file containing all updates and hotfixes. So the whole process is automated now, except for cleaning after sort2cab is finished. Haven't thought of a nice method to clean when office and visio are combined.

Attached File(s)

•  Export_msi_tables.au3 (5.05K)
  Number of downloads: 53

This post has been edited by veger: 25 September 2006 - 02:17 PM

[beeker]

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 File(s)

•  Update_msi_tables.au3 (4.7K)
  Number of downloads: 46

This post has been edited by beeker: 25 September 2006 - 09:22 PM

[veger]

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 File(s)

•  sort2cabs.js (18.28K)
  Number of downloads: 101

[veger]

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
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 ) can make use of them!

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

Attached File(s)

•  sort.zip (104.07K)
  Number of downloads: 134

[beeker]

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 File(s)

•  beefstew.zip (18.66K)
  Number of downloads: 128

This post has been edited by beeker: 01 November 2006 - 07:05 PM

[beeker]

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,