I-BOOST SOLUTIONS Excel Import App

I-copyright
Copyright © 2022 Boost Solutions Co., Ltd. Wonke amalungelo agodliwe.
Zonke izinto eziqukethwe kulolu shicilelo zivikelwe yi-Copyright futhi akukho ngxenye yalolu shicilelo engaphinda ikhiqizwe, ilungiswe, iboniswe, igcinwe ohlelweni lokuthola kabusha, noma idluliselwe nganoma iyiphi indlela noma nganoma iyiphi indlela, i-electronic, mechanical, photocopying, ukurekhoda noma ngenye indlela, ngaphandle kwemvume ebhaliwe ye-Boost Solutions.
Eyethu web indawo: http://www.boostsolutions.com

Isingeniso

I-SharePoint Excel Import App ivumela abasebenzisi bebhizinisi ukuthi bangenise noma yisiphi isipredishithi se-Excel (.xlsx, .xls, noma .csv file) ohlwini lwe-SharePoint Online kanye nezinkambu zedatha yemephu ngokwenza noma ngokuzenzakalelayo.
Ngokusebenzisa i-Excel Import App, abasebenzisi bangangenisa idatha ezinhlotsheni eziningi ezakhelwe ngaphakathi zamakholomu e-SharePoint, okuhlanganisa Umugqa Owodwa Wombhalo, Imigqa Eminingi Yombhalo, Inketho, Inombolo, Idethi nesikhathi, Imali, Abantu noma Iqembu, Ukubheka, Yebo/Cha kanye Isixhumanisi noma Izithombe.
Lo mhlahlandlela womsebenzisi usetshenziselwa ukufundisa umsebenzisi ukuthi angalusebenzisa kanjani lolu hlelo lokusebenza.
Ukuze uthole ikhophi yakamuva yalokhu neminye imihlahlandlela, sicela uvakashele:
http://www.boostsolutions.com/download-documentation.html

Isetshenziswa kanjani i-Excel Import App

Ngenisa Ispredishithi

Ukuze ungenise Ispredishithi, kufanele okungenani ube nezimvume zokungeza Izinto kanye Nokuhlela Izinto ohlwini noma ube yilungu leqembu le-SharePoint Online elinezimvume zokungeza Izinto kanye Nokuhlela Izinto ohlwini.

 

• Faka uhlu ofuna ukungenisa kulo ispredishithi. (Faka ifolda ethile, ungangenisa i-aspreadsheet kufolda.)
• Chofoza okuthi Ngenisa i-Excel kubha yesenzo ephezulu. (I-Excel yokungenisa ayitholakali ku-SharePoint yakudala.)
• Ebhokisini lengxoxo le-Excel Ngenisa, kokuthi Ngenisa usuka esigabeni seSpredishithi, hudula i-Excel file uhlose ukungenisa endaweni yebhokisi elinamachashazi (noma chofoza Hudula bese udedela noma chofoza lapha ukuze ukhethe i-Excel file ukuze ukhethe i-Excel noma i-CSV file).
• Ngemuva kokuthi i-Excel file ilayishiwe, amashidi afakiwe azolayishwa futhi atholakalele ukungeniswa. Esigabeni esithi Ishidi, khetha ishidi ofuna ukulingenisa.
  Sebenzisa umugqa wesihloko othi Inketho Yeqa ku-Excel ukuze unqume ukuthi uyawungenisa yini umugqa wokuqala noma cha. Le nketho inikwe amandla ngokuzenzakalela futhi ingakhutshazwa mathupha uma ungenazo izihloko zenkambu kumugqa wokuqala noma uma ungafuni ukusebenzisa umugqa wokuqala njengezihloko zenkambu.
• Esigabeni Semephu Yekholomu, khetha amakholomu ku-Excel futhi uwabeke kumephu ukuze ufake amakholomu ohlwini.
  Ngokuzenzakalelayo, amakholomu anegama elifanayo azokwenziwa imephu ngokuzenzakalelayo noma nini lapho ishidi lilayishwa. Ukwengeza, amakholomu adingekayo azomakwa ngenkanyezi ebomvu futhi akhethwe ngokuzenzakalelayo.
