Kupanga mu Confluence

Hello aliyense!

Dzina langa ndine Masha, ndimagwira ntchito ngati injiniya wotsimikizira bwino pagulu lamakampani la Tinkoff. Ntchito ya QA imaphatikizapo kulankhulana kwambiri ndi anthu osiyanasiyana ochokera m'magulu osiyanasiyana, komanso ndinali woyang'anira ndi mphunzitsi wa mapulogalamu a maphunziro, kotero mapu anga olankhulana anali otakata momwe ndingathere. Ndipo panthawi ina ndinaphulika: ndinazindikira kuti sindingathe, sindingathe, sindingathe kudzaza matani a gehena a matebulo ndi zolemba zosawerengeka.

Ndithudi aliyense wa inu tsopano analingalira zimene ine ndikunena ndipo anatuluka thukuta lozizira: mindandanda ya surname popanda dongosolo zilembo, matebulo ndi mazana a mizati ndi zokhotakhota masanjidwe, matebulo ndi zikwi mizere mmene muyenera kupukuta chala chanu. pa gudumu la mbewa kuti muyang'ane mutu, matani a masamba a malangizo osawerengeka, mazana a makalata otumizidwa kwa wina ndi mzake ndi deta yomwe imayenera kufufuzidwa ndi kukonzedwa mwadongosolo ndikuyika mu matebulo osawerengeka mofanana.

Choncho, nditakhazikika pang’ono, ndinaganiza zolemba nkhaniyi. Ndilankhula za momwe mungathere (ngakhale nthawi zina mosavuta) kusunga zolemba zosiyanasiyana zomwe sizinthu. Ndikuyembekeza kuti nkhaniyi idzafalikira pa intaneti ndipo mlingo wa gehena m'madipatimenti oyandikana ndi chitukuko udzachepa pang'ono, ndipo anthu (kuphatikizapo ine ndekha) adzakhala osangalala pang'ono.

Zida

Zolemba zamalonda nthawi zambiri zimasungidwa pafupi ndi code, zomwe ndi zabwino. Ndipo zolembedwa zosakhala zopangidwa nthawi zambiri zimasungidwa kulikonse. Nthawi zambiri anthu amayesa kusamutsa zidziwitso kuchokera kumalo osiyanasiyana kupita ku Confluence, ndipo ifenso ndife osiyana. Choncho nkhani yotsalayo ndi ya iye.

Mwambiri, Confluence ndi injini yawiki yapamwamba. Zimakuthandizani kuti mugwire ntchito ndi data mumitundu yosiyanasiyana yowonetsera: zolemba ndi masanjidwe, matebulo, ma chart osiyanasiyana. Ichi ndi chida chosangalatsa kwambiri komanso champhamvu, koma ngati simukudziwa momwe mungakonzekere, ndiye kuti mudzakhala ndi zolemba zina zosawerengeka. Ndikuphunzitsani kuphika!

Macro

Pafupifupi matsenga onse a Confluence amachokera ku macros. Pali ma macros ambiri, ndipo amatha kuphatikizidwa wina ndi mnzake. Atha kulipidwa kapena kwaulere; m'munsimu padzakhala zitsanzo zosiyanasiyana za macros okhala ndi maulalo olembedwa kwa iwo.

Mawonekedwe ogwirira ntchito ndi macros ndi osavuta momwe angathere. Kuti muwonjezere macro, muyenera dinani pazowonjezera ndikusankha chinthu chomwe mukufuna pamndandanda.

Ngati macro amadzidalira okha, ndiye kuti, safuna kuyika china chilichonse mkati mwake, amawoneka ngati chipika.

Ngati macro ikufuna kuyika china chake mkati mwake kuti igwire ntchito, imawoneka ngati chimango.

Nthawi yomweyo, mutha kuyika ena ambiri momwe mungafunire mkati mwa chimango chimodzi, bola ngati pali malingaliro mu piramidi yanu.

