Category Archives: SharePoint

Erabiliz “Pertsona edo Talde” bat kalkulatzen zutabean

People commonly ask about using a column of data type "Person or Group" in another column of data type "Calculated".

Behean line, horrek ez du lan egiten WSS 3.0 (edo MOSS).

Noiz kalkulatzen zutabe bat gehituz, WSS shows the list of fields it allows you to use for the calculation. If you type in the name of a column that is not in its list, pasatzean,:

Bat edo gehiago zutabe erreferentziak ez dira onartzen, zutabeak dira datu-mota bat bezala definitzen duelako ez dela formula onartzen.

Sahiesteko: Use an event handler. The event handler fires when the user saves the item. It performs the update you would have wanted the calculated column to do for you.

Erabilgarria eremu kalkulatzen loturak, oro har,:

Quick Lege-oharra: Gainetik egiazkoak eta zehatzak izan behar duela uste dut,, baina ikusi dut nahikoa clever trikimailu han eta hemen MOSS / WSS litzateke hori ez dut oso harrituta (agog duzu bada) if someone has figured out a way to do this without resorting to code. If you’ve figured out clever work-around or know someone that did, please let me know!

MOSS / WSS esaten dit: “Orria izan da egilearen beste aldaketa on …” baina, egia esan,, ez zen.

We did some heavy duty re-organizing of our site taxonomy via "Manage Content and Structure". For reasons unknown to me, Prozesu honetan (nagusi, nahiz eta lan-) broke some navigation links in the quick launch. The broken links are characterized by:

  • Wrong URL. Adibidez, it should be "/sites/departments/HumanResources/…". Hala eta guztiz ere, the new link is "/sites/Corporate/HumanResources/…".
  • Errepikatzen buruzko epigrafe kontsulta katea bit, bezala:

/guneak / sail / HumanResources / _layouts / viewlsts.aspx?BaseType = 0?BaseType = 0?BaseType = 0?BaseType = 0

That’s easy enough to fix via site settings/navigation. Except, MOSS aurkezten me batera, eta saiatu dut:

image

Izan ere,, inork ez edozein aldaketa ez dago egiten ari da (alde batera from me, jakina).

Bilaketa bizkor bat bihurtzen da, hau MSDN eztabaida foroak: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1691577&SiteID=1

William Heurdier ere, planoan out nicely azkenaurreko en (gisa 10/02/07) bidaltzeko:

Izan da:

Hondatuta izenburuak berrezarri, behar duzu :

– kendu zerrendak guztiak epigrafe hondatuta pean

– kendu hondatuta epigrafe

– Zerrenda ezarpenen, add a removed list to the quick launch (Hau birsortzeko ez hondatuta epigrafe)

Ondoren, zaude onak joan….


Sharepoint aditua – Sogeti Cap Gemini Suitza

Apur bat nahastu izan dut mantendu I nabigazio orrira nahi duelako, make the change and then get hit with the "page was modified" message. Azkenean, I realized I had to go to the list settings and remove/add it to quick launch. That did the trick. Happy times are here again!

</amaiera>

Nire blog Harpidetu!

Arazoak dituzten “Noiz arte pausatu” SPD sortutako fluxuak jarduera

UPDATE 12/10/07: Hotfix as described in MSDN KB929816 solved the problem for us mentioned below. Obtain the hotfix and then install on each server on the farm. Gero, sharepoint configuration utility on each server. Here is the MS Support link for that KB: http://support.microsoft.com/kb/932816.

Aurrekariak:

Enpresa-baldintza, non ingurumen ingeniaritza kudeatzailea behar ziurtatu dugu 30 some-odd manufacturing locations located throughout the United States needs to ensure that those plants file for their various state-mandated permits in a timely fashion. One approach we’ve investigated leverages the "Pause Until Date" activity available to us via SharePoint Designer worfklow. The engineering manager (edo bere laguntzaile) enters all the required permits and reminder dates at the start of the year. The system then does all the heavy lifting.

Ingurumena:

