Kategorija Arhiva: SharePoint

Korištenje “Osoba ili Grupa” u izračunatom stupcu

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

Bottom line, to ne rade u WSS 3.0 (ili MOSS).

Kod dodavanja izračunatog stupca, 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, to vam govori:

Jedna ili više stupaca reference ne smiju, jer su stupovi definira kao vrstu podataka koji nije podržan u formulama.

Rješenje: 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.

Korisni linkovi na izračunatih polja općenito:

Brza disclaimer: Vjerujem da gore da bi bilo istinito i točno, ali vidio sam dovoljno dosjetljivim trikovima tu i tamo u MOSS / WSS da neću biti vrlo iznenađeni (nestrpljivo ako hoćeš) 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, javite mi!

MOSS / WSS mi govori: “Stranica je izmijenjena od strane drugih autora na …” ali zapravo, nije bilo.

We did some heavy duty re-organizing of our site taxonomy via "Manage Content and Structure". For reasons unknown to me, taj proces (iako radi u glavni) broke some navigation links in the quick launch. The broken links are characterized by:

  • Wrong URL. Na primjer, it should be "/sites/departments/HumanResources/…". Međutim, the new link is "/sites/Corporate/HumanResources/…".
  • Ponovljeni bita na niz upita od naslova, kao u:

/mjesta / odjela / HumanResources / _izgledi / viewlsts.aspx?BaseType=0?BaseType=0?BaseType=0?BaseType=0

That’s easy enough to fix via site settings/navigation. Except, MOSS mi predstavlja s tim kad sam probati i učiniti ga:

slika

Činjenica je, nitko se ne postoje nikakve promjene (Osim mene, naravno).

Brza pretraga pretvara se u raspravu MSDN foruma: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1691577&SiteID=1

William Heurdier ga izlaže lijepo u predzadnjem (od 10/02/07) pošta:

Činjenica je:

Za vraćanje oštećene naslove, moraš :

– ukloniti sve popise po korumpiran naslova

– uklanjanje oštećene naslova

– Iz popisa postavkama, add a removed list to the quick launch (Ovo regeneraciju oštećene non naslova)

Vi ste onda dobro proći….


Sharepoint Expert – Cap Gemini Sogeti Švicarska

Bio sam malo zbunjena jer sam se želio ići u navigacijskom stranici, make the change and then get hit with the "page was modified" message. Konačno, 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!

</kraj>

Pretplatite se na moj blog!

Problemi s “Pauza do datuma” aktivnost u SPD-stvorenih radnih tijekova

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. Tada, sharepoint configuration utility on each server. Here is the MS Support link for that KB: http://support.microsoft.com/kb/932816.

Pozadina:

Imamo poslovne zahtjev u kojem inženjerstva okoliša manager treba osigurati da 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 (ili njezin pomoćnik) enters all the required permits and reminder dates at the start of the year. The system then does all the heavy lifting.

Okolina:

MOSS, 64 bit, virtualni stroj okoliš (Razvoj box), 2 poslužitelji (SQL na poslužitelju #1, sve ostalo na poslužitelju #2).

Problemi:

The Pause Until Date action seems like the perfect solution and it may well prove itself to be. Međutim, to ne radi i iz kutije (za nas).

  1. Tijek posao nije na rasporedu, ever. I discovered this by reading through Christopher Whitea (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:\>

    To je čudno, ali rezultat se lako riješiti:

    C:\>stsadm -o setproperty -propertyname "job-worfklow" -propertyvalue "every 1 minuta između 0 i 59" -url http://localhost

    Operacija je uspješno završena.

    C:\>

    Na taj događaj, the first "In Progress" tijek brzo vatru i učinio da je posao.

  2. Nažalost, the next one didn’t work as expected. Srećom, Christopher refers us ovdje (http://support.microsoft.com/kb/932816). As of writing of this entry, čekamo IT odjela dobiti taj hitni popravak, but it does look promising. Our copies of the affected .dll’s do not share the same byte size, pa se nadam da će to riješiti problem.

Rješenje:

Re-running the stsadm -o setproperty command seemed to prod the workflow timer awake. It would, grubo 7 minuta kasnije, actually wake up and continue along with the workflow.

Pitanja / Razmatrana pitanja:

Pauza Do danas ne rade.

Pauza do datuma se ne vraća.

Workflow status does not change from "In Progress"

Workflow status stays "In Progress"

MRO tijeka studija slučaja pomoću MAHOVINA, SPD, InfoPath & web servisi.

Pregled

Ovaj ulaz opisuje studija slučaja opisuje stvarni MRO (Održavanje, Popravak i operacije) tijek proces odobravanja provodi u MAHOVINA.

To nije otvoreno tehničke rasprave, već služi za pružanje stvarnom svijetu primjer koji pokazuje kako MOSS platforma upoznao stvarne potrebe.

(Ovaj ulaz je pošta prijeći između http://paulgalvin.spaces.live.com i http://blogs.conchango.com)

Pozadina

Klijentovog MRO proces bio obilježen sljedeće

  • Priručnik proces odobravanja.
  • Neki podržavaju korištenje Excel proračunske tablice.
  • Irregular approval process. The same MRO purchase approval process would vary day to day, Osoba prema osobi.
  • Mnogo papiru i rukom pisane potpisa — kupnju obespravljivanja obvezne do 3 pisani potpisi prije konačnog odobrenja.

Ciljevi ovog projekta su:

  • Potpuno automatizirati proces.
  • Provođenje poslovne standarde za odobrenje.
  • Osigurati konsolidirani pogled MRO kupovnu raznim menadžerima.
  • Detailed audit trail.

As a side effect of the solution, pisani potpisi su više nisu potrebni.

Proces odobravanja

The approval process consists of four "swim lanes": Pokretač, Izravna manager, Funkcionalna manager i dijeljenje menadžer.

Pokretač:

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. Neki puta, the originator does not have the technical expertise to fill out the PO requisition. Na primjer, Korisnik svibanj želite zahtjevnicama novi laptop računalo, , ali ne znam najbolji prodavač, IT standardima, itd.. U tom slučaju, the originator works with IT and IT actually fills out the requisition.

Izravna manager:

To je izravna menadžer inicijatora (koje može biti različito od osobe koja je zapravo ušao u PO rekvizicije u MOSS). Direct managers must approve the PO requisition before the system seeks approval further down the line.

Funkcionalna 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. Na primjer, 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.

Rješenje

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, revizije staze i druge značajke.

InfoPath Forms Services: MOSS komponenta, to omogućava korisnicima da ispunite kupnju obespravljivanja putem web preglednika.

SharePoint Designer (SPD): Koristili smo SPD provesti automatski tijek procesa.

Web usluga: 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. Vidjeti ovdje za tehničku dubokom zaronu na ovu temu i naše razloge za to koristi.

Prilagođeni popisi: MOSS user profiles provided a given user’s direct manager, but did not provide most of the data that controlled workflow decisions (e.g. Izdvojena li upravitelj dužan odobriti PO rekvizicije). 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) funkcionalnost i sigurnost revizije iz kutije.

Use Case

Ovaj slučaj pokazuje kako korištenje rješenje uklapa zajedno:

  1. Paul wants a new laptop. He describes his needs to Vivek, IT osoba upoznat s korporativnim standardima laptop, povlaštene dobavljači, itd..
  2. Vivek prijavljuje na 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 rada počinje, Određuje Pavlov izravna menadžer i putevi rekvizicija za njegov menadžer, Stacy.
  4. Stacy odobrava kupnju rekvizicije.
  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 odobrava rekvizicije.
  7. SPD tijeka ponovno pregledava rekvizicije i utvrdi da je iznos kupnje prelazi maxium dolar iznos te ga usmjerava na direktora sektora za odobrenje.
  8. Podjela manager odobrava kupnju rekvizicije.

Bilješke

  • 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.
  • Ako odgovorni menadžer odbacuje kupnju rekvizicije u bilo kojem trenutku, the PO requisition is "dead" and the process must be started from the beginning.
  • Workflow obavještava začetnikom na svakom koraku.
  • Pismena potpisa — Klijent određuje (nakon nekih silovitim preporuka) da je tijek revizije kako je propisano preko tijeka povijesti, služio njihov revizije treba.
  • Napor — it took approximately three man weeks to implement this solution.

Zaključak

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 (koja sama po sebi utjecati Moss), almost no actual "programming" bila potrebna.

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

Rječnik

MRO: Održavanje, repair and operations. These purchases typically include items such as notepads, stolice, osobna računala, pisači, mobitela i slično.

Moss / WSS Rezultati pretraživanja (i dataviews): pregled sirovih XML podataka

To može biti očito da mnogi, ali dok je studirao za moj ispit Moss programskog, Saznala sam da je prilično lako dobiti stvarni XML iz upita za pretraživanje putem korisničkog sučelja.

Jedan brzi način kako slijedi:

  • Pristupite napredno pretraživanje.
  • Izvršite pretraživanje da vraća neke podatke.
  • Uredi stranicu (putem Postavke web-mjesta).
  • Promijeniti XSL na sljedeće:

<?xml verzija="1.0" kodiranje="UTF-8"?>
<
XSL:stilovima verzija="1.0" xmlns:XSL="http://www.w3.org/1999/XSL/Transform">
<
XSL:izlaz način="xml" verzija="1.0" kodiranje="UTF-8" uvući="da"/>
<
XSL:predložak odgovarati="/">
<
pre>
<
XSL:copy-mjesta odabrati="*"/>
</
pre>
</
XSL:predložak>
</
XSL:stilovima>

  • Hit primjenjuje.
  • Vidi izvor u pregledniku.

Imajte na umu da <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 puta sam stvorio neke prilagođene rezultate pretraživanja.

Ovo bi trebalo raditi za dataviews kao i, iako nisam testirao da van još.

Sjajna i detaljni pregled API za upravljanje sadržajem

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

Prvi put sam pokupila ovaj link Joris poelmans blogu, na http://jopx.blogspot.com/.

Čak i ako ste poput mene, u koju nisu morali učiniti mnogo ruke na radu za upravljanje sadržajem, to je dobro isplati 20 minutes of your time to read.

Korištenje API, može se:

  • Izvoz i uvoz sadržaja vrlo jednostavno.
  • Re-parent content. If you want to export some content from a site "A" and send it to site "B" , ali u potpuno novo mjesto u hijerarhiji, to je moguće.
  • Izvoz sadržaja na web-mjestu A i uvoz odabranih bitova u mjestu A.
  • Re-link sadržaj (što znači nositi sa svim linkovima).

WSS, doc libs & popisi, Izračunati stupci koji uključuju [Me]

Someone on the Internets was asking about how to create a calculated column on a list that would show a value formatted as "[Korisnik] – [Status] – [Lokacija]" as in "Paul Galvin – Konzumiranje [besplatno] Pivo – The Beach".

Paul would go in and update his entry in the list and the calculated column would update appropriately. The [Korisnik] treba se vratiti na default korisnika koji ulazi / ažuriranje popisa.

A calculated column cannot use "volatile" funkcije kao što su [Me] ili [Danas]. I solved it in a test environment with these steps:

  1. Create a text column named "Current User".
  2. Postavite svoju zadanu vrijednost [Me]
  3. Create a calculated column called "Calc Test".
  4. Postavite svoju vrijednost = [Trenutni korisnik]

Otišao sam u, dodao stavku na popisu, a to je radio.

Povremene IE ruši kada pristupate dokumente u WSS / MOSS biblioteci dokumenata

Sam udario po to za 9 mjeseci i vidim da ljudi na MSDN i Usenet forumima su ga too.l

Ponekad, kada pristupate dokument programa Word (doc ili druge vrste) od biblioteci dokumenata izaziva Internet Explorer jednostavno srušiti i otići (poduzima sve kartice s njom ako su otvoreni).

Ovaj hitni popravak MS može to riješiti: http://support.microsoft.com/kb/938888

Također, postoji neki opis problema ovdje:

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

Hoće li pravi XPath korak naprijed?

Pregled:

Stvorili prilagođeni popis koji upravlja vrstu sadržaja s desetak stupaca.

Dodano je na stranici, a zatim preko UPZ, pretvoriti u podatkovnom prikazu.

Problem:

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:vrijednost od>
          </td>
        </tr>
      </XSL>
    </stol>

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.

Otopina:

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.

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

<nobr><raspon><A HREF="/sites/Corporate/HumanResources/TalentAcquisition/_layouts/userdisp.aspx?ID=17">Galvin, Pavle</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></raspon></nobr>