Macro iliyonse imakhala ndi chithunzithunzi: imawonetsa nthawi yomweyo ngati mwadzaza ndikusintha macro molondola.

Mapangidwe

Kuphatikiza pa macros, pali chida chothandizira kudzaza zomwe zili - template.
Ma templates atha kugwiritsidwa ntchito popanga tsamba lililonse: ingodinani madontho atatu omwe ali pafupi ndi batani la "Pangani" ndikusankha chithunzi chomwe mukufuna.

Kenako zonse zomwe zili mu template zidzawonjezedwa patsamba lomwe lapangidwa.

Aliyense akhoza kupanga masamba kuchokera ku ma templates, koma okhawo omwe ali ndi ufulu wopanga kapena kusintha ma template okha ndi omwe angathe kutero. Mukhoza kuwonjezera malangizo owonjezera ku template ya momwe tsambalo liyenera kusamalidwa.

Matsenga a matebulo

Kwenikweni, monga techie, ndimakonda kwambiri matebulo ndipo ndimatha kukulunga pafupifupi chilichonse mwa iwo (ngakhale izi sizothandiza nthawi zonse). Matebulowo ndi omveka bwino, opangidwa, owopsa, amatsenga!

Koma ngakhale chinthu chodabwitsa chotero monga tebulo chikhoza kuwonongeka. Ndipo mutha kugwiritsa ntchito bwino komanso ngakhale kuwongolera. Zambiri pa izi pansipa.

Kusefa (pulogalamu yowonjezera yolipidwa)

Gome lililonse lalikulu, losawerengeka litha kukhala locheperako komanso losavuta kuwerenga pogwiritsa ntchito kusefa. Mutha kugwiritsa ntchito macro olipidwa pa izi "Table filter".

Muyenera kuyika tebulo mkati mwa macro (ngakhale yoyipa kwambiri ndizotheka, chinthu chachikulu ndikukankhira kwathunthu). Mu macro, mutha kusankha mizati ya zosefera zotsikira, zosefera zolemba, zosefera manambala, ndi zosefera tsiku.

Tangoganizani kuti zidziwitso zonse za omwe adzalembetse ntchito zonse zalembedwa pamndandanda wama tabular. Mwachilengedwe, osasankhidwa - anthu amabwera ku zoyankhulana osati motsatira zilembo. Ndipo muyenera kumvetsetsa ngati mudafunsapo munthu wofunsayo m'mbuyomu. Mukungoyenera kuyika gehena iyi mu fyuluta yayikulu, onjezani zosefera ndi dzina lomaliza - ndipo voila, chidziwitsocho chili pazenera lanu.

Ndizofunikira kudziwa kuti kusefa matebulo akulu kumatha kukhudza magwiridwe antchito ndi nthawi yotsitsa masamba, kotero kuyika tebulo lalikulu muzosefera ndi njira yosakhalitsa; ndikwabwino kupanga njira yomwe anthu sayenera kupanga matebulo akulu, osawerengeka ( chitsanzo cha ndondomeko adzakhala kumapeto kwa nkhani).

Kusanja (pulogalamu yowonjezera yolipidwa)

Kugwiritsa ntchito macro macro "Table filter" Mukhozanso kukhazikitsa mtundu wokhazikika pazambiri zilizonse ndikuwerengera mizere. Kapena dinani pagawo lililonse la tebulo lomwe layikidwa muzosefera zazikulu, ndipo kusanja kudzachitika ndi gawolo.

Mwachitsanzo, muli ndi tebulo lomwelo ndi ofunsira ndipo muyenera kuyerekezera kuchuluka kwa zoyankhulana zomwe zidachitika m'mwezi wina - sankhani ndi tsiku ndikukhala osangalala.

Pivot tables (pulogalamu yowonjezera yolipira)

Tsopano tiyeni tipitirire ku nkhani yosangalatsa kwambiri. Tangoganizani kuti tebulo lanu ndi lalikulu ndipo muyenera kuwerengera chinachake kuchokera pamenepo. Zachidziwikire, mutha kuyikopera ku Excel, kuwerengera zomwe mukufuna ndikuyikanso datayo ku Confluence. Kodi mungagwiritse ntchito macro kamodzi? "Pivot table" ndikupeza zotsatira zomwezo, zosinthidwa zokha.

