|
|
Dynamics GP Partner Newsflash: Disabling MS Office Outlook Snap-In - Alba Spectrum
Alba Spectrum
If you have Microsoft Dynamics GP, formerly known as Great Plains Dynamics and eEnterprise implemented in large organization, especially when you are deploying non-Microsoft email solutions: Lotus Notes Domino, for example, you may receive error messages on login Dynamics GP user workstation. Errors are typically associated with Microsoft Office Web Components absence. Dynamics GP integration with MS Office and Sharepoint really makes its user interface easy and intuitive, but we can understand that if you are on Linux and Open Office, error messages on login might be annoying (Metrics are not available because Microsoft Office Chart - or something like that). In this small publication we are offering you Outlook integration disabling scripts with basic explanations:
1. Please open SQL Server 2005 Management Studio for SQL 2005 or SQL Server Enterprise Manager and Query Analyzer for SQL 2000. In New Query switch to Dynamics Database and copy this SQL statement:
UPDATE A SET COLNUMBR = 0, SEQNUMBR = 0, Visible = 0 FROM SY08100 A WHERE (SectionID = 2) AND
(DICTID = 0) AND ((COLNUMBR <> 0) OR (SEQNUMBR <> 0) OR (Visible <> 0)) and USERID='FRED'
Attention: please, before you hit run button, change Fred to actual user id. If you want to take off integration for all the users, we recommend you first to make SY08100 table backup, run this statement:
SELECT * INTO SY08100_Backup from SY08100
And then run the following statement:
UPDATE A SET COLNUMBR = 0, SEQNUMBR = 0, Visible = 0 FROM SY08100 A WHERE (SectionID = 2) AND
(DICTID = 0) AND ((COLNUMBR <> 0) OR (SEQNUMBR <> 0) OR (Visible <> 0))
2. Dynamics GP 10.0 user workstation installation issues. If you have Microsoft Dynamics GP 10.0 CD #1, it is natural to try to insert CD and follow installation defaults. However, if you have Windows XP Pro or Vista OS and you already deployed MS Office 2007, you may get Dexterity Shared components installation failure and no options offered to continue. There is work around, you need to login Dynamics GP Customer Source and download files: DexSkipDotNetCheck.mst and probably SkipDotNetCheck.mst. Then copy GP CD1 content into your Workstation hard drive and launch installation from command line:
msiexec /i "c:\gp10\cd1\Bin\DexCmn\DexterityCommonFiles.msi" TRANSFORMS="C:\DexSkipDotNetCheck.mst"
This command allows you to get around Dexterity Shared Components, and second statement:
msiexec /i "C:\gp10\cd1\bin\GreatPlains.msi" SQL_SERVER_NAME="ALBASERVER" INSTALLDIR="C:\Program Files\Microsoft Dynamics\GP" SELECTED_COUNTRY="United States" TRANSFORMS=:Inst01;c:\skipdotnetcheck.mst INSTANCE_NAME="GP" MSINEWINSTANCE=1 /qb+
allows you to avoid older .Net components version install. In the command line scripts, please change directories to your real paths
3. We assume that if you are reading these lines, you probably have tight budget and would like to resolve GP installation issues internally. However, feel free to give us a call for short consultancy: 1-866-528-0577, help@albaspectrum.com
Andrew Karasev, Alba Spectrum, help@albaspectrum.com http://www.albaspectrum.com 1-866-528-0577. Please visit our info portal Pegas Planet: http://www.pegasplanet.com Local Service in Chicago, Atlanta, San Diego, Los Angeles, Orange County, Houston. We also have SAP Business One Software Development Factory and SB1 Technical Support Call Center, serving USA country side businesses and internationally: Canada, Brazil. Illinois practice: Naperville, Aurora, Plainfield, Marseilles, Ottawa, DeKalb, Springfield, Oakbrook, Glenn Ellyn, Wheaton, Bolingbrook, Romeoville, Lisle, Melrose Park, Brookfield. San Diego and LA practice: Rancho Bernardo, Oceanside, Poway, Long Beach, Irvine, Mission Viejo, San Marcos, Carlsbad, La Jolla, Escondido. Houston Practice: Dallas, Galveston, Sugar Land, Pearland, Katy, Pasadena, Rosenberg, League City, Galena Park
Author Site
6/23/2009
|
|
