SharePoint Security Fundamentals Primer / Tsis txhob muaj cov Pitfalls khaub

8 Replies

HLOOV TSHIAB 12/18/07: Saib Paul Liebrand tshooj rau ib co kev zoo kev tshem tawm los yog modifying lub neej ntawd pab pawg npe (koj saib nws saib cov hauv qab no kom zoo).

Txheej txheem cej luam:

SharePoint ruaj ntseg yuav yooj yim rau configure thiab hwj. Txawm li cas los, nws muaj proven tsis yooj yim rau ib co sij hawm ua ntej thawj xibfwb qhwv tes puag ncig ntawd yeej. Tsis tas li ntawd, Kuv pom muaj ib co thawj xibfwb tuaj nkag siab rau hnub Zwj Hli xwb los tau ploj ntawm Friday vim lawv tsis tau ua lus configuration nyob rau lub sij hawm intervening zoo meej. (Kuv yuav coj tau qhov teeb meem no muaj kuv tus kheej lees). No nkag teb chaws blog hopefully qhia ib pab SharePoint ruaj ntseg primer thiab cov ntsiab lus ntawm ib co ruaj ntseg configuration qha.

Lus tseem ceeb:

Cov hauj lwm no yog xyuas los ntawm mus rau ntawm lub box SharePoint ruaj ntseg. Kuv tus kheej kev yog oriented NTXHUAB thaj tsam li no tej zaum yuav muaj ib co NTXHUAB tej khoom no, tab sis kuv ntseeg tias nws yuav yog rau WSS. Kuv cia siab tias leej twg pom cov lus kom raug los omissions yuav taw tes uas hauv cov lus los yog email rau kuv. Kuv mam li ua corrections rooj vag mus ceev.

Fundamentals:

Rau cov hom phiaj ntawm qhov txheej txheem cej luam, muaj plaub siv kev kom ruaj: cov neeg los ib pawg, securable khoom, tso cai ntxiv thiab tej ncaus.

Cov neeg thiab ib pawg cia rau:

  • Cov neeg uas ib tug neeg: Rho tawm dhia daim keeb kwm los created hauv SharePoint.
  • Tej pawg: Mapped ntawm lub directory los yog tsim nyob rau hauv SharePoint. Pawg no tus sau los ntawm cov neeg. Yog ntiaj teb no nyob rau hauv ib qhov chaw sau tej pawg. Lawv yeej ib txwm tsis "tied" muaj kev tawm tsam securable.

Securable khoom khis cia kom tsawg:

  • Chaw
  • Daim ntawv qiv
  • Yam khoom ntawd npe thiab daim ntawv qiv
  • Folders
  • Ntau cov chaw BDC.

Muaj lwm yam khoom uas securable, tab sis, koj yuav tau daim duab.

Tso cai ntau ntau: Ib lub nras uas ntau / tej txoj cai uas tsis muaj kawm ntawv uas muaj tej yam li ua/nyeem/rho tawm nkag hauv lub npe.

Ncaus: Los ntawm cov chaw vim inherit cov chaw ruaj ntseg ntawm cov twj paj nruas uas muaj. Ncua lub chaw inherit txoj kev tsocai los ntawm nws niam nws txiv. Daim ntawv qiv ntawm lawv qhov chaw inherit. Hais txog thiab li ntawd.

Cov neeg siv thiab pawg txheeb securable khoom ntawm tso cai ntxiv thiab tej ncaus.

Cov tseem ceeb tshaj plaws Security cai To taub, Ever 🙂 :

  1. Pawg no cias collections ntawm cov neeg.
  2. Yog ntiaj teb no nyob rau hauv ib qhov chaw sau tej pawg (i.e. yog tsis muaj zoo li no uas yog ib cov lus sau tseg rau hauv ib qhov chaw tiaj).
  3. Pab pawg neeg lub npe tsis withstanding, pawg tsis, nyob rau hauv thiab ntawm lawv tus kheej, muaj tej tug theem ntawm kev ruaj ntseg.
  4. Pawg muaj kev ruaj ntseg hauv lub ntsiab lus teb ib securable hais kwv.
  5. Koj yuav cob cov qib sib txawv tso cai mus rau cov pab pawg neeg tib yam rau txhua txhua tus kwv securable.
  6. Web daim ntawv cai trump nov tag nrho (saib hauv qab).

