Hli Archives: November 2007

Koj yeej tsis tau lub SharePoint cuag

1 Teb

Thaum kawg ob hnub, Kuv tau koom ntawm ob tug rooj sib tham thaum lub caij uas peb nyob ib SharePoint ib qhov soj ntsuam. Lub CIO thiab nws pab neeg koom lub rooj sab laj thawj. Uas yog txheem thiab tsis xws notable. Yog tus rollout enterprise ntawm yog ib qhov kev siv tshuab obviously pab lawv IT. Lub rooj sab laj ob txhab kom muaj ib tug V.P. txhob ua li, ntau cov sawv cev HR directors, Logistics, Raug, Capital txug tej yaam, Tsis zoo, Kev yuav khoom, Neeg kev loj hlob thiab lwm tus saib xyuas (ib txhia neeg uas twb tsis koom tes txawm ncaj qha rau cov theem tam sim no). Uas yog ib cov neeg tuaj saib mighty dav.

Hauv kuv lub neej ua ntej, Kuv uas ua haujlwm rau ERP thiab CRM txug tej yaam. Nkawd ob leeg muaj ib lub sau hais haum haum dav tab sis txhob kom dav li SharePoint. Mus tau mas pom tau hais, Tej yaam num SharePoint legitimately thiab tas mus nto txhua nook thiab cov cranny uas yog cov koom haum. Tsawg lwm enterprise dlaws tau uas tsi cuag? Tsis ntau.

SharePoint kom meej meej nruab nrab yog caij nyoog rau cov uas peb muaj hmoo txaus rau hauv qhov chaw no enormous. Nws muaj ib tug zoo kawg thiab kev sib (uas yog cas nres rau ntawm nws lub taub hau ntawm no nyob rau hauv "Yees koj yuav tsum lug tau sai dlua"). Nws yuav zoo dua, tab sis kuj tseem, SharePoint exposes peb rau tus uas nws kim heev thiab dav ntau yam kev ua hauj lwm muaj dab los ntawm cov engagements. Pes CRM tshwj xeeb nrog tus raug sab ntawm koj lub tuam txhab? Pes ERP pheejyig npaum licas ua neeg nrhiav kev pab rau tshaaj txuj ci? SharePoint coob tshaj li lawv ob.

Zoo li dab tsi, yog tsis zoo meej, tab sis, nws yog ib qhov chaw zoo damned yuav.

Rau txoj kev hlub ntawm [sau koj feem txheeb tus neeg/dua tau], tsis hloov lub ' Title’ qhov chaw kem.

7 Replies

Nyob rau lub SharePoint forums, ib tug neeg qee nug txog "hloov ntawm daim ntawv lo ntawm Title" los txog "tshem npe los ntawm lub npe".

Ntxaib: Tsis txhob ua!

Sadly, tus neeg siv interface pub rau ib seem kev hloov ntawm daim ntawv lo ntawd qhia kiag li:

duab

Npe yog ib sab nrog qhov "khoom" cov hom. Ntau yam, ntau yam, ntau i txoj siv no sab thiab yog hais tias koj hloov nws nyob ntawm no, Nws hais rau qhov txhia chaw ripples. Muaj zoo sij hawm uas koj yuav tsis npaj rau qhov uas yuav tshwm sim. Koj muaj tej zaum tau xav mus rau koj tus kheej, "Kuv muaj ib daim ntawv teev kev cai lookup thiab ' Title’ cia li tsis raug raws li vaj qhia kiag, ces kuv mus hloov rau ' raws li txoj cai Code’ thiab ntxiv ib nqe lus piav qhia kiag." Tab sis, yog hais tias koj ua raws li rau cov uas xav thiab rename ' Title’ los 'Raws li txoj cai Code', txhua daim ntawv teev npe (nrog rau daim ntawv qiv) kev pauv kom "raws li txoj cai Code" thiab koj tej zaum tsis yuav npaj rau qhov uas yuav tshwm sim.

Qhov teeb meem tiag tiag yog hais tias qhov no yog ib cov hloov seem. Cov UI "paub" "title ntawd" yog ib lo lus reserved. Li ntawd, Yog koj sim thiab hloov "raws li txoj cai Code" rov qab mus rau "Title", nws yuav tiv thaiv koj thiab ua tam sim no koj twb pleev xim rau koj tus kheej mus rau kaum tsev using paint that never dries 🙂

Yuav ua li cas yog hais tias koj twb hloov nws? Kuv tsis pom cov lus teb peb yeej xav, Nws yog ib tug yooj yooj yim thiab yooj yim txoj kev los pauv cov ntawv sau rov qab mus 'Title'. tam sim no, lub tswv yim zoo yog yuav txia mus ua ib yam dab tsi zoo li "Doc/khoom Title". Tus ntawd yog ib daim ntawv lo generic txaus uas tej zaum yuav tsis muaj jarring heev rau koj cov neeg siv.

Kuv muaj ob peb lwm yam tswvyim uas muaj rau kuv to-do daim ntawv uas muaj tej yam uas yuav tau tshawb fawb:

  • Hu rau Microsoft.
  • Yuav ua ib yam dab tsi nrog lub nruas qauv, tej zaum nyob tau nrog ib tug feature.
  • Xyuas seb cov database schema thiab hloov SQL manually. (Koj yuav tsum hu Microsoft lub cav no ho; nws yuav yuav void daim ntawv cog lus them nyiaj yug koj).

Yog leej twg paub li cas los daws kom tau qhov no, thov logged.

Hloov cov caij tav su, 11/15: Kuv nrhiav tau no txuas uas piav rau tsim daim ntawv teev tias tsis muaj ib txoj cai title kem ib yam: http://www.venkat.org/index.php/2007/09/03/how-to-remove-title-column-from-a-custom-list/

BDC ADF thiab koj cov phooj ywg, CDATA

1 Teb

Kuv twb pom tej yam ua tau txawv txawv thiab ruaj tes-encoding RdbCommandText nyob hauv ib co piv txwv ntawm cov (xws li lwm cov ntaub ntawv MSDN).

Kuv xav taw tes rau cov tuaj tshiab rau BDC tias commands yuav muab qhwv hauv ib CDATA lossis nyob rau "natural lawv" daim ntawv. Li ntawd, qhov kev siv ua tau txawv txawv:

<Khoom Lub npe="RdbCommandText" Hom="System.String">
  QHO dbo.MCRS_SETTLEMENT.ID, dbo.MCRS_SETTLEMENT.Settlement los ntawm dbo.MCRS_SETTLEMENT 
    QHOV TWG (tus ID &gt;= @MinId) THIAB (tus ID &LT;= @MaxId)
</Khoom>

uas muaj yeej yuav zoo dua tuaj li no:

<Khoom Lub npe="RdbCommandText" Hom="System.String">
<![CDATA[
 QHO dbo.MCRS_SETTLEMENT.ID, dbo.MCRS_SETTLEMENT.Settlement los ntawm dbo.MCRS_SETTLEMENT
QHOV TWG (tus ID >= @MinId) THIAB (tus ID <= @MaxId)
]]>
</Khoom>

</kawg>

BDC Primer

Intro mus BDC

Tej cov piv txwv: BDC ADF uas yog connects los SQL database nrog embedded cov neeg siv tus id thiab lo lus zais

4 Replies

