BOOST SOLUTIONS Excel Ntshuam App

Copyright
Copyright © 2022 Boost Solutions Co., Ltd. All rights reserved.
Tag nrho cov ntaub ntawv uas muaj nyob rau hauv qhov kev tshaj tawm no muaj kev tiv thaiv los ntawm Copyright thiab tsis muaj ib feem ntawm qhov kev tshaj tawm no yuav raug muab luam tawm, hloov kho, tso tawm, khaws cia rau hauv qhov system retrieval, los yog kis nyob rau hauv ib daim ntawv los yog los ntawm kev siv, electronics, mechanical, photocopy, recording los yog lwm yam, yam tsis tau sau ntawv tso cai ua ntej ntawm Boost Solutions.
Peb web qhov chaw: http://www.boostsolutions.com

Taw qhia

SharePoint Excel Ntshuam App tso cai rau cov neeg siv lag luam tuaj yeem xa cov ntawv Excel (.xlsx, .xls, lossis .csv file) rau hauv SharePoint Online daim ntawv teev thiab daim ntawv qhia cov ntaub ntawv teb manually los yog txiav.
Siv Excel Ntshuam App, cov neeg siv tuaj yeem import cov ntaub ntawv rau feem ntau cov khoom tsim hauv SharePoint txhua kab, suav nrog Ib Kab ntawm Cov Ntawv, Ntau Kab ntawm Cov Ntawv, Xaiv, Tus lej, Hnub thiab Sijhawm, Nyiaj, Tib Neeg lossis Pab Pawg, Saib, Yog / Tsis yog thiab Hyperlink lossis Duab.
Cov neeg siv phau ntawv qhia no yog siv los qhia cov neeg siv yuav ua li cas siv cov app no.
Yog xav paub ntxiv txog daim ntawv no thiab lwm cov lus qhia, thov mus saib:
http://www.boostsolutions.com/download-documentation.html

Yuav Siv Excel Import App li cas

Import ib daim ntawv qhia

Txhawm rau import ib daim Spreadsheet, koj yuav tsum muaj yam tsawg kawg Ntxiv Cov Khoom thiab Kho Cov Khoom Tso Cai hauv cov npe lossis yog ib tus tswv cuab ntawm pawg SharePoint Online uas muaj Cov Khoom Ntxiv thiab Kho cov khoom tso cai hauv cov npe.

 

• Nkag mus rau cov npe uas koj xav import ib daim ntawv nthuav qhia rau hauv. ( Nkag mus rau hauv cov ntawv tshwj xeeb, koj tuaj yeem import aspreadsheet rau hauv daim nplaub tshev.)
• Nyem Ntshuam Excel nyob rau sab saum toj ua bar. (Ntshuam Excel yog tsis muaj nyob rau hauv classic SharePoint kev.)
• Hauv Excel Import dialog box, hauv Ntshuam los ntawm Spreadsheet seem, luag Excel file koj npaj siab yuav import rau thaj chaw dotted (los yog nyem Drag thiab poob los yog nyem qhov no los xaiv Excel file xaiv ib qho Excel lossis CSV file).
• Thaum Excel file yog uploaded, cov nplooj ntawv suav nrog yuav tsum tau loaded thiab muaj rau import. Hauv seem Sheet, xaiv ib daim ntawv uas koj xav import.
  Siv Option Hla header kab hauv Excel los txiav txim siab seb puas yuav import thawj kab. Qhov kev xaiv no tau qhib los ntawm lub neej ntawd thiab tuaj yeem ua haujlwm tsis siv neeg yog tias koj tsis muaj cov npe hauv thawj kab lossis yog tias koj tsis xav siv thawj kab ua cov npe teb.
• Hauv kab ntawv kab lus, xaiv kab hauv Excel thiab qhia lawv kom sau kab.
  Los ntawm lub neej ntawd, cov kab nrog tib lub npe yuav raug kos duab thaum twg ib daim ntawv thauj khoom. Tsis tas li ntawd, cov kab uas xav tau yuav raug cim nrog lub hnub qub liab thiab xaiv tau.