Ruaj ntseg thawj xibfwb poob rau hauv lub hiav txwv los ntawm kev faib pab pawg neeg thiab cov neeg siv yeej ib txwm khi cov axioms los tswj thiab to taub txog cov kev ruaj ntseg configuration.

Hom Pitfalls:

  • Pab pawg neeg cov npe yees tsi tso cai: Mus rau ntawm lub box, SharePoint nyiaj thiab lub sij txheej pawg uas lawv cov npe teev ib theem ntawm kev ruaj ntseg xam qhovkev. Xav txog rau pawg "Contributor". Ib qho txawv uas ruaj ntseg SharePoint yuav zoo saib ntawd lub npe thiab tias tias pawg neeg yuav "pab txhawb kev pov plob" mus rau lwm qhov chaw/sau/tsev qiv ntawv hauv lub portal. Uas tej zaum yuav muaj tseeb tiam sis tsis tau vim tias cov pab pawg neeg lub npe zoo li yuav tau "contributor". Qhov no tsuas mus rau ntawm lub box muaj tseeb vim hais tias cov pab pawg neeg tau muab daim ntawv tso cai npaum li uas lawv mus ntxiv/hloov/rho tawm kawm ntawm lub hauv paus kawm ntawv enables. Los ntawm ncaus, "contributors cov" pab pawg neeg kuj yuav ntxiv/hloov/rho tawm ntsiab lus ntawm txhua qhov chaw ncua. Ib tug yuav "tawg" qhov ncaus saw thiab pauv kev tso cai lawm ib ncua ntawm tej tus neeg ntawm qhov sib "Contributor" pab tsis tau pab txhawb txhua, tab sis, tsuas nyeem (Piv txwv). Qhov no yuav tsis muaj ib lub tswv yim zoo, obviously, vim nws yuav ruam heev tag.
  • Pawg no tsis txhais ntawm ib qhov chaw tiaj. Nws yog ib qho yooj yim uas totaub los ntawm cov neeg interface. Microsoft muaj ib qhov txuas yooj yim rau cov neeg siv/pab pawg neeg tswj ntawm txhua qhov chaw tus "neeg thiab ib pawg" txuas. Nws yog ib qho yooj yim uas ntseeg tias thaum kuv tab tom kawm ntawv "xyzzy" thiab kuv tsim tau ib pab los ntawm xyzzy tus neeg thiab ib pawg txuas uas kuv twb nyuam qhuav yuav tsim cov ib pawg uas tsuas tshwm sim nyob xyzzy. Uas yog tsis tau hais. Kuv twb tau tsim ib pawg rau cov tseem kawm ntawv sau.
  • Pawg koom tsis txawv ntawm qhov chaw (i.e. Nws yog ib yam qhov txhia chaw siv rau pawg): Xav txog cov pab pawg neeg "tswv" thiab ob qhov chaw, "HR" thiab "Logistics". Ces yuav tsis xav tias ob dua lwm cov neeg uas yuav muaj cov chaw — tus HR cov tswv tsev thiab tus tswv tsev Logistics. Tus neeg siv interface ua kom yooj yim rau ib tug neeg khiav dej num ruaj ntseg rau mishandle no scenario. Yog hais tias kuv tsis paub zoo, Kuv yuav nkag tau rau neeg thiab ib pawg txog ntawm tus HR chaw, xaiv "tswv lub" pab pawg neeg thiab ntxiv kuv HR tswv rau ntawd. Ib hlis tom qab, Logistics los ntawm kab. Kuv saib cov neeg thiab cov neeg nyob ua ke ntawm lub Logistics site, ntxiv rub tau "tswv lub" ib pab. Kuv pom tus HR tswv muaj thiab tshem nws, xav tias kuv yuav hle nws los ntawm tus tswv tsev rau lub Logistics site. qhov tseeb, Kuv yuav hle nws los ntawm tus tswv neeg ntiaj teb no. Hilarity ensues.
  • Failing rau npe pawg raws li ib tug: "Approvers cov" ib pab neeg yog ib tug piv txwv zoo meej. Neeg no pab approve yuav zoo li cas? Lawv yuav pom tau tias qhov twg? Kuv yeej xav tsi neeg Logistics koom tau pom zoo HR cov ntaub ntawv? Tau kawg tsis. Yuav tsum rau npe pawg raws li lawv lub luag hauj lwm nyob rau hauv lub koom haum. Qhov no yuav pab txo kom tias cov kev pab yog muab ib theem tej kev tso cai rau ib qho securable kwv. Lub npe pawg raws cov luag hauj lwm intended. Nyob rau hauv tus HR/Logistics scenario dhau los, Kuv yuav tsum tau tsim ib pawg ob tug tshiab: "HR cov tswv" thiab "Logistics tswv" thiab cob cov paub tab paub xav tso cai ntau ntau rau neb thiab nyiaj yam tsawg kawg nkaus uas rau cov neeg siv cov ua lawv txoj hauj lwm.

