Kumbuka: hii ndiyo ya kwanza posted katika www.endusersharepoint.com hapa: http://www.endusersharepoint.com/2009/11/02/comparing-dates-in-a-data-view-web-part-to-build-a-wss-kpi-in-sharepoint/.

Hii ni baada ya mwingine blog juu ya kulinganisha tarehe za XSL katika sehemu ya data mtazamo mtandao katika SharePoint.

Hii ni hali yangu:

• Nina orodha desturi.
• madhumuni ya biashara katika orodha hii ni kusaidia wazo la mfanyakazi mpya na kazi yake / zake na kukamilishwa katika 7 siku ya kuanza kazi.
• Wao ni katika "ukanda wa onyo" baada ya 4 siku kama si kumaliza kazi hizi.
• Nataka kujenga dashibodi rahisi kwamba inaonyesha kijani wakati wao aidha kumaliza kazi au kama wana zaidi ya 4 siku kukamilisha.
• Nataka dashibodi kuonyesha njano kama ni katika ukanda wa onyo.
• Nataka kuonyesha nyekundu kama si kumaliza kazi baada ya tarehe kutokana.

Mimi zilizokopwa kutoka makala hii katika Marc Anderson ya blog (http://mdasblog.wordpress.com/2008/02/19/comparing-dates-in-sharepoint-using-xsl/) kupata mantiki ya kulinganisha na makala hii katika www.endusersharepoint.com kwa ajili ya mawazo ya msingi nyuma ya dashibodi (http://www.endusersharepoint.com/2008/12/09/visual-indicators-for-the-masses-kpis-in-wss/) Imeandikwa na Toni Frankola.

Unapaswa kusoma blogs kusaidia, lakini utekelezaji unaendelea kama hii:

1. Kujenga aina ya maudhui (nguzo + CT)
2. Kutengeneza orodha ya desturi na kujiunga pamoja na aina ya maudhui.
3. Kujenga sehemu mtandao ukurasa.
4. Kuongeza orodha ya desturi na ukurasa sehemu ya mtandao.
5. Kufungua ukurasa katika SPD.
6. Kubadilisha orodha ya DVWP.
7. Kurekebisha XSL kuzalisha bits dashibodi.

Mimi na tarehe mbili: a warning date and a due date. To compare the dates, xsl yangu anafanya zifuatazo:

 <xsl:kuchagua>

 <!-- Wakati wote na sera ya kitabu ni sahihi, sisi ni kijani bila kujali tarehe. -->

 <xsl:wakati mtihani="@Employee_x0020_Handbook_x003F_ = 1 na @ Security_x0020_Policies = 1">

 <img src="/_layouts/images/KPIDefault-0.GIF" zamani="No problems"/>

 <a href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID ={@ ID}&Amp;Chanzo = / HumanResources / Pamoja Nyaraka / New Hire Dashboard.aspx"> [Hariri]</a>

 </xsl:wakati>

 <!-- Kuonyesha kaharabu kiashiria kama tupo nyuma tarehe ya onyo. -->

 <xsl:wakati mtihani="ddwrt:FormatDateTime(string(ddwrt:Leo()), 1033, 'YyyyMMdd') &gt;= Ddwrt:FormatDateTime(string(@ TaskDueDate), 1033, 'YyyyMMdd')">

 <img src="/_layouts/images/KPIDefault-2.GIF" zamani="Overdue"/>

 <a style="border: 0px" href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID ={@ ID}&Amp;Chanzo = / HumanResources / Pamoja Nyaraka / New Hire Dashboard.aspx"> [Hariri]</a>

 </xsl:wakati>

 <!-- Kuonyesha kiashiria nyekundu kama sisi ni kupita kutokana tarehe. -->

 <xsl:wakati mtihani="ddwrt:FormatDateTime(string(ddwrt:Leo()), 1033, 'YyyyMMdd') &gt;= Ddwrt:FormatDateTime(string(@ Warning_x0020_Date), 1033, 'YyyyMMdd')">

 <img src="/_layouts/images/KPIDefault-1.GIF" zamani="Warning"/> 

 <a href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID ={@ ID}&Amp;Chanzo = / HumanResources / Pamoja Nyaraka / New Hire Dashboard.aspx"> [Hariri]</a>

 </xsl:wakati>

 <!-- Kama tutapata hapa, sisi ni mapema zaidi ya tarehe ya onyo, hivyo sisi ni kijani. -->

 <xsl:vinginevyo>

 <img src="/_layouts/images/KPIDefault-0.GIF" zamani="No problems"/>

 <a href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID ={@ ID}&Amp;Chanzo = / HumanResources / Pamoja Nyaraka / New Hire Dashboard.aspx"> [Hariri]</a>

 </xsl:vinginevyo>

 </xsl:kuchagua>

chache muhimu pointi kutoka juu:

• I tried to compare dates without using the ddwrt functionality and got nowhere. I still don’t understand that. They dates displayed correctly, lakini wote wawili ">"Na"<” comparisons always failed. Katika mwisho, ddwrt alikuja kuniokoa (shukrani, tena, Marc).
• Mimi pia kuonyesha [Hariri] link to the item. I mainly did this so that I could easily test this out. The link itself may be useful to someone trying to figure it out.
• Huu utatekelezwa katika SharePoint online na kazi nicely.
• images mimi rejea katika saraka _layouts (/_layouts / images / KPI ...) zinapatikana nje ya boksi katika mazingira yangu ili pengine inapatikana kwa ajili yenu pia.

Hapa ni risasi screen ya nini inaonekana kama kwa ajili yangu:

</mwisho>

Kujiunga na blog yangu.

Kufuata yangu juu ya Twitter kwa http://www.twitter.com/pagalvin

Kuna utajiri wa habari kubwa kwenye WSS 3.0 Takwimu View Mtandao Sehemu ya (DVWP) on the web from several sources. Hata hivyo, I found it to be surprisingly difficult to find information on this first very basic step. Here is another article in the "quick and easy" mfululizo kulishughulikia.

Fuata hatua hizi ili kujenga data mtandao mtazamo sehemu (DVWP). They are based on an "Announcements" mtandao sehemu, lakini kuomba orodha ya wengi.

1. Kujenga mtandao Matangazo sehemu na kuongeza kwa tovuti.
2. Kufungua tovuti katika SharePoint Designer.
3. Kufungua default.aspx tovuti.
4. Select the Announcements web part and right-click.
5. Kutoka orodha ya mazingira, select "Convert to XSLT Data View".

SharePoint Designer notifies kwamba tovuti hii sasa umeboreshwa kutoka tovuti ufafanuzi wake. Hiyo si lazima mbaya, lakini kuna athari muhimu (utendaji, kuboresha, wengine) which are beyond the scope of this little "Quick and Easy" kuingia. To get more information on this subject, Mimi kupendekeza vitabu vyote viwili hapa kama vile Internet yako tafuta favorite.

Kuthibitisha kwamba alifanya kwa usahihi:

1. Karibu na re-kufungua kivinjari (to avoid accidentally re-posting the original "add a new web part").
2. Select the web part’s arrow drop-down and choose "Modify Shared Web Part" kutoka orodha ya.
3. jopo chombo kuufungua na haki.
4. jopo imebadilika kutoka kawaida yake kuweka chaguzi hii: