Kwa nthawi yayitali kale ntchito ya 1C idakhala pulogalamu yotchuka kwambiri pakati pa owerengera ndalama, okonza mapulani, azachuma ndi oyang'anira. Ili ndi mitundu yosiyanasiyana yamachitidwe osiyanasiyana, komanso kutengera kuthekera pansi pazowerengera zaka m'maiko angapo padziko lapansi. Makampani ambiri akuyamba kugwiritsa ntchito pulogalamu imeneyi. Koma njira yosamutsira deta pamanja kuchokera ku mapulogalamu ena owerengera ndalama kupita ku 1C ndi ntchito yayitali komanso yotopetsa, yomwe imatenga nthawi yambiri. Kampani ikasunga marekodi pogwiritsa ntchito Excel, njira yosamutsira imatha kukhala yamagalimoto kwambiri komanso kuthamanga.
Kusamutsa deta kuchokera ku Excel kupita ku 1C
Kusamutsa deta kuchokera ku Excel kupita ku 1C sikofunikira kokha pakanthawi koyamba kugwira ntchito ndi pulogalamuyi. Nthawi zina zimachitika izi, mukamachita ntchito muyenera kuyika mindandanda yomwe yasungidwa patebulo la processor. Mwachitsanzo, ngati mukufuna kusinthitsa mindandanda yamitengo kapena madongosolo kuchokera ku malo ogulitsira pa intaneti. M'malo momwe mindandanda ili yaying'ono, ndiye kuti imatha kuyendetsedwa pamanja, koma bwanji ngati ilipo mazana mazana a zinthu? Kuti muchepetse njirayi, mutha kuyang'ana pazowonjezera zina.
Pafupifupi mitundu yonse ya zikalata ndi yoyenera kulayisha yokha:
- Mndandanda wazinthu;
- Mndandanda wazofanana;
- Mndandanda wamtengo;
- Mndandanda wamalamulo;
- Zambiri pazogula kapena malonda, ndi zina.
Ziyenera kudziwika nthawi yomweyo kuti mu 1C palibe zida zopangidwira zomwe zingakulore kusamutsa deta kuchokera ku Excel. Pazifukwa izi, muyenera kulumikiza bootloader yakunja, yomwe ili fayilo epf.
Kukonzekera kwa deta
Tidzafunika kukonzekereratu zomwe zili mu Excel spreadsheet yomwe.
- Mndandanda uliwonse womwe wanyamula mu 1C uyenera kukhala wolinganizidwa bwino. Simungathe kutsitsa ngati pali mitundu ingapo ya zosowa mu foloko imodzi kapena khungu, mwachitsanzo, dzina la munthu komanso nambala ya foni. Potere, zolembedwa zofananazi ziyenera kugawidwa m'mitundu yosiyanasiyana.
- Maselo ophatikizidwa saloledwa, ngakhale pamutu. Izi zimatha kubweretsa zotsatira zolakwika posamutsa deta. Chifukwa chake, ngati maselo ophatikizika alipo, ayenera kupatulidwa.
- Ngati mungapangitse gwero la magwero kukhala losavuta komanso lolunjika popanda kugwiritsa ntchito matekinoloje (macros, formula, ndemanga, zolemba zapansipa, zinthu zina zosintha, zina), izi zikuthandizira kuteteza kwambiri mavuto mu njira zinanso zosamutsira.
- Onetsetsani kuti mwabweretsa dzina la kuchuluka kwake konse. Sichiloledwa kukhala ndi dzina, kilogalamu yowonetsedwa ndi mitundu ingapo: kg, "kilogalamu", "kg.". Pulogalamuyo idzawamvetsetsa ngati mitundu yosiyanasiyana, kotero muyenera kusankha njira imodzi yojambulira, ndikukonza zina zonse za template iyi.
- Zizindikiritso zapadera ndizofunikira. Gawo lingathe kuseweredwa ndi zomwe zili mgulu lililonse zomwe sizibwerezedwa pamizere ina: nambala ya msonkho, chiwerengero cha zolemba, ndi zina zambiri. Ngati tebulo lomwe mulibe mzere wokhala ndi mtengo wofanana, ndiye kuti mutha kuwonjezera gawo lina ndikuchita manambala osavuta pamenepo. Izi ndizofunikira kuti pulogalamuyo izindikire zomwezo mumzere uliwonse, ndipo osaziphatikiza.
- Maofesi ambiri a Excel sagwira ntchito ndi mtundu xxx, koma ndi mawonekedwe xx. Chifukwa chake, ngati chikalata chathu chili ndi chowonjezera xxx, ndiye muyenera kusintha. Kuti muchite izi, pitani ku tabu Fayilo ndipo dinani batani Sungani Monga.
Zenera lopulumutsa limatseguka. M'munda Mtundu wa Fayilo mtunduwo udzafotokozedweratu xxx. Sinthani kuti "Excel Book 97-2003" ndipo dinani batani Sungani.
Pambuyo pake, chikalatacho chidzasungidwa momwe mukufuna.
Kuphatikiza pazakuchita konseku pakukonzekera deta yomwe ili mu buku la Excel, zidzakhalanso zofunikira kubweretsa chikalatacho mogwirizana ndi zofunikira za bootloader inayake, yomwe tidzagwiritse ntchito, koma tidzalankhula za izi kanthawi kena.
Lumikizani bootloader yakunja
Lumikizani bootloader yakunja ndi kuwonjezera epf kugwiritsa ntchito 1C ndikotheka, onse musanakonzekere fayilo ya Excel, ndikatha. Chachikulu ndikuti mfundo zonse ziwiri zakukonzekera izi ziyenera kuthetsedwa ndikuyamba kwa kutsitsa.
Pali zida zingapo zapa tebulo za Excel zakunja za 1C, zomwe zimapangidwa ndi opanga osiyanasiyana. Tiona mwachitsanzo pogwiritsa ntchito chida chokonzera zidziwitso "Tikusitsa chidziwitso kuchokera ku chikalata chazipepala" za mtundu 1C 8.3.
- Pambuyo fayilo ali mu mtundu epf otsitsidwa ndikusungidwa pa hard drive ya computer, yendetsani pulogalamu 1C. Ngati fayilo epf utayikidwa mu nkhokwe, ziyenera kuyamba zachotsedwa pamenepo. Pamwambamwamba pomwe pali pulogalamuyo, dinani batani lomwe limayambitsa menyu. Mu mtundu 1C 8.3 umawonetsedwa ngati gawo lozungulira lomwe limalembedwa mozungulira mozungulira lalanje. Pa mndandanda womwe ukuwoneka, pitani zinthuzo Fayilo ndi "Tsegulani".
- Fayilo yotsegulira fayilo imayamba. Pitani ku dongosololi la malo ake, sankhani chinthucho ndikudina batani "Tsegulani".
- Pambuyo pake, bootloader iyamba 1C.
Tsitsani kusaka "Mumakonda kutsitsa kuchokera ku chikalata chazipepala"
Kusanja deta
Chimodzi mwazinthu zazikuluzikulu zomwe 1C imagwira ntchito ndi mndandanda wamitundu ndi ntchito zosiyanasiyana. Chifukwa chake, kuti tifotokozere njira yodulira kuchokera ku Excel, tiyeni tikambirane zitsanzo zosamutsira mtundu wa data uwu.
- Timabwereranso pazenera. Popeza tidzakweza mgululi wazogulitsa, mu paramu "Tsitsani ku" kusinthaku kuyenera kukhala pamalo "Buku". Komabe, imayikidwa mwachisawawa. Muyenera kusinthira pokhapokha ngati mukufuna kusinthitsa mtundu wina wa data: gawo la tabular kapena chidziwitso. Komanso m'munda "Mawonekedwe" dinani batani lomwe likuwonetsa ellipsis. Mndandanda wotsika pansi umatseguka. Mmenemo tiyenera kusankha "Nomenclature".
- Pambuyo pake, woperekera zakumasoyo amakonzekeretsa yekha magawo omwe pulogalamuyo imagwiritsa ntchito mtundu wamtunduwu. Zofunika kudziwa nthawi yomweyo kuti sikofunikira kuti mudzaze minda yonse.
- Tsopano tsegulani chikalata chowoneka cha Excel. Ngati dzina la mizati yake likusiyana ndi mayina akuminda yomwe ili mufayilo ya 1C, yomwe ili ndi zomwe zikugwirizana, ndiye kuti muyenera kutchulanso mizati iyi ku Excel kuti mayina agwirizane kwathunthu. Ngati pali mizati patebulopo pomwe mulibe mndandanda mu chikwatu, ndiye kuti ayenera kuchotsedwa. Kwa ife, mzati wotere ulipo "Kuchuluka" ndi "Mtengo". Tiyeneranso kuwonjezeredwa kuti dongosolo la zipilala mu chikalatacho liyenera kufanana kwenikweni ndi zomwe zaperekedwa pokonzekera. Ngati pazakola zina zomwe zikuwonetsedwa mu bootloader, mulibe deta, ndiye kuti izi ndizosiyidwa zopanda kanthu, koma kuwerengera kwa makalawo komwe tsambalo likupezeka liyenera kukhala lomwelo. Kuti muthane mosavuta komanso kuthamanga kwa kusintha, mutha kugwiritsa ntchito mawonekedwe apadera a Excel kuti musunthire mwachangu mizati m'malo.
Zitachitika izi, dinani pachizindikirocho Sungani, yomwe imawonetsedwa ngati chithunzi chosonyeza diski ya floppy kumtunda kumanzere kwa zenera. Kenako tsekani fayilo podina batani lozungulira.
- Timabwereranso kuwindo la 1C. Dinani batani "Tsegulani", yomwe imawonetsedwa ngati chikwatu chachikasu.
- Fayilo yotsegulira fayilo imayamba. Timapita kumalo osungira komwe chikalata cha Excel chomwe timafunikira chili. Chosinthira chosasinthika cha fayilo chidakhazikitsidwa kuti chikule mxl. Kuti muwonetse fayilo yomwe timafunikira, iyenera kukonzedwanso Phukusi lothandizira. Pambuyo pake, sankhani chikwatu chonyamula ndikudina batani "Tsegulani".
- Pambuyo pake, zomwe zili mkati zimatsegulidwa muzowongolera. Kuti muwone kulondola kwa kudzaza deta, dinani batani "Kudzaza kudziletsa".
- Monga mukuwonera, chida chowongolera chimatiuza kuti palibe zolakwa zomwe zidapezeka.
- Tsopano pitani ku tabu "Kukhazikitsa". Mu Bokosi Losaka ikani chidule pamzera womwe ukakhala wapadera pazinthu zonse zomwe zalembedwa mu chikwatu. Nthawi zambiri, minda imagwiritsidwa ntchito pamenepa. "Nkhani" kapena "Dzinalo". Izi ziyenera kuchitidwa kuti poonjezera maudindo atsopano pamndandandandawu, zomwe mwasankhazi sizichulukitsidwa.
- Pambuyo poti datha yonse yaikidwa ndipo makonzedwe atsirizidwa, mutha kupitiliza kukweza zidziwitso mwachinsinsi. Kuti muchite izi, dinani mawu olembedwa "Tsitsani deta".
- Njira yotsitsa ikuyenda. Mukamaliza, mutha kupita ku chikwatu cha nomenclature ndikuwonetsetsa kuti zofunikira zonsezo zimawonjezedwamo.
Phunziro: Momwe mungasinthire mizati mu Excel
Tinatsata njira yowonjezerera deta ku dilesi ya nomenclature mu 1C 8.3. Kwa zolemba zina ndi zikalata zina, kutsitsa kudzachitika chimodzimodzi, koma ndi zovuta zina zomwe wogwiritsa ntchito angadziwone okha. Tiyeneranso kudziwa kuti njirayi ikhoza kukhala yosiyana kwa omwe ali ndi chipani chachitatu, koma njira yokhayo imakhala yofanana kwa aliyense: choyamba, wowongolera amangolowera zenera kuchokera pa fayiloyo pazenera momwe amakonzedweramo, ndipo pokhapokha amawonjezedwa mwachindunji ku database ya 1C.
