BOOST SOLUTIONS Excel Import Mushandisi Wekushandisa

Zviri mukati hide

1 BOOST SOLUTIONS Excel Import App

2 Nhanganyaya

3 Maitiro ekushandisa Excel Import App

3.1 Pinza Spreadsheet

3.2 Inotsigirwa SharePoint Column Types

4 Appendikisi 1: Subscription Management

4.1 Kutsvaga Saiti Collection URL

5 Zvinyorwa / Zvishandiso

5.1 References

6 Related Posts

BOOST SOLUTIONS Excel Import App

Copyright
Copyright © 2022 Boost Solutions Co., Ltd. Kodzero dzese dzakachengetwa.
Zvese zviri mugwaro rino zvinodzivirirwa neCopyright uye hapana chikamu chechinyorwa chino chinogona kutsikiswa, kugadziridzwa, kuratidzwa, kuchengetwa muchirongwa chekutora, kana kufambiswa nenzira ipi zvayo kana neimwe nzira, zvemagetsi, zvemuchina, kufotokopa, kurekodha kana neimwe nzira, pasina mvumo yakanyorwa yeBoost Solutions.
Yedu web saiti: http://www.boostsolutions.com

Nhanganyaya

SharePoint Excel Import App inobvumira vashandisi vebhizinesi kuunza chero eExcel spreadsheet (.xlsx, .xls, kana .csv file) kupinda muSharePoint Online rondedzero uye mepu data minda nemaoko kana otomatiki.
Uchishandisa Excel Import App, vashandisi vanogona kupinza data kune akawanda akavakirwa-mukati marudzi eSharePoint makoramu, anosanganisira Imwe Mutsara Wechinyorwa, Yakawanda Mitsetse Yezvinyorwa, Sarudzo, Nhamba, Zuva uye Nguva, Mari, Vanhu kana Boka, Tarisa, Hongu/Kwete uye Hyperlink kana Mifananidzo.
Gwaro iri remushandisi rinoshandiswa kudzidzisa mushandisi mashandisiro eiyi app.
Kuti uwane iyo yazvino kopi yeiyi nemamwe madhairekitori, ndapota shanya:
http://www.boostsolutions.com/download-documentation.html

Maitiro ekushandisa Excel Import App

Pinza Spreadsheet

Kuti utore kunze Spreadsheet, unofanirwa kuve uine kanenge Wedzera Zvinhu uye Rongedza Zvinhu zvibvumirano mune rondedzero kana kuve nhengo yeSharePoint Online boka rine Wedzera Zvinhu uye Rongedza Zvinhu mvumo mune rondedzero.

Isa rondedzero yaunoda kupinza spreadsheet mairi. (Pinda iyo chaiyo folda, unogona kuendesa aspreadsheet kune folda.)
Dzvanya Import Excel mubhara rekuita repamusoro. (Import Excel haiwanikwe mune yekare SharePoint chiitiko.)

MuExcel Import dialog box, in Import kubva kuSpreadsheet chikamu, dhonza iyo Excel file iwe urikuda kuunza kune ine madoti bhokisi nzvimbo (kana tinya Dhonza uye donhedza kana tinya pano kuti usarudze Excel file kusarudza Excel kana CSV file).
Pane imwe nguva Excel file inokwidzwa, mapepa anosanganisirwa achaiswa uye anowanikwa kuti apinzwe kunze. Muchikamu cheSheet, sarudza pepa raunoda kuunza kunze.
Shandisa Option Skip header row muExcel kuti usarudze kana kupinza mutsara wekutanga. Iyi sarudzo inogoneswa nekusarudzika uye inogona kuvharwa nemaoko kana iwe usina mazita emumunda mumutsara wekutanga kana iwe usingade kushandisa mutsara wekutanga semazita emunda.

Muchikamu cheColumn Mepu, sarudza makoramu muExcel uye mepu kuti anyore makoramu.
Nekumisikidza, makoramu ane zita rimwechete anozoiswa mepu otomatiki pese pese pese parinoiswa shiti. Pamusoro pezvo, makoramu anodiwa anozomakwa neasterisiki tsvuku uye anosarudzwa otomatiki.
Muchikamu cheSefa, sarudza huwandu hwe data uye pinza iyo data yaunoda. Kana ukasasarudza iyi sarudzo, mitsetse yese muExcel sheet inozotengeswa kunze kwenyika.Kana ukasarudza bhokisi rekutarisa riri padivi peKupinza kubva ku [] kuenda ku [] sarudzo, uye tsanangura huwandu hwe data sekubva pamutsara 2 kusvika 8, iyo chete mitsetse yakatsanangurwa ndiyo ichapinzwa kune iyo rondedzero.

Muchikamu cheKupinza Sarudzo, tsanangura kana iwe uchida kugadzirisa SharePoint rondedzero uchishandisa Excel file.
Pakupinza kekutanga, hazvina basa kusarudza iyi sarudzo.

Asi kana wakambounza data kunze kwenyika, ungangoda kusarudza kuti ndechipi danho rinofanira kutorwa kana zvakapetwa zvawanikwa pakuunza Excel kuSharePoint.
Usati waita izvi, unofanirwa kugonesa iyo Tarisa marekodhi kana uchipinza sarudzo.
Duplicate marekodhi anogona kuvapo mune ese ari maviri SharePoint rondedzero uye Excel Sheet. Kuti utarise marekodhi akadhindwa, kiyi inofanirwa kutsanangurwa kuti uone marekodhi akadhindwa.
Koramu yakakosha ndeimwe inosarudzika marekodhi pakati peExcel uye SharePoint runyorwa (senge ID column). Iwe unogona kutsanangura zvinopfuura makoramu akakosha.

Cherechedza
Makoramu chete akasarudzwa muchikamu cheColumn Mapping anogona kushandiswa sekoramu kiyi.
Aya makoramu anogona kusetwa seMakoramu Akakosha: Mutsetse mumwechete wezvinyorwa, Sarudzo, Nhamba, Zuva uye Nguva, Mari uye Hongu/Kwete.

Kana iyo Chengetedza duplicate marekodhi kana sarudzo yekunze ikagoneswa, pane zviito zviviri zvinogona kutorwa kana chero zvakapetwa zvawanikwa pakuunza Excel kunyora.

Svetuka marekodhi akadhindwa
Excel Import App inofananidza kukosha kwekoramu yakakosha muExcel uye SharePoint Online runyorwa, kana hunhu hwakafanana pamativi ese, marekodhi anozoonekwa seakapetwa.
Dhata rakaonekwa semarekodhi akadzokororwa muExcel spreadsheet richaregwa pakuunza kunze kwenyika uye chete marekodhi akasarudzika asara ndiwo achatengeswa kunze kwenyika.

Gadziridza marekodhi akadhindwa
Excel Import App inofananidza kukosha kweKiyi koramu muExcel uye SharePoint Online runyorwa, kana hunhu hwakafanana pamativi ese, marekodhi anozoonekwa seakapetwa.
Zvemarekodhi akadhindwa, Excel Import App ichavandudza ruzivo mune zvakapetwa marekodhi muSharePoint Online runyorwa neruzivo rwunoenderana muExcel spreadsheet. Zvadaro, iyo data yakasara yespredishiti ichaonekwa semarekodhi matsva uye inounzwa kunze zvinoenderana.
Cherechedza
Kana iyo kiyi koramu isiri yakasarudzika muExcel kana rondedzero, iyo yakapetwa marekodhi ichasvetuka.
For example, uchifungidzira kuti waisa iyo Order ID column sekiyi:
Kana paine akawanda marekodhi muExcel ane kukosha kwakafanana kweOdha ID koramu, marekodhi aya anozoonekwa seakapetwa uye akasvetuka.
Kana paine akawanda marekodhi ane kukosha kwakafanana kweOdha ID mutsara mune runyorwa, marekodhi ari murondedzero anozoonekwa seakapetwa uye akasvetuka.
Wobva wadzvanya bhatani rekuti Import.

Mushure mekunge maitiro ekuunza kunze apera, unogona kuona mibairo yekupinza seinotevera. Dzvanya bhatani reKuvhara kuti ubude.
Iyo mune iyo rondedzero, iwe uchaona kuti ese marekodhi eExcel file akapinzwa kunze kwenyika sezvinotevera.

Inotsigirwa SharePoint Column Types

Anonyanya kufarirwa SharePoint makoramu anotsigirwa neExcel Import App, inosanganisira Imwe Mutsetse Wechinyorwa, Yakawanda Mitsetse Yezvinyorwa, Sarudzo, Nhamba, Zuva uye Nguva, Mari, Vanhu kana Boka, Tarisa, Hongu/Kwete uye Hyperlink kana Mifananidzo. Unogona kumepu makoramu eExcel kune aya SharePoint makoramu paunenge uchiunza Excel file.

Nekudaro, kune mamwe marudzi emakoramu, pane mamwe matipi aunoda kutarisira:

Sarudzo
Sarudzo koramu ndeye yakavakirwa-mukati SharePoint Online column ine predefined values, kupinza ma values muiyi column type, you need to check and make sure the value and case are same in Excel and list.

Kupinza akawanda ma values muSarudzo column, ma values anofanirwa kupatsanurwa necomma ",".

For example, kukosha kweCategory column kunofanirwa kupatsanurwa ne "," sekutevera, zvino vanogona kutengwa kunze kwenyika zvinobudirira.

Lookup Column
Kupinza kukosha kune SharePoint Lookup column, inoda kukosha kuve chinyorwa kana nhamba. Zvinoreva kuti chikamu chakasarudzwa cheMuchikamu chino chinofanira kunge chiri Mutsetse mumwechete wezvinyorwa kana nhamba yeNhamba.

Kana iwe ukaronga kupinza akawanda ma values muSarudzo koramu, kukosha kunofanirwa kupatsanurwa ne ";".

For example, kukosha kweRelated Cases column inofanira kupatsanurwa ne ";" sekutevera, zvino vanogona kuendeswa kune iyo Lookup column zvinobudirira.

Munhu kana Boka Column
Kupinza mazita kune SharePoint Person kana Group column, zita remushandisi muExcel rinofanira kunge riri zita rekupinda, zita rekuratidzira kana email kero; kana iwe uchida kuunza akawanda ma values kune ino koramu, iyo yakakosha inofanira kupatsanurwa ne ";".
For example, zita rinoratidza kana kero yeemail sezviri kuratidzwa pamufananidzo uri pazasi unogona kupinza zvinobudirira muMunhu kana Boka Column.

Appendikisi 1: Subscription Management

Unogona kushandisa Excel Kupinza App muyedzo kunyoreswa kwemazuva makumi matatu kubva pazuva rawakatanga kuishandisa.
Kana nguva yekunyorera yekuyedza ikapera, iwe unozofanirwa kutenga kunyoreswa.
Kunyoreswa kweExcel Import App ndeye saiti (yaimbonzi "saiti kuunganidzwa") kana rent pagore.
Kunyoreswa kuunganidzwa kwesaiti, hapana magumo-mushandisi anogumira. Vese vashandisi vari muunganidzwa wesaiti vanogona kuwana iyo app.
Pakunyoreswa kwemaroja, hapana mawebhusaiti kana saiti yekuunganidza miganho. Vese vashandisi vanogona kuwana iyo app mumasaiti ese kana saiti kuunganidzwa mukati memurendi mumwe chete.

Kutarisa Kunyoresa Status

Paunovhura Excel Import dialog, mamiriro ekunyorera anozoratidzwa pamusoro peiyo dialog.
Kana kunyoreswa kwave kuda kupera mukati memazuva makumi matatu, meseji yekuzivisa inogara ichiratidza mazuva asara.
Kuti uvandudze mamiriro ekunyorera, ndapota isa mbeva pane yekuzivisa meseji uye tinya iyo, ipapo chimiro chitsva chinozoiswa.
Kana iyo yekunyorera mamiriro ikasachinja, ndapota bvisa cache yebrowser uye tinya zvakare.
Kana mamiriro ekunyorera atendeuka kuKunyoreswa kwako haashande sekutevera, zvinoreva kuti kunyorera kwako kwapera.
Ndapota titumirei (sales@boostsolutions.com) nzvimbo URL kuenderera mberi nekunyorera kana kuvandudza.

Kutsvaga Saiti Collection URL

Kuti uwane saiti (yaimbonzi saiti kuunganidzwa) URL, ndapota enda kune Active saiti peji yeiyo itsva SharePoint admin centre.
Dzvanya saiti kuti uvhure hwindo rine marongero esaiti. Mune General tab, tinya Rongedza link uye ipapo unogona kuwana saiti URL.Kana saiti yako URL shanduko, ndapota titumire itsva URL kugadzirisa kunyoresa.

Kutsvaga ID yemuroja

Kuti utore ID yemuroja, ndapota tanga waenda kuSharePoint admin centre.
Kubva kuSharePoint admin centre, tinya pane Zvimwe zvinongedzo link kubva kuruboshwe kufamba, uye wobva wadzvanya bhatani Vhura pasi peMapurogiramu.
MuPeji Yekuronga Mapurogiramu, tinya pane More maficha link kubva kuruboshwe rwekufamba.
Uye wobva wadzvanya bhatani Vhura pasi pemvumo yeApp.
Peji yeMvumo yeApp inonyora ese maapuro, kusanganisira zita rinoratidza app uye zviziviso zveapp. Muchikamu cheApp Identifier, chikamu chinotevera @ chiratidzo ndicho chako Tenant ID.
Ndapota titumirei (sales@boostsolutions.com) ID yemuroja kuti uenderere mberi nekunyorera kana kuvandudza.
Kana kuti iwe unogona kuwana ID yemuroja kuburikidza neAzure portal.
Saina kuAzure portal.
Sarudza Azure Active Directory.
Sarudza Properties.