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:

• Korištenje [Me] u izračunatom stupcu
• Primjeri formula izraza (ljubaznošću http://jopx.blogspot.com/2007/10/calculated-fields-in-windows-sharepoint.html)

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!

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:

Č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!

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"