Monthly Archives: September 2007

MRO Workflow dæmisögu með mosa, SPD, InfoPath & vefur þjónusta.

Yfirlit

Þessi færsla lýsir dæmisögu sem lýsir í raun MRO (Viðhald, Viðgerðir og rekstur) workflow samþykki aðferð til framkvæmda í mosa.

Þetta er ekki overtly tæknilega umræðu, heldur þjónar að veita raunverulegur-veröld dæmi sem sýnir hvernig MOSS vettvang hitti alvöru-heiminum verða.

(This entry is cross posted between http://paulgalvin.spaces.live.com og http://blogs.conchango.com)

Bakgrunnur

The client’s MRO process had been characterized by the following

  • Manual approval process.
  • Some support using excel spreadsheets.
  • Irregular approval process. The same MRO purchase approval process would vary day to day, person by person.
  • Lots of paper and hand-written signatures — purchase requisitions required up to 3 written signatures before final approval.

The objectives of this project included:

  • Fully automate the process.
  • Enforce enterprise standards for approval.
  • Provide consolidated view of MRO purchasing to various managers.
  • Detailed audit trail.

As a side effect of the solution, written signatures were no longer required.

Approval Process

The approval process consists of four "swim lanes": Originator, Direct manager, Functional manager and division manager.

Originator:

Sees the need for the purchase and starts the process. Note that the originator may or may not actually enter the purchase requisition, but instead direct another staff member to do so. Sumir sinnum, the originator does not have the technical expertise to fill out the PO requisition. Til dæmis, a user may want to requisition a new laptop computer, but does not know the best vendor, IT standards, o.fl.. Í þessu tilviki, the originator works with IT and IT actually fills out the requisition.

Direct manager:

This is the direct manager of the originator (which may be different from the person who actually entered the PO requisition into MOSS). Direct managers must approve the PO requisition before the system seeks approval further down the line.

Functional Manager:

The functional manager is the individual responsible for ensuring that the proposed purchase conforms to enterprise standards within the scope of a particular corporate function. Til dæmis, IT purchases are approved by an IT functional manager.

Division Manager:

Division managers approve purchase requisitions strictly by dollar amount. Division manager approve purchase requisitions in excess of a configurable dollar amount.

The Solution

We used the following tools and components to implement the solution:

Moss: Serves as the platform off which everything else "hangs". MOSS provides bedrock services for security, master data, audit trails and other features.

InfoPath forms services: A MOSS component, this enables users to fill out purchase requisitions via a web browser.

SharePoint Designer (SPD): We used SPD to implement the automated workflow process.

Web Service: A c# web service enhances the user experience by enabling cascading selections lists in the InfoPath form and provides better performance with respect to filtering data. Sjá hér for a technical deep dive on this subject and our reasons for using it.

Custom Lists: MOSS user profiles provided a given user’s direct manager, but did not provide most of the data that controlled workflow decisions (e.g. whether the divisional manager is required to approve the PO requisition). We used custom lists in an "Enterprise Data" site to maintain data such as "Divisional Manager Approval Dollar Amount", "Functional Area Manager" and so forth. Lists integrated very nicely with InfoPath and also provide create/update/delete (CRUD) functionality with auditing and security out of the box.

Use Case

This use case illustrates how the solution fits together:

  1. Paul wants a new laptop. He describes his needs to Vivek, an IT person familiar with corporate laptop standards, preferred vendors, o.fl..
  2. Vivek logs into MOSS, accesses the PO Requisition form and enters the requisition on behalf of Paul. The form prompts Vivek for a purchase category which then uses the web services to populate a drop-down list of company-approved vendors. Vivek also specifies the corporate functional area of this purchase (e.g. "IT" or "Finance").
  3. SPD based workflow starts, determines Paul’s direct manager and routes the requisition to his manager, Stacy.
  4. Stacy approves the purchase requisition.
  5. SPD workflow inspects the requisition and determines it’s an IT purchase. It routes the workflow to the IT functional manager, Wonson.
  6. Wonson approves the requisition.
  7. SPD workflow again inspects the requisition and determines that the purchase amount exceeds a maxium dollar amount and routes it to the division manager for approval.
  8. The division manager approves the purchase requisition.

Skýringar

  • The use case demonstrates a "clean" run with no rejections or jumps.
  • Every approver has the ability to approve or reject the requisition as well as provide written comments. These are logged in the audit trail.
  • If a responsible manager rejects the purchase requisition at any point, the PO requisition is "dead" and the process must be started from the beginning.
  • Workflow notifies the originator at every step of the process.
  • No written signatures — the client determined (after some forceful recommendations) that the audit trail as provided via workflow history, served their auditing needs.
  • Effort — it took approximately three man weeks to implement this solution.

Ályktun

This solution leverages MOSS as a development and run-time platform. The client was able to leverage core MOSS features to automate a routine business process that affected nearly every employee in the company. With the exception of a simple web service (which itself leverages MOSS), almost no actual "programming" was required.

The solution also serves as a "showcase" for the client, demonstrating how different MOSS features can be combined to create a fully featured business application and generate new consulting opportunities in the future.

Glossary

MRO: Viðhald, repair and operations. These purchases typically include items such as notepads, chairs, personal computers, printers, cell phones and the like.

Próf 70-542: Study tillögur (Microsoft Office SharePoint Server 2007 – Umsókn Þróun)

UPDATE: Í athugasemdum, einhver staða á þennan tengil: http://www.midnightmonkey.co.uk/blog/blogging/?page_id=5. It looks good to me too.

Ég stóðst MOSS tæknilega exam dag, entitled "Microsoft Office SharePoint Server 2007 – Application Development". I found the exam to be pretty rigorous and that it matched up quite well with Microsoft’s undirbúning fylgja.

Ég hef verið að vinna með mosa á hverjum degi og ekkert slá raunverulegur snertið ekki-á reynsla fyrir öllum þessum prófum.

Sem sagt, I took note of what I was studying as I studied. I believe that all of these resources are helpful, sérstaklega sem leið styrkja að snertið ekki-á reynsla.

Efni Link
Excel Services http://msdn2.microsoft.com/en-us/library/ms519581.aspx
Leita No special recommendation. I had taken a class on search earlier this year and real-world experience carried me through. Work with the "search center" hluti af mosa.
BDC http://msdn2.microsoft.com/en-us/library/ms563661.aspx
Áhorfendur http://msdn2.microsoft.com/en-us/library/ms496822.aspx
Snið http://msdn2.microsoft.com/en-us/library/ms496822.aspx
Content Mgmt http://www.sharepointblogs.com/tonstegeman/archive/2007/02/01/moss-custom-policies-part-1-creating-a-custom-information-management-policy.aspx

http://blogs.msdn.com/ecm/archive/2007/03/04/customize-the-page-editing-toolbar-in-moss-2007.aspx

http://msdn2.microsoft.com/en-us/library/aa674506.aspx

BI Hands-á að vinna með er KPI í mosa.
Vinnuflæði http://msdn2.microsoft.com/en-us/library/aa830816.aspx
Upplýsingar Mgmt http://msdn2.microsoft.com/en-us/library/bb397403.aspx
Tilbrigði http://aspnetcoe.wordpress.com/2007/02/09/customize-variation-root-landing-logic/
Records Mgmt http://blogs.msdn.com/recman/archive/2006/06/16/633393.aspx
InfoPath http://msdn.microsoft.com/msdnmag/issues/06/08/infopath2007/default.aspx

Margir af þessum tenglum leiddi til fleiri tengla og ég tilhneigingu til að fylgja þeim upp í um 3 stigum djúpt.

Ég myndi ekki segja að allt sem ég las beint beitt til prófið, en ég sé ekki eftir að lesa eitthvað af því og jafnvel þótt sumir bitar voru ekki beint viðeigandi. Það er allt gott efni til að vita og ég mæli eindregið með efni fyrir alla aspirín vel ávalar mosa verktaki.

MOSS / WSS Leitarniðurstöður (og dataviews): skoða hrátt XML gögn

Þetta kann að vera augljóst að margir, en á meðan að læra fyrir mosa forritun prófinu, Ég lærði að það er frekar auðvelt að fá raunverulegt XML úr leit í gegnum notendaviðmót.

Einn fljótur aðferð er eins og hér segir:

  • Aðgangur ítarlegri leit.
  • Framkvæma leit sem skilar einhverjum gögnum.
  • Breyttu síðunni (í gegnum stillingar á síðuna).
  • Breyta XSL til eftirfarandi:

<?XML útgáfa="1.0" Kóðun="UTF-8"?>
<
XSL:stílsíðu útgáfa="1.0" xmlns:XSL="HTTP://www.w3.org/1999/XSL/Transform">
<
XSL:framleiðsla aðferð="XML" útgáfa="1.0" Kóðun="UTF-8" undirlið=""/>
<
XSL:sniðmát passa="/">
<
fyrirfram>
<
XSL:afrita af velja="*"/>
</
fyrirfram>
</
XSL:sniðmát>
</
XSL:stílsíðu>

  • Högg sækja.
  • Skoða Source í vafranum.

Athugaðu að <fyrirfram> tag doesn’t do much except serve as a convenient marker when you view the results.

This trick can be very helpful when working with managed properties and customizing search. It will provide a definitive list of the XML available for you to use in your xslt which would have been very helpful the last 25 sinnum ég búið til nokkrar sérsniðnar leitarniðurstöður.

Þetta ætti að vinna fyrir dataviews eins vel, þótt ég hafi ekki prófað það út eins og enn.

Engin CQWP fyrir WSS? Prófaðu þetta…

Ég sé að Eric Kraus was faced with a requirement normally met with a content query web part. The problem? He was in a pure WSS environment with no access to the CQWP. Rather than curling up in the fetal position (hvöt ég að berjast á hverjum degi, það virðist), he came up with solution that at least gives WSS shops a fighting chance to succeed. It’s described hér.

Ljómandi og ítarlegt yfirlit yfir innihald stjórnun API

Stefan Gossner has put together a terrific 4-part series on the SharePoint Content and Deployment API hér. It offers a great overview and very good examples in code (C #).

Ég tók fyrst upp þennan tengil frá Joris Poelmans blogginu á http://jopx.blogspot.com/.

Jafnvel ef þú ert eins og mig, í gerðir þú ekki hafa þurft að gera mikið snertið ekki-á vinnu fyrir innihald stjórnun, þetta er vel þess virði 20 minutes of your time to read.

Notkun API, maður getur:

  • Auðveldlega inn og flytja efni mjög.
  • Re-parent content. If you want to export some content from a site "A" and send it to site "B" en í algerlega nýjum stað í stigveldi, þetta er possibleness.
  • Útflutningur efni frá a staður A og flytja valin bita inn á síðuna A.
  • Re-hlekkur efni (þýðir takast með öllum tengla).

WSS, doc libs & listar, Reiknaðir dálka þátttöku [Mig]

Someone on the Internets was asking about how to create a calculated column on a list that would show a value formatted as "[Notandi] – [Staða] – [Staðsetning]" as in "Paul Galvin – Drykkja [frjáls] Bjór – The Beach".

Paul would go in and update his entry in the list and the calculated column would update appropriately. The [Notandi] ætti sjálfgefið að notandi fer inn / uppfæra listann.

A calculated column cannot use "volatile" virka eins og [Mig] eða [Í dag]. I solved it in a test environment with these steps:

  1. Create a text column named "Current User".
  2. Setja sjálfgefið gildi hennar að [Mig]
  3. Create a calculated column called "Calc Test".
  4. Setja gildi = [Núverandi Notandi]

Ég fór í, við hlut á listann og það í uppnámi.

Liðin mín 70-315 próf í dag!

I passed the "Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET" próf í dag í miklu stöðu NJ á venerable skrifstofum SolarTech í Hasbrouck Heights.

I put this exam up there with BizTalk in terms of difficulty. You can’t fake your way through it.

Til að kanna, I used the the MCAD/MCSD Self Paced Training kit book entitled Developing Web Applications with Microsoft Visual Basic .NET and Visual C# .NET.

Microsoft guidelines (hér) are exactly correct IMO. The book addresses everything and if you have a modicum or real-world experience, it should be a straight-forward exam. If not, take the time get some real world experience or at least execute the labs in the book. That will probably give you what you need.

I even go so far as to recommend the book to pro’s, especially self-taught people like myself. It covers some basic stuff which I just never had a reason to stumble upon in my travels and I’m kicking myself a little bit for never having taken the time to learn them.

SharePoint Designer, “Safna gögnum frá notanda” og nota þær niðurstöður.

Use the "Collect Data from User" action to create and assign a task to a user that prompts them for data. Among other things, Ég hef notað það til að hvetja notandann til að samþykkja eða hafna beiðni og slá nokkrar athugasemdir.

Þessi aðgerð tekur mynd af:

Safna gögn frá Þessi notandi (Framleiðsla til Variable: collect1)

Ef smellt er á gögn draga upp röð af svarglugganum sem þú tilgreinir hvaða gögn sem notandinn ætti að veita þegar klára verkefni og Þessi notandi er augljóst.

The framleiðsla hluti (Variable: collect1) saves the ID of the task. You use this in your workflow to extract the user’s actual response via the "Compare any data source" condition.

Það ástand sýnir sem

Ef sviði jafngildir gildi

Smelltu á sviði og síðan f(x) icon and it pulls up another dialog box. Use this generalized dialog box to to tell SPD two things;

1. What is the list and column whose value you want to compare.

2. Hvernig ætti workflow vél finna tiltekna röð í þeim lista?

Til að gera þetta:

  1. Change the "Source" dropdown to point at the correct task list. Note that the dialog box expands to show a "Find the List Item" kafla.
  2. Í leit Upplýsingar sviði listanum, velja nafn á sviði þar sem verðmæti sem þú vilt (þetta kort til hvað þú heitir í safna gögnum valmynd ofan).
  3. In the "Find the List Item" kafla, select "Tasks:ID" á sviði listanum.
  4. Í gildi sviði, smelltu á f(x). This opens yet another dialog box.
  5. Change the source "Workflow Data"
  6. Select the workflow variable that matches to the "Output to Variable" frá safna gögnum aðgerð.
  7. Smelltu á OK / Í lagi og þú ert búinn.

Það lítur út eins og þetta fyrir mig:

mynd

Á þessum tímapunkti, þú getur núna notað það gildi í workflow sem krafist.

Á Skýringar:

Sem innskot stutt, I always create an appropriately named workflow variable of type "List Item ID" and use that instead of the auto-generated "collect1".

This "compare any data source" valmynd sett er notað í nokkrum mismunandi stöðum í SPD og er vel þess virði að húsbóndi.

== Endir

Technorati Tags:

Hléum hrun IE þegar aðgangur skjöl í WSS / MOSS skjal bókasafn

Ég hef verið plága við þetta fyrir 9 mánuði og ég sjá að fólk á MSDN og Usenet ráðstefnur hafa það too.l

Stundum, þegar aðgangur orð skjal (eða öðrum doc gerðir) úr skjali bókasafni veldur Internet Explorer til að einfaldlega hrun og fara burt (taka allar flipa með það ef einhverjar eru opin).

Þetta MS snarhasti má leysa það: http://support.microsoft.com/kb/938888

Einnig, það er einhver lýsing um vandamál hér:

http://jopx.blogspot.com/2007/07/solving-internet-explorer-crash-when.html

Mun alvöru XPath skref áfram?

Yfirlit:

Búið til sérsniðna lista sem stýrir gerð efnis með nokkrum tugi dálka.

Bætt það á síðu og þá í gegnum SPD, breytt í upplýsinga skoðað.

Vandamál:

My Xpath expression was returning blank for a column named "Current Position". I referenced it thusly:

    <table border="1">
      <XSL:for-each select="/dsQueryResponse/Rows/Row" >
        <tr>
          <td>
            Current Status:
            <XSL:value-of select="@Current_x0020_Status"></XSL:gildi-af>
          </td>
        </tr>
      </XSL>
    </borð>

The column in the CT is named "Current Status". It shows up in the lookup as "Current Status". Everywhere you look, you see "Current Status".

While thrashing madly about, looking for a solution, I instead referred to "@Recruiter" and behold! — that actually returned back the current status. I expected it to return back the recruiter when I did that.

Lausn:

I poked about in SPD. Go to that page in SPD and it shows the data view. You can inspect the actual data provided to the view and associated Xpath. Here I found out that indeed, the Xpath pointed at "Recruiter". Strangely enough, the "actual" recruiter field pointed from "Recruiter1".

Take Away:

SPD provides authoritative Xpath expressions for rows & columns in a data view.

Annað, it shows the actual data. So for example, a column of type shows this:

<nobr><span><A HREF="/sites/Corporate/HumanResources/TalentAcquisition/_layouts/userdisp.aspx?ID=17">Galvin, Paul</A><IMG border ="0" height="1" width="3" src="/_layouts/images/blank.gif"/><a href=’javascript:’ onclick=’IMNImageOnClick();return false;’ class=’ms-imnlink’><img name=’imnmark’ title=” border=’0′ height=’12’ width=’12’ src=’/_layouts/images/blank.gif’ alt=’No presence information’ sip=’PGalvin@xxx.com’ id=’imn_77,type=smtp’/></a></span></nobr>