Kuv xav tau los hlau tuaj NTXHUAB rau ib SQL database ntawm BDC. Rau kev tshuaj ntsuam txog/POC, Kuv xav mus embed rau SQL tus account neeg tus id thiab lo lus zais rau hauv cov ADF. Pib nrog no template (http://msdn2.microsoft.com/en-us/library/ms564221.aspx), Kuv tsim ib ADF connects rau ib tug SQL neeg rau zaub mov lom thiab logs tau maub ib hais neeg tus id thiab lo lus zais thiab qhia hauv no snippet:

  <LobSystemInstances>
    <LobSystemInstance Lub npe="ClaimsInstance">
      <Khoom>
        <Khoom Lub npe="AuthenticationMode" Hom="System.String">PassThrough</Khoom>
        <Khoom Lub npe="DatabaseAccessProvider" Hom="System.String">SqlServer</Khoom>
        <Khoom Lub npe="RdbConnection tej ntaub ntawv tau qhov twg los" Hom="System.String">serveractual txoos lom</Khoom>
        <Khoom Lub npe="RdbConnection thaum Catalog" Hom="System.String">nqi pib catalog</Khoom>
        <Khoom Lub npe="RdbConnection kev ruaj ntseg" Hom="System.String">SSPI</Khoom>
        <Khoom Lub npe="RdbConnection Pooling" Hom="System.String">tsis tseeb</Khoom>

        <!-- Cov no yog cov tseem ceeb hauv qhov tseem ceeb: -->
        <Khoom Lub npe="Cov neeg siv RdbConnection ID" Hom="System.String">ib tugctual neeg ID</Khoom>
        <Khoom Lub npe="RdbConnection Password" Hom="System.String">txoos Password</Khoom>
        <Khoom Lub npe="RdbConnection Trusted_Connection" Hom="System.String">tsis tseeb</Khoom>

      </Khoom>
    </LobSystemInstance>
  </LobSystemInstances>

Nws tseem tsis tau muaj kev xyaum zoo tshaj, tiam sis nws tseem pab tau rau ib txoj kev sai thiab yooj yim configuration kev soj ntsuam. Qhov no kuj ceeb tias yooj yim paub. Kuv yeej tsis pom ib tug piv txwv tej qhov chaw uas nrhiav keywords:

  • adf kev userid thiab lo lus zais
  • embed neeg tus id thiab lo lus zais rau hauv adf
  • embed neeg tus id thiab lo lus zais rau hauv adf bdc
  • sharepoint bdc primer
  • sharepoint embed neeg tus id thiab lo lus zais rau hauv adf

</kawg>

Subscribe rau kuv blog.

Tej yam kev cai workflow SPD — txoj hlua manipulation enhancements

1 Teb

Txog li ib lub lim tiam dhau los, Yog li ib qhov project codeplex uas muab ib tug yooj yooj yim thiab tubntxhais generic txujci rau kev ntxiv kev cai ua zog los workflow SharePoit Designer. Nws tseem nyob ntawm no: http://www.codeplex.com/spdwfextensions. Tshaj ntawd tsuas muab lub moj khaum, aims nws kuj muab kev pab tau nws qhov kev siv uas yuav ua rau SPD ntau pab/yooj ywm/haib txheej.

Nov yog qhov tam sim no lawm nta rau version 1.0: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=spdwfextensions&ReleaseId=8280

Yog leej twg muaj npe rau qhov project no, thov cia ib tug saib los pib/ntxiv rau ib tug tham ntawm no: http://www.codeplex.com/spdwfextensions/Thread/List.aspx

Ntawm no yog qhov txheej tam sim no tso cai muaj lawm coded (Txawm siab tsis tau kuaj li ntawm 11/08/07):

Muaj nuj nqi Hauj lwm lawm (Yog hais tias tsis tib yam li muaj nuj nqi .net)
Num nkag() Tus nab npawb "nkag rov qab los" nyob rau hauv ib txoj hlua as per ib daim kev cai tswjhwm delimiter.

Piv txwv: Num-nkag rau hauv ib txoj hlua "ib,b,c" nrog delimiter"," = 3.

Nkag() Cov nth token rov rau hauv ib txoj hlua as per ib daim kev cai tswjhwm delimiter.
Ntev String.Length
Hloov() String.Replace()
Muaj() String.Contains()
Rov lo lus "tseeb" los sis lo lus "tsis tseeb".
Substring(pib) String.Substring(pib)
Substring(pib,kawg) String.Substring(pib,kawg)
ToUpper() String.ToUpper()
ToLower() String.ToLower()
StartsWith() String.StartsWith()
Rov lo lus "tseeb" los sis lo lus "tsis tseeb".
EndsWith() String.EndsWith()
Rov lo lus "tseeb" los sis lo lus "tsis tseeb".

Ceev & ib qho yooj yim url Encoding duab company

3 Replies

Hu ua kuv twb tau deductible url-encode tej cov hlua no lub limtiam thiab nplawm ua ke ib me ntsis dej uas kuv xav tias kuv yuav muab rau SkyDrive rau hauv lub zej zos.

Tau lub binary no: http://cid-1cc1edb3daa9b8aa.skydrive.live.com/self.aspx/SharePoint/WinUrlEncode.zip

Tau siv qhov muag saib lub studio muab ntawm no: http://cid-1cc1edb3daa9b8aa.skydrive.live.com/self.aspx/SharePoint/WinUrlEncodeVS2005.zip

Ntawm no yog ib qho screen txhaj:

duab

Txoj kev sai thiab yooj yim: Embed ib hyperlink rau hauv tej ntaub ntawv saib web Tshooj XSLT

6 Replies

HLOOV TSHIAB (01/17/08): No nkag teb chaws hauv blog hais txog ntau hyperlink XSL siab zoo: http://www.sharepointsecurity.com/blog/sharepoint/sharepoint-2007-development/rewriting-links-in-search-results-xslt.

Txheej txheem cej luam thiab lub hom phiaj: Kuv tau tsim ib yooj yim bar daim ntawv kom tswj tivthaiv rau ib dashboard. Kuv yuav txuag kom paub meej txog tsev kab kos rau ib qho, tab sis, kuv tsis tau txua tus txheej txheem (los yog cov lus nug kos, rau qhov teeb meem ntawd). Nws muab tau ib kab nyob rau ntawm daim ntawv thiab thaum kuv tas uas muaj, Kuv muab lub hwj tsam los mus hloov tej daim ntawv lo rau hauv hyperlinks uas taw tes qhia rau lwm daim ntawv qab cov teeb. Piv txwv, muaj ib daim ntawv lo nrog tus nqi "Tuav". Kuv xav mus dhau los ntawm daim ntawv lo ua ib hyperlink kom tus neeg siv yuav tau nyem rau ntawm nws thiab tho coj mus rau kev nkag rau hauv daim ntawv uas tus nqi raws li txoj cai yog "Puag".

Ruam:

  1. Siv kev studio rau sharepoint-paub intellisense.
  2. Luam rau DVWP XSLT rau studio nrig txog kev pom (tsim ib qhov dawb paug project, ntxiv ib cov ntaub ntawv XSL rau peb tes num).
  3. Copy qhov link koj yuav siv tau rau hauv cov ntawv los teev cia.
  4. Paste rau hauv qhov chaw zoo nyob rau lub XSL.
  5. Hloov ua lwm yam URL cav separators rau cov lus nug txoj hlua ntawm"&" mus"&amp;"
  6. Url-encode ib tug neeg lus.
  7. Muab qhwv rau ntawd hauv ib <ib tug href…> </ib tug>

Piv txwv:

Kuv muaj ib tug URL:

http://[neeg rau zaub mov]/[kawm ntawv]/Lists/Open Positions/AllItems.aspx?Pom ={84EEA2F5-121B-40B7-946F-0FA704A1DAA1}&FilterField1 = Recruiter&FilterValue1 = tuav

Kuv yuav hloov rau nws:

     <ib tug href="Lists/Open Positions/AllItems.aspx?Pom = % 7b84EEA2F5-121B-40B7-946F-
0FA704A1DAA1 %7 d&amp;FilterField1 = Recruiter&amp;FilterValue1 = tuav">
       Tuav:
     </ib tug>

Kuv manually transformed thawj sib cav los:

{84EEA2F5-121B-40B7-946F-0FA704A1DAA1}

mus:

%7b84EEA2F5-121B-40B7-946F-0FA704A1DAA1 %7 d

(Nyob rau hauv no, transforms brace qhib rau % 7b thiab kaw brace transforms mus %7 d)

Nqe lus thib ob thiab peb’ tsis ("FilterField1 =Recruiter" thiab "FilterValue1 =Tuav" feem) tsis xav url encoded vim lawv tsis muaj kev tsis zoo kev cim.

Sau ntawv:

Cov txheej txheem no yuav tsum tau feem ntau haujlwm nyob txhua qhov chaw uas koj xav kom ib tug hyperlink embed nyob qhov twg cov hyperlink muab tsis tau rau hauv qhov URL xws li XSLT:

http://[neeg rau zaub mov]/[kawm ntawv]/Lists/Open Positions/AllItems.aspx?Pom ={84EEA2F5-121B-40B7-946F-0FA704A1DAA1}&FilterField1 = Recruiter&FilterValue1 = tuav

Kuv tau txais qhov URL nws tus kheej ntawm tus txheejtxheem ntawm kev cai sau thiab manually filtering rau sab pej xeem Mes Kas (labeled "Recruiter" saum toj).

Yooj yim thiab ceev thaum: Pab kom cov SharePoint Designer workflow los mus hloov ib cov ntawv InfoPath

sau ntawv cia

Scenario: Kuv muaj ib daim InfoPath ntawd hauv ntej-hnub tau neej DVR siv SharePoint Designer workflow. Rau ib kis, ib tug neeg saib xyuas yuav tsum pom zoo rau tsab ntawv. Lawm kuv yuav tsis suav rau yav tas los workflow kom tau raws li kuv tus auditing yuav tsum, Kuv txiav txim siab yuav muab kuv cov lus uas koj auditing cia rau hauv daim ntawv xwb.

Txheej txheem cej luam:

Tsim muaj rau tsab ntawv thiab luam tawm tsab nws lub yog ib cov hom thiab nws tus kheej mus rau lub tsev qiv ntawv hauv daim ntawv. Kos qhov kev kawm ntawv daim ntawv teb yog ib tug updateable NTXHUAB. Daim ntawv tied rau cov hom thiab cov hom "txuas" mus rau lub tsev qiv ntawv ntaub (los ntau, yog koj xav). Sau ib cov workflow uas siab teb.

Ib ruam:

  1. Ua ib daim ntawv qiv. Qhov no yuav tau tuav koj InfoPath template.
  2. Tsim ib tug ntawv qiv.
  3. Tsim daim InfoPath. Muaj ib daim teb ntawv nyeem, "Tshawb lus".
  4. Luam tawm tsab ntawv ua ib yam uas koj kawm ntawd (TSIS muaj ntaub ntawv).
  5. Thaum uas sau teb cov dialogs publishing:
    ib tug) Txuag cov .xsn ua ntaub ntawv thov mus rau lub tsev qiv ntawv hauv daim ntawv (kauj ruam #1).
    b) Luam tawm tsab "Audit hais" teb thiab kos yeej muaj tseeb: "Cia cov neeg los kho kom raug cov ntaub ntawv nyob hauv daim teb no thaum uas siv cov datasheet los yog khoom phab".
    c) Ua kom muaj txheej ib yam tshiab thiab muab nws ua ib lub npe uas tsim nyog.
  6. Saib tau cov ntaub ntawv qiv.
    ib tug) Mus rau hauv tej chaw nws txawm zoo thiab pab tau cov tsev qiv ntawv cov ntaub ntawv uas tswj cov hom.
    b) Xaiv cov hom tshiab khiv created (5c saum toj no). Nws yuav tsum tau grouped nyob rau hauv "Microsoft InfoPath" (lossis zoo).
    c) Tshem cov default "daim ntawv" cov hom los ntawm lub tsev qiv ntawv.
    d) Suam saib koj lub tsev qiv ntawv "qhia raws li cov qhov web page" ua daim ntawv yuav tua tawm los ntawm SharePoint thiab tsis tus InfoPath workstation neeg.
  7. Rov qab mus rau hauv cov tsev qiv ntawv kom zoo thiab nias rau "New" kom tsuas muaj tseeb hais tias daim ntawv no muab lo kom raug thiab kuj raws li koj xav.
  8. Hluav taws tuaj SharePoint Designer thiab next lub site hosts koj lub tsev qiv ntawv uas yog daim ntawv (los ntawm cov kauj ruam 2).
  9. Tsim ib tug tshiab workflow uas txuas mus rau lub tsev qiv ntawv ntaub.
  10. Ntxiv ib tug nkaus nkaus xwb "Laij teb rau tam sim no yam". Koj yuav tsum npaj muaj SharePoint Designer daim ntawv teev koj nyob nraum koj thaj teb, "Tshawb lus". Cob nws muaj nqis.
  11. Nyem tag thiab rov qab mus rau lub tsev qiv ntawv hauv daim ntawv.
  12. Tsim ib daim ntawv tshiab thiab yuav muab qee tus nqi kuaj no mus rau qhov "Audit xov" teb.
  13. Txuag cia thiab rov qab mus rau lub tsev qiv ntawv hauv daim ntawv.
  14. Right-click, xaiv "Workflow" thiab pib nce koj workflow.
  15. Nws yuav tsum khiav tam sim ntawd yuav luag. Rub tau tsab ntawv (los ntawm cov kauj ruam 12) thiab yog hais tias tag nrho cov tau ncaim mus npaj, "Tshawb xov" muaj nyiaj no txawm tus nqi uas koj pab nyob rau theem 10.