• Esigabeni esithi Hlunga, khetha ububanzi bedatha bese ungenisa idatha oyidingayo. Uma uyeka ukukhetha le nketho, yonke imigqa eshidini le-Excel izongeniswa.Uma ukhetha ibhokisi lokuthikha eduze kwenketho ethi Ngenisa usuka ku-[] uye ku-[], futhi ucacise ububanzi bedatha obusuka kumugqa 2 ukuya ku-8, imigqa ecacisiwe kuphela ezongeniswa ohlwini.
• Esigabeni Sezinketho Zokungenisa, cacisa ukuthi ufuna ukubuyekeza uhlu lwe-SharePoint usebenzisa i-Excel file.
  Ukungenisa okokuqala, akudingekile ukukhetha le nketho.

Kodwa uma usuvele ungenisile idatha ngaphambilini, ungase udinge ukunquma ukuthi yisiphi isinyathelo okufanele sithathwe uma okuphindiwe kutholakala lapho ungenisa i-Excel ku-SharePoint.
Ngaphambi kokwenza lokhu, udinga ukunika amandla okuthi Hlola amarekhodi ayimpinda lapho ungenisa inketho.
Amarekhodi ayimpinda angaba khona kukho kokubili uhlu lwe-SharePoint kanye ne-Excel Sheet. Ukuze uhlole amarekhodi ayimpinda, ukhiye kufanele ucaciswe ukuze kutholakale amarekhodi ayimpinda.
Ikholomu eyisihluthulelo ileyo ekhomba ngokukhethekile amarekhodi phakathi kwe-Excel nohlu lwe-SharePoint (njengekholomu ye-ID). Ungacacisa amakholomu okhiye angaphezu kwelilodwa.

Qaphela
Amakholomu akhethiwe kuphela esigabeni Semephu Yekholomu angasetshenziswa njengekholomu yokhiye.
Lawa makholomu angasethwa njengamakholomu Abalulekile: Umugqa owodwa wombhalo, Inketho, Inombolo, Usuku kanye nesikhathi, Imali kanye no-Yebo/Cha.

Uma okuthi Hlola amarekhodi ayimpinda uma inketho yokungenisa isinikwe amandla, kunezinyathelo ezimbili ezingenziwa uma kukhona okuphindeke kabili okutholakala lapho kungenisa i-Excel ukuze kufakwe ohlwini.

• Yeqa amarekhodi ayimpinda
  I-Excel Ngenisa Uhlelo Lokusebenza luqhathanisa amanani ekholomu eyinhloko ku-Excel kanye nohlu lwe-SharePoint Online, uma amanani afana nhlangothi zombili, amarekhodi azobonakala njengayimpinda.
  Idatha ehlonzwe njengamarekhodi ayimpinda kusipredishithi se-Excel izokweqiwa lapho kuthunyelwa futhi amarekhodi ahlukile kuphela asele azongeniswa.
• Buyekeza amarekhodi ayimpinda
  I-Excel Import App iqhathanisa amanani wekholomu engukhiye ku-Excel kanye nohlu lwe-SharePoint Online, uma amanani afana nhlangothi zombili, amarekhodi azobonakala njengayimpinda.
  Kumarekhodi ayimpinda, i-Excel Import App izobuyekeza ulwazi kumarekhodi ayimpinda ohlwini lwe-SharePoint Online nolwazi oluhambisanayo kusipredishithi se-Excel. Bese, idatha esele yesipredishithi izothathwa njengamarekhodi amasha futhi ingeniswe ngokufanele.
  Qaphela
  Uma ikholomu yokhiye ingeyona into ehlukile ku-Excel noma ohlwini, amarekhodi ayimpinda azokweqiwa.
  Okwesiboneloample, ucabange ukuthi usethe ikholomu ye-ID ye-oda njengokhiye:
  Uma kukhona amarekhodi amaningi ku-Excel anenani elifanayo lekholomu ye-ID Yoku-oda, lawa marekhodi azobonakala njengayimpinda futhi eqiwe.
  Uma kukhona amarekhodi amaningi anenani elifanayo lekholomu ye-ID ye-oda ohlwini, amarekhodi ohlwini azobonakala njengayimpinda futhi eqiwe.