• Hauv seem Lim, xaiv cov ntaub ntawv ntau thiab import cov ntaub ntawv koj xav tau. Yog tias koj tsis xaiv qhov kev xaiv no, txhua kab hauv Excel daim ntawv yuav raug xa mus.Yog tias koj xaiv lub checkbox ntawm ib sab ntawm Ntshuam los ntawm [] rau [] kev xaiv, thiab qhia meej cov ntaub ntawv ntau yam xws li los ntawm kab 2 mus rau 8, ces tsuas yog cov kab uas tau teev tseg yuav raug xa mus rau cov npe.
• Hauv seem Kev Xaiv Ntshuam, qhia meej yog tias koj xav hloov kho SharePoint npe siv Excel file.
  Rau thawj zaug ntshuam, nws tsis tas yuav xaiv qhov kev xaiv no.

Tab sis yog tias koj twb tau import cov ntaub ntawv ua ntej, tej zaum koj yuav tau txiav txim siab seb yuav tsum tau ua li cas yog tias duplicates pom thaum importing Excel rau SharePoint.
Ua ntej ua qhov no, koj yuav tsum tau ua kom lub Kos duplicate cov ntaub ntawv thaum importing xaiv.
Cov ntaub ntawv luam tawm tuaj yeem muaj nyob hauv ob daim ntawv SharePoint thiab Excel Sheet. Txhawm rau txheeb xyuas cov ntaub ntawv duplicate, tus yuam sij yuav tsum tau teev tseg los txheeb xyuas cov ntaub ntawv sib npaug.
Ib sab tseem ceeb yog ib qho tshwj xeeb txheeb xyuas cov ntaub ntawv ntawm Excel thiab SharePoint daim ntawv teev npe (zoo li kab ID). Koj tuaj yeem qhia ntau tshaj ib kab ntawv tseem ceeb.

Nco tseg
Tsuas yog cov kab uas tau xaiv nyob rau hauv kab kem Mapping tuaj yeem siv ua kem tseem ceeb.
Cov kab ntawv no tuaj yeem raug teeb tsa ua cov kab tseem ceeb: Ib kab ntawm cov ntawv nyeem, Xaiv, Tus lej, Hnub thiab Sijhawm, txiaj thiab Yog / Tsis yog.

Thaum lub check duplicate cov ntaub ntawv thaum importing kev xaiv yog enabled, muaj ob yam uas yuav ua tau yog hais tias ib tug duplicates pom thaum importing Excel rau sau.

• Hla duplicate cov ntaub ntawv
  Excel Ntshuam App piv qhov tseem ceeb ntawm kab ntawv tseem ceeb hauv Excel thiab SharePoint Online daim ntawv teev npe, yog tias cov txiaj ntsig zoo ib yam ntawm ob sab, cov ntaub ntawv yuav raug txheeb xyuas tias duplicate.
  Cov ntaub ntawv uas tau raug txheeb xyuas tias yog cov ntaub ntawv sib npaug hauv Excel daim ntawv yuav raug hla thaum importing thiab tsuas yog cov ntaub ntawv tshwj xeeb uas tseem tshuav yuav raug xa mus.
• Hloov cov ntaub ntawv duplicate
  Excel Ntshuam App sib piv cov txiaj ntsig ntawm Key kem hauv Excel thiab SharePoint Online daim ntawv teev npe, yog tias cov txiaj ntsig zoo ib yam ntawm ob sab, cov ntaub ntawv yuav raug txheeb xyuas tias duplicate.
  Rau cov ntaub ntawv sib npaug, Excel Import App yuav hloov kho cov ntaub ntawv hauv cov ntaub ntawv sib tshooj hauv SharePoint Online nrog cov ntaub ntawv sib xws hauv Excel spreadsheet. Tom qab ntawd, cov ntaub ntawv seem ntawm daim ntawv nthuav qhia yuav raug suav tias yog cov ntaub ntawv tshiab thiab raug xa tawm raws li.
  Nco tseg
  Yog tias kab ntawv tseem ceeb tsis yog tshwj xeeb hauv Excel lossis cov npe, cov ntaub ntawv sib npaug yuav raug hla.
  Rau example, xav tias koj tau teeb lub Order ID kem ua tus yuam sij:
  Yog tias muaj ntau cov ntaub ntawv hauv Excel nrog tib tus nqi ntawm Order ID kem, cov ntaub ntawv no yuav raug txheeb xyuas tias duplicate thiab hla.
  Yog tias muaj ntau cov ntaub ntawv nrog tib tus nqi ntawm Order ID kem hauv daim ntawv teev npe, cov ntaub ntawv hauv cov npe yuav raug txheeb xyuas tias duplicate thiab hla.
