Arkivji tal-Kategorija: Data View Web Parti

Tqabbil Dati fi Data View Web Parti Tibni KPI WSS

Innota: this was first posted at www.endusersharepoint.com hawn: http://www.endusersharepoint.com/2009/11/02/comparing-dates-in-a-data-view-web-part-to-build-a-wss-kpi-in-sharepoint/.

Dan huwa pass ieħor blog post fuq tqabbil dati XSL fil-fehma data part web SharePoint.

Dan huwa xenarju tiegħi:

  • I jkollhom lista custom.
  • The business purpose of the list is to support the idea of a new employee and his/her tasks to be completed within 7 days of starting the job.
  • They are in a “warning zone” after 4 days if they have not completed these tasks.
  • I want to create a simple dashboard that shows green when they have either completed the task or if they have more than 4 days to complete it.
  • I want the dashboard to show yellow if they are in the warning zone.
  • I want to to show red if they have not completed the task after the due date.

I borrowed from dan l-artikolu fil Marc Anderson’s blog (http://mdasblog.wordpress.com/2008/02/19/comparing-dates-in-sharepoint-using-xsl/) to get the comparison logic and dan l-artikolu fil www.endusersharepoint.com for the basic ideas behind the dashboard (http://www.endusersharepoint.com/2008/12/09/visual-indicators-for-the-masses-kpis-in-wss/) written by Toni Frankola.

You should read the supporting blogs, but the implementation goes like this:

  1. Oħloq tip kontenut (kolonni + CT)
  2. Create a custom list and associate it with the content type.
  3. Create a web part page.
  4. Add the custom list to the web part page.
  5. Open up the page in SPD.
  6. Convert the list to a DVWP.
  7. Modify the XSL to generate the dashboard bits.

I have two dates: a warning date and a due date. To compare the dates, my xsl does the following:

 
 <XSL:jagħżlu>
 
 <!-- When both handbook and policy are signed, we are green regardless of dates. -->
 <XSL:Meta test="@Employee_x0020_Handbook_x003F_ = 1 and @Security_x0020_Policies = 1">
 <img src="/_layouts/images/KPIDefault-0.GIF" qodma="No problems"/>
 <a href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID={@ID}&amp;Source=/HumanResources/Shared Documents/New Hire Dashboard.aspx"> [Edit]</a>
 </XSL:Meta>
 
 <!-- Show amber indicator if we're past the warning date. -->
 <XSL:Meta test="ddwrt:FormatDateTime(string(ddwrt:Illum()), 1033, 'yyyyMMdd') &gt;= ddwrt:FormatDateTime(string(@TaskDueDate), 1033, 'yyyyMMdd')">
 <img src="/_layouts/images/KPIDefault-2.GIF" qodma="Overdue"/>
 <a stil="border: 0px" href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID={@ID}&amp;Source=/HumanResources/Shared Documents/New Hire Dashboard.aspx"> [Edit]</a>
 </XSL:Meta>
 
 <!-- Show red indicator if we're passed the due date. -->
 <XSL:Meta test="ddwrt:FormatDateTime(string(ddwrt:Illum()), 1033, 'yyyyMMdd') &gt;= ddwrt:FormatDateTime(string(@Warning_x0020_Date), 1033, 'yyyyMMdd')">
 <img src="/_layouts/images/KPIDefault-1.GIF" qodma="Warning"/> 
 <a href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID={@ID}&amp;Source=/HumanResources/Shared Documents/New Hire Dashboard.aspx"> [Edit]</a>
 </XSL:Meta>
 
 <!-- If we get here, we're earlier than the warning date, so we're green. -->
 <XSL:inkella>
 <img src="/_layouts/images/KPIDefault-0.GIF" qodma="No problems"/>
 <a href="/HumanResources/Lists/New Employee Checklist/EditForm.aspx?ID={@ID}&amp;Source=/HumanResources/Shared Documents/New Hire Dashboard.aspx"> [Edit]</a>
 </XSL:inkella>
 
 </XSL:jagħżlu>

A few key points from above:

  • I tried to compare dates without using the ddwrt functionality and got nowhere. I still don’t understand that. They dates displayed correctly, but both “>” and “<” comparisons always failed. Fl-aħħar, ddwrt came to my rescue (grazzi, darb'oħra, Marc).
  • I’m also displaying an [Edit] 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.
  • This is implemented in SharePoint online and works nicely.
  • The images I reference in the _layouts directory (/_layouts/images/KPI…) are available out of the box in my environment so they are probably available for you as well.

Here’s a screen shot of what it looks like for me:

image

</aħħar>

Abbona għall-blog tiegħi.

Follow lili Twitter fi http://www.twitter.com/pagalvin

Quick u Easy: Oħloq Data View Web Parti (DVWP)

Hemm minjiera ta 'informazzjoni kbir fuq il-WSS 3.0 Data View Web Parti (DVWP) on the web from several sources. Madankollu, 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" serje jindirizzawha.

Segwi dawn il-passi biex toħloq parti tad-data web ħsieb (DVWP). They are based on an "Announcements" parti web, iżda tapplika għal-listi aktar.

  1. Oħloq parti web Avviżi u iżżidhiex għal sit.
  2. Iftaħ is-sit SharePoint Designer.
  3. Iftaħ-sit default.aspx.
  4. Select the Announcements web part and right-click.
  5. Mill-menu kuntest, select "Convert to XSIl-T Data View".

SharePoint Designer javżak li dan is-sit issa huwa customised mid-definizzjoni sit tagħha. Li mhux neċessarjament ħażin, iżda hemm implikazzjonijiet importanti (prestazzjoni, upgrade, oħrajn) which are beyond the scope of this little "Quick and Easy" dħul. To get more information on this subject, I jirrakkomandaw żewġ kotba hawn kif ukoll tfittxija tiegħek Internet favoriti.

Ikkonferma li inti ma kien korrett:

  1. Agħlaq u terġa tiftaħ il-web browser (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" mill-menu.
  3. Il-bord għodda jiftaħ lejn il-lemin.
  4. Il-bord inbidel minn għażliet tagħha sett normali għal dan:
immaġni