Isandiso 1C sekuyisikhathi eside sibe uhlelo oludumile kunazo zonke phakathi kwabathengisi, abahleli, abomnotho nabaphathi. Ayinayo kuphela inombolo ehlukahlukene yokulungiselelwa kwezinhlobo ezahlukene zemisebenzi, kodwa futhi indawo yangaphakathi ngaphansi kwamazinga wokubalwa emazweni amaningi emhlabeni. Amabhizinisi amaningi futhi ashintshela ukubalwa kwezimali kulolu hlelo oluthile. Kodwa inqubo yokudlulisa idatha ngesandla kusuka kwesinye isofthiwe yokubala ku-1C impela umsebenzi omude futhi othakazelisayo, ukuthatha isikhathi esiningi. Uma inkampani ibilokhu iphendula ngokusebenzisa i-Excel, inqubo yokudlulisa ingaba yenzeke ngokuzenzakalelayo futhi ihambelane.
Kudluliswa kwedatha kusuka ku-Excel kuya ku-1C
Yenza ukudluliswa kwedatha kusuka ku-Excel kuya ku-1C akudingeki kuphela esikhathini sokuqala somsebenzi nalolu hlelo. Ngesinye isikhathi kunesidingo salokhu, ngenkathi usebenza umsebenzi udinga ukubeka ezinye izinhlu ezigcinwe encwadini yeprosesa ye-tabular. Isibonelo, uma ufuna ukudlulisa izinhlu zamanani noma ama-oda asuka esitolo se-intanethi. Endabeni lapho izinhlu zingaphansi, zingathunyelwa ngesandla, kodwa kuthiwani uma ziqukethe izinto eziningi? Ukuze uphuthukise inqubo, ungasebenzisa ezinye izici ezengeziwe.
Cishe zonke izinhlobo zamadokhumenti zifanele ukulayisha okuzenzakalelayo:
- Uhlu lokwehlukanisa;
- Uhlu lwamanqamuzana;
- Uhlu lwamanani;
- Uhlu lwama-oda;
- Ulwazi ngokuthenga noma ukuthengisa, njll.
Ngaso leso sikhathi kufanele kuqashelwe ukuthi ku-1C azikho amathuluzi akhiwe ngaphakathi angavumela ukudlulisa idatha kusuka ku-Excel. Ngale njongo, udinga ukuxhuma umthwalo wangaphandle, okuyifayela efomethi i-epf.
Ukulungiswa kwedatha
Sizodinga ukulungisa idatha etafuleni le-Excel ngokwayo.
- Noma yiluphi uhlu olulayishwe ku-1C kufanele luhlelwe ngendlela efanayo. Awukwazi ukwenza ukulanda uma kunezinhlobo eziningana zedatha kukholomu eyodwa noma ngeselula, isibonelo, igama lomuntu nenombolo yakhe yefoni. Kulesi simo, okufakiwe okuphindwe kabili kumele kuhlukaniswe ngamakholomu ahlukene.
- Awuvunyelwe ukuba ahlangane namaseli ngisho nasezihlokweni. Lokhu kungaholela emiphumeleni engalungile lapho kudluliswa idatha. Ngakho-ke, uma amaseli ahlanganisiwe ekhona, kudingeka ahlukaniswe.
- Uma ithebula elisuka kumthombo lenziwe njengento elula futhi eqondakalayo ngangokunokwenzeka ngaphandle kokusetshenziswa kobuchwepheshe obuyinkimbinkimbi (ama-macros, amafomula, amazwana, umbhalo waphansi, izici ezingenasidingo zokufometha, njll.), Lokhu kuzosiza ukuvimbela izinkinga ngangokunokwenzeka ezinyathelweni zokudlulisa ezalandela.
- Qinisekisa ukuthi ulethe igama lazo zonke izilinganiso kufomethi eyodwa. Awuvunyelwe ukuba negama, isibonelo, i-kilogram ekhonjiswe okufakiwe okuhlukile: "kg", "kilogram", "kg.". Lolu hlelo luzowaqonda njengamanani ahlukile, ngakho-ke kudingeka ukhethe inguqulo eyodwa yerekhodi, futhi ulungise okunye kwalesi sifanekiso.
- Ukuba khona okuphoqelekile kwezihlonzi eziyingqayizivele. Esikhundleni sabo kungase kube okuqukethwe kwanoma yiliphi ikholomu elingaphenduliwe kwezinye imigqa: inombolo ngayinye yentela, i-athikili, njll. Uma ithebula elikhona lingenakho ikholomu elinenani elifanayo, khona-ke ungangezela ikholomu eyengeziwe bese wenza ukubala okulula lapho. Lokhu kuyadingeka ukuze uhlelo lukwazi ukubona idatha emgqeni ngamunye ngokwehlukana, kunokuba "bahlanganise" ndawonye.
- Abanikazi abaningi befayela le-Excel asebenzi ngefomethi. xlsx, kodwa kuphela ngefomethi xls. Ngakho-ke, uma idokhumenti yethu inesandiso xlsxke udinga ukuguqula. Ukuze wenze lokhu, iya kuthebhu "Ifayela" bese uchofoza inkinobho "Londoloza".
Iwindi lokugcina livula. Ensimini "Uhlobo lwefayela" ifomethi izocaciswa ngokuzenzakalelayo xlsx. Shintsha kuya "Incwadi yokusebenzela ye-Excel 97-2003" bese uchofoza inkinobho "Gcina".
Emva kwalokho, idokhumenti izogcinwa kufomethi oyifunayo.
Ngaphezu kwalezi zenzo zomhlaba jikelele zokulungiselela idatha encwadini ye-Excel, kuzodingeka ukuthi ulethe idokhumenti ukuthi ihambisane nezidingo zomthwalo othile, esizoyisebenzisa, kepha sizoxoxa ngakho ngemuva kwesikhathi.
Ukuxhumeka kwe-bootloader yangaphandle
Xhuma i-bootloader yangaphandle ngesandiso i-epf I-Annex 1C ingaba, njengaphambi kokulungiselela ifayela le-Excel, nangemva kwalokho. Into esemqoka yukuthi ekuqaleni kokuqala kokuqalisa ibhulogi kokubili la maphuzu alungiselelwe axazululiwe.
Kunezintambo eziningi zangaphandle ze-Excel zamatafula we-1C adalwe ngabathuthukisi abahlukahlukene. Sizocabangela isibonelo ngokusebenzisa ithuluzi lokucubungula ulwazi. "Ilayisha idatha kumadokhumenti we-tabular" for version 1C 8.3.
- Ngemuva kwefomethi yefayela i-epf ilayishwe futhi igcinwa kwi-disk eyinkimbinkimbi yekhompyutha, sebenzisa uhlelo 1C. Uma ifayela i-epf ephakanyisiwe kungobo yomlando, kumele kuqala ikhishwe ukusuka lapho. Ekhasini lesicelo eliphezulu elingenhla, chofoza inkinobho eqala imenyu. Ngokwe-version 1C 8.3, iboniswa njengonxantathu ebhaliswe kwisiyingi se-orange, iphenduke phezulu. Kulolu hlu oluvela, isinyathelo ngesinyathelo "Ifayela" futhi "Vula".
- Iwindi lefayela elivulekile liqala. Iya kusiqondisi endaweni yayo, ukhethe into bese uchofoza inkinobho "Vula".
- Emva kwalokho, i-bootloader izoqala ngo-1C.
Ukucutshungulwa kokulanda "Ukulayisha idatha kumadokhumenti we-tabular"
Idatha yokulayisha
Enye yezinqolobane eziyinhloko lapho i-1C isebenza khona uhlu lwezimpahla namasevisi. Ngakho-ke, ukuchaza inqubo yokulayisha kusuka ku-Excel, ake sihlale esibonelweni sokudluliswa kwalolu hlobo oluthile lwedatha.
- Sibuyela ewindini lokucubungula. Njengoba sizobe silayishe uhla lwemikhiqizo, kupharamitha "Landa ku" inkinobho kufanele ibe sesikhundleni "Inkomba". Noma kunjalo, ifakwe ngokuzenzakalelayo. Kufanele usishintshe kuphela uma udlulisela olunye uhlobo lwedatha: ingxenye yombhalo noma irejista yolwazi. Okulandelayo ensimini "Ukubuka kwerekhodi" chofoza inkinobho, ekhombisa amachashazi. Uhlu lokudonsa luvuleka. Kulo, kufanele sikhethe into "Isiqongo".
- Emva kwalokhu, umphathi uhlela ngokuzenzakalelayo amasimu okusetshenziswa kulolu hlobo lwemibhalo. Kumele kuphawulwe ngokushesha ukuthi akudingekile ukugcwalisa wonke amasimu.
- Manje uphinde uvule idokhumenti ye-Excel ephathekayo. Uma igama lamakholomu alo lihlukile egameni lemikhakha yomhlahlandlela we-1C, equkethe okuhambisana nawo, khona-ke udinga ukuqamba kabusha le kholomu ku-Excel ukuze amagama ahambisane ngokuphelele. Uma kukhona amakholomu etafuleni okungekho amafananiselo ebhokisini lokubhekisela, kufanele asuswe. Esimweni sethu, amakholomu anjalo "Isibalo" futhi "Intengo". Kumele futhi wengeze ukuthi ukuhlelwa kwamalungiselelo amakholomu kumadokhumenti kufanele kuhambisane ngqo nalowo owethulwe ekucubunguleni. Uma kukho amakholomu athile aboniswa ku-loader, awunawo idatha, khona-ke lezi zikholomu zingashiywa zingenalutho, kodwa ukubalwa kwamakholomu lapho kunedatha kufanele kube okufanayo. Ukuze kube lula futhi ijubane lokuhlelwa, ungasebenzisa isici esikhethekile se-Excel ukuhambisa ngokushesha amakholomu ezindaweni.
Ngemuva kokuthi lezi zenzo zenziwe, chofoza isithonjana "Gcina"okuyinto enikezwa ngesimo sesithonjana esibonisa i-diskette ekhoneni eliphezulu elingakwesokunxele lewindi. Bese uvale ifayela ngokuchofoza inkinobho yokuvala evamile.
- Sibuyela ewindini lokucubungula le-1C. Sicindezela inkinobho "Vula"okuboniswa njengefolda ephuzi.
- Iwindi lefayela elivulekile liqala. Iya kusiqondisi lapho idokhumenti ye-Excel itholakala khona, esiyidingayo. I-switch default display display ihlelwe ukwandiswa. mxl. Ukuze sibonise ifayela esiyidingayo, udinga ukulihlele kabusha esikhundleni I-Excel Sheet. Emva kwalokho, khetha idokhumenti ephathekayo bese uchofoza inkinobho "Vula".
- Emva kwalokho, okuqukethwe kuvulwa kumphathi. Ukuze uhlole ukufaneleka kwedatha yokugcwalisa, chofoza inkinobho "Ukulawula ukugcwalisa".
- Njengoba ungabona, ithuluzi lokulawula lokugcwalisa lisitshela ukuthi awekho amaphutha atholakele.
- Manje hamba kuthebhu "Ukusetha". Ngaphakathi "Insimu yokusesha" sibeka umkhawulo kulowo mgca, ozobe ohlukile kuzo zonke izinto ezifakwe ohlwini lwemibhalo yegama lomsebenzisi. Ngokuvamile kakhulu kulezi zinsuku zokusebenzisa "Isihloko" noma "Igama". Lokhu kufanele kwenziwe ukuze uma ungeza izikhundla ezintsha ohlwini, idatha ngeke iphindwe.
- Ngemuva kokuthi yonke idatha ifakiwe futhi izilungiselelo zenziwe, ungaqhubeka nokulanda ngokuqondile kolwazi kumqondisi. Ukwenza lokhu, chofoza kulebula "Landa idatha".
- Inqubo ye-boot isebenza. Ngemva kokuqedela, ungaya ku-lwemibhalo yento bese uqinisekisa ukuthi yonke idatha edingekayo ingeziwe khona.
Isifundo: Ungashintsha kanjani amakholomu ku-Excel
Silandele inqubo yokwengeza idatha ebhokisini lokubhekisisa le-nomenclature ohlelweni 1C 8.3. Kwezinye izincwadi zokubhekisela kanye namadokhumenti, ukulanda kuzokwenziwa ngesimiso esifanayo, kodwa ngezinye izimo eziningana lapho umsebenzisi azokwazi ukuzibona eyedwa. Kumele kuqashelwe ukuthi inqubo yabaphathi bezithathu ezahlukeneyo ingase ihluke, kepha indlela ejwayelekile iyaqhubeka iyafana: okokuqala, umphathi wenkampani ephethe imininingwane esuka efayeleni efasiteleni lapho ihlelwa khona, bese yenezelwa ngqo ku-database ye-1C.