Lwm yam chiv keeb uas pab tau:

Yog hais tias koj twb ua nws qhov no kom deb deb:

Thov qhia rau kuv paub tias koj kev xav mentsis ntawm cov lus los sis email rau kuv. Yog koj paub lwm yam chiv keeb zoo, thov koj ua zoo li qub!

Ntawv cim npe Technorati:

Txoj kev sai thiab yooj yim: Tsim ib cov ntaub ntawv saib Web feem (DVWP)

2 Replies

Muaj ib tug wealth yawm hais txog ntawm tus WSS 3.0 Tej ntaub ntawv saib Web site qhov (DVWP) nyob rau web los ntawm ntau qhov chaw. Txawm li cas los, Kuv pom tias nws yuav tsis yooj yim kuj ceeb tias yuav nrhiav tau cov lus qhia ntawm no thawj kauj ruam yooj yim heev. Ntawm no yog ib tsab xov xwm nyob rau hauv "txoj kev sai thiab yooj yim" Series nyob rau nws.

Ua raws li cov kauj ruam yuav tsim ib tug ntawv saib Web site qhov (DVWP). Lawv yog raws "Tshajtawm ib" cov qhov Web site, tab sis, feem ntau cov npe rau koj.

  1. Tsim kev tshajtawm web Tshooj thiab ntxiv mus rau ib qhov chaw.
  2. Qhib lub site los rau SharePoint Designer.
  3. Qhib lub site default.aspx.
  4. Xaiv ib sab Tshajtawm web thiab right-click.
  5. Ntawm lub ntsiab lus teb ntawv qhia ua zaub mov, xaiv "sau tug ntawv hloov ua lwm yam kom xLT tej ntaub ntawv saib".

SharePoint Designer ceeb rau koj hais tias qhov Web site no yog tam sim no Mekas los ntawm nws qhov chaw txhais. Uas yog tsis tas tsis zoo, tiam sis yog ib qho tseem ceeb uas siv (kev kawm, txawj tej yam ntxiv, lwm tus) uas muaj tshaj li qhov uas cov no me ntsis "ceev thiab yoojyim" nkag. Kom paub ntau ntxiv txog cov ntawv no, Kuv xav ob phau ntawv ntawm no as Well as koj tsis mus nrhiav hauv Internet nyiam.

Tshawb kom paub tseeb tias koj ua nws thwj:

  1. Kaw thiab rov qhib cov qhov web browser (yuav tsum tsis txhob ntawd rov ntaus tej ncauj lus tus thawj "ntxiv cov qhov web tshiab").
  2. Xaiv cov Web site qhov tus xub nco-down thiab xaiv "hloov koom Web site qhov" los ntawm cov ntawv qhia zaub mov.
  3. Tus tuam vaj huam sib luag rau txoj cai opens.
  4. Lub vaj huam sib luag tau hloov los ntawm nws cov teeb li ib txwm xaiv tau qhov no:
duab

“Tsis tau daim ntawv teev khoom schema qhia kiag los rau ntawm daim ntawv SharePoint” — hauj lwm/ua hauj lwm-arounds

4 Replies