• Thiab ces nias lub khawm Import.
• Tom qab cov txheej txheem importing tiav, koj tuaj yeem pom cov txiaj ntsig tau raws li hauv qab no. Nyem qhov Kaw khawm kom tawm.
• Hauv daim ntawv teev npe, koj yuav pom tias tag nrho cov ntaub ntawv Excel file tau raug coj mus rau hauv cov npe raws li hauv qab no.

Txhawb SharePoint Kem Hom

Cov kab uas nrov tshaj plaws SharePoint tau txais kev txhawb nqa los ntawm Excel Import App, suav nrog Ib Kab ntawm Cov Ntawv, Ntau Kab ntawm Cov Ntawv, Xaiv, Tus lej, Hnub thiab Sijhawm, Nyiaj, Tib Neeg lossis Pab Pawg, Saib, Yog / Tsis yog thiab Hyperlink lossis Duab. Koj tuaj yeem ua daim ntawv qhia Excel kab rau cov kab SharePoint no thaum importing Excel file.

Txawm li cas los xij, rau qee hom kab, muaj qee cov lus qhia koj yuav tsum tau saib xyuas:

Kev xaiv
Xaiv kem yog ib kem ua-nyob rau hauv SharePoint Online nrog predefined qhov tseem ceeb, kom import qhov tseem ceeb rau hauv kab ntawv no, koj yuav tsum tau xyuas thiab xyuas kom meej tias tus nqi thiab cov ntaub ntawv yog tib yam nyob rau hauv Excel thiab daim ntawv teev.

Txhawm rau import ntau qhov tseem ceeb rau hauv kab Xaiv, cov txiaj ntsig yuav tsum tau muab cais los ntawm comma ",".

Rau example, qhov tseem ceeb ntawm Pawg Pawg yuav tsum tau muab cais los ntawm "," raws li hauv qab no, ces lawv tuaj yeem raug xa mus tau zoo.

Saib Kem
Txhawm rau import tus nqi mus rau SharePoint Lookup kem, nws yuav tsum muaj tus nqi yog ntawv lossis tus lej. Nws txhais tau hais tias xaiv kem ntawm Hauv kab ntawv no yuav tsum yog ib kab ntawm cov ntawv nyeem lossis kab zauv.

Yog tias koj npaj yuav import ntau qhov tseem ceeb rau hauv kab Xaiv, cov txiaj ntsig yuav tsum raug cais los ntawm ";".

Rau example, Qhov tseem ceeb ntawm Kab Mob Sib Tham yuav tsum tau muab cais los ntawm ";" raws li hauv qab no, tom qab ntawd lawv tuaj yeem raug xa mus rau kab Lookup tiav.

Tus neeg lossis Pab Pawg
Txhawm rau import cov npe rau tus neeg SharePoint lossis pawg pawg, tus neeg siv lub npe hauv Excel yuav tsum yog lub npe nkag, tso npe lossis email chaw nyob; Yog tias koj xav tau import ntau qhov tseem ceeb rau kab ntawv no, cov txiaj ntsig yuav tsum tau muab cais los ntawm ";".
Rau example, lub npe tso saib lossis email chaw nyob raws li qhia hauv daim duab hauv qab no tuaj yeem ua tiav rau hauv Tus Neeg lossis Pawg Pawg.

Daim Ntawv Ntxiv 1: Kev Tswj Xyuas Kev Sau Npe