Moss, 64 bit, Makina birtual ingurumena (garapen kutxa), 2 zerbitzariak (SQL zerbitzari batean #1, beste guztia zerbitzari batean #2).

Arazoak:

The Pause Until Date action seems like the perfect solution and it may well prove itself to be. Hala eta guztiz ere, ez da ongi atera kutxa (Gurekin).

  1. Workflow lana ez zen programatuta exekutatu, ever. I discovered this by reading through Christopher White en (http://chrissyblanco.blogspot.com/2007/06/issues-with-delay-activity-in-moss.html) excellent write-up by using stsadm thusly:

    C:\>stsadm -o getproperty -propertyname "job-workflow" -url http://localhost

    <Property Exist="No" />

    C:\>

    Duten emaitza harrigarria izan zen, baina erraz konpondu:

    C:\>stsadm -o setproperty -propertyname "job-worfklow" -propertyvalue "every 1 minutu artean 0 eta 59" -url http://localhost

    Eragiketa burutu.

    C:\>

    Gainean egiten duten, the first "In Progress" workflow azkar tiro sortu eta bere lana egin.

  2. Tamalez, the next one didn’t work as expected. Zorionez, Christopher refers us hemen (http://support.microsoft.com/kb/932816). As of writing of this entry, IT departamentuko ari gara Hotfix zuzenketa hori lortzeko zain, but it does look promising. Our copies of the affected .dll’s do not share the same byte size, beraz, espero honek arazoa konponduko.

Sahiesteko:

Re-running the stsadm -o setproperty command seemed to prod the workflow timer awake. It would, gutxi gorabehera 7 minutu geroago, actually wake up and continue along with the workflow.

Galderak / Aleak Norentzat:

Data pausatu arte ez du funtzionatzen.

Data pausatu arte ez da hasi berriro.

Workflow status does not change from "In Progress"

Workflow status stays "In Progress"

MRO Workflow kasu MOSS erabiliz, SPD, InfoPath & web zerbitzuak.

Orokorra

Sarrera honen benetako MRO bat deskribatzen duen kasu bat deskribatzen (Mantentze-lanak, Konponketa eta ebakuntzak) workflow onartzeko prozesuan MOSS ezarri.

Hau ez da overtly tekniko eztabaida bat, baizik eta balio errealean munduko Adibidez frogatzen nola MOSS plataforma ezagutu real-munduaren premia bat eskaintzea.

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

Aurrekariak

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. Batzuetan, the originator does not have the technical expertise to fill out the PO requisition. Adibidez, a user may want to requisition a new laptop computer, but does not know the best vendor, IT standards, etc. Kasu honetan, 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. Adibidez, 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. Ikusi hemen 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) kontu ikuskaritza eta segurtasun-kutxa atera duen funtzionalitatea.

Erabili Case

Erabilera kasu honek erakusten du nola irtenbidea egokitzen elkarrekin:

  1. Paul wants a new laptop. He describes his needs to Vivek, ordenagailu eramangarri bat korporatiboaren arauen pertsona ezagunak IT, hobetsia saltzaileen, etc.
  2. Vivek MOSS sartu erregistroak, 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 oinarritutako workflow hasten, 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.

Oharrak

  • 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.

Ondorioa

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: Mantentze-lanak, repair and operations. These purchases typically include items such as notepads, chairs, personal computers, printers, cell phones and the like.

MOSS / WSS Bilaketaren emaitzak (eta dataviews): ikusteko gordin XML datuak

Honek askotan, agerikoa izan daiteke, baina nire MOSS programazioaren azterketa-berriz ikasten, Hori nahiko erraza benetako XML lortzeko bilaketa baten erabiltzaile interfazaren bidez ikasi dut.

Ko azkar metodoa honakoa da:

  • Sartzeko bilaketa aurreratua.
  • Egin bilaketa bat itzultzen dituen datu batzuk.
  • Editatu orria (gune ezarpenak bidez).
  • Aldatu XSL du honako:

<?xml bertsioa="1.0" kodeketa="utf-8"?>
<
xsl:Estilo orria bertsioa="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<
xsl:irteera metodoa="xml" bertsioa="1.0" kodeketa="UTF-8" koska="bai"/>
<
xsl:txantiloia dator="/">
<
pre>
<
xsl:kopia-eko hautatu="*"/>
</
pre>
</
xsl:txantiloia>
</
xsl:Estilo orria>

  • Asmatu aplikatzen.
  • Ikusi nabigatzailean.

Ohartu <pre> 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 batzuetan bilaketa pertsonalizatuen emaitzetan sortu dut.

Hau izan beharko dataviews lan egiteko, baita, dut probatu, baina ez dela oraindik.

Bikaina eta zehatza eduki kudeaketa API ikuspegia

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

Eskuartean lehendabizikoz hartu nuenean lotura hau Joris poelmans blog at http://jopx.blogspot.com/.

Nahiz eta ni bezalako Oraindik duzu, horretan ez duzu asko egin izan du lan-esku-edukiak kudeatzeko, hau merezi 20 minutes of your time to read.

API erabiliz, ko can:

  • Esportazio eta inportazio eduki oso erraz.
  • Re-parent content. If you want to export some content from a site "A" and send it to site "B" baina hierarkian leku bat guztiz berri batean, hau da, ahalik eta.
  • Esportatu edukia gune bat A-tik eta hautatutako bit inportatu gune bihurtu.
  • Re-lotura eduki (Operazio zentzua hiperestekak guztiak).

WSS, doc libs & zerrendak, Kalkulatutako zutabeak parte hartuko dute [Me]

Someone on the Internets was asking about how to create a calculated column on a list that would show a value formatted as "[Erabiltzaile] – [Status] – [Kokapena]" as in "Paul Galvin – Edateko [free] Garagardoa – The Beach".

Paul would go in and update his entry in the list and the calculated column would update appropriately. The [Erabiltzaile] behar du erabiltzaileak sartzean / zerrenda eguneratzen lehenetsia.

A calculated column cannot use "volatile" hala nola, funtzio [Me] edo [Gaur egun]. I solved it in a test environment with these steps:

  1. Create a text column named "Current User".
  2. Ezarri lehenetsia du balio [Me]
  3. Create a calculated column called "Calc Test".
  4. Ezarri bere balioa = [Oraingo erabiltzailearen]

Hasi nintzen, elementu bat gehitu behar zerrenda eta lan egin.

Aldizkako IE kraskatzen denean, dokumentu bat sartzean WSS / MOSS dokumentua liburutegian

Dut hau beteta eman 9 hilabete eta ikusten dut MSDN eta Usenet foroak pertsona hori izan da too.l

Batzuetan,, denean word dokumentu bat sartzean (edo beste dokumentu motak) Dokumentu liburutegia batetik Internet Explorer eragiten du, besterik gabe, huts egin eta joan (fitxa guztiak hartuz berarekin edozein irekita daudenean).

MS Hotfix zuzenketa hau konpondu ahal izango: http://support.microsoft.com/kb/938888

Era berean,, Arazo buruzko azalpen batzuk hemen:

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

Will benetako XPath urrats?

Orokorra:

Sortu Ohiko zerrenda eduki mota bat kudeatzen dozena zutabe batzuekin.

Added ezazu orri bat eta, ondoren, SPD bidez, datuak ikuspegi bat bihurtu.

Arazoa:

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>
            Gaur egungo egoera:
            <xsl:value-of select="@Current_x0020_Status"></xsl:balio du>
          </td>
        </tr>
      </xsl>
    </taula>

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".

Bitartean thrashing madly buruz, irtenbide baten bila, I instead referred to "@Recruiter" eta behold! — that actually returned back the current status. I expected it to return back the recruiter when I did that.

Irtenbidea:

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 eskaintzen autoritario XPath errenkadak adierazpenak & en datuak ikuspegian zutabeak.

Bigarren, it shows the actual data. So for example, motako zutabe bat erakusten du, hau:

<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();itzultzeko faltsuak;’ class = "MS-imnlink '><img name=’imnmark’ title =” border =’0′ altuera = '12’ width = '12’ src = "/ _layouts / irudi / blank.gif’ alt = 'presentzia informaziorik ez’ sip = 'PGalvin@xxx.com’ id = 'imn_77, mota = smtp' /></bat></span></nobr>