Kaj storiti če Edit in datasheet view ne dela




Kar naenkrat je v SharePoint Portalu 2003 nehala delat funkcija urejanja v datasheet view. Micorosft support ni dal prave rešitve, le to, da bi naj delalo le v Office Pro 2003 in ne v Office 2007, čeprav je nam to delovalo, pa da bi naj bil krivec SP3 za Office 2003, kar pa tudi ne drži v našem primeru. Tole je Microsoftov odgovor:

Problem: User unable to view a list in Datasheet view on WSS 3.0

Background: Users report problems viewing a list in the Datasheet view on WSS 3.0. An error message users receive is:

“The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.”

Problem Causes: The Microsoft knowledge base on this issue is located here. This behavior occurs if one or more if the following conditions are true:

* A datasheet component that is compatible with Windows SharePoint Services is not installed.
* A Microsoft Office 2003 Professional edition is not installed on the computer.
* The Web browser does not support ActiveX controls.
* Support for ActiveX controls is disabled.

042908_1713_thelistcann1

Torej se je bilo potrebno lotiti resnega guglanja. Edino kar je bilo v kratkem inštalirano, je bila nadgradnja WSS na 3.o verzijo in na SPP 2003 SP3 in to se je tudi izkazalo kot krivec. In res je našel google povezavo med wss 3.0 + SP3 in tem problemom.

stanje na strežniku: Windows 2003 SP2
SharePointPortal 2003 SP3
WSS 3.0

REŠITEV:
V SPP 2003 serverju pojdi do datoteke ows.js
C:\Program Files\Common Files\Microsoft Shared <BR>\web server extensions\60\TEMPLATE\LAYOUTS\1033

Odpri OWS.js v notepadu,poišči “PortalPinToMyPage” in vnesi naslednjo kodo:

function PortalPinToMyPage(eForm, portalUrl, instanceID)
{
eForm.action = portalUrl + ‘_vti_bin/portalapi.aspx?
Cmd=PinToMyPage’;
eForm.ReturnUrl.value = window.location.href;
eForm.ListViewUrl.value =
MakeMtgInstanceUrl(eForm.ListViewUrl.value, instanceID);
eForm.submit();
}
—-Start copy here—-
function RenderActiveX(str)
{
document.write(str);
}
—-End copy here—-

var L_CutToolTip_TEXT = “Cut”;

Potreben je le še restart IIS in problem je odpravljen.

Enhanced by Zemanta

Saša

Works as system engineer in Slovenian Enterprise in Microsoft environment focusing on security, deployments, SharePoint, SCCM and CheckPoint firewall. Author of successful blog about IT security, Microsoft tips & tricks, social media, internet trends.

Leave a Reply