Sau ntawv:

Tsis yog txhua yam ntawm lwm yam uas yuav configured kev no sib tham lis-directional. Piv txwv, nws tsis zoo li kev ua SPD workflow uas yog modifies ntawv teb qhwv hauv rov khej.

Ib qho ntawm qhov tseem ceeb mus-lawm tus no yog tias peb twb yeej tsim ib yam cov uas muaj tus mob template. Qhov no tseem enables peb khaws cov ntau InfoPath daim ntawv templates nyob rau daim ntawv qiv tib.

Qhov no yuav tsum tau cov ntaub ntawv neeg rau zaub mov. Nws yog feem coob yeej tsis mus ua hauj lwm hauv ib WSS 3.0 ib puag ncig thiab tej zaum kuj yuav tsum ua lub chaw Enterprise SharePoint.

Cov Beagle muaj Landed (Lub Kaum hli ntuj 2007 qhov teeb meem)

sau ntawv cia

(Qhov no yog ua tau me ntsis laus xov xwm, tab sis raws li kuv lub chaw nres tsheb tua hluav taws nyiam motto proclaims, "Zoo lig tshaj yeej tsis").

Xyuas no: http://www.sharepointbeagle.com/

Yog hais tias koj twb tsis muaj, Nco ntsoov cuv npe.

