30.6.10

XSL per dashboard collegate a dataview in sharepoint designer ? VoilĂ 

<xsl:stylesheet xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" version="1.0" exclude-result-prefixes="xsl msxsl ddwrt" xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:WebControls="Microsoft.SharePoint.WebControls" xmlns:ddwrt2="urn:frontpage:internal">
    <xsl:output method="html" indent="no"/>
    <xsl:param name="dvt_apos">&apos;</xsl:param>
    <xsl:variable name="dvt_1_automode">0</xsl:variable>
    <xsl:template match="/" xmlns:x="http://www.w3.org/2001/XMLSchema" xmlns:d="http://schemas.microsoft.com/sharepoint/dsp" xmlns:asp="http://schemas.microsoft.com/ASPNET/20" xmlns:__designer="http://schemas.microsoft.com/WebParts/v2/DataView/designer" xmlns:WebControls="Microsoft.SharePoint.WebControls">
        <xsl:call-template name="dvt_1"/>
    </xsl:template>
    <xsl:template name="dvt_1">
        <xsl:param name="ParentPath"/>
        <xsl:variable name="dvt_StyleName">Table</xsl:variable>
        <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row"/>
        <xsl:variable name="dvt_RowCount" select="count($Rows)" />
        <xsl:variable name="IsEmpty" select="$dvt_RowCount = 0" />
        <xsl:call-template name="dvt_1.footer">
            <xsl:with-param name="Rows" select="$Rows" />
        </xsl:call-template>
    </xsl:template>
    <xsl:template name="percentformat">
        <xsl:param name="percent"/>
        <xsl:choose>
            <xsl:when test="format-number($percent, '#,##0%;-#,##0%')= 'NaN'">0%</xsl:when>
            <xsl:otherwise>
                <xsl:value-of select="format-number($percent, '#,##0%;-#,##0%')" />
            </xsl:otherwise>
        </xsl:choose>
    </xsl:template>
    <xsl:template name="ChartRow">
        <xsl:param name="RowName"></xsl:param>
        <xsl:param name="Value"></xsl:param>
        <xsl:param name="PercentValue"></xsl:param>
        <tr>
            <td class="ms-formbody" width="125px" style="vertical-align:middle">
                <xsl:value-of select="$RowName"/>: <xsl:value-of select="$Value" />
                <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;
            </xsl:text>(<xsl:call-template name="percentformat">
                    <xsl:with-param name="percent" select="$PercentValue"/>
                </xsl:call-template>)
            </td>
            <td>
                <table width="100%" >
                    <tr>
                        <td width="{round($PercentValue*100)+1}%" height="15px" class="ms-selected">
                            <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
                        </td>
                        <td width="100%" >
                            <xsl:text xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" ddwrt:nbsp-preserve="yes" disable-output-escaping="yes">&amp;nbsp;</xsl:text>
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </xsl:template>
    <xsl:template name="dvt_1.footer">
        <xsl:param name="ParentPath" />
        <xsl:param name="Rows" />
        <xsl:variable name="NotStarted" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Priority) = '(1) Alta'])" />
        <xsl:variable name="InProgress" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Priority) = '(2) Normale'])" />
        <xsl:variable name="Completed" select="count(/dsQueryResponse/Rows/Row[normalize-space(@Priority) = '(3) Bassa'])" />
        <xsl:variable name="AllTasks" select="count(/dsQueryResponse/Rows/Row)" />
        <xsl:variable name="percentNotStarted" select="$NotStarted div $AllTasks" />
        <xsl:variable name="percentInProgress" select="$InProgress div $AllTasks" />
        <xsl:variable name="percentCompleted" select="$Completed div $AllTasks" />
        <table width="100%" cellspacing="0" cellpadding="2" style="border-right: 1 solid #C0C0C0; border-bottom: 1 solid #C0C0C0; border-left-style: solid; border-left-width: 1; border-top-style: solid; border-top-width: 1;">
            <xsl:call-template name="ChartRow">
                <xsl:with-param name="RowName">Alta</xsl:with-param>
                <xsl:with-param name="Value">
                    <xsl:value-of select="$NotStarted"/>
                </xsl:with-param>
                <xsl:with-param name="PercentValue">
                    <xsl:value-of select="$percentNotStarted"/>
                </xsl:with-param>
            </xsl:call-template>
            <xsl:call-template name="ChartRow">
                <xsl:with-param name="RowName">Normale</xsl:with-param>
                <xsl:with-param name="Value">
                    <xsl:value-of select="$InProgress"/>
                </xsl:with-param>
                <xsl:with-param name="PercentValue">
                    <xsl:value-of select="$percentInProgress"/>
                </xsl:with-param>
            </xsl:call-template>
            <xsl:call-template name="ChartRow">
                <xsl:with-param name="RowName">Bassa</xsl:with-param>
                <xsl:with-param name="Value">
                    <xsl:value-of select="$Completed"/>
                </xsl:with-param>
                <xsl:with-param name="PercentValue">
                    <xsl:value-of select="$percentCompleted"/>
                </xsl:with-param>
            </xsl:call-template>
        </table>
    </xsl:template>
</xsl:stylesheet>

Invio email a gruppo di sharepoint da workflow designer, si ma, …

Puoi farlo si ma,

 

  1. Su SharePoint site
  2. Site Actions
  3. Site Settings
  4. Modify All Site Settings
  5. Users and Permissions
  6. People and groups
  7. Seleziona gruppo interessato
  8. Settings
  9. Group Settings
  10. Group Settings area
  11. Seleziona:  everyone for who can view the membership of the group, click OK.

Migration e Command i

stsadm -o export -url http://win2003-sp2007/sites/Documents/Ticketing -filename migrateD.dat -includeusersecurity -versions 4

 

 

stsadm -o import -url http://win2003-sp2007/destinationsiteEmpty1040 -filename migrate.dat

 

 

stsadm -o createweb -url http://win2003-sp2007/destinationsiteDati1040 -Lcid 1040

 

stsadm -o createsite -url http://win2003-sp2007/sites/destinationMigration1040 -owneremail administrator@win2003-SP2007.com  -ownerlogin win2003-SP2007\administrator -lcid 1033

Allegati (attachments), DataView e Sharepoint Designer e il lupo cattivo

Se aggiungete solo


<xsl:value-of select="@Attachments" />


vedrete solo 'True' o 'False'


Dovete invece aggiugere il controllo sharepoint


<SharePoint:AttachmentsField ControlMode="Display" FieldName="Attachments" runat="server" Visible="true"/>

Nascondere link “Cestino” e “Visualizza tutto il contenuto del sito”

Modifica del file css core.css in

C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\ [CODICE LINGUA] \STYLES

 

 

  • per nascondere il cestino

#ctl00_PlaceHolderLeftNavBar_idNavLinkRecycleBin
{
       Visibility:hidden;
}

 

  • per nascondere “Visualizza tutto il contenuto del sito”

#ctl00_PlaceHolderLeftNavBar_idNavLinkViewAll
{
Visibility:hidden;
}

Installare template stp

stsadm -o addtemplate -filename “project-simple.stp” -title “Project site – simple” -description “Project site template with a simple structure”