Isikhathi eside isivele isicelo se-1C saba uhlelo oludumile kakhulu phakathi kwezimali, abahleli, osomnotho nabaphathi. Akukona kuphela inani elihlukile lokucushwa kwezinhlobo ezahlukahlukene zemisebenzi, kodwa futhi nokwenziwa kwasekhaya ngaphansi kwamazinga okubalwa kwezimali emazweni ambalwa womhlaba. Amabhizinisi amaningi andayo atshintshana nokubala imali kulolu hlelo oluthile. Kepha inqubo yokudlulisa imininingwane yedatha kusuka kwezinye izinhlelo zokubalwa kwemali iye ku-1C ngumsebenzi omude futhi odabukisayo, othatha isikhathi esiningi. Uma inkampani igcina amarekhodi isebenzisa i-Excel, inqubo yokudlulisa ingazenzekela kakhulu futhi isheshiswe.
Ukudluliswa kwedatha kusuka ku-Excel kuya ku-1C
Ukudlulisa idatha kusuka ku-Excel iye ku-1C akudingeki ngesikhathi sokuqala somsebenzi kuphela ngalolu hlelo. Kwesinye isikhathi kuvela lokhu, lapho phakathi komsebenzi udinga ukufaka uhlu oluthile olugcinwe encwadini yemisebenzi yetafula. Isibonelo, uma ufuna ukudlulisa uhlu lwamanani noma ama-oda avela esitolo se-inthanethi. Esimweni lapho uhlu lincane, khona-ke lungahanjwa ngesandla, kepha kuthiwani uma luqukethe amakhulu ezinto? Ukuze usheshise inqubo, ungaphendukela kwezinye izici ezengeziwe.
Cishe zonke izinhlobo zamadokhumenti zilungele ukulayishwa okuzenzakalelayo:
- Uhlu lwezinto;
- Uhlu lwabalingani;
- Uhlu lwamanani;
- Uhlu lwama-oda;
- Imininingwane mayelana nokuthenga noma ukuthengisa, njll.
Kufanele kwaziwe ngaleso sikhathi ukuthi e-1C awekho amathuluzi owakhelwe ngaphakathi angakuvumela ukuthi udlulise idatha esuka ku-Excel. Ngalezi zinhloso, udinga ukuxhuma i-bootloader yangaphandle, okuyifayela elifomethi i-epf.
Ukulungiswa kwedatha
Sizodinga ukulungiselela idatha ku-Excel ispredishithi uqobo.
- Noma yiluphi uhlu olulayishwe ku-1C kufanele luhlelwe ngendlela efanayo. Awukwazi ukulanda uma kunezinhlobo eziningi zedatha kwikholamu eyodwa noma iseli, ngokwesibonelo, igama lomuntu nenombolo yocingo. Kulokhu, amarekhodi aphindwe kanjalo kufanele ahlukaniswe ngamakholomu ahlukene.
- Amaseli ahlanganisiwe awavunyelwe, ngisho nakuheda. Lokhu kungaholela emiphumeleni engalungile lapho kudluliswa idatha. Ngakho-ke, uma amaseli ahlanganisiwe etholakala, kufanele ahlukaniswe.
- Uma wenza itafula lomthombo libe lula futhi liqonde ngangokunokwenzeka ngaphandle kokusebenzisa ubuchwepheshe obunzima (ama-macros, amafomula, amazwana, imibhalo yaphansi, izinto zokufometha ezingeziwe, njll.), Lokhu kuzosiza ukuvimbela kakhulu izinkinga ezinyathelweni ezengeziwe zokudlulisela.
- Qiniseka ukuthi uletha igama lawo wonke amanani ngefomethi eyodwa. Akuvunyelwe ukuthi kube negama, ngokwesibonelo, ikhilogremu ekhonjiswa ukufakwa okuhlukile: kg, "kilogram", "kg.". Uhlelo luzoziqonda njengamanani ahlukile, ngakho-ke udinga ukukhetha okukodwa kokuqopha, bese ulungisa okusele kule template.
- Izikhombi ezihlukile ziyadingeka. Indima ingadlalwa ngokuqukethwe kwanoma iyiphi ikholamu engaphindwa kweminye imigqa: inombolo yentela yomuntu ngamunye, inombolo yendatshana, njll. Uma ithebula elivele lingenayo ikholomu enenani elifanayo, ungangeza ikholomu eyengeziwe bese wenza izinombolo ezilula lapho. Lokhu kuyadingeka ukuze uhlelo lukwazi ukukhomba imininingwane emgqeni ngamunye ngokwahlukana, futhi hhayi "ukuhlanganisa" ndawonye.
- Iningi labaphathi befayela le-Excel alisebenzi nefomethi xlsx, kodwa kuphela ngefomethi xls. Ngakho-ke, uma idokhumenti lethu linesandiso xlsx, lapho-ke udinga ukuguqula. Ukuze wenze lokhu, iya kuthebhu Ifayela bese uchofoza inkinobho Gcina Njengo.
Iwindows yokulinda iyavula. Ensimini Uhlobo lwefayela ifomethi izocaciswa ngokuzenzakalelayo xlsx. Ishintshe ibe "I-Excel Book 97-2003" bese uchofoza inkinobho Gcina.
Ngemuva kwalokho, idokhumenti lizogcinwa ngendlela oyifunayo.
Ngaphezu kwalezi zenzo ezenziwa endaweni yonke zokulungiselela idatha encwadini ye-Excel, kuzodingeka futhi ukuletha idokhumenti ihambisane nezidingo ze-bootloader ethile, esizoyisebenzisa, kepha sizokhuluma ngalokhu kungekudala.
Xhuma i-bootloader yangaphandle
Xhuma i-bootloader yangaphandle nesandiso i-epf isicelo 1C kungenzeka, kokubili ngaphambi kokulungiswa kwefayela le-Excel, nangemva kwalokho. Into esemqoka ukuthi womabili la maphuzu wokulungiselela kufanele axazululwe ekuqaleni kwenqubo yokulanda.
Kunezilayishi ezimbalwa zetafula le-Excel zangaphandle ze-1C, ezakhiwa abathuthukisi abahlukahlukene. Sizocubungula isibonelo ngokusebenzisa ithuluzi lokucubungula imininingwane "Ukulayisha idatha kusuka kudokhumenti yespredishithi" yinguqulo 1C 8.3.
- Ngemuva kokuthi ifayela lisesimweni i-epf ukulandwa futhi kugcinwe kwi-hard drive yekhompyutha, sebenzisa uhlelo 1C. Uma ifayela i-epf ifakwe kungobo yomlando, kufanele ikhishwe kuqala lapho. Kwiphaneli ephezulu evundlile yohlelo, chofoza inkinobho esethula imenyu. Enguqulweni 1C 8.3 kuvezwa njengonxantathu obhalwe emjikelezweni we-orange, yaphenduka yabheka phansi. Kuluhlu olubonakala, dlula ezintweni Ifayela futhi "Vula".
- Ifayela elivulekile lefayela liqala. Iya kumkhombandlela wendawo yakhe, khetha leyo nto bese uchofoza inkinobho "Vula".
- Ngemuva kwalokho, i-bootloader izoqala ku-1C.
Ukulanda ukulanda "Ukulayisha idatha kusuka kudokhumenti yespredishithi"
Ukulayisha idatha
Enye yolwazi oluyinhloko i-1C esebenza nayo uhla lobubanzi bezimpahla nezinsizakalo. Ngakho-ke, ukuchaza inqubo yokulayisha evela kwa-Excel, ake sihlale esibonelweni sokudlulisa lolu hlobo lwedatha ethile.
- Sibuyela ewindini elisebenzayo. Njengoba sizolayisha uhla lomkhiqizo, kupharamitha "Landa ku-" switch kufanele ibe sesimweni "Inkomba". Noma kunjalo, ifakiwe ngokuzenzakalelayo. Kufanele uyiguqule kuphela lapho uhlela ukudlulisa olunye uhlobo lwedatha: isigaba se-tabular noma irejista yolwazi. Futhi endle "Ukubuka kwesiqondisi" chofoza inkinobho ekhombisa ama-ellipsis. Uhlu olwehlayo luvula. Kuyo kufanele sikhethe kuyo "Nomenclature".
- Emva kwalokho, isiphathi sihlela ngokuzenzakalelayo lezo zinkambu ezisetshenziswa yilolu hlelo kulolu hlobo lwemibhalo. Kufanele kuqashelwe ngaso leso sikhathi ukuthi akudingekile ukugcwalisa zonke izinkambu.
- Manje vula futhi idokhumenti ephathekayo ye-Excel. Uma igama lamakholomu alo lihluke kwigama lezinkambu kusikhombisi se-1C, esiqukethe okuhambelana, kuzodingeka uqambe kabusha la makholamu ku-Excel ukuze amagama ahlangane ngokuphelele. Uma kukhona amakholomu etafuleni okungekho okufana nalo kwisikhombi, kufanele asuswe. Okwethu, amakholomu anjalo "Ubuningi" futhi "Intengo". Kufanele futhi wengezwe ukuthi i-oda lamakholomu kudokhumenti kumele ahambisane ngokuqinile nelethulwa ekucutshungweni. Uma kwamanye amakholomu aboniswe ku-bootloader, awunayo idatha, lawo makholomu angashiywa engenalutho, kepha ukubalwa kwalelo kholamu lapho idatha etholakalayo kufanele kufane. Ukuze kube lula nesivinini sokuhlela, ungasebenzisa isici esikhethekile se-Excel ukuhambisa ngokushesha amakholomu ezindaweni.
Ngemuva kokuthi lezi zenzo zenziwe, chofoza kusithonjana Gcina, eyethulwa njengesithonjana esibonisa idiski ye-floppy ekhoneni elingaphezulu ngakwesobunxele lewindi. Ngemuva kwalokho vala ifayela ngokuchofoza inkinobho evamile evaliwe.
- Sibuyela ewindini lokucubungula le-1C. Chofoza inkinobho "Vula", ekhonjiswa njengefolda ephuzi.
- Ifayela elivulekile lefayela liqala. Siya enkombeni lapho idokhumenti ye-Excel esiyidingayo itholakala. I-switch ye-default file isethelwe ukunwetshwa mxl. Ukuze sikhombise ifayela esilidingayo, lidinga ukuhlelwa kabusha Ishidi lokusebenzela. Ngemuva kwalokho, khetha idokhumenti ephathekayo bese uchofoza inkinobho "Vula".
- Ngemuva kwalokho, okuqukethwe kuvulwa kusiphathi. Ukubheka ukunemba kokugcwaliswa kwemininingwane, chofoza inkinobho "Ukulawula ukugcwalisa".
- Njengoba ubona, ithuluzi lokulawula lokugcwalisa lisitshela ukuthi awekho amaphutha atholakele.
- Manje hambisa kuthebhu "Iyasethela". In Ibhokisi Lokucinga faka uphawu kumugqa ozobe uhlukile kuzo zonke izinto ezifakwe ohlwini lwemibhalo. Imvamisa, amasimu asetshenziselwa lokhu. "I-athikili" noma "Igama". Lokhu kumele kwenziwe ukuze lapho ungeza izikhundla ezintsha ohlwini, idatha ayiphindwe kabili.
- Ngemuva kokuthi yonke imininingwane ifakiwe futhi izilungiselelo seziqediwe, ungaqhubeka nokulayisha okuqondile kolwazi kusiqondisi. Ukuze wenze lokhu, chofoza okubhaliwe "Landa idatha".
- Inqubo yokulanda iyaqhubeka. Ngemuva kokuphothulwa, ungaya kwisikhombi se-nomenclature futhi uqiniseke ukuthi yonke imininingwane edingekayo iyangezwa lapho.
Isifundo: Ungashintsha kanjani amakholamu ku-Excel
Silandele inqubo yokufaka idatha kumkhombandlela we-nomenclature ku-1C 8.3. Kweminye imikhombandlela kanye namadokhumenti, ukulanda kuzokwenziwa ngomgomo ofanayo, kepha ngezifiso ezithile umsebenzisi angazitholela zona ngokwazo. Kufanele futhi kwaziwe ukuthi inqubo ingahluka kubantu abalayisha uhlangothi oluhlukile, kepha indlela ejwayelekile ihlala ifana kuwo wonke umuntu: okokuqala, umphathi ophethe ulayisha imininingwane esuka kufayela awuse ewindini lapho ihlelwe khona, futhi kuphela lapho ke ifakwa ngqo kudathabhethi ye-1C.