Lub lim tiam no, peb thaum kawg tswv cuab txog ib qho teeb meem uas tau raug tus mob no los ntawm ib tug neeg siv tej thaj chaw deb: Thaum twg nws sim export tus txheem ntawm ib daim ntawv teev kom mus zoo, tej yam uas yuav zoo li rov ua haujlwm, tab sis, ces cov Excel xav pop txog ib qho kev ua yuam kev: "Tsis tau daim ntawv teev khoom schema qhia kiag los ntawm daim ntawv SharePoint". Nws twb khiav chaw ua hauj lwm 2003, XP qhov rais thiab txuas rau NTXHUAB.

Nrhiav cov Internets thiab pom cov speculation tab sis tsis muaj dab tsi 100% kuj. Li no, no ncej.

Qhov teeb meem: Exporting ib tug saib kom mus zoo uas muaj ib hnub (hnub tim = tus ntawv hom sab).

Dab tsi ua hauj lwm rau peb: Siv lub hnub los ib tug "hluas kab hauv phau ntawv". Ces, hloov rov qab mus rau ib hnub.

Solved uas. Yog pom tias tus conversion ua hauj lwm zoo, ua tau. Yog tias converting yam li no yuav tsis tshee heev, tiam sis nws tsis.

Ces muab pov cov kab no muaj tseg ib tug duab ntxoo loj loj nyob rau hnub ntawv seb nyob rau hauv tus neeg lub siab, li ntawd, peb mus nrhiav kom paub cov lus teb los ntawm Microsoft kuj thiab hopefully kuv mam tswg hloov ntawm no nyob rau tom ntej tsis muaj sijhawm ntau nrog lawv zaj lus teb thiab hotfix lus.

Lwm yam chiv keeb:

http://www.kevincornwell.com/blog/index.php/cannot-get-the-list-schema-column-property-from-the-sharepoint-list/

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2383611&SiteID=1

<kawg>

Subscribe rau kuv blog.

Ntawv cim npe Technorati: ,

Yooj yim thiab ceev thaum: Xa tus email nrog embedded hyperlink ntawm SharePoint Designer workflow

sau ntawv cia

Hli ib zaug los yog ob zaug, ib tug neeg posts ib lo lus nug hauv rooj sab laj: "Cas ua kuv li hyperlinks rau URL ntawv uas yog los ntawm ib cov SharePoint Designer email clickable?"

Hais tsis tau ntxiv saib: (zoo, yeej yog saib ntxiv tom qab daim duab):

duab

Becky Isserman raws nrog ib tus pab piav embed ib qhov txuas rau ib yam khoom rau tus email no yuav ua li cas: http://www.sharepointblogs.com/mosslover/archive/2007/11/20/addition-to-paul-galvin-s-post-about-sending-an-e-mail-with-hyperlinks-in-spd.aspx

Ntawv cim npe Technorati: , ,

Tshiab tawm: SharePoint Designer Workflow Extensions (txoj hlua manipulation zog)

5 Replies

HLOOV TSHIAB: Saib ntawm no kuv xav nyob commercializing qhov project no: http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!569.entry

Kuv twb tau tibneeg hu tauj coob khiav hauj lwm rau kuv qhov project Codeplex uas yog presently kws tsom rua kev muab txoj hlua manipulation extensions mus workflows tsim ntawm SharePoint Designer.

Ntawm no saib kom paub meej:

Lub tsev qhov project: http://www.codeplex.com/spdwfextensions

Tso tawm: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=spdwfextensions&ReleaseId=8280

Version 1.0 muaj cov yam ntxwv tshiab li nram no:

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,ntev) String.Substring(pib,ntev)
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".

Yuam ib tug BDC runtime kev piav

2 Replies

Kuv los yuam ib tug BDC kev no lub limtiam uas manifested nws tus kheej rau cov neeg siv interface thiab ua tus 12 nas muv cav Thaum runtime.

Ua ntej, qhov no nyob hauv cov neeg interface:

Kuj tsis paub liaj teb mus tau ntxig yaam tseem ceeb txhua lub Identifier nuav los yog txim tuag SpecificFinder MethodInstance nrog lub npe … Xyuas input tsis tau nrog txhua Identifier uas sau tseg rau qhov chaw no TypeDescriptors.

Ntawm no yog ib qho screen txhaj:

clip_image001

Kuv tseem ua txoj xov tshwm nyob rau lub 12 nas muv ca thaum yuav (siv kuv patented high-tech-don't-try-this-at-home uas "mysterious tsis" txujci):

11/14/2007 09:24:41.27 w3wp.exe (0x080C) 0x0B8C SharePoint Portal neeg rau zaub mov ua lag ua luam cov ntaub ntawv 6q4x High kos hauv BusinessDataWebPart.OnPreRender: System.InvalidOperationException: Cov nqi no Identifier ”, yam ”, yog invalid. Xav pom Identifier tus nqi rau cov hom 'System.String'. tom Microsoft.Office.Server.ApplicationRegistry.MetadataModel.Entity.FindSpecific(Nruas[] subIdentifierValues, LobSystemInstance lobSystemInstance) tom Microsoft.SharePoint.Portal.WebControls.BdcClientUtil.FindEntity(Qhov chaw qhov chaw, Nruas[] userValues, LobSystemInstance lobSystemInstance) tom Microsoft.SharePoint.Portal.WebControls.BusinessDataItemBuilder.GetEntityInstance(Saib desiredView) tom Microsoft.SharePoint.Portal.WebControls.BusinessDataDetailsWebPart.GetEntityInstance() tom Microsoft.SharePoint.Portal.WebControls.BusinessDataDetailsWebPart.SetDataSourceProperties()

Kuv nrhiav ib ncig thiab nrhiav tau tej yam ua nyob rau hauv lub Rooj sab laj MSDN, tab sis lawv tsis txaus kuv nkag siab kuv yog ua dab tsis ncaj ncees lawm. Kuv saib ib webcast los Ted Pattison uas kuv niaj hnub muaj squirreled mus rau ib tug neeg rau zaub mov thiab tuaj kom paub kuv qhov teeb meem.

Nyob rau hauv kuv ADF, Kuv yuav siv rau ib SQL database li:

            <Khoom Lub npe="RdbCommandText" Hom="System.String">
              <![CDATA[
                XAIV SETID, CARRIER_ID, EFFDT, DESCR, EFF_STATUS, TAXPAYER_ID, NETWORK_ID, FRT_FORWARD_FLG, ALT_NAME1, ALT_NAME2, LANGUAGE_CD,
                      LUB TEB CHAWS, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, LUB ZOS, NUM1, NUM2, HOUSE_TYPE, ADDR_FIELD1, ADDR_FIELD2, ADDR_FIELD3,
                      CHEEB NROOG, LUB XEEV, KOJ, GEO_CODE, IN_CITY_LIMIT, COUNTRY_CODE, XOV TOOJ, EXTENSION, FAX MUS, LAST_EXP_CHK_DTTM, FREIGHT_VENDOR,
                      INTERLINK_DLL, TMS_EXCLUDE_FLG los dbo.PS_CARRIER_ID_VW nrog (nolock)
                QHOV TWG
                  (SETID <> 'FEEM') thiab
                  (qis(CARRIER_ID) >= sab(@MinId)) thiab
                  (qis(CARRIER_ID) <= sab(@MaxId)) thiab
                  (qis(DESCR) NYIAM sab(@InputDescr))
                ]]>
            </Khoom>

Kuv tau muab qhov SQL los ntawm ib tug neeg DBA thiab kuv muab kuv mus nkag siab hais tias nws yog ib tug tshwj xeeb saib lawv tsim cia rau kuv. Cov yuam sij nws yog CARRIER_ID.

Ntawm no yog cov yoov nkag tau kuv:

      <Identifiers>
        <Identifier Lub npe="CARRIER_ID" TypeName="System.String" />
        <Identifier Lub npe="DESCR" TypeName="System.String" /> 
      </Identifiers>

Qhov chaw nyob ntawm kab, Kuv tswj tau rau kuv tus kheej lawm lub ntsiab ntawm yam <Identifiers> thiab ntxiv DESCR txawm tias tsis tau ib identifier. Kuv muab DESCR lub teeb identifiers thiab presto! Nws cov ua haujlwm.

I hope this saves someone some grief 🙂

Ntawv cim npe Technorati: , , ,

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.