• Bese uchofoza inkinobho ethi Ngenisa.
• Ngemva kokuqeda inqubo yokungenisa, ungabona imiphumela yokungenisa njengokulandelayo. Chofoza inkinobho ethi Vala ukuze uphume.
• Ohlwini, uzothola ukuthi wonke amarekhodi e-Excel file zingeniswe ohlwini njengokulandelayo.

Izinhlobo Zekholomu Ye-SharePoint Esekelwe

Amakholomu e-SharePoint aziwa kakhulu asekelwa Uhlelo Lokusebenza Lwe-Excel Lokungenisa, okuhlanganisa Umugqa Owodwa Wombhalo, Imigqa Eminingi Yombhalo, Inketho, Inombolo, Idethi nesikhathi, Imali, Abantu noma Iqembu, Ukubheka, Yebo/Cha kanye ne-Hyperlink noma Izithombe. Ungakwazi ukumepha amakholomu e-Excel kulawa makholomu e-SharePoint lapho ungenisa i-Excel file.

Nokho, kwezinye izinhlobo zamakholomu, kunamanye amathiphu okudingeka uwanakekele:

Ukukhetha
Ikholomu yokukhetha iyikholomu ye-SharePoint Online eyakhelwe ngaphakathi enamanani achazwe ngaphambilini, ukuze ungenise amanani kulolu hlobo lwekholomu, udinga ukuhlola futhi uqinisekise ukuthi inani necala kuyafana ku-Excel kanye nohlu.

Ukuze ungenise amanani amaningi kukholomu Yokukhetha, amanani kufanele ahlukaniswe ngokhefana “,”.

Okwesiboneloample, amanani ekholomu Yesigaba kufanele ahlukaniswe ngokuthi “,” njengokulandelayo, ngemva kwalokho angangeniswa ngempumelelo.

Bheka Ikholomu
Ukuze ungenise ivelu kukholomu ye-SharePoint Lookup, kudinga inani libe umbhalo noma inombolo. Kusho ikholomu ekhethiwe kokuthi Kule kholomu kufanele kube umugqa Owodwa wombhalo noma ikholomu Yenombolo.

Uma uhlela ukungenisa amanani amaningi kukholomu Yokukhetha, amanani kufanele ahlukaniswe ngokuthi “;”.

Okwesiboneloample, amanani wekholomu Yezimo Ezihlobene kufanele ahlukaniswe ngokuthi “;” njengokulandelayo, khona-ke zingangeniswa kukholomu yokubheka ngempumelelo.

Umuntu noma Ikholomu Yeqembu
Ukuze ungenise amagama kukholomu Yomuntu We-SharePoint noma Iqembu, igama lomsebenzisi ku-Excel kufanele libe igama lokungena, igama eliboniswayo noma ikheli le-imeyili; uma udinga ukungenisa amanani amaningi kule kholomu, amanani kufanele ahlukaniswe ngokuthi “;”.
Okwesiboneloample, igama eliboniswayo noma ikheli le-imeyili njengoba kukhonjisiwe emfanekisweni ongezansi lingangeniswa ngempumelelo kuKholamu Yomuntu noma Yeqembu.

Isithasiselo 1: Ukuphathwa Kokubhalisa

Ungasebenzisa ukubhalisa kwesilingo sokungenisa Uhlelo lokusebenza lwe-Excel isikhathi esiyizinsuku ezingu-30 kusukela osukwini owasisebenzisa ngalo okokuqala.
Uma isikhathi sokubhalisa kwesilingo siphela, uzodinga ukuthenga okubhaliselwe.
Ukubhaliswa kwe-Excel Ngenisa Uhlelo lokusebenza kusayithi (ngaphambilini ebibizwa ngokuthi “iqoqo lesayithi”) noma isiqashi minyaka yonke.
Ngokubhaliselwe kweqoqo lesayithi, awukho umkhawulo womsebenzisi wokugcina. Bonke abasebenzisi ekuqoqweni kwesayithi bangafinyelela uhlelo lokusebenza.
Ngokubhalisela umqashi, awekho amasayithi noma umkhawulo wokuqoqwa kwesayithi. Bonke abasebenzisi bangafinyelela uhlelo lokusebenza kuwo wonke amasayithi noma amaqoqo esayithi ngaphakathi komqashi oyedwa.

Ihlola Isimo Sokubhalisa

• Uma uvula ibhokisi lengxoxo le-Excel Ngenisa, isimo sokubhalisa sizovezwa phezulu engxoxweni.
  Uma ukubhalisa sekuzophelelwa yisikhathi phakathi kwezinsuku ezingu-30, umlayezo wesaziso uzohlale ubonisa izinsuku ezisele.
• Ukuze ubuyekeze isimo sokubhalisa, sicela ubeke igundane kumlayezo wesaziso bese uchofoza, bese isimo esisha sizolayishwa.
  Uma isimo sokubhalisa singashintshi, sicela usule inqolobane yesiphequluli bese uchofoza futhi.
• Uma isimo sokubhalisa siphendukela kokuthi Ukubhalisa kwakho akuvumelekile njengokulandelayo, kusho ukuthi ukubhalisa kwakho kuphelelwe yisikhathi.
• Sicela usithumele (sales@boostsolutions.com) indawo URL ukuqhubeka nokubhalisa noma ukwenza kabusha.

Ukuthola Iqoqo Lesayithi URL

• Ukuthola indawo (ngaphambilini ebibizwa ngokuthi iqoqo lesayithi) URL, sicela uye ekhasini lamasayithi asebenzayo lesikhungo esisha sokuphatha se-SharePoint.
• Chofoza isayithi ukuze uvule iwindi elinezilungiselelo zesayithi. Kuthebhu ethi Okujwayelekile, chofoza isixhumanisi sokuhlela bese ungathola isayithi URL.Uma isayithi lakho URL izinguquko, sicela usithumelele okusha URL ukuze ubuyekeze ukubhalisa.

Ukuthola I-ID Yomqashi 

• Ukuze uthole i-ID yesiqashi, sicela uqale uye esikhungweni somqondisi we-SharePoint.
• Kusukela esikhungweni sokuphatha se-SharePoint, chofoza isixhumanisi esithi Izici Eziningi ukusuka ekuzuleni kwesokunxele, bese uchofoza inkinobho ethi Vula ngaphansi kwe-Apps.
• Ekhasini elithi Phatha Izinhlelo zokusebenza, chofoza isixhumanisi esithi Izici Eziningi ukusuka ekuzuleni kwesokunxele.
• Bese uchofoza inkinobho ethi Vula ngaphansi kwezimvume zohlelo lokusebenza.
• Ikhasi Lezimvume Zohlelo Lokusebenza libala zonke izinhlelo zokusebenza, okuhlanganisa igama lesibonisi sohlelo lokusebenza nezihlonzi zohlelo lokusebenza. Kukholomu Yesihlonzi Sohlelo Lokusebenza, ingxenye engemva kophawu @ i-ID yakho Yomqashi.
  Sicela usithumele (sales@boostsolutions.com) i-ID yesiqashi ukuze uqhubeke nokubhalisa noma ukuvuselela.
  Noma ungathola i-ID yesiqashi ngengosi ye-Azure.
• Ngena ngemvume kuphothali ye-Azure.
• Khetha i-Azure Active Directory.
• Khetha Izakhiwo.
• Bese, skrolela ezansi kunkambu ye-ID Yomqashi. Ungathola i-ID yesiqashi ebhokisini.

Amadokhumenti / Izinsiza

I-BOOST SOLUTIONS Excel Import App [pdf] Umhlahlandlela Womsebenzisi I-Excel Ngenisa Uhlelo Lokusebenza, Ngenisa Uhlelo Lokusebenza, Ngenisa i-Excel, Ngenisa, Uhlelo Lokusebenza

Izithenjwa

• Imaniwali yosebenzisayo