Lezi zici zitholakala kuphela ekucushweni kohlelo olujwayelekile nolwephrofeshinali.
Sizocabangela isibonelo sokulayisha ububanzi bomkhiqizo kanye namabhalansi okuqala.
Ivula uhla lwemibhalo "i-nomenclature" ukuze ubone ukuthi uyingenisa kanjani idatha ohlelweni isuka kufayela elisha le- XLSX MS Excel .
Engxenyeni engenhla yewindi, chofoza kwesokudla ukuze ushayele imenyu yokuqukethwe bese ukhetha umyalo "Ngenisa" .
Iwindi le-modal lokungenisa idatha lizovela.
Sicela ufunde ukuthi kungani ungeke ukwazi ukufunda imiyalelo ngokuhambisana futhi usebenze efasiteleni elivelayo.
Ukungenisa isampula yefayela le- XLSX elisha, nika amandla inketho ye-' MS Excel 2007 '.
Sicela uqaphele ukuthi efayelini esizolingenisa ukuze silayishe into ngamabhalansi okuqala, kufanele kube nezinkambu ezinjalo. Okokuqala letha ifayela le-Excel efomini elidingekayo.
Amakholomu anezihloko eziluhlaza kufanele abe yimpoqo - lolu ulwazi oluyinhloko mayelana nobubanzi bomkhiqizo. Futhi ungafaka amakholomu anezihloko eziluhlaza okwesibhakabhaka efayeleni elingenisiwe uma ufuna uhlu lwamanani namabhalansi omkhiqizo agcwaliswe ngokungeziwe.
Bese ukhetha ifayela. Igama lefayela elikhethiwe lizofakwa endaweni yokufaka.
Manje qiniseka ukuthi ifayela elikhethiwe alivuliwe ohlelweni lwakho lwe- Excel .
Chofoza inkinobho ethi ' Okulandelayo '.
Ngemuva kwalokho, ifayela le-Excel elishiwo lizovuleka engxenyeni engakwesokudla yebhokisi lengxoxo. Futhi ohlangothini lwesobunxele, izinkambu zohlelo lwe- 'USU ' zizofakwa ohlwini. Skrolela phansi. Sizodinga izinkambu amagama azo aqala ngokuthi ' IMP_ '. Zenzelwe ukungenisa idatha .
Manje sidinga ukukhombisa ukuthi iyiphi inkambu yohlelo lwe- USU imininingwane evela kukholomu ngayinye yefayela le-Excel izongeniswa.
Okokuqala chofoza ' IMP_NAME ' inkambu kwesokunxele. Lapha yilapho igama lomkhiqizo ligcinwa khona.
Ngokuqhubekayo sichofoza kwesokudla kunoma iyiphi indawo yekholomu ' C '. Amagama ezimpahla asohlwini lwale kholomu yefayela elingenisiwe.
Bese kwakhiwa uxhumano. ' [Ishidi1]C ' izovela ohlangothini lwesobunxele lwegama lenkambu ' IMP_NAME '. Lokhu kusho ukuthi ulwazi luzolayishwa kule nkambu kusuka kukholomu ' C ' yefayela le-excel.
Ngomgomo ofanayo, sixhuma zonke ezinye izinkambu zohlelo lwe- 'USU ', siqala ngokuthi ' IMP_ ', namakholomu efayela le-excel. Uma ungenisa umugqa womkhiqizo onezinsalela, umphumela kufanele ubukeke kanje.
Manje ake sithole ukuthi isho ukuthini inkambu ngayinye yokungenisa.
IMP_BARCODE - ibhakhodi.
IMP_CAT - isigaba.
IMP_SUBCAT - isigatshana.
IMP_NAME - igama lomkhiqizo.
IMP_SKLAD - inqolobane.
IMP_AMOUNT - inani lezimpahla ezitholakalayo njengamanje endaweni yokugcina impahla eshiwo.
IMP_UNITS - amayunithi okulinganisa.
IMP_PRICE_POKUP - inani lokuthenga.
IMP_PRICE_SALE - intengo yokuthengisa.
Qaphela efasiteleni elifanayo ukuthi udinga ukweqa umugqa owodwa phakathi nenqubo yokungenisa, njengoba umugqa wokuqala wefayela le-excel awuqukethe idatha, kodwa izihloko zensimu.
Chofoza inkinobho ethi ' Okulandelayo '.
' Isinyathelo sesi-2 ' sizovela, lapho amafomethi ezinhlobo ezahlukene zedatha amiswa khona. Ngokuvamile asikho isidingo sokushintsha noma yini lapha.
Chofoza inkinobho ethi ' Okulandelayo '.
' Isinyathelo sesi-3 ' sizovela. Kuyo, sidinga ukusetha wonke ' amabhokisi okuhlola ', njengoba kukhonjisiwe emfanekisweni.
Uma sihlela ukungenisa esihlela ukukwenza ngezikhathi ezithile, ngakho-ke kungcono ukulondoloza zonke izilungiselelo kufayela lezilungiselelo ezikhethekile ukuze ungazisethi ngaso sonke isikhathi.
Kuyanconywa futhi ukuthi ulondoloze izilungiselelo zokungenisa uma ungenaso isiqiniseko sokuthi uzophumelela okokuqala.
Cindezela inkinobho ' Gcina isifanekiso '.
Senza igama lefayela lezilungiselelo zokungenisa. Kungcono ukuyigcina endaweni efanayo lapho ifayela ledatha likhona, ukuze yonke into ibe sendaweni eyodwa.
Uma usuzibalulile zonke izilungiselelo zokungenisa, singakwazi ukuqala inqubo yokungenisa ngokwayo ngokuchofoza inkinobho ethi ' Run '.
Ngemva kokubulawa, ungabona umphumela. Uhlelo luzobala ukuthi bangaki imigqa engezwe ohlelweni nokuthi bangaki abadale iphutha.
Kukhona nelogi yokungenisa. Uma kwenzeka amaphutha ngesikhathi sokwenza, wonke azochazwa kulogi nenkomba yomugqa wefayela le-excel.
Incazelo yamaphutha kulogi ingeyobuchwepheshe, ngakho-ke azodinga ukuboniswa kubahleli bezinhlelo be- 'USU ' ukuze basize ngokulungisa. Imininingwane yokuxhumana ibalwe kusizindalwazi usu.kz.
Chofoza inkinobho ethi ' Khansela ' ukuze uvale ibhokisi lokungenisa.
Siphendula umbuzo ngokuvuma.
Uma kungewona wonke amarekhodi awele iphutha, futhi amanye engeziwe, ngaphambi kokuthi uzame ukungenisa futhi, uzodinga ukukhetha futhi ususe amarekhodi angeziwe ukuze ukhiphe izimpinda esikhathini esizayo.
Uma sizama ukungenisa kabusha idatha, sibiza ingxoxo yokungenisa futhi. Kodwa kulokhu sicindezela inkinobho ' Layisha isifanekiso '.
Khetha ifayela elondolozwe ngaphambilini elinezilungiselelo zokungenisa.
Ngemva kwalokho, ebhokisini lengxoxo, yonke into izogcwaliswa ngendlela efanayo ncamashi naleyo yayiyiyo ngaphambili. Akukho okunye okudingeka kulungiselelwe! Igama lefayela, ifomethi yefayela, izixhumanisi phakathi kwezinkambu namakholomu ethebula le-excel nakho konke okunye kugcwalisa.
Ngenkinobho ethi ' Okulandelayo ', ungadlula ezinyathelweni ezilandelayo zebhokisi ukuze nje uqinisekise okungenhla. Noma vele ucindezele inkinobho ethi ' Run ' ngokushesha.
Uma wonke amaphutha elungisiwe, khona-ke ilogi yokukhipha idatha izobukeka kanje.
Uma umphakeli ehlala ekuthumela i-invoyisi yezimpahla ezithengiwe ngefomu le-elekthronikhi, awukwazi ukuyifaka mathupha, kodwa kalula. ngenisa .
Bona ngezansi ukuze uthole ezinye izihloko eziwusizo:
I-Universal Accounting System
2010 - 2024