Sawubona wonke umntu!
Igama lam ndinguMasha, ndisebenza njengenjineli yokuqinisekisa umgangatho kwiqela lenkampani laseTinkoff. Umsebenzi we-QA ubandakanya unxibelelwano oluninzi nabantu abohlukeneyo abavela kumaqela ahlukeneyo, kwaye ndandikwangumphathi kunye nomhlohli weenkqubo zemfundo, ngoko ke imephu yam yonxibelelwano yayibanzi kangangoko. Kwaye ngexesha elithile ndaqhuma: ndaqonda ukuba andinako, andinako, andinako ukuzalisa iitoni zesihogo zeetafile ezingenakufundeka kunye namaxwebhu.
Ngokuqinisekileyo ngamnye wenu ngoku ukhe wayicinga le nto ndithetha ngayo kwaye wagqabhuka ngokubila okubandayo: uluhlu lweefani ngaphandle kolandelelwano lwealfabhethi, iitheyibhile ezinamakhulukhulu eekholamu ezinobume obugoso, iitafile ezinamawaka emigca apho kufuneka usule umnwe wakho. kwivili lemouse ukujonga iheader, iitoni zamaphepha emiyalelo engenamanani, amakhulu oonobumba abathunyelwe omnye komnye ngedata efuna ukucazululwa kwaye icwangciswe kwaye ihlohlwe kwiitafile ezingafundeki ngokulinganayo.
Kwaye ke, xa ndiphole kancinci, ndagqiba ekubeni ndibhale eli nqaku. Ndiza kuthetha ngendlela onokuthi ngayo ngesiqhelo (nangona ngamanye amaxesha kube lula) ukugcina amaxwebhu ahlukeneyo angeyomveliso. Ndiyathemba ukuba inqaku liya kusasazeka kwi-Intanethi kwaye inqanaba lesihogo kumasebe akufutshane nophuhliso liya kuncipha ubuncinci, kwaye abantu (kubandakanywa nam) baya kuba nolonwabo ngakumbi.
Zixhobo
Amaxwebhu emveliso ahlala egcinwe ecaleni kwekhowudi, into enhle. Kwaye amaxwebhu angeyomveliso ahlala egcinwa naphi na. Abantu bahlala bezama ukususa ulwazi ukusuka kwiindawo ezahlukeneyo ukuya kwiNgqungquthela, kwaye nathi asinjalo. Ngoko ke lonke ibali lithetha ngaye.
Ngokubanzi, i-Confluence yinjini ye-wiki ephambili. Ikuvumela ukuba usebenze ngedatha kwiintlobo ezahlukeneyo zokubonisa: isicatshulwa ngokufomatha, iitafile, iitshathi ezahlukeneyo. Esi sixhobo esinomdla kakhulu kwaye sinamandla, kodwa ukuba awukwazi ukusilungiselela, ngoko uya kugqiba enye inkunkuma yamaxwebhu angafundekiyo. Ndiza kukufundisa ukupheka!
IiMacros
Phantse yonke imilingo yeConfluence ivela kwiimacros. Zininzi iimacros, kwaye zinokudityaniswa kunye. Bangahlawulwa okanye basimahla; ngezantsi kuya kubakho imizekelo eyahlukeneyo yeemacros ezinamakhonkco kumaxwebhu kubo.
Ujongano lokusebenza ngeemacros lulula kangangoko. Ukongeza i-macro, kufuneka ucofe kwi-plus kwaye ukhethe into oyifunayo kuluhlu.
Ukuba i-macro izimele, oko kukuthi, ayifuni ukufaka enye into ngaphakathi kwayo, ibonakala ngathi ibhloko.
Ukuba i-macro ifuna into efakwe ngaphakathi kuyo ukuze isebenze, ibonakala njengesakhelo.
Kwangaxeshanye, ungabeka abanye abaninzi njengoko uthanda ngaphakathi kwisakhelo esinye, ukuba nje kukho ingqiqo kwiphiramidi yakho.
Imakhro nganye inomboniso wangaphambili: ibonisa ngoko nangoko ukuba uzalise kwaye uqwalasele i-macro ngokuchanekileyo.
Iipateni
Ukongeza kwi-macros, kukho isixhobo esifanelekileyo sokuzalisa umxholo wangaphambili - itemplate.
Iitemplates zingasetyenziswa xa udala naliphi na iphepha: nqakraza nje amachaphaza amathathu ecaleni kweqhosha elithi "Yenza" kwaye ukhethe itemplate oyifunayo.
Emva koko wonke umxholo okwi-template uya kongezwa kwiphepha elenziwe.
Nabani na angenza amaphepha ukusuka kwiitemplates, kodwa kuphela abo banamalungelo okudala okanye ukuhlela iitemplates ngokwabo banokwenza njalo. Unokongeza imiyalelo eyongezelelweyo kwithemplate malunga nokuba iphepha kufuneka ligcinwe njani.
Umlingo weetafile
Ngokwenyani, njenge-techie, ndizithanda kakhulu iitafile kwaye ndiyakwazi ukusonga phantse naluphi na ulwazi kuzo (nangona oku kungasoloko kusebenza). Iitheyibhile ngokwazo zicacile, zicwangcisiwe, zinokunyuka, zinomlingo!
Kodwa nequmrhu elimangalisayo elinjengetafile linokonakala. Kwaye ungayisebenzisa ngempumelelo kwaye uyiphucule. Okungakumbi kule ngezantsi.
Ukuhluza (i-plugin ehlawulweyo)
Nayiphi na itafile enkulu, engafundekiyo inokwenziwa ibencinci kwaye ifundeke ngakumbi kusetyenziswa ukuhluza. Ungasebenzisa imacro ehlawulweyo kule nto .
Kufuneka ubeke itafile ngaphakathi kule macro (nokuba eyona imbi kakhulu inokwenzeka, into ephambili kukuyityhala ngokupheleleyo). Kwimakhro, ungakhetha iikholamu zesihluzo sokuhla, isihluzo sokubhaliweyo, isihluzo samanani, kunye nesihluzo somhla.
Khawufane ucinge ukuba yonke ingcaciso ngabagqatswa bazo zonke izithuba irekhodwa kuluhlu lwetheyibhile. Ngokwendalo, ayilungiswanga - abantu beza kudliwano-ndlebe hayi ngokulandelelana kwealfabhethi. Kwaye kufuneka uqonde ukuba ukhe wadlana indlebe nomfaki-sicelo othile ngaphambili. Kufuneka nje ubeke esi sihogo kwisihluzi esikhulu, yongeza isihluzo sokubhaliweyo ngegama lokugqibela- kwaye voila, ulwazi lukwisikrini sakho.
Kufanelekile ukuqaphela ukuba ukuhluza iitafile ezinkulu kunokuchaphazela ukusebenza kwenkqubo kunye namaxesha okulayishwa kwephepha, ke ukubeka itafile enkulu kwisihluzi yinto nje yokwexeshana; kungcono ukwakha inkqubo apho kunganyanzelekanga ukuba abantu benze iitafile ezinkulu ezingafundekiyo ( umzekelo wenkqubo iya kuba ekupheleni kwenqaku).
Ukuhlela (i-plugin ehlawulwayo)
Ukusebenzisa imacro yomlingo Unako kwakhona ukuseta uhlobo olungagqibekanga nakweyiphi na ikholamu kunye nenombolo kwimiqolo. Okanye nqakraza nakweyiphi na ikholamu yetafile efakwe kwisihluzo esikhulu, kwaye ukuhlelwa kuya kwenzeka ngalo mhlathi.
Umzekelo, unetafile efanayo kunye nabafaki-zicelo kwaye kufuneka uqikelele ukuba zingaphi udliwano-ndlebe olwenziwe kwinyanga ethile - hlela ngomhla kwaye wonwabe.
Iitafile zePivot (i-plugin ehlawulweyo)
Ngoku makhe siqhubele phambili kwelinye icala elinomdla ngakumbi. Khawucinge ukuba itafile yakho inkulu kwaye kufuneka ubale into ethile kuyo. Ewe, ungayikopisha kwi-Excel, ubale into oyifunayo kwaye ulayishe idatha kwi-Confluence. Ungayisebenzisa imacro kube kanye? kwaye ufumane iziphumo ezifanayo, zihlaziywa kuphela.
Umzekelo: unetafile eqokelela idatha kubo bonke abasebenzi - apho babekwe ngokwejografi kwaye zeziphi izikhundla abanazo. Ukubala ukuba bangaphi abantu kwisixeko ngasinye, kufuneka ukhethe umqolo kwi-PivotTable macro edibanisa idatha (indawo) kunye nohlobo lokusebenza (ukongeza).
Ngokwemvelo, unokwenza iqela ngeenqobo ezininzi ngaxeshanye, onke amathuba anokujongwa .
Iitshathi (iplagi ehlawulwayo)
Njengoko benditshilo, ayinguye wonke umntu othanda iitafile njengam. Ngelishwa, abaphathi abaninzi abazithandi kwaphela. Kodwa wonke umntu uyayithanda ngokwenene imizobo enemibala eqaqambileyo.
Abadali be-Confluence ngokuqinisekileyo babeyazi ngale nto (mhlawumbi banabo abaphathi abathanda iingxelo kunye nemizobo, baya kuba phi ngaphandle kwayo). Ke ngoko, ungasebenzisa i-macro yomlingo . Kule macro kufuneka ubeke itafile yepivot ukusuka kumhlathi wangaphambili, kwaye voila - idatha yakho edikayo engwevu ibonwa kakuhle.
Ngokwemvelo, le macro nayo inesetingi. Ikhonkco kumaxwebhu ayo nayiphi na imacro inokufunyanwa kwindlela yokuhlela yaloo macro.
Ukuhlanganiswa okulula
Ulwazi olusuka kwimihlathi engaphambili mhlawumbi ibingesiso isityhilelo kuwe. Kodwa ngoku ngokuqinisekileyo uyayazi indlela yokusebenzisa iimacros, kwaye ndiyakwazi ukuqhubela phambili kwindawo enomdla ngakumbi yenqaku.
Iilebula
Kubi xa abantu begcina ulwazi kwinqaku elingacwangciswanga okanye kwitafile enkulu. Kubi nangakumbi xa iinxalenye zolu lwazi zingalungiswanga nje ngokungafundekiyo, kodwa zikwasasazwe kuyo yonke iNgqungquthela. Ngethamsanqa, kunokwenzeka ukuqokelela ulwazi oluthe saa kwindawo enye. Ukwenza oku kufuneka usebenzise (iithegi eziqhelekileyo kuye wonke umntu ovela kwinethiwekhi zentlalo).
Unokongeza naliphi na inani leethegi nakweliphi na iphepha. Ukucofa kwithegi kuyakusa kwiphepha lodityaniso elinamakhonkco kuwo wonke umxholo onaloo thegi, kunye neseti yeethegi ezinxulumeneyo. Iithegi ezinxulumeneyo zezo zivela rhoqo kwiphepha elinye.
Iipropati zephepha
Unokongeza enye i-macro enomdla kwiphepha ukwakha ulwazi - . Ngaphakathi kuyo kufuneka ungenise itafile yeekholomu ezimbini, eyokuqala iya kuba sisitshixo, kwaye okwesibini iya kuba lixabiso lepropati. Ngaphezu koko, i-macro inokufihlwa kwiphepha ukuze ingaphazamisi ukufunda umxholo, kodwa iphepha liya kuphawulwa ngezitshixo eziyimfuneko.
Nika ingqalelo kwi-ID - kulungele ukuseta ukwabela amaqela ahlukeneyo ezakhiwo kumaphepha ahlukeneyo (okanye amaqela ahlukeneyo eempawu kwiphepha elinye).
Iingxelo
Unokuqokelela iingxelo usebenzisa iithegi. Umzekelo, macro iqokelela onke amaphepha aneseti ethile yeethegi.
Kodwa ingxelo enomdla ngakumbi yimacro . Ikwaqokelela onke amaphepha aneseti ethile yeethegi, kodwa ayibonisi nje uluhlu lwazo, kodwa idala itafile (ngaba ubamba uxhulumaniso kunye nesiqalo senqaku?), Apho iikholamu kwiphepha izitshixo zepropati.
Isiphumo sisishwankathelo setafile yolwazi oluvela kwimithombo eyahlukeneyo. Kuhle ukuba inemisebenzi efanelekileyo: i-adaptive layout, ukuhlela ngayo nayiphi na ikholamu. Kwakhona, itheyibhile enjalo yokunika ingxelo inokuqwalaselwa ngaphakathi kwe-macro.
Xa uqwalasela, unokususa ezinye iikholamu kwingxelo, setha imeko engagqibekanga okanye inani leerekhodi ezibonisiweyo. Unokuseta i-ID yepropathi yephepha ukuze ubone kuphela ulwazi oludingayo.
Ngokomzekelo, unamaphepha amaninzi omqeshwa, la maphepha anesethi yeempawu malunga nomntu: yiyiphi inqanaba, apho akhoyo, xa ejoyina iqela, njalo njalo. Ezi propati ziphawulwe ID = umqeshwa_inf. Kwaye kukho isethi yesibini yeepropati kwiphepha elifanayo, eliqulethe ulwazi malunga nomntu njengenxalenye yeqela: yiyiphi indima edlalwa ngumntu, liphi iqela elikulo, njalo njalo. Ezi propati ziphawulwe ID = team_inf. Emva koko, xa uqulunqa ingxelo, unokubonisa kuphela ulwazi lwe-ID enye okanye ezimbini ngaxeshanye - nokuba yeyiphi eyona ilunge ngakumbi.
Ubuhle bale ndlela kukuba wonke umntu unokuhlanganisa itafile yolwazi abayidingayo, engayi kuphinda nantoni na kwaye iya kuhlaziywa xa iphepha eliphambili lihlaziywa. Umzekelo: ayinamsebenzi kwiqela elikhokelayo xa abaphuhlisi bakhe befumene umsebenzi, kodwa kubalulekile ukuba yiyiphi indima edlalwa ngumntu ngamnye kwiqela. Iqela elikhokelayo liya kuqokelela ingxelo ngeqela. Kwaye umgcini-mali ngokuqhelekileyo akakhathaleli ukuba ngubani owenza indima, kodwa izikhundla zibalulekile - uya kuqulunqa ingxelo ngezikhundla. Kule meko, umthombo wolwazi awuyi kuphinda uphindwe okanye udluliselwe.
Inkqubo yokugqibela
Imiyalelo
Ke, sinokwakheka kakuhle kwaye sihlanganise ngokufanelekileyo ulwazi kwi-Confluence sisebenzisa iimacros njengomzekelo. Kodwa ngokufanelekileyo, kufuneka uqiniseke ukuba ulwazi olutsha lucwangciswe ngokukhawuleza kwaye luwela kuzo zonke iindlela zokudibanisa esele zisetyenziswa.
Kulapho iqela le-macros kunye neetemplates ziya kuhlangula. Ukunyanzela abantu ukuba benze amaphepha amatsha kwifomati efunwayo, ungasebenzisa iYenza ukusuka kwiTemplate macro. Yongeza iqhosha kwiphepha, xa ucofa, iphepha elitsha lenziwe kwitemplate oyifunayo. Ngale ndlela unyanzela abantu ukuba basebenze ngokukhawuleza kwifomathi oyifunayo.
Kwi template odala kuyo iphepha, kufuneka ungeze iilebula, i-"Page Properties" macro kunye netafile yeepropati ozifunayo kwangaphambili. Ndikwacebisa ukongeza imiyalelo malunga nokuba ngawaphi amaxabiso kufuneka azaliswe kwiphepha, kunye namaxabiso epropathi.
Emva koko inkqubo yokugqibela iya kujongeka ngolu hlobo:
- Udala itemplate yohlobo oluthile lolwazi.
- Kule template wongeza iilebhile kunye neempawu zephepha kwi-macro.
- Nakweyiphi na indawo efanelekileyo, yenza iphepha lengcambu ngeqhosha, ucofa apho kudala iphepha lomntwana kwi template.
- Uvumela abasebenzisi ukuba baye kwiphepha leengcambu, abanokuthi bavelise ulwazi oluyimfuneko (ngokwethemplate efunekayo, ngokuchofoza iqhosha).
- Uqokelela ingxelo kwiipropati zephepha usebenzisa iithegi ozikhankanye kwitemplate.
- Vuyisa: unalo lonke ulwazi olufunekayo ngendlela efanelekileyo.
ngenye into
Njengenjineli esemgangathweni, ndingatsho ngokukhuselekileyo ukuba akukho nto igqibeleleyo emhlabeni. Kwanezithebe zobuthixo azifezekanga. Kwaye kukho imigibe kule nkqubo ingentla.
- Ukuba uthatha isigqibo sokutshintsha amagama okanye ukubunjwa kweempawu zephepha, kuya kufuneka uhlaziye zonke izinto esele zenziwe ukuze idatha yazo ifakwe ngokuchanekileyo kwingxelo yesishwankathelo. Oku kubuhlungu, kodwa, ngakolunye uhlangothi, kukunyanzela ukuba ucinge ngokubanzi malunga "nezakhiwo" zeseti yakho yolwazi, owona msebenzi unomdla kakhulu.
- Kuya kufuneka ubhale inani elifanelekileyo lemiyalelo malunga nendlela yokugcwalisa iitheyibhile zolwazi kunye nokusebenzisa iithegi. Kodwa kwelinye icala, unokubabetha bonke abantu abalungileyo ngeli nqaku.
Umzekelo wokugcina amaxwebhu angeyomveliso
Ngenkqubo echazwe ngasentla, unokuququzelela ukugcinwa phantse naluphi na ulwazi. Ubuhle bendlela yeyokuba yeyomhlaba wonke: xa abasebenzisi sele beyiqhelile, bayayeka ukuvelisa isiphithiphithi. Enye enkulu (kodwa hayi simahla) kunye nokukwazi ukuqokelela izibalo ezahlukeneyo kubhabho kunye nokuzoba imizobo emihle esekwe kuzo.
Makhe ndikunike umzekelo wenkqubo yethu yokugcina ulwazi malunga neqela.
Sigqibe ekubeni senze ikhadi lomsebenzi kumntu ngamnye kwiqela. Ngokufanelekileyo, sinethemplate ethi umntu ngamnye omtsha azenzele eli khadi kwaye agcine yonke ingcaciso yobuqu kuyo.
Njengoko ubona, sinetheyibhile eneenkcukacha yeepropathi kwaye ngoko nangoko sinemiyalelo malunga nendlela yokugcinwa kweli phepha. Ezinye iithegi zongezwa ngabasebenzi ngokwabo ngokwemiyalelo; ithemplate iqulethe kuphela ezona ziphambili: ithegi yekhadi umqeshwa-ikhadi, ithegi yesalathiso ulwalathiso-bandakanya kunye nethegi yeqela iqela-qa.
Ngenxa yoko, emva kokuba wonke umntu ezenzele ikhadi, itafile epheleleyo enolwazi kubasebenzi ifunyenwe. Olu lwazi lunokusetyenziswa kwiindawo ezahlukeneyo. Abaphathi bemithombo banokuqokelela iitafile eziqhelekileyo ngokwabo, kwaye iqela elikhokelayo linokwenza iitafile zeqela ngokongeza ithegi yeqela ekukhethweni.
Ungabona izishwankathelo ezahlukeneyo ngeethegi, umzekelo qa-upgrade-plan Yonke imisebenzi yophuhliso lwe-QA iya kuboniswa. Ngelo xesha, umntu ngamnye ugcina imbali ebalulekileyo kunye nesicwangciso sakhe sophuhliso kwikhadi lakhe lomqeshwa - udala iphepha elifakwe kwi-template yezicwangciso zophuhliso.
isiphelo
Gcina nawaphi na amaxwebhu ngendlela yokuba kungabikho ntloni kuyo, kwaye ayibangeli intlungu ebuhlungu kubasebenzisi!
Ndiyathemba ngokwenene ukuba inqaku liya kuba luncedo kwaye ulandelelwano luya kuza kuwo onke amaxwebhu ehlabathini.
umthombo: www.habr.com