Ntlafatsa litharollo tsa Excel Import App

Copyright
Copyright © 2022 Boost Solutions Co., Ltd. Litokelo tsohle li sirelelitsoe.
Lisebelisuoa tsohle tse hlahang khatisong ena li sirelelitsoe ke Copyright 'me ha ho karolo ea khatiso ena e ka hlahisoang, ho fetoloa, ho hlahisoa, ho bolokoa ka mokhoa ofe kapa ofe kapa ka mokhoa ofe kapa ofe, oa elektroniki, oa mochini, oa ho kopitsoa, ​​oa rekotoa kapa o mong, ntle le tumello e ngotsoeng pele ea Boost Solutions.
Ea rona web sebaka: http://www.boostsolutions.com

Selelekela

SharePoint Excel Import App e dumella basebedisi ba kgwebo ho reka kantle ho Excel spreadsheet (.xlsx, .xls, kapa .csv file) lethathamong la SharePoint Online le masimong a data a 'mapa ka letsoho kapa ka boiketsetso.
U sebelisa Excel Import App, basebelisi ba ka kenya data ho mefuta e mengata e hahelletsoeng ka har'a likholomo tsa SharePoint, ho kenyeletsoa Mola o le Mong oa Sengoloa, Mela e Mengata ea Sengoloa, Khetho, Nomoro, Letsatsi le Nako, Chelete, Batho kapa Sehlopha, Lookup, E / Che le Hyperlink kapa Litšoantšo.
Bukana ena ea mosebelisi e sebelisoa ho ruta mosebelisi mokhoa oa ho sebelisa sesebelisoa sena.
Bakeng sa likopi tsa morao-rao tsa tataiso ena le tse ling, ka kopo etela:
http://www.boostsolutions.com/download-documentation.html

Mokhoa oa ho sebelisa Excel Import App

Kenya Spreadsheet

Ho kenya Spreadsheet, bonyane u tlameha ho ba le tumello ea ho Eketsa Lintho le ho Fetola Lintho lethathamong kapa u be setho sa sehlopha sa SharePoint Online se nang le tumello ea ho Eketsa Lintho le ho Fetola Lintho lethathamong.

 

• Kenya lenane leo u batlang ho kenya spreadsheet ho lona. (Kena sephutheli se ikhethileng, u ka kenya li-spreadsheet foldareng.)
• Tobetsa Import Excel bareng ea ketso e holimo. (Import Excel ha e fumanehe boiphihlelong ba khale ba SharePoint.)
• Ka har'a lebokose la puisano la Excel Import, ho Import ho tsoa karolong ea Spreadsheet, hula Excel file o ikemiseditse ho tlisa sebakeng sa matheba (kapa tobetsa Hula o dihe kapa o tobetse mona ho kgetha Excel file ho khetha Excel kapa CSV file).
• Ka lekhetlo le leng Excel file e kentsoe, maqephe a kenyellelitsoeng a tla kengoa 'me a fumanehe bakeng sa ho tsoa kantle ho naha. Karolong ea Sheet, khetha leqephe leo u batlang ho le kenya.
  Sebelisa Mola oa sehlooho oa Option Skip ho Excel ho etsa qeto ea hore na o tla kenya mola oa pele kapa che. Khetho ena e nolofalitsoe ka ho sa feleng 'me e ka holofatsoa ka letsoho haeba u se na litlotla tsa tšimo moleng oa pele kapa ha u sa batle ho sebelisa mola oa pele joalo ka lihlooho tsa masimo.
• Karolong ea 'Mapa oa Kholomo, khetha likholomo ho Excel ebe u li etsa 'mapa ho thathamisa likholomo.
  Ka linako tsohle, litšiea tse nang le lebitso le tšoanang li tla etsoa 'mapa ka bo eona neng kapa neng ha leqephe le kentsoe. Ho feta moo, litšiea tse hlokahalang li tla tšoauoa ka naleli e khubelu ebe li khethoa ka bohona.