Mwachitsanzo: muli ndi tebulo lomwe limasonkhanitsa deta kuchokera kwa antchito onse - komwe ali ndi malo omwe ali nawo. Kuti muwerenge kuchuluka kwa anthu mumzinda uliwonse, muyenera kusankha mzere wa PivotTable macro womwe umaphatikiza deta (malo) ndi mtundu wa ntchito (zowonjezera).

Mwachilengedwe, mutha kupanga magulu angapo nthawi imodzi, zotheka zonse zitha kuwonedwa mu zolembedwa.

Ma chart (pulagini yolipira)

Monga ndanenera, si aliyense amene amakonda matebulo monga momwe ndimakondera. Tsoka ilo, mameneja ambiri samawakonda nkomwe. Koma aliyense amakondadi zithunzi zamitundu yowala.
Omwe amapanga Confluence amadziwa za izi (mwina alinso ndi mabwana omwe amakonda malipoti ndi zithunzi, akanakhala kuti popanda izo). Chifukwa chake, mutha kugwiritsa ntchito magic macro "Tchati kuchokera patebulo". Mu macro muyenera kuyika tebulo la pivot kuchokera mundime yapitayi, ndipo voila - deta yanu yotuwa ikuwoneka bwino.

Mwachilengedwe, macro iyi ilinso ndi zoikamo. Ulalo wamakalata amtundu uliwonse umapezeka munjira yosinthira ya macro.

Kuphatikiza kosavuta

Zambiri za ndime zam'mbuyomu mwina sizinali vumbulutso kwa inu. Koma tsopano mukudziwa momwe mungagwiritsire ntchito macros, ndipo nditha kupita ku gawo losangalatsa la nkhaniyi.

Malemba

Ndizoipa pamene anthu amasunga zambiri m'nkhani imodzi yosalongosoka kapena patebulo lalikulu. Zimakhala zoyipitsitsa kwambiri pamene mbali za chidziwitsochi sizinapangidwe mosawerengeka, komanso zimabalalika mu Confluence. Mwamwayi, ndizotheka kusonkhanitsa zambiri zobalalika pamalo amodzi. Kuti muchite izi muyenera kugwiritsa ntchito ma tag (ma tag odziwika kwa aliyense pamasamba ochezera).

Mutha kuwonjezera ma tag angapo patsamba lililonse. Kudina pa tag kudzakutengerani patsamba lophatikiza lomwe lili ndi maulalo a zonse zomwe zili ndi tagyo, komanso ma tag ogwirizana nawo. Ma tag ogwirizana ndi omwe amawonekera pafupipafupi patsamba lomwelo.

Masamba katundu

Mutha kuwonjezera macro ena osangalatsa patsambalo kuti mupange zambiri - "Page Properties". Mkati mwake muyenera kupereka tebulo la mizati iwiri, yoyamba idzakhala fungulo, ndipo yachiwiri idzakhala mtengo wa katundu. Kuphatikiza apo, ma macro amatha kubisika patsamba kuti zisasokoneze kuwerenga zomwe zili, koma tsambalo likhalabe ndi makiyi ofunikira.

Samalani ndi ID - ndikosavuta kuyiyika kuti igawire magulu osiyanasiyana azinthu masamba osiyanasiyana (kapena magulu osiyanasiyana azinthu patsamba limodzi).

Malipoti

Mutha kusonkhanitsa malipoti pogwiritsa ntchito ma tag. Mwachitsanzo, macro "Content Report" imasonkhanitsa masamba onse okhala ndi ma tag enieni.

Koma lipoti losangalatsa kwambiri ndi macro "Page Properties Report". Imasonkhanitsanso masamba onse okhala ndi ma tag ena, koma sikuti imangowonetsa mndandanda wawo, koma imapanga tebulo (kodi mumagwira kugwirizana ndi chiyambi cha nkhaniyo?), momwe mizati ndi tsamba. makiyi katundu.

