blog.devbroker.org author="Patrick Rabian" about="c#, sharepoint, biztalk, team system resources" more="news, samples, tips for .NET world's developers !"

Sharepoint 2007 : disable automatic cleanup of workflow history

Thursday, 26 June 2008 20:16 by prabian

To keep a detailed history of the approval processes, It could be necessary to keep the workflow history after 60 days (predefined cleanup in MOSS 2007).

See the following article : http://technet.microsoft.com/en-us/library/cc298800.aspx

The main point of attention is the fact that "workflow history" is a Sharepoint List and could it decrease MOSS's site performance if the list exceeds 2000 items.

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags:   ,
Categories:   SharePoint
Actions:   E-mail | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed

Error on MOSS workflow using Active Directory Groups (domain groups)

Thursday, 26 June 2008 20:14 by prabian

Lightweight Directory Access Protocol Clients that use the DirectorySearcher class to query the Active Directory directory service may receive an incomplete result set.
It could be identified by the following error :

 System.DirectoryServices.DirectoryServicesCOMException (0x800700EA): More data is available.
 
This problem appears on MOSS 2007 while a workflow is processed and a domain group was used to define the approvers.
 
To correct the problem, go to the web.config of the target webapp (the path could be something like : C:\Inetpub\wwwroot\wss\VirtualDirectories\webappname) and apply the following changes :
 
  •  Add this first green block above the red tag
[…]
 
<section name="system.directoryservices" type="System.DirectoryServices.SearchWaitHandler, System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
 </configSections>
 <SharePoint>
 
[…]
 
 
  •  Add this second green block between the red tag
[…]
 
 </SharePoint>
 <system.directoryservices>
    <DirectorySearcher waitForPagedSearchData="true" />
 </system.directoryservices>
 <system.web>
 
[…]
 
More details at Microsoft support : http://support.microsoft.com/kb/833789
Problem is described for .NET 1.1 but this post is dedicated for .NET 2.0

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Internet Explorer : ouvrir un document Excel depuis un lien hypertext.

Thursday, 26 June 2008 19:51 by prabian

Voici comment ouvrir un document Excel sous forme de lien hypertexte à partir d'un script javascript puis vbscript.
Il est important que le niveau de sécurité du navigateur autorise l'execution de composants ActiveX.
Ces scripts peuvent être utiles dans un contexte ou seul Internet Explorer est utilisé. (contrainte d'execution ActiveX).

JAVASCRIPT

<script language="javascript" type="text/javascript">
<!--

function OpenExcelDocument(documentUrl)
{    
    if (!window.ActiveXObject)
    {
        alert('Attention ! Les paramètres de sécurité de votre poste n\'autorisent pas le lancement de composants ActiveX.');
        return;
    }

    excelApp = new ActiveXObject("Excel.Application");  

    if(excelApp==null)
    {
        alert('Attention ! La version d\'Excel requise ne semble pas être installée.');
        return;
    }

    excelApp.WorkBooks.Open(documentUrl);
    excelApp.Application.Visible = true;    
    excelApp.UserControl = true;    
}

//-->
</script>

[...] 

<a href="javascript:OpenExcelDocument('Fichier.xls');">LIEN</a> 

 

VBSCRIPT

<script language="vbscript" type="text/vbscript">
     
   Sub OpenExcelDoc(strLocation)
    On Error Resume Next
    Dim objExcel
    Set objExcel = CreateObject("Excel.Application")
    If Err.number <> 0 Then
        MsgBox "Attention ! Les paramètres de sécurité de votre poste n'autorisent pas le lancement de composants ActiveX ou la version d'Excel requise ne semble pas être installée."
        Exit Sub
    End If
    objExcel.WorkBooks.Open strLocation
    objExcel.Visible = true    
    objExcel.UserControl = true
   End Sub
   
</script>

[...]

<a href="#" language="vbscript" onClick="OpenExcelDoc('Fichier.xls')">LIEN</a>
 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags:   ,
Categories:   COM | Javascript | Office | Win32
Actions:   E-mail | del.icio.us | Permalink | Comments (0) | Comment RSSRSS comment feed