• Karolong ea Filter, khetha mofuta oa data ebe o kenya data eo o e hlokang. Haeba u sa khethe khetho ena, mela eohle e leqepheng la Excel e tla tlisoa kantle ho naha.Haeba u khetha lebokose la ho hlahloba le haufi le Lata ho tloha ho [] ho ea ho [] khetho, 'me u hlalose lethathamo la data ho tloha moleng oa 2 ho isa ho oa 8, ho tla romelloa feela mela e boletsoeng lethathamong.
• Karolong ea Likhetho tsa ho Kenya, bolela hore na u batla ho nchafatsa lenane la SharePoint u sebelisa Excel file.
  Bakeng sa ho reka ka lekhetlo la pele, ha ho hlokahale ho khetha khetho ena.

Empa haeba u se u kile oa kenya data ka ntle ho naha, u ka 'na ua hloka ho etsa qeto ea hore na u lokela ho nka khato efe haeba ho fumanoa likopi ha u kenya Excel ho SharePoint.
Pele o etsa sena, o hloka ho nolofalletsa khetho ea Check duplicate ha o kenya khetho.
Lirekoto tse kopitsoang li ka ba teng lethathamong la SharePoint le Excel Sheet. Bakeng sa ho hlahloba lirekoto tse kopitsoang, ho tlameha ho behiloe senotlolo ho tsebahatsa lirekoto tse kopitsoang.
Kholomo ea bohlokoa ke e khethollang ka mokhoa o ikhethileng lirekoto lipakeng tsa lenane la Excel le SharePoint (joalo ka kholomo ea ID). O ka hlakisa likholomo tsa linotlolo tse fetang bonngoe.

Hlokomela
Ke litšiea tse khethiloeng karolong ea 'Mapa ea Kholomo feela tse ka sebelisoang e le kholomo ea bohlokoa.
Likholomo tsena li ka hlophisoa e le likholomo tsa Bohlokoa: Mola o le mong oa mongolo, Khetho, Nomoro, Letsatsi le Nako, Chelete le E/Che.

Hang ha "Check duplicate records" ha khetho ea ho kenya e nolofalitsoe, ho na le mehato e 'meli e ka etsoang haeba ho na le tse ling tse kopitsoang ha u kenya Excel ho thathamisa.

• Tlola lirekoto tse kopitsoang
  Excel Import App e bapisa boleng ba kholomo ea bohlokoa lethathamong la Excel le SharePoint Online, haeba boleng bo tšoana ka mahlakoreng ka bobeli, lirekoto li tla tsejoa e le tse kopitsoang.
  Lintlha tse hloailoeng e le lirekoto tse kopitsoang ka har'a spreadsheet ea Excel li tla tloloa ha li rekoa, 'me ho tla romelloa lirekoto tse ikhethang feela tse setseng.
• Ntlafatsa lirekoto tse kopitsoang
  Excel Import App e bapisa boleng ba kholomo ea Key lethathamong la Excel le SharePoint Online, haeba boleng bo tšoana ka mahlakoreng ka bobeli, lirekoto li tla tsejoa e le tse kopitsoang.
  Bakeng sa lirekoto tse kopitsoang, Excel Import App e tla nchafatsa tlhahisoleseling lirekotong tse kopitsoang lenaneng la SharePoint Online ka tlhaiso-leseling e tsamaellanang le spreadsheet ea Excel. Joale, data e setseng ea spreadsheet e tla nkoa e le litlaleho tse ncha 'me e romelloe ka ntle ho naha.
  Hlokomela
  Haeba kholomo ea bohlokoa e sa ikhetha ho Excel kapa lethathamong, lirekoto tse peli li tla tloloa.
  Bakeng sa mohlalaample, ho nahanoa hore u behile kholomo ea ID ea Order joalo ka senotlolo:
  Haeba ho na le lirekoto tse ngata ho Excel tse nang le boleng bo lekanang ba kholomo ea ID ea Taelo, lirekoto tsena li tla khetholloa e le tse kopitsoang ebe lia tloloa.
  Haeba ho na le lirekoto tse ngata tse nang le boleng bo lekanang ba kholomo ea ID ea Taelo lethathamong, lirekoto tse lethathamong li tla khetholloa e le tse kopitsoang ebe li tloloa.