Zotsatira zake ndi tabulo lachidule la chidziwitso chochokera kuzinthu zosiyanasiyana. Ndibwino kuti ili ndi ntchito zosavuta: masanjidwe osinthika, kusanja ndi gawo lililonse. Komanso, tebulo lofotokozera lotere likhoza kukhazikitsidwa mkati mwa macro.

Mukakonza, mutha kuchotsa zipilala zina kuchokera ku lipotilo, ikani malo osasinthika kapena kuchuluka kwa zolemba zomwe zikuwonetsedwa. Muthanso kukhazikitsa ID ya katundu watsamba kuti muwone zomwe mukufuna.

Mwachitsanzo, muli ndi masamba ambiri ogwira ntchito, masambawa ali ndi katundu wokhudza munthuyo: msinkhu wake, komwe ali, pamene adalowa nawo gulu, ndi zina zotero. Zinthu izi zalembedwa ID = wantchito_inf. Ndipo pali seti yachiwiri ya katundu patsamba lomwelo, lomwe lili ndi chidziwitso chokhudza munthuyo monga gawo la gulu: gawo lomwe munthuyo amasewera, gulu lomwe ali, ndi zina zotero. Zinthu izi zalembedwa ID = team_inf. Kenako, polemba lipoti, mutha kuwonetsa chidziwitso cha ID imodzi kapena ziwiri nthawi imodzi - chilichonse chomwe chili chosavuta.

Ubwino wa njirayi ndikuti aliyense akhoza kusonkhanitsa tebulo lazidziwitso lomwe akufuna, lomwe silingabwereze chilichonse ndipo lidzasinthidwa tsamba lalikulu likasinthidwa. Mwachitsanzo: zilibe kanthu kuti gulu likutsogolereni pomwe opanga ake adapeza ntchito, koma ndikofunikira kuti aliyense wa iwo achite chiyani mu timu. Otsogolera timu atenga lipoti la timu. Ndipo wowerengera nthawi zambiri samasamala yemwe amachita ntchito, koma maudindo ndi ofunikira - adzalemba lipoti la maudindo. Pamenepa, gwero la chidziwitso sichidzabwerezedwa kapena kusamutsidwa.

Njira yomaliza

Malangizo

Chifukwa chake, titha kupanga bwino ndikuphatikiza zidziwitso mu Confluence pogwiritsa ntchito macros mwachitsanzo. Koma moyenera, muyenera kuwonetsetsa kuti zatsopano zakonzedwa nthawi yomweyo ndikulowa munjira zonse zophatikiza zomwe zikugwiritsidwa ntchito kale.

Apa ndipamene gulu la macros ndi ma templates adzabwera kudzapulumutsa. Kukakamiza anthu kupanga masamba atsopano mumtundu womwe mukufuna, mutha kugwiritsa ntchito Pangani kuchokera ku Template macro. Imawonjezera batani patsamba, ikadina, tsamba latsopano limapangidwa kuchokera ku template yomwe mukufuna. Mwanjira iyi mumakakamiza anthu kuti agwiritse ntchito nthawi yomweyo momwe mukufuna.

Mu template yomwe mumapangira tsamba, muyenera kuwonjezera zilembo, "Page Properties" macro ndi tebulo lazinthu zomwe mukufuna pasadakhale. Ndikupangiranso kuwonjezera malangizo pazomwe ziyenera kudzazidwa patsamba, ndi mitengo ya katundu.

Ndiye ndondomeko yomaliza idzawoneka motere:

1. Mumapanga template ya mtundu wina wa chidziwitso.
2. Mu template iyi mumawonjezera zolemba ndi masamba mu macro.
3. Pamalo aliwonse abwino, pangani tsamba la mizu ndi batani, ndikudina lomwe limapanga tsamba lachibwana kuchokera pa template.
4. Mumalola ogwiritsa ntchito kupita patsamba la mizu, omwe atha kupanga zofunikira (malinga ndi template yofunikira, podina batani).
5. Mumasonkhanitsa lipoti lazomwe zili patsambalo pogwiritsa ntchito ma tag omwe mwawafotokozera mu template.
6. Sangalalani: muli ndi zofunikira zonse mumpangidwe wosavuta.

Zowopsa

Monga injiniya wabwino, ndinganene mosabisa kuti palibe chomwe chili chabwino padziko lapansi. Ngakhale matebulo aumulungu ndi opanda ungwiro. Ndipo pali misampha mu ndondomeko pamwamba.

• Ngati mwaganiza zosintha mayina kapena mawonekedwe amasamba, muyenera kusintha zinthu zonse zomwe zidapangidwa kale kuti deta yawo ikhale yophatikizidwa mu lipoti lachidule. Izi ndi zomvetsa chisoni, koma, kumbali ina, zimakukakamizani kuganizira mwatsatanetsatane za "zomangamanga" za chidziwitso chanu, chomwe ndi ntchito yosangalatsa kwambiri.
• Muyenera kulemba kuchuluka kwa malangizo amomwe mungadzazitsire matebulo achidziwitso ndi kugwiritsa ntchito ma tag. Koma kumbali ina, mutha kungogunda anthu onse oyenera ndi nkhaniyi.

Chitsanzo chosungira zolembedwa zopanda mankhwala

Kupyolera mu ndondomeko tafotokozazi, mukhoza kukonza kusungirako pafupifupi chilichonse. Kukongola kwa njirayo ndikuti ndi yapadziko lonse lapansi: ogwiritsa ntchito akangozolowera, amasiya kupanga chisokonezo. China chachikulu (koma osati chaulere) kuphatikiza ndikutha kusonkhanitsa ziwerengero zosiyanasiyana pa ntchentche ndikujambula zithunzi zokongola potengera iwo.

Ndiroleni ndikupatseni chitsanzo cha ndondomeko yathu yosunga zambiri za gulu.

Tinaganiza zopanga khadi lantchito la munthu aliyense pagulu. Chifukwa chake, tili ndi template yomwe munthu aliyense watsopano amadzipangira yekha khadili ndikusunga zambiri zaumwini momwemo.

Monga mukuwonera, tili ndi tebulo latsatanetsatane lazinthu ndipo nthawi yomweyo timakhala ndi malangizo amomwe tingasamalire tsamba ili. Ena mwa ma tag amawonjezedwa ndi ogwira ntchitowo molingana ndi malangizo; template ili ndi zazikulu zokha: makhadi khadi lantchito, chizindikiro cha mayendedwe mayendedwe-kuphatikizapo ndi timu tag timu-qa.

Zotsatira zake, aliyense atadzipangira yekha khadi, tebulo lathunthu lokhala ndi chidziwitso cha ogwira ntchito limapezeka. Izi zitha kugwiritsidwa ntchito pazigawo zosiyanasiyana. Oyang'anira zothandizira atha kudzipezera okha matebulo, ndipo otsogolera gulu amatha kupanga matebulo amagulu powonjezera tag yamagulu pazosankha.

Mutha kuwona zidule zosiyanasiyana ndi ma tag, mwachitsanzo qa-kukweza-pulani Ntchito zonse zachitukuko za QA zidzawonetsedwa. Panthawi imodzimodziyo, munthu aliyense amasunga mbiri yofunikira komanso ndondomeko yake yachitukuko mu khadi lake la ntchito - amapanga tsamba lokhala ndi zisa kuchokera ku ndondomeko yachitukuko.

Pomaliza

Sungani zolemba zilizonse m'njira yoti mulibe manyazi, ndipo sizimayambitsa ululu woopsa kwa ogwiritsa ntchito!

Ndikukhulupirira kuti nkhaniyi idzakhala yothandiza ndipo dongosolo lidzabwera ku zolemba zonse padziko lapansi.

Source: www.habr.com