Kateqoriya Arxivləri: SharePoint

Istifadə “Şəxs və ya qrup” hesablanmış sütunda

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

Aşağı xətt, Bu WSS işləmir 3.0 (və ya MOSS).

Hesablanmış sütun əlavə edərkən, 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, o sizə deyir:

Bir və ya daha sütun istinad icazə verilmir, sütunlar bir veri növü kimi müəyyən olunur, çünki düsturlar dəstəklənmir ki,.

Puç: 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.

Ümumi hesablanır sahələr üzrə Faydalı linklər:

Sadə disclaimer: Mən yuxarıda doğru və dəqiq olmaq, iman, lakin mən çox heyran deyil ki MOSS / WSS burada və orada kifayət qədər ağıllı tövsiyələr gördüm (arzulu Siz) 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, lütfen!

MOSS / WSS mənə deyir: “Bu səhifə başqa bir müəllif tərəfindən redaktə edilmişdir …” ancaq, olmayıb.

We did some heavy duty re-organizing of our site taxonomy via "Manage Content and Structure". For reasons unknown to me, Bu prosesi (əsas iş olsa) broke some navigation links in the quick launch. The broken links are characterized by:

  • Wrong URL. Məsələn, it should be "/sites/departments/HumanResources/…". Lakin, the new link is "/sites/Corporate/HumanResources/…".
  • Repeated bits on the query string of the heading, kimi:

/sites/departments/HumanResources/_layouts/viewlsts.aspx?BaseType=0?BaseType=0?BaseType=0?BaseType=0

That’s easy enough to fix via site settings/navigation. Except, MOSS presents me with this when I try and do it:

image

The fact is, no one is making any change there (aside from me, əlbəttə).

A quick search turns up this MSDN forums discussion: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1691577&SiteID=1

William Heurdier lays it out nicely in the the penultimate (kimi 10/02/07) poçt:

Fact is:

To reset corrupted headings, you have to :

– remove all the lists under corrupted heading

– remove corrupted heading

– From the list settings, add a removed list to the quick launch (This regenerate a non corrupted heading)

You are then good to go….


Sharepoint Expert – Sogeti Cap Gemini Switzerland

I was a bit confused because I kept wanting to go to the navigation page, make the change and then get hit with the "page was modified" message. Nəhayət, 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!

</son>

Blog abunə!

Ilə problemlər “Tarixə qədər Pause” SPD yaradılmış axınları fəaliyyət

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

Fon:

Biz ekoloji Engineering Manager təmin etmək lazımdır bir iş tələb var ki, 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 (və ya onun köməkçisi) enters all the required permits and reminder dates at the start of the year. The system then does all the heavy lifting.

Ətraf mühit:

MOSS, 64 parça, virtual maşın mühit (inkişaf qutusu), 2 serverlər (Server SQL #1, server başqa hər şey #2).

Problemləri:

The Pause Until Date action seems like the perfect solution and it may well prove itself to be. Lakin, bu qutusu yaxşı işləri deyil (Bizim üçün).

  1. Bu iş iş çalıştırmak üçün müəyyən olunmayıb, ever. I discovered this by reading through Christopher Ağ (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:\>

    Bu təəccüblü nəticə idi, lakin asanlıqla həll:

    C:\>stsadm -o setproperty -propertyname "job-worfklow" -propertyvalue "every 1 arasında dəqiqə 0 və 59" -url http://localhost

    Əməliyyat uğurla başa.

    C:\>

    Bunu sonra, the first "In Progress" iş tez atəş və onun iş görmüşdür.

  2. Qubarlı, the next one didn’t work as expected. Təşəkkürlə, Christopher refers us burada (http://support.microsoft.com/kb/932816). As of writing of this entry, ki, düzeltme almaq üçün IT Departamentinin bekliyoruz, but it does look promising. Our copies of the affected .dll’s do not share the same byte size, Beləliklə, ümid edirəm bu problemi həll edəcək.

Puç:

Re-running the stsadm -o setproperty command seemed to prod the workflow timer awake. It would, təxminən 7 dəqiqə sonra, actually wake up and continue along with the workflow.

Suallar / Məsələlər:

Tarixinə qədər Pause işləmir.

Tarixinə qədər fasilə davam etmir.

Workflow status does not change from "In Progress"

Workflow status stays "In Progress"

MOSS istifadə MRO Workflow case study, SPD, InfoPath & web services.

Baxış

Bu giriş faktiki MRO izah təcrübələrin öyrənilməsi təsvir (Xidmət, Təmir və Əməliyyatlar) MOSS həyata iş təsdiq prosesi.

Bu açıq-aydın texniki müzakirə deyil, lakin əvəzinə MOSS platforması real-dünya tələbatını necə nümayiş etdirir ki, real-dünya nümunə xidmət.

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

Fon

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. Some times, the originator does not have the technical expertise to fill out the PO requisition. Məsələn, a user may want to requisition a new laptop computer, but does not know the best vendor, IT standards, və s.. Bu halda, 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. Məsələn, 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. Görmək burada 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, və s..
  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.

Qeydlər

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

Nəticə

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

MOSS / WSS Axtarış nəticələri (və dataviews): ham XML data keçirmək

Bu, çox aydın ola bilər, ancaq MOSS proqramlaşdırma imtahan üçün öyrənilməsi zamanı, Hesab edirəm ki, istifadəçi interfeysi vasitəsilə bir axtarış sorğu faktiki XML almaq üçün olduqca asan olduğunu öyrəndim.

Aşağıdakı kimi biri tez metodu:

  • Ətraflı axtarış daxil.
  • Bəzi qaytarır bir axtarış həyata.
  • Səhifənin Düzenle (site parametrləri ilə).
  • Change the XSL to the following:

<?xml variant="1.0" encoding="utf-8"?>
<
XSL:stylesheet variant="1.0" xmlns:XSL="http://www.w3.org/1999/XSL/Transform">
<
XSL:output üsul="xml" variant="1.0" encoding="UTF-8" indent="bəli"/>
<
XSL:şablon matç="/">
<
pre>
<
XSL:copy-of seçmək="*"/>
</
pre>
</
XSL:şablon>
</
XSL:stylesheet>

  • Hit apply.
  • View Source in the browser.

Note that the <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 times I created some customized search results.

This ought to work for dataviews as well, though I have not tested that out as yet.

WSS üçün heç CQWP? Bu cəhd edin…

Görürəm ki Eric Kraus was faced with a requirement normally met with a content query web part. Problem? He was in a pure WSS environment with no access to the CQWP. Rather than curling up in the fetal position (Mən hər gün mübarizə üçün dürtü, görünür), he came up with solution that at least gives WSS shops a fighting chance to succeed. It’s described burada.

Content management API Brilliant və ayrıntılı

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

Mən ilk Joris poelmans blog Bu link ayağa qaldırdı http://jopx.blogspot.com/.

Siz mənim kimi etdiyiniz bile, ki, content idarə edilməsi üçün iş hands-çox nə idi yoxdur, bu yaxşı dəyər 20 minutes of your time to read.

API istifadə, olar:

  • Çox asan content ixrac və idxal.
  • Re-parent content. If you want to export some content from a site "A" and send it to site "B" lakin iyerarxiyasında tamamilə yeni yerdə, bu mümkün.
  • Bir site content ixrac site içinə seçilmiş bit idxal.
  • Re-link content (bütün hiperlink ilə məşğul deməkdir).

WSS, doc libs & siyahıları, Cəlb hesablanır sütunları [Yadda]

Someone on the Internets was asking about how to create a calculated column on a list that would show a value formatted as "[İstifadəçi] – [Status] – [Location]" Paul Galvin "kimi – İçməli [pulsuz] Pivə – The Beach ".

Paul would go in and update his entry in the list and the calculated column would update appropriately. The [İstifadəçi] siyahısını yenilənməsi / daxil olan istifadəçi-u mənim olmalıdır.

A hesablanır sütun "uçucu istifadə edə bilməzsiniz" kimi funksiyaları [Yadda] və ya [Bugün]. I solved it in a test environment with these steps:

  1. "Cari İstifadəçi" adlı bir mətn sütun yarat.
  2. U mənim dəyəri seçin [Yadda]
  3. "Calc Test" adlı hesablanır sütun yarat.
  4. Dəyəri = seçin [Istifadəçi]

I getdi, siyahısına bir maddə əlavə və işləyib.

Aralıklı IE qəzaları bir WSS / MOSS sənəd kitabxana sənədlərin erişirken

Mən bu ilə mürəkkəbləşdirilir olduğunuz 9 ay və mən MSDN və Usenet forumlarda insanların bu too.l ki bax

Bəzən, bir söz sənəd erişirken (və ya digər doc növləri) bir sənəd kitabxana sadəcə qəza və getmək üçün Internet Explorer səbəb olur (onunla bütün Nişanlar alaraq hər hansı bir açıq olduqda).

Bu MS düzeltme həll edə bilər: http://support.microsoft.com/kb/938888

Həmçinin, problem haqqında bəzi təsviri burada var:

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

Irəli real XPath addım olacaq?

Baxış:

Bir çox sütun bir içerik növü idarə edən xüsusi siyahı Yaradılma.

Bir səhifə üçün əlavə və sonra SPD vasitəsilə, bir veri görünüşü çevrilir.

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:dəyər və>
          </TD>
        </tr>
      </XSL>
    </masa>

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.

Həll:

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.

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

<nobr><aşırım><A HREF="/sites/Corporate/HumanResources/TalentAcquisition/_layouts/userdisp.aspx?ID=17">Galvin, Paul</A><img sərhəd ="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’/></bir></aşırım></nobr>