• Ebe o tobetsa konopo ea Import.
• Ka mor'a hore mokhoa oa ho reka o felile, o ka bona liphetho tsa ho reka ka tsela e latelang. Tobetsa konopo ea Koala ho tsoa.
• Lethathamong, u tla fumana hore lirekoto tsohle tsa Excel file li tlisitsoe ka ntle lethathamong ka tsela e latelang.

Mefuta e Tšehetsoeng ea Kholomo ea SharePoint

Likholomo tse tsebahalang haholo tsa SharePoint li tšehetsoa ke Excel Import App, ho kenyeletsoa Mola o le Mong oa Mongolo, Mela e Mengata ea Mongolo, Khetho, Nomoro, Letsatsi le Nako, Chelete, Batho kapa Sehlopha, Lookup, E/Che le Hyperlink kapa Litšoantšo. U ka etsa 'mapa likholomo tsa Excel ho likholomo tsena tsa SharePoint ha u kenya Excel file.

Leha ho le joalo, bakeng sa mefuta e meng ea likholomo, ho na le malebela ao u hlokang ho a hlokomela:

Khetho
Kholomo ea khetho ke kholomo ea SharePoint Online e nang le litekanyetso tse boletsoeng esale pele, ho kenya boleng mofuteng ona oa kholomo, o hloka ho hlahloba le ho netefatsa hore boleng le nyeoe li tšoana ho Excel le lenane.

Ho kenya litekanyetso tse ngata ka har'a kholomo ea Khetho, litekanyetso li lokela ho aroloa ka comma ",".

Bakeng sa mohlalaample, boleng ba Sehlopha sa kholomo se tlameha ho aroloa ka "," joalo ka se latelang, ebe se ka romelloa kantle ho naha ka katleho.

Lethathamo la Kholomo
Ho kenya boleng ho kholomo ea SharePoint Lookup, ho hloka boleng hore e be mongolo kapa nomoro. Ho bolela kholomo e khethiloeng ea Kholomong ena e lokela ho ba mola o le Mong oa mongolo kapa kholomo ea Palo.

Haeba u rera ho kenya litekanyetso tse ngata ka har'a kholomo ea Khetho, litekanyetso li lokela ho aroloa ka ";".

Bakeng sa mohlalaample, boleng ba kholomo ea Maemo a Amanang e tlameha ho aroloa ka ";" joalo ka tse latelang, joale li ka romelloa ho kholumo ea Lookup ka katleho.

Motho kapa Sehlopha sa Sehlopha
Ho kenya mabitso ho Kholomo ea Motho kapa Sehlopha sa SharePoint, lebitso la mosebelisi ho Excel e lokela ho ba lebitso la ho kena, lebitso le bonts'ang kapa aterese ea lengolo-tsoibila; haeba o hloka ho kenya litekanyetso tse ngata kholomong ena, litekanyetso li lokela ho aroloa ka ";".
Bakeng sa mohlalaample, lebitso la pontšo kapa aterese ea lengolo-tsoibila joalokaha ho bontšitsoe setšoantšong se ka tlase e ka romelloa ka katleho ho Motho kapa Sehlopha sa Sehlopha.

Sehlomathiso sa 1: Tsamaiso ea Lipeeletso

U ka sebelisa peeletso ea teko ea Excel Import App ka nako ea matsatsi a 30 ho tloha ka letsatsi leo u e sebelisang ka lekhetlo la pele.
Haeba nako ea tekolo e fela, o tla hloka ho reka peeletso.
Ngoliso ea Excel Import App ke sebaka se seng le se seng (seo pele se neng se bitsoa "pokello ea sebaka") kapa mohiri selemo le selemo.
Bakeng sa ngoliso ea pokello ea sebaka, ha ho na moeli oa basebelisi ba ho qetela. Basebelisi bohle ba pokellong ea sebaka sa marang-rang ba ka fumana sesebelisoa.
Bakeng sa ngoliso ea mohiri, ha ho na libaka kapa moeli oa pokello ea sebaka. Basebelisi bohle ba ka fihlella sesebelisoa libakeng tsohle kapa pokellong ea libaka ka har'a mohiri a le mong.

E hlahloba Boemo ba Ngoliso

• Ha o bula puisano ea Excel Import, boemo ba peeletso bo tla bonts'oa kaholimo ho lebokose.
  Ha peeletso e le haufi le ho felloa ke nako nakong ea matsatsi a 30, molaetsa oa tsebiso o tla lula o bonts'a matsatsi a setseng.
• Ho nchafatsa boemo ba ngoliso, ka kopo, beha mouse molaetseng oa tsebiso ebe u e tobetsa, ebe boemo bo bocha bo tla kengoa.
  Haeba boemo ba peeletso bo sa fetohe, ka kopo hlakola cache ea sebatli ebe o tobetsa hape.
• Hang ha boemo ba peeletso bo fetohela ho phaliso ea hau e fosahetse joalo ka e latelang, ho bolela hore peeletso ea hau e felile.
• Ka kopo, re romelle (sales@boostsolutions.com) sebaka URL ho ntshetsa pele peeletso kapa ntjhafatso.

Ho Fumana Pokello ea Sebaka URL

• Ho fumana sebaka (seo pele se neng se bitsoa pokello ea sebaka) URL, ka kopo, e-ea leqepheng la Liwebsaete tse sebetsang la setsi se secha sa tsamaiso ea SharePoint.
• Tobetsa sebaka seo ho bula fensetere e nang le litlhophiso tsa sebaka. Ho General tab, tobetsa sehokelo sa Edita ebe o ka fumana sebaka sa marang-rang URL.Haeba sebaka sa hau URL liphetoho, ka kopo re romelle tse ncha URL ho nchafatsa peeletso.

Ho fumana ID ea Mohiri 

• Ho fumana ID ea mohiri, ka kopo qala ka ho ea setsing sa batsamaisi ba SharePoint.
• Ho tsoa setsing sa admin sa SharePoint, tlanya ho Likarolo tse ling sehokelo ho tloha ka letsohong le letšehali, ebe u tobetsa konopo ea Bula tlasa Lisebelisoa.
• Leqepheng la Laola Lisebelisoa, tobetsa sehokelo sa Mehato e meng ho tsoa leqeleng le letšehali.
• Ebe o tobetsa konopo ea Open tlas'a tumello ea App.
• Leqephe la Litumello tsa App le thathamisa lits'ebetso tsohle, ho kenyeletsoa lebitso la pontšo ea app le li-ID tsa li-app. Khomong ea Identifier ea App, karolo e ka morao ho letšoao la @ ke ID ea hau ea Mohiri.
  Ka kopo, re romelle (sales@boostsolutions.com) ID ea mohiri ho ntšetsa pele peeletso kapa nchafatso.
  Kapa o ka fumana ID ea mohiri ka portal ea Azure.
• Kena ho portal ea Azure.
• Khetha Azure Active Directory.
• Khetha Properties.
• Ebe, tsamaisetsa tlase sebakeng sa ID sa Tenant. U ka fumana ID ea mohiri ka lebokoseng.

Litokomane / Lisebelisoa

Ntlafatsa litharollo tsa Excel Import App [pdf] Bukana ea Mosebelisi Excel Import App, Import App, Excel Import, Import, App

Litšupiso

• Bukana ea Mosebelisi