tau mas, Nco ntsoov nyeem kuv tsab xov xwm hais txog ib tug yog ib qhov SharePoint qhov tseeb (nrog rau cov ntawv yuav tsum txhais, Lub KPI, cov hom, dashboards thiab tshaj) li well li Kuv colleague tsab xov xwm hais txog cov lus nug qhov web ib sab.

Muaj ntau ntau lwm yam khoom uas koj zoo heev.

Tshem li cas “Saib tag nrho cov ntawv kawm ntawv” txuas

sau ntawv cia

Kuv yuav nug txog lo lus nug no yuav luag txhua lub limtiam, feem ntau nyob hauv cov ntsiab lus teb uas muaj kev ruaj ntseg kev sib sab laj. Tus neeg khiav dej num/chaw creator tau provisioned ib tug kawm ntawv, configured ruaj ntseg, web txheej txheem ntawm qhov chaw thiab cov Mekas lub community launch ceev ntawv ntawd teeb huag-li-tag nrho cov kev xaiv kom tus neeg siv tag. Tab sis npog, mus rau ntawm lub box, koj yuav tsis tshem cov "saib tag nrho cov ntawv kawm ntawv" txuas.

Mark Wagner muab cov lus teb ntawm no (http://www.crsw.com/mark/Lists/Posts/Post.aspx?ID=36). Nws tus write-up no zoo kawg li rau theem ob. Nws qhia txog kev yuav teb kom tau cov lus nug, "Cas ua kuv tshem cov saib txhua qhov chaw cov" txuas? Ces, nws teb cov lus nug follow-on tam sim: Pab li cas yuav ua kuv yooj yim kom tus saib tag nrho cov ntawv kawm ntawv txuas ntawm ib qhov chaw uas-qhov chaw?

Raws li ib tug lawm: Nws mus kom ze rau cov WSS xwb, tsis yog NTXHUAB.

</kawg>

Subscribe rau kuv blog!