Koj tuaj yeem siv Excel Import App sim ua npe rau lub sijhawm 30 hnub txij li hnub koj thawj zaug siv.
Yog hais tias lub sij hawm mus sib hais subscription xaus, koj yuav tau yuav ib tug subscription.
Kev tso npe ntawm Excel Import App yog ib qhov chaw (yav tas los hu ua "site sau") lossis tus neeg xauj tsev txhua xyoo.
Rau qhov chaw sau npe yuav khoom, tsis muaj kev txwv rau cov neeg siv kawg. Txhua tus neeg siv hauv qhov chaw sau tuaj yeem nkag mus rau lub app.
Rau cov neeg xauj tsev, tsis muaj qhov chaw lossis qhov chaw khaws cia txwv. Txhua tus neeg siv tuaj yeem nkag mus rau lub app hauv txhua qhov chaw lossis chaw khaws khoom hauv tib tus neeg xauj tsev.

Txheeb xyuas qhov xwm txheej

• Thaum koj qhib Excel Ntshuam dialog, cov xwm txheej subscription yuav tshwm nyob rau sab saum toj ntawm lub dialog.
  Thaum qhov kev tso npe yuav tas li nyob rau hauv 30 hnub, cov lus ceeb toom yuav nco ntsoov qhia cov hnub sab laug.
• Txhawm rau hloov kho cov xwm txheej subscription, thov tso tus nas rau ntawm cov lus ceeb toom thiab nyem rau nws, ces cov xwm txheej tshiab yuav raug thauj.
  Yog tias qhov xwm txheej tsis hloov pauv, thov tshem lub cache ntawm browser thiab nyem dua.
• Thaum cov xwm txheej hloov pauv mus rau Koj qhov kev tso npe tsis raug raws li hauv qab no, nws txhais tau tias koj qhov kev tso npe tau tas sijhawm.
• Thov xa tuaj rau peb (sales@boostsolutions.com) lub site URL mus ua ib tug subscription lossis txuas ntxiv.

Nrhiav Qhov Chaw Sau URL

• Kom tau txais qhov chaw (yav dhau los hu ua qhov chaw sau) URL, thov mus rau nplooj ntawv nquag ntawm SharePoint admin chaw tshiab.
• Nyem rau ntawm qhov chaw qhib lub qhov rais nrog qhov chaw teeb tsa. Hauv General tab, nyem Kho kom raug txuas thiab tom qab ntawd koj tuaj yeem tau txais lub xaib URL.Yog koj qhov chaw URL hloov, thov xa peb cov tshiab URL hloov tshiab subscription.

Nrhiav tus neeg xauj tsev ID 

• Txhawm rau kom tau txais tus ID nkag mus, thov ua ntej mus rau SharePoint admin chaw.
• Los ntawm SharePoint admin chaw, nyem rau ntawm Ntxiv nta txuas los ntawm sab laug navigation, thiab tom qab ntawd nyem rau ntawm pob Qhib hauv qab Apps.
• Hauv Manage Apps nplooj ntawv, nyem rau ntawm Ntxiv nta txuas los ntawm sab laug navigation.
• Thiab tom qab ntawd nyem rau ntawm pob Qhib hauv qab App tso cai.
• Nplooj Ntawv Tso Cai App teev tag nrho cov apps, suav nrog cov app tso saib lub npe thiab cov cim app. Hauv kab App Identifier, ib feem tom qab lub cim @ yog koj tus Tenant ID.
  Thov xa tuaj rau peb (sales@boostsolutions.com) tus neeg xauj tsev ID txhawm rau ua qhov kev tso npe lossis rov ua dua tshiab.
  Lossis koj tuaj yeem nrhiav tus neeg xauj tsev ID los ntawm Azure portal.
• Nkag mus rau Azure portal.
• Xaiv Azure Active Directory.
• Xaiv Cov Khoom.
• Tom qab ntawd, nqes mus rau qhov chaw Tenant ID. Koj tuaj yeem pom tus neeg xauj tsev ID hauv lub thawv.

Cov ntaub ntawv / Cov ntaub ntawv

BOOST SOLUTIONS Excel Ntshuam App [ua pdf] Cov neeg siv phau ntawv qhia Excel Import App, Ntshuam App, Excel Ntshuam, Ntshuam, App

Cov ntaub ntawv

• Cov neeg siv phau ntawv