Export to Excel Activex Controls for Restricted user in Windows

[raves]

Hi Everyone

We have a web client of B7333 which the End-users login to production. The issue is that there is change in the system setup of their local Windows PC. Their administrative rights have been removed and now they are logged in to WINDOWS AS NORMAL RESTRICTED USERS.

Now the JDEexport Activex jdeexpimp.inf” and “jdeexpimp.ocx does not get installed as the user no longer has admin rights. This has become a showstopper and as the local system setup will span to many more departments. This is going to be a very big hurdle.

Could you suggest an alternative through which the user can get the "Export to Excel" feature?

Thanks in Advance.

 

[klwong]

There are various tech white papers that talk about pre-installing the ActiveX controls for the users. Try searching for solution ID 200810572, or document number 761109.1.

 

[Malcolm]

We use Group Policy to push them out, work nicely

 

[Stats]

We have this issue with every Tools upgrade, 88.96>8.97>8.98. As Malcom said, a push by the network guys seems to be the best solution.

 

[unitas99007]

We just did this for the 8.98 tools. I had one Group Policy Obcject with a startup script (for the stuff that needed admin rights) and a logon script (for the stuff that had to be invdividual user).

GPO Startup script:
<font class="small">Code:</font><hr /><pre>
c:

xcopy /y /r "\\<servername>\<sharename>\JDE_90\jdewebctlsU.ocx" c:\Windows\System32\
xcopy /y /r "\\<servername>\<sharename>\JDE_90\jdewebctls.inf" c:\Windows\System32\
xcopy /y /r "\\\<servername>\<sharename>\JDE_90\jdeexpimpU.ocx" c:\Windows\System32\
xcopy /y /r "\\<servername>\<sharename>\JDE_90\jdeexpimp.inf" c:\Windows\System32\
xcopy /y /r "\\<servername>\<sharename>\JDE_90\JDE_90.reg" c:\Windows\System32\

cd c:\windows\system32
regsvr32.exe jdewebctlsU.ocx
regsvr32.exe jdeexpimpU.ocx
</pre><hr />

GPO Logon Script:
<font class="small">Code:</font><hr /><pre>
xcopy /y /r "\\<servername>\<sharename>\JDE_90\JDE_90.reg" c:\Windows\System32\

C:

CD C:\Windows\system32

REGEDIT.EXE /S \\<servername>\<sharename>\JDE_90\JDE_90.reg
</pre><hr />

Contents of JDE_90.reg:
<font class="small">Code:</font><hr /><pre>
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ZoneMap\Domains\<your domain here>]
"*"=dword:00000002

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\2]
"1604"=dword:00000000
"2200"=dword:00000000
"1803"=dword:00000000
"1809"=dword:00000003

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\3]
"1604"=dword:00000000
"2200"=dword:00000000
"1803"=dword:00000000
"1809"=dword:00000003

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
"MaxConnectionsPerServer"=dword:0000000a
"MaxConnectionsPer1_0Server"=dword:0000000a
"EnableHttp1_1"=dword:00000001
"ProxyHttp1.1"=dword:00000001
</pre><hr />

So between the startup script, the logon script, and the registry key, this copies the activex controls from a share, registers them, adds your domain to trusted sites, sets the active x controls to all the appropriate settings, and setts HTTP to 1.1 mode, and sets the "MaxHTTPConnections" value to 10. (2 by default, 10 is recommended by Edwards). The HTTPConnections thing solved alot of client machine performance problems for us.

Hope all goes well.

Unitas99007