Hello vose!
Zita rangu ndinonzi Masha, ndinoshanda sainjiniya wekusimbisa hunhu paboka reTinkoff remakambani. Basa reQA rinosanganisira kutaurirana kwakawanda nevanhu vakasiyana kubva kuzvikwata zvakasiyana, uye ndaivewo maneja uye mudzidzisi wezvirongwa zvedzidzo, saka mepu yangu yekutaurirana yaive yakakura sezvaikwanisika. Uye pane imwe nguva ndakaputika: ndakaona kuti handigoni, handigoni, handigoni kuzadza matani ehero ematafura asingaverengeki uye zvinyorwa.
Chokwadi mumwe nemumwe wenyu atofungidzira zvandiri kutaura nezvazvo uye akabuda dikita rinotonhora: rondedzero yemazita asina alfabheti, matafura ane mazana emakoramu ane akatsveyama marongero, matafura ane zviuru zvemitsara yaunoda kupukuta munwe wako. pavhiri regonzo kutarisa musoro, matani emapeji emirairo isingaverengeki, mazana emabhii anotumirwa kune mumwe nemumwe aine data inoda kuongororwa uye kurongeka uye kuiswa mumatafura asingaverengeki zvakaenzana.
Uye saka, pandakadzikama zvishoma, ndakafunga kunyora chinyorwa ichi. Ini ndichataura nezve maitiro aunokwanisa kuita (kunyangwe dzimwe nguva zviri nyore) kuchengetedza akasiyana-siyana asiri-chigadzirwa zvinyorwa. Ndinovimba kuti chinyorwa chichapararira paInternet uye mwero wegehena mumadhipatimendi ari padyo nebudiriro uchadzikira zvishoma, uye vanhu (kusanganisira ini) vachave vanofara zvishoma.
Tools
Zvinyorwa zvechigadzirwa zvinowanzochengetwa pedyo nekodhi, icho chinhu chakanaka. Uye zvinyorwa zvisiri-zvigadzirwa zvinowanzochengetwa chero kupi zvako. Vanhu vanowanzo edza kufambisa ruzivo kubva kunzvimbo dzakasiyana kuenda kuConfluence, uye isu hatina mutsauko. Saka imwe nyaya yasara iri pamusoro pake.
Kazhinji, Confluence injini yepamberi yewiki. Iyo inokutendera kuti ushande nedata mumhando dzakasiyana dzekuratidzira: zvinyorwa zvine fomati, matafura, akasiyana machati. Ichi chishandiso chinonakidza uye chine simba, asi kana iwe usingazivi kuti ungachigadzirira sei, ipapo iwe unozopedzisira uine imwe marara ezvinyorwa zvisingaverengeki. Ndichakudzidzisa kubika!
Macros
Anenge ese emashiripiti eConfluence anobva kumamacros. Kune akawanda macros, uye anogona kusanganiswa pamwe chete. Ivo vanogona kubhadharwa kana mahara; pazasi pachave neakasiyana mienzaniso yemacros ane zvinongedzo kune zvinyorwa kwavari.
Iyo interface yekushanda nema macros iri nyore sezvinobvira. Kuti uwedzere macro, unofanirwa kudzvanya pane yekuwedzera uye wosarudza chinhu chaunoda kubva pane rondedzero.
Kana iyo macro yakazvimiririra, ndiko kuti, haidi kuisa chero chinhu mukati mayo, inoita senge block.
Kana macro ichida kuti chimwe chinhu chiiswe mukati mayo kuti ishande, inoita senge furemu.
Panguva imwecheteyo, iwe unogona kuisa mamwe akawanda sezvaunoda mukati mefuremu imwe chete, chero paine pfungwa mupiramidhi yako.
Imwe neimwe macro ine preview: inokurumidza kuratidza kana iwe wakazadza uye nekugadzirisa iyo macro nemazvo.
Mapepa
Pamusoro pemacros, pane chishandiso chiri nyore chekuzadza-yemukati - template.
Matemplate anogona kushandiswa paunenge uchigadzira chero peji: ingobaya pane matatu madotsi padyo nebhatani re "Gadzira" uye sarudza template yaunoda.
Ipapo zvese zvirimo mutemplate zvichawedzerwa kune rakagadzirwa peji.
Chero ani zvake anogona kugadzira mapeji kubva kumatemplate, asi avo chete vane kodzero yekugadzira kana kugadzirisa matemplate ivo pachavo vanogona kuzviita. Iwe unogona kuwedzera mamwe mirairo kune template nezvekuti peji yacho inofanira kuchengetedzwa sei.
Mashiripiti ematafura
Chaizvoizvo, se techie, ndinoda zvikuru matafura uye ndinogona kuputira chero ruzivo mukati mawo (kunyangwe izvi zvisingashande nguva dzose). Iwo matafura pachawo akajeka, akaumbwa, anotsemuka, ane mashiripiti!
Asi kunyange chinhu chinoshamisa chakadaro setafura chinogona kuparadzwa. Uye iwe unogona kubudirira kuishandisa uye kunyange kuivandudza. Zvimwe pane izvi pazasi.
Kusefa (yakabhadharwa plugin)
Chero tafura hombe, isingaverengeki inogona kuitwa shoma shoma uye inoverengwa zvishoma uchishandisa kusefa. Iwe unogona kushandisa yakabhadharwa macro kune izvi .
Iwe unofanirwa kuisa tafura mukati meiyi macro (kunyangwe iyo yakashata inogoneka, chinhu chikuru ndechekusundidzira iyo yakazara). Mune macro, unogona kusarudza makoramu ekudonha-pasi sefa, mameseji sefa, nhamba sefa, uye zuva sefa.
Chimbofungidzira kuti ruzivo rwese rwevavhoterwa kune vese vacance varekodhwa mune tabular runyorwa. Sezvingatarisirwa, zvisina kurongwa - vanhu vanouya kubvunzurudzo kwete muhurongwa hwearufabheti. Uye iwe unofanirwa kunzwisisa kana iwe wakambobvunzurudza munhu akakumbira kare. Iwe unongoda kuisa gehena iri musefa macro, wedzera chinyorwa sefa nezita rekupedzisira - uye voila, ruzivo rwuri pachiratidziro chako.
Zvakakosha kucherechedza kuti kusefa matafura mahombe kunogona kukanganisa mashandiro ehurongwa uye nguva yekurodha peji, saka kuisa tafura hombe musefa itsvimbo yenguva pfupi; zviri nani kuvaka maitiro umo vanhu havafanirwe kugadzira matafura makuru, asingaverengeki (an. muenzaniso wemaitiro achave pakupera kwechinyorwa).
Kuronga (yakabhadharwa plugin)
Kushandisa magic macro Iwe unogona zvakare kuseta iyo yakasarudzika mhando pane chero column uye nhamba mitsara. Kana kuti tinya pane chero koramu yetafura yakaiswa mukati mesefa macro, uye kuronga kuchaitika nekoramu iyoyo.
Semuenzaniso, une tafura imwe chete nevanyoreri uye unofanirwa kufungidzira kuti ingani mabvunzurudzo akaitwa mune mumwe mwedzi - ronga nemazuva uye ufare.
Pivot matafura (yakabhadharwa plugin)
Zvino ngatiendei kune imwe nyaya inofadza. Fungidzira kuti tafura yako yakakura uye iwe unofanirwa kuverenga chimwe chinhu kubva pairi. Ehe, iwe unogona kuikopa muExcel, kuverenga zvaunoda uye kurodha iyo data kuConfluence. Unogona kushandisa macro kamwe chete? uye uwane mhedzisiro yakafanana, yakagadziridzwa chete.
Semuenzaniso: une tafura inounganidza data kubva kune vese vashandi - kwavanenge vari munzvimbo uye zvinzvimbo zvavanobata. Kuti uverenge kuti vangani vanhu vari muguta rega rega, unofanirwa kusarudza mutsara muPivotTable macro inounganidza iyo data (nzvimbo) uye rudzi rwekushanda (wedzero).
Nomuzvarirwo, unogona kuunganidza nemaitiro akati wandei kamwechete, mikana yese inogona kutariswa .
Machati (yakabhadharwa plugin)
Sezvandakataura, havasi vese vanoda matafura sezvandinoita. Sezvineiwo, mamaneja mazhinji haavadi zvachose. Asi munhu wose anonyatsoda madhayagiramu ane mavara akajeka.
Vagadziri veConfluence zvechokwadi vaiziva nezveizvi (ivo vangangove vanewo maboss anoda mishumo nemadhayagiramu, vaizovepi pasina iyo). Naizvozvo, iwe unogona kushandisa iyo magic macro . Mune iyi macro iwe unofanirwa kuisa iyo pivot tafura kubva pandima yapfuura, uye voila - yako grey inofinha data inoonekwa zvakanaka.
Sezvingatarisirwa, iyi macro inewo marongero. Chinongedzo kune zvinyorwa zvechero macro chinogona kuwanikwa mune editing modhi yeiyo macro.
Easy aggregation
Ruzivo kubva mundima dzapfuura pamwe yanga isiri chizaruro chako. Asi ikozvino iwe unonyatsoziva mashandisiro e macros, uye ini ndinogona kuenderera kune chikamu chinonakidza chechinyorwa.
Mavara
Zvakaipa kana vanhu vakachengeta ruzivo mune chimwe chinyorwa chisina kuumbwa kana tafura hombe. Zvakatonyanya kuipa kana zvikamu zveruzivo urwu zvisina kungonyorwa zvisina kuverengeka, asiwo zvakapararira mukati meConfluence. Sezvineiwo, zvinokwanisika kuunganidza ruzivo rwakapararira munzvimbo imwechete. Kuti aite izvi unofanira kushandisa (ma tag anozivikanwa nemunhu wese kubva pasocial network).
Iwe unogona kuwedzera chero nhamba yemategi kune chero peji. Kudzvanya pane tag kunokuendesa kune peji rekubatanidza rine zvinongedzo kune zvese zvirimo neiyo tag, pamwe neseti yematagi ane hukama. Ma tag ane hukama ndeaya anowanzo onekwa pane imwechete peji.
Peji zvivakwa
Iwe unogona kuwedzera imwe inonakidza macro kune peji kugadzira ruzivo - . Mukati mayo unoda kuendesa tafura yemakoramu maviri, yekutanga ichava kiyi, uye yechipiri ichava kukosha kwepfuma. Uyezve, iyo macro inogona kuvanzwa kubva pane peji kuitira kuti isakanganise nekuverenga zvirimo, asi peji rinoramba rakamakwa nemakiyi anodiwa.
Teerera kune iyo ID - zviri nyore kuimisa kuti ipe mapoka akasiyana ezvivakwa kumapeji akasiyana (kana kunyange mapoka akasiyana ezvivakwa kune peji rimwe).
Mishumo
Unogona kuunganidza mishumo uchishandisa ma tag. Somuenzaniso, macro inounganidza mapeji ese ane seti chaiyo yema tag.
Asi imwe rondedzero inonakidza ndeye macro . Inounganidzawo mapeji ese ane imwe seti yemategi, asi haingoratidzi rondedzero yavo, asi inogadzira tafura (unobata kubatana nekutanga kwechinyorwa?), umo makoramu ari peji. makiyi epfuma.
Mhedzisiro itafura yepfupiso yeruzivo kubva kunzvimbo dzakasiyana. Zvakanaka kuti ine mabasa ari nyore: inogadzirisa dhizaini, kuronga nechero column. Zvakare, tafura yekubika yakadaro inogona kugadzirwa mukati me macro.
Paunenge uchigadzirisa, unogona kubvisa mamwe makoramu kubva kumushumo, isa mamiriro akasarudzika kana nhamba yezvinyorwa zvinoratidzwa. Iwe unogona zvakare kuseta iyo peji chivakwa ID kuti uone chete ruzivo rwaunoda.
Semuenzaniso, une mapeji akawanda evashandi, mapeji aya ane seti yezvivakwa nezvemunhu: ndeipi nhanho, ari kupi, paakapinda muchikwata, zvichingodaro. Zvinhu izvi zvakaiswa chiratidzo ID = mushandi_inf. Uye kune yechipiri seti yezvivakwa pane imwechete peji, ine ruzivo nezvemunhu sechikamu chechikwata: basa ripi iro munhu anoita, nderipi timu yaari, zvichingodaro. Zvinhu izvi zvakaiswa chiratidzo ID = team_inf. Zvino, kana uchinyora rondedzero, unogona kuratidza ruzivo rwechitupa chimwe chete kana maviri kamwechete - chero chiri nyore.
Runako rwenzira iyi nderekuti munhu wese anogona kuunganidza tafura yeruzivo yavanoda, iyo isingazodzokorore chero chinhu uye ichagadziridzwa kana iyo huru peji yagadziridzwa. Semuenzaniso: hazvina basa kune mutungamiri weboka apo vagadziri vake vakawana basa, asi zvakakosha kuti mumwe nomumwe wavo anoita basa ripi muboka. Vatungamiri vechikwata vachatora rondedzero yechikwata. Uye accountant kazhinji haana hanya kuti ndiani anoita basa ripi, asi zvinzvimbo zvakakosha - anonyora mushumo wezvinzvimbo. Muchiitiko ichi, kunobva ruzivo hakuzodzokororwe kana kutamiswa.
Final process
Mirayiridzo
Saka, isu tinokwanisa kuronga zvakanaka uye nekunyatso kuunganidza ruzivo muConfluence tichishandisa macros semuenzaniso. Asi zvine hungwaru, iwe unofanirwa kuve nechokwadi chekuti ruzivo rutsva rwunogadzirwa nekukasira uye rwunowira mune ese maitirwo ekubatanidza atove kushandiswa.
Apa ndipo apo boka remacros uye matemplate achauya kuzonunura. Kumanikidza vanhu kugadzira mapeji matsva mune yaunoda fomati, unogona kushandisa Gadzira kubva kuTemplate macro. Iyo inowedzera bhatani kune peji, kana yadzvanywa, peji nyowani inogadzirwa kubva kune template yaunoda. Nenzira iyi unomanikidza vanhu kuti vashande nekukurumidza mufomati yaunoda.
Mune template yaunogadzira peji, iwe unofanirwa kuwedzera mavara, "Peji Properties" macro uye tafura yezvivakwa zvaunoda pamberi. Ini zvakare ndinokurudzira kuwedzera mirairo pane izvo zvakakosha zvinofanirwa kuzadzwa mupeji, uye hunhu hwezvivakwa.
Zvadaro nzira yekupedzisira ichaita seizvi:
- Iwe unogadzira template yerumwe rudzi rweruzivo.
- Mune iyi template iwe unowedzera mavara uye mapeji zvivakwa mune macro.
- Munzvimbo ipi neipi yakanakira, gadzira peji yemidzi ine bhatani, uchidzvanya pane iyo inogadzira peji remwana kubva patemplate.
- Iwe unorega vashandisi kuenda kune iyo midzi peji, iyo inogona kuburitsa ruzivo rwakakosha (maererano neinodiwa template, nekudzvanya pane bhatani).
- Iwe unounganidza chirevo pane zvivakwa zvepeji uchishandisa iwo ma tag awakatsanangura mutemplate.
- Fara: iwe une ruzivo rwese rwunodiwa mune yakanakira fomati.
Pitfalls
Seinjiniya yemhando, ndinogona kutaura zvakachengeteka kuti hapana chakakwana munyika. Kunyange tafura dzoumwari hadzina kukwana. Uye pane zvipingamupinyi mumaitiro ari pamusoro apa.
- Kana iwe ukafunga kushandura mazita kana kuumbwa kwezvivakwa zvepeji, iwe uchafanirwa kugadzirisa zvese zvakatogadzirwa zvinhu kuti data ravo rinyatso kuverengerwa mushumo wepfupiso. Izvi zvinosuruvarisa, asi, kune rumwe rutivi, zvinokumanikidza kuti ufunge zvakadzama nezve "architecture" yemashoko ako akaiswa, iro basa rinonakidza zvikuru.
- Iwe uchafanirwa kunyora huwandu hwakaringana hwemirairo yekuti unozadza sei matafura eruzivo uye kushandisa ma tag. Asi nerumwe rutivi, unogona kungorova vanhu vese vakanaka nechinyorwa ichi.
Muenzaniso wekuchengetedza zvinyorwa zvisiri zvechigadzirwa
Kuburikidza nemaitiro anotsanangurwa pamusoro apa, unogona kuronga kuchengetwa kweanenge chero ruzivo. Runako rwemaitiro acho ndeokuti ndeyepasirese: kana vashandisi vajaira, vanomira kugadzira bongozozo. Imwe hombe (asi isiri yemahara) kuwedzera iko kugona kuunganidza akasiyana manhamba panhunzi uye kudhirowa madhayagiramu akanaka akavakirwa pazviri.
Rega ndikupe muenzaniso wemaitiro edu ekuchengetedza ruzivo nezvechikwata.
Takafunga kugadzira kadhi revashandi remunhu wese ari muchikwata. Saizvozvo, isu tine template zvinoenderana nekuti munhu wese mutsva anozvigadzirira kadhi iri uye anochengeta ruzivo rwese rwemunhu mariri.
Sezvauri kuona, isu tine yakadzama tafura yezvivakwa uye nekukasira tine mirairo yekuti sei chaizvo kuchengetedza peji rino. Mamwe ma tag anowedzerwa nevashandi pachavo maererano nemirairo; iyo template ine chete iwo makuru: kadhi tag mushandi-kadhi, tag yekunanga kutungamira-kusanganisira uye team tag team-qa.
Somugumisiro, mushure mokunge munhu wose azvigadzirira kadhi, tafura yakakwana ine ruzivo rwevashandi inowanikwa. Ruzivo urwu runogona kushandiswa munzvimbo dzakasiyana. Maneja ezvishandiso anogona kuzviunganidzira matafura akajairwa, uye vatungamiriri vechikwata vanogona kugadzira matafura echikwata nekuwedzera teki yechikwata pane kusarudzwa.
Iwe unogona kuona zvipfupiso zvakasiyana nema tag, semuenzaniso qa-upgrade-plan Mabasa ese ekuvandudza QA acharatidzwa. Panguva imwecheteyo, munhu wega wega anochengeta nhoroondo yakakosha uye chirongwa chake chekuvandudza mune kadhi yemushandi wake - anogadzira peji rakaiswa kubva kune ekuvandudza zvirongwa template.
mhedziso
Chengetedza chero zvinyorwa nenzira yekuti hapana kunyadziswa mairi, uye hazvikonzeri kurwadziwa kwakanyanya kune vashandisi!
Ndinovimba chaizvo kuti chinyorwa chichave chinobatsira uye kurongeka kuchauya kune zvese zvinyorwa zviri munyika.
Source: www.habr.com