BOOST SOLUTIONS Excel Import App

Ufulu
Ufulu © 2022 Boost Solutions Co., Ltd. Ufulu wonse ndi wotetezedwa.
Zida zonse zomwe zili m'bukuli ndizotetezedwa ndi Copyright ndipo palibe gawo lililonse la bukhuli lomwe lingasindikizidwe, kusinthidwa, kuwonetsedwa, kusungidwa m'makina otengera, kapena kufalitsidwa mwanjira ina iliyonse kapena mwanjira ina iliyonse, pakompyuta, pamakina, kujambula, kujambula kapena mwanjira ina iliyonse, popanda chilolezo cholembedwa cha Boost Solutions.
Zathu web tsamba: http://www.boostsolutions.com

Mawu Oyamba

SharePoint Excel Import App imalola ogwiritsa ntchito mabizinesi kulowetsa spreadsheet (.xlsx, .xls, kapena .csv) file) mumndandanda wa SharePoint Online ndi mapu a data pamanja kapena zokha.
Pogwiritsa ntchito Excel Import App, ogwiritsa ntchito amatha kulowetsa zidziwitso kumitundu yambiri ya SharePoint, kuphatikiza Mzere Umodzi wa Mawu, Mizere Yambiri, Chosankha, Nambala, Tsiku ndi Nthawi, Ndalama, Anthu kapena Gulu, Kufufuza, Inde/Ayi ndi Hyperlink kapena Zithunzi.
Bukuli limagwiritsidwa ntchito polangiza ogwiritsa ntchito momwe angagwiritsire ntchito pulogalamuyi.
Kuti mudziwe zambiri za izi ndi maupangiri ena, chonde pitani:
http://www.boostsolutions.com/download-documentation.html

Momwe mungagwiritsire ntchito Excel Import App

Lowetsani Spreadsheet

Kuti mulowetse Spreadsheet, muyenera kukhala ndi zilolezo zosachepera Onjezani Zinthu ndi Kusintha Zinthu pamndandanda kapena kukhala membala wagulu la SharePoint Online lomwe lili ndi zilolezo za Onjezani Zinthu ndi Kusintha Zinthu pamndandanda.

 

• Lowetsani mndandanda womwe mukufuna kulowetsamo spreadsheet. (Lowetsani chikwatucho, mutha kulowetsa asspreadsheet kufoda.)
• Dinani Import Excel mu bar yochitapo kanthu. (Import Excel sichikupezeka muzochitikira zakale za SharePoint.)
• Mu bokosi la dialog la Excel Import, mu Import kuchokera kugawo la Spreadsheet, kokerani Excel file mukufuna kulowetsa ku bokosi la madontho (kapena dinani Kokani ndi kuponya kapena dinani apa kuti musankhe Excel file kusankha Excel kapena CSV file).
• Pambuyo pa Excel file ikakwezedwa, mapepala omwe akuphatikizidwa adzakwezedwa ndikupezeka kuti alowe. Mugawo la Mapepala, sankhani pepala limene mukufuna kuitanitsa.
  Gwiritsani ntchito mzere wamutu wa Option Skip mu Excel kuti musankhe kulowetsa mzere woyamba kapena ayi. Njirayi imayatsidwa mwachisawawa ndipo imatha kuyimitsidwa pamanja ngati mulibe maudindo pamzere woyamba kapena ngati simukufuna kugwiritsa ntchito mzere woyamba ngati mitu yam'munda.
• M'gawo la Mapu a Column, sankhani mizati mu Excel ndikuwayika kuti mulembe mizati.
  Mwachisawawa, mizati yokhala ndi dzina lomwelo idzajambulidwa yokha pamene pepala lidayikidwa. Kuphatikiza apo, mizati yofunikira idzalembedwa ndi nyenyezi yofiira ndikusankhidwa yokha.
• Mugawo la Zosefera, sankhani mtundu wa data ndikulowetsa zomwe mukufuna. Ngati simusankha izi, mizere yonse papepala la Excel idzatumizidwa kunja.Ngati musankha bokosi loyang'ana pafupi ndi Tengani kuchokera ku [] kupita ku [] njira, ndi kutchula mndandanda wa deta monga kuyambira mzere wa 2 mpaka 8, ndiye kuti mizere yodziwika yokha idzatumizidwa ku mndandanda.
• Mugawo la Import Options, tchulani ngati mukufuna kusintha mndandanda wa SharePoint pogwiritsa ntchito Excel file.
  Kuti mulowetse koyamba, sikofunikira kusankha njira iyi.

Koma ngati mudatumizapo kale deta, mungafunike kusankha zomwe muyenera kuchita ngati zobwereza zitapezeka potumiza Excel ku SharePoint.
Musanachite izi, muyenera kuyatsa Chongani zolemba zobwereza poitanitsa njira.
Zolemba zobwereza zitha kupezeka pamndandanda wa SharePoint ndi Excel Sheet. Kuti muwone ma rekodi obwereza, Key ikuyenera kufotokozedwa kuti muzindikire zobwereza.
Mzere wofunikira ndi womwe umazindikiritsa mwapadera zolemba pakati pa Excel ndi SharePoint mndandanda (monga ndime ya ID). Mutha kutchula makiyi angapo.

Zindikirani
Mizati yokhayo yomwe yasankhidwa mu gawo la Mapu a Mzere ndi yomwe ingagwiritsidwe ntchito ngati gawo lalikulu.
Mizati iyi ikhoza kukhazikitsidwa ngati mizati yofunika: Mzere umodzi wa mawu, Chosankha, Nambala, Tsiku ndi Nthawi, Ndalama ndi Inde/Ayi.

Mukangotsegula Chongani mbiri yobwereketsa ikayatsidwa, pali zinthu ziwiri zomwe zingachitike ngati zobwerezedwa zilizonse zikapezeka pakulowetsa Excel kuti mulembe.

• Dumphani zolemba zobwereza
  Excel Import App ikufanizira milingo yayikulu mu Excel ndi SharePoint Online list, ngati mikhalidwe ili yofanana mbali zonse ziwiri, zolembedwazo zizidziwika ngati zobwereza.
  Deta yomwe yadziwika kuti ndi mbiri yobwereza mu Excel spreadsheet idzalumphidwa potumiza kunja ndipo ma rekodi apadera omwe atsala ndi omwe atumizidwa kunja.
• Sinthani zolemba zobwereza
  Excel Import App ikufanizira mindandanda yazachidule mu Excel ndi SharePoint Online list, ngati mikhalidwe ili yofanana mbali zonse ziwiri, zolembedwazo zizidziwika ngati zobwereza.
  Pazolemba zobwereza, Excel Import App isintha zambiri muzolemba zomwe zili pamndandanda wa SharePoint Online ndi zidziwitso zofananira mu Excel spreadsheet. Kenako, deta yotsala ya spreadsheet idzatengedwa ngati zolemba zatsopano ndikutumizidwa moyenerera.
  Zindikirani
  Ngati gawo lofunikira silili lapadera mu Excel kapena mndandanda, zolemba zobwereza zidzadumphidwa.
  Za example, mukuganiza kuti mwakhazikitsa gawo la ID ya Order ngati kiyi:
  Ngati pali ma rekodi angapo mu Excel okhala ndi mtengo wofanana wa ID ya Order, zolemba izi zitha kudziwika ngati zobwerezedwa ndikudumphidwa.
  Ngati pali ma rekodi angapo okhala ndi mtengo wofanana wa ID ya Order pamndandanda, zolemba zomwe zili pamndandandawu zizindikirika ngati zobwerezedwa ndikudumphidwa.
• Kenako dinani batani la Import.
• Pambuyo kuitanitsa ndondomeko yatha, mukhoza kuona zotsatira monga zotsatirazi. Dinani Tsekani batani kuti mutuluke.
• Pamndandanda, mupeza kuti zolemba zonse za Excel file zalowetsedwa mumndandanda motere.

Mitundu Yothandizira ya SharePoint Column

Mizati yotchuka kwambiri ya SharePoint imathandizidwa ndi Excel Import App, kuphatikiza Mzere Umodzi wa Mawu, Mizere Yambiri, Chosankha, Nambala, Tsiku ndi Nthawi, Ndalama, Anthu kapena Gulu, Kufufuza, Inde/Ayi ndi Hyperlink kapena Zithunzi. Mutha kupanga mapu a Excel kumagulu awa a SharePoint mukalowetsa Excel file.

Komabe, pamitundu ina yamzanja, pali malangizo omwe muyenera kuwasamalira:

Kusankha
Chosankha ndi gawo lokhazikika la SharePoint Online lomwe lili ndi zikhalidwe zofotokozedweratu, kuti mulowetse zikhalidwe mumtundu uwu, muyenera kuyang'ana ndikuwonetsetsa kuti mtengo wake ndi wofanana mu Excel ndi mndandanda.

Kuti mulowetse ma values ​​angapo mugawo la Chosankha, miyeso iyenera kulekanitsidwa ndi koma ",".

Za example, ma values ​​a Category column ayenera kulekanitsidwa ndi "," motsatira, ndiye akhoza kutumizidwa kunja bwino.

Tsamba Loyang'ana
Kuti mulowetse mtengo kugawo la SharePoint Lookup, pamafunika mtengo kukhala malemba kapena nambala. Zikutanthauza kuti gawo losankhidwa la Mugawoli liyenera kukhala mzere umodzi wamawu kapena Nambala.

Ngati mukufuna kuitanitsa zinthu zingapo mugawo la Choice, mfundozo ziyenera kulekanitsidwa ndi ";".

Za example, zikhulupiriro za Nkhani Zogwirizana nazo ziyenera kulekanitsidwa ndi ";" monga zotsatirazi, ndiye akhoza kutumizidwa ku gawo la Lookup bwinobwino.

Munthu kapena Gulu
Kutumiza mayina ku SharePoint Person kapena Gulu la Gulu, dzina la wogwiritsa ntchito ku Excel liyenera kukhala dzina lolowera, dzina lowonetsera kapena imelo adilesi; ngati mukufuna kulowetsamo zinthu zingapo pamndandandawu, zikhalidwe ziyenera kulekanitsidwa ndi ";".
Za example, dzina lowonetsera kapena imelo adilesi monga momwe zasonyezedwera pachithunzi pansipa zitha kutumizidwa bwino mu Gulu la Munthu kapena Gulu.

Zowonjezera 1: Kuwongolera Kulembetsa

Mutha kugwiritsa ntchito kulembetsa kwa Excel Import App kwa masiku 30 kuyambira tsiku lomwe mudaigwiritsa ntchito koyamba.
Ngati nthawi yolembetsa yoyeserera itha, muyenera kugula zolembetsa.
Kulembetsa kwa Excel Import App kumachitika patsamba lililonse (lomwe kale linkatchedwa "tototolekiti") kapena wobwereka pachaka.
Polembetsa kusonkhanitsa malo, palibe malire a ogwiritsa ntchito. Ogwiritsa ntchito onse omwe ali pamasamba atha kugwiritsa ntchito pulogalamuyi.
Pakulembetsa kwa lendi, palibe masamba kapena zoletsa zosonkhanitsira masamba. Ogwiritsa ntchito onse atha kugwiritsa ntchito pulogalamuyi m'mawebusayiti onse kapena zosonkhanitsidwa zamtundu womwewo.

Kuyang'ana Mkhalidwe Wolembetsa

• Mukatsegula kukambirana kwa Excel Import, zolembetsa zidzawonetsedwa pamwamba pa dialog.
  Kulembetsa kukatsala pang'ono kutha mkati mwa masiku 30, uthenga wachidziwitso umawonetsa masiku omwe atsala.
• Kuti musinthe mawonekedwe olembetsa, chonde ikani mbewa pa uthenga wachidziwitso ndikudina, kenako mawonekedwe atsopano adzakwezedwa.
  Ngati kulembetsa sikusintha, chonde chotsani cache ya osatsegula ndikudinanso.
• Kulembetsa kwanu kukatembenukira ku Kulembetsa kwanu kumakhala kolakwika monga motsatira, zikutanthauza kuti kulembetsa kwanu kwatha.
• Chonde titumizireni (sales@boostsolutions.com) tsamba URL kuti mupitirize kulembetsa kapena kukonzanso.

Kupeza Zosonkhanitsira Tsamba URL

• Kuti mupeze tsamba (lomwe limadziwika kale kuti kusonkhanitsa tsamba) URL, chonde pitani ku tsamba la Active Sites la malo olamulira a SharePoint.
• Dinani patsamba kuti mutsegule zenera lokhala ndi makonda atsamba. Pa General tabu, dinani Sinthani ulalo ndiye mutha kupeza tsambalo URL.Ngati tsamba lanu URL zosintha, chonde titumizireni zatsopano URL kukonzanso zolembetsa.

Kupeza ID ya Tenant 

• Kuti mupeze ID ya lendi, chonde pitani ku malo olamulira a SharePoint.
• Kuchokera pagawo loyang'anira la SharePoint, dinani ulalo wa Zowonjezera Zambiri kuchokera kumanzere kumanzere, kenako dinani Tsegulani batani pansi pa Mapulogalamu.
• Patsamba la Sinthani Mapulogalamu, dinani ulalo wa Zowonjezera Zambiri kuchokera kumanzere kumanzere.
• Kenako dinani batani Tsegulani pansi pa zilolezo za App.
• Tsamba la Zilolezo pa App lili ndi mndandanda wa mapulogalamu onse, kuphatikizapo dzina la pulogalamuyo ndi zozindikiritsa mapulogalamu. Mugawo la App Identifier, gawo pambuyo pa @ chizindikiro ndi ID yanu ya Tenant.
  Chonde titumizireni (sales@boostsolutions.com) ID ya lendi kuti mupitirize kulembetsa kapena kukonzanso.
  Kapena mutha kupeza ID yobwereka kudzera pa portal ya Azure.
• Lowani ku portal ya Azure.
• Sankhani Azure Active Directory.
• Sankhani Properties.
• Kenako, yendani pansi kumunda wa ID ya Tenant. Mutha kupeza ID ya lendi m'bokosi.

Zolemba / Zothandizira

BOOST SOLUTIONS Excel Import App [pdf] Buku Logwiritsa Ntchito Excel Import App, Import App, Excel Import, Import, App

Maumboni

• Buku Logwiritsa Ntchito