In the past
I would consider ”SAS Add-In for Microsoft Office” as very easy to sequence, and 7.15 hf3 was working well
without doing anything special.
But after
we tried to sequence the latest 8.2 version on
W10 build 1809 with Office 2019 (x86) installed into the Os,
we had some problems getting the COM plugin to load when we put the package in
a Connection group with lots of other packages.(Worked sometimes when deployed with just a runvirtual key to Office)
We tried
both with and without different VSTO versions in the base Os, and also
tried to seq. it into the package for testing.
And we even
tried Seq. on 1709 and with Office 2013 (x86) in base with no luck.
So I had to
investigate further using a Procmon trace of the
manual install vs the sequenced install, and noticed the correct COM entry’s
was not created during startup with the package in CG
using the create entry’s in the package.
This entry seems to be the place where it creates the key corresponding to the
correct office version with 15.0 for 2013 and 16.0 for Office 2016/365 or above
: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\User
Settings\SAS Add-In for Microsoft Office\Create\Software\Microsoft\Office\Excel\Addins\SAS.ExcelAddIns
and the same for Word, Powerpoint and Outlook.
Having
repackaged a lot of Office plugins over the years I found the missing keys, and
created a regfile with the missing keys, and imported them during the capture. I deselected outlook addin during install so that’s why it’s not there.
But it’s in the same place.. HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\outlook…..
The regfile is like this:
|
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn] "CommandLineSafe"=dword:00000001 "Description"="The SAS Add-In
for Microsoft Office allows you to access the power of SAS directly from your
Microsoft Office application." "FriendlyName"="SAS
Add-In 8 for Microsoft Office" "LoadBehavior"=dword:00000003 "Manifest"="C:\\Program Files
(x86)\\SASHome\\x86\\SASAddinforMicrosoftOffice\\8\\SAS.ExcelAddIn.vsto|vstolocal" "Version"="8" [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn] "CommandLineSafe"=dword:00000001 "Description"="The SAS Add-In
for Microsoft Office allows you to access the power of SAS directly from your
Microsoft Office application." "FriendlyName"="SAS
Add-In 8 for Microsoft Office" "LoadBehavior"=dword:00000003 "Manifest"="C:\\Program Files
(x86)\\SASHome\\x86\\SASAddinforMicrosoftOffice\\8\\SAS.PowerPointAddIn.vsto|vstolocal" "Version"="8" [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn] "CommandLineSafe"=dword:00000001 "Description"="The SAS Add-In
for Microsoft Office allows you to access the power of SAS directly from your
Microsoft Office application." "FriendlyName"="SAS
Add-In 8 for Microsoft Office" "LoadBehavior"=dword:00000003 "Manifest"="C:\\Program Files
(x86)\\SASHome\\x86\\SASAddinforMicrosoftOffice\\8\\SAS.WordAddIn.vsto|vstolocal" "Version"="8" |
How to Sequence:
I recommend
installing the VSTO
tool into the base Os.
Same for the vcreds. Install all Vcreds
from package into base OS. Also install them on your production computers.
Latest Ms
Office (2019) the installation source files into base OS.
(Os need to be rebooted after installation.)
Example of
install cmd script for silent install of vsto and vcreds, may be newer
versions so check that out, my sample file was from 7.15hf4 version.
|
echo Installing
(1/7): vstor redist- %~dp0prereq\vstor\vstor_redist.exe /q /norestart echo Return Code: %ERRORLEVEL% :: echo Installing (2/7): VC++ 2013 x86 %~dp0prereq\vcredist2013\vcredist_x86.exe /q echo Return Code: %ERRORLEVEL% :: echo Installing (3/7): VC++ 2013 x64 %~dp0prereq\vcredist2013\vcredist_x64.exe /q echo Return Code: %ERRORLEVEL% :: echo Installing (4/7): VC++ 2015 x86 %~dp0prereq\vcredist2015\vc_redist.x86.exe /q echo Return Code: %ERRORLEVEL% :: echo Installing (5/7): VC++ 2015 x64 %~dp0prereq\vcredist2015\vc_redist.x64.exe /q echo Return Code: %ERRORLEVEL% |
Sequencing information included in the documentation
file
------------------------------------------------------------------------------------------------------------------------------------
Documentation for App-V-Sequenced application: SAS Office addin
8.2
Documentation
created: 25.03.2020 16:31
Installation
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Sequenced
on Windows Version:10.0.17763.0 system with App-V Sequencer version:
10.0.17763.1
Sequenced
created:25.03.2020 15:27:29
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Appvnavn:SAS Office addin
Version:0.0.0.5
PackageID=989c4592-8ace-49fa-9a89-80218be427b5
VersionID=12fc5ea0-e4ea-483e-a6c1-387eaba2c43f
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
-----------------------------------------------------
Prerequirements before Sequencing:
-----------------------------------------------------
Latest Ms
Office (2019) must be installed together with the attached (VSTO) vstor_redist.exe
from the installation source files into
base OS.
(Os need to be rebooted after installation.)
-----------------------------------------------------
Sequence
Install with the following parameters: Install all package Vcreds
into sequencer machine, could be found in vcred
folder under application when installed. Also install them on your production
computers.
-----------------------------------------------------
Sequence
Install with the following parameters:
-----------------------------------------------------
Load your appv template file
Remove vcreds capture from package
Sequence as
plugin.
Run
"install.sas.officeaddin.cmd" file from installation source files. It
will Turn off all languages and Deselect Outlook addin.
Install script
will also install custom regkey and then copy "%SAS.OfficeAddin.dll.config" to "%ProgramFiles(x86)%\SASHome\x86\SASAddinforMicrosoftOffice\8\"
Save
package.
Open in TMedit. Cleanup package, except
.net compile and merge of registry keys.
Save
package.
Open
package in AVE and delete all extra shortcuts.
Save
package.
-----------------------------------------------------
Package
information:
-----------------------------------------------------
-- Machinescripts --
-----------------------------------------------------------------------------
On Add Package:
MachineAdd.cmd (For details see Source.exe)
Script Altiris Rule:
Rollback:1
Timer:60
On Publish Package:
MachinePublish.cmd (For details see Source.exe)
Script Altiris Rule:
Rollback:1
Timer:60
On Unpublish
Package:
MachineUnpublish.cmd (For details see Source.exe)
Script Altiris Rule:
Rollback:1
Timer:60
On Remove Package:
MachineRemove.cmd (For details see Source.exe)
Script Altiris Rule:
Rollback:1
Timer:60
-- Userscripts –
-----------------------------------------------------------------------------
Added Scriptfiles:
MachineAdd.cmd
MachinePublish.cmd
MachineRemove.cmd
MachineUnpublish.cmd
------------------------
COM - OPTIONS -------------------------
FullVfsWriteMode: True
COM:Integrated | InProcessEnabled = false | OutOfProcessEnabled = true
DiableBrowserPlugin = false
Object
Isolation Exclutions:
*
-----------------------------------------------------------------
REG - INFO:
c:\Temp\Appv\Doc\000_Registry.dat:
Node Keys:
4641
Value Keys:
6125
c:\Temp\Appv\Doc\007_Registry.dat:
Node Keys:
4650
Value Keys:
6143
Nodes
Deleted : 0
Nodes
Unchanged : 10766
Nodes
Modified : 0
REG -
CHANGES:
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn\CommandLineSafe:
1
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn\Description:
The SAS Add-In for Microsoft Office allows you to access the power of SAS
directly from your Microsoft Office application.
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn\FriendlyName:
SAS Add-In 8 for Microsoft Office
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn\LoadBehavior:
3
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn\Manifest:
[{ProgramFilesX86}]\SASHome\x86\SASAddinforMicrosoftOffice\8\SAS.ExcelAddIn.vsto|vstolocal
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\SAS.ExcelAddIn\Version:
8
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn\CommandLineSafe:
1
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn\Description:
The SAS Add-In for Microsoft Office allows you to access the power of SAS
directly from your Microsoft Office application.
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn\FriendlyName:
SAS Add-In 8 for Microsoft Office
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn\LoadBehavior:
3
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn\Manifest:
[{ProgramFilesX86}]\SASHome\x86\SASAddinforMicrosoftOffice\8\SAS.PowerPointAddIn.vsto|vstolocal
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins\SAS.PowerPointAddIn\Version:
8
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn\CommandLineSafe:
1
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn\Description:
The SAS Add-In for Microsoft Office allows you to access the power of SAS
directly from your Microsoft Office application.
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn\FriendlyName:
SAS Add-In 8 for Microsoft Office
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn\LoadBehavior:
3
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn\Manifest:
[{ProgramFilesX86}]\SASHome\x86\SASAddinforMicrosoftOffice\8\SAS.WordAddIn.vsto|vstolocal
Added:ROOT\REGISTRY\MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Word\Addins\SAS.WordAddIn\Version:
8
FILE -
CHANGES:
Changed:StreamMap.xml
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Altiris
detection rules:
- PublishPackage:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\COMPANY\AppV\SAS Office addin
PublishPackage=0.0.0.5/989c4592-8ace-49fa-9a89-80218be427b5/12fc5ea0-e4ea-483e-a6c1-387eaba2c43f
- AddPackage:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\COMPANY\AppV\SAS Office addin
AddPackage=0.0.0.5/989c4592-8ace-49fa-9a89-80218be427b5/12fc5ea0-e4ea-483e-a6c1-387eaba2c43f
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
Powershell:
-----------------------------------------------------
Add Publish
Mount commandline Powershell:
powershell.exe "Add-AppvClientPackage -Path 'SAS Office addin.appv'
| Publish-AppvClientPackage –Global | Mount-AppvClientPackage"
Add Mount commandline Powershell:
powershell.exe "Add-AppvClientPackage -Path 'SAS Office addin.appv'
| Mount-AppvClientPackage"
Publish
Mount commandline Powershell:
powershell.exe "Publish-AppvClientPackage -Name 'SAS Office addin'
–Global | Mount-AppvClientPackage"
UnPublish
Remove commandline Powershell:
powershell.exe "Unpublish-AppvClientPackage -Name 'SAS Office addin' -Global | Remove-AppVClientPackage"
Unpublish
commandline Powershell:
powershell.exe "Unpublish-AppvClientPackage -Name 'SAS Office addin' -Global"
Unpublish
Remove Widh PackageID and VersionID commandline Powershell:
powershell.exe "Unpublish-AppvClientPackage -packageid
989c4592-8ace-49fa-9a89-80218be427b5 -versionid
12fc5ea0-e4ea-483e-a6c1-387eaba2c43f -global |Remove-AppvClientPackage"
No comments:
Post a Comment