Sauke bayanai daga littafin aiki na Excel zuwa 1C

Na dogon lokaci tuni aikace-aikacen 1C ya zama mafi mashahuri shirin a cikin masu lissafi, masu tsara shirye-shirye, masana tattalin arziki da manajoji. Ba kawai keɓance ɗumbin wurare don ayyukan daban-daban ba, amma har ma da ƙaddamar da maƙasudin lissafi a cikin ƙasashe da yawa na duniya. Andarin kamfanoni da yawa suna juyawa zuwa lissafi a cikin wannan shirin musamman. Amma tsarin canja wurin bayanai da hannu daga wasu shirye-shiryen lissafi zuwa 1C aiki ne mai matukar tsayi kuma mai daukar hankali, wanda ke daukar lokaci mai yawa. Idan kamfanin ya kiyaye bayanan ta amfani da Excel, za a iya sarrafa mai saurin sarrafa kansa da saurin aiki.

Canja wurin bayanai daga Excel zuwa 1C

Canja wurin bayanai daga Excel zuwa 1C ba kawai a farkon lokacin aiki tare da wannan shirin ba. Wasu lokuta buƙatu ta taso don wannan, lokacin da ake gudanar da aiki kuna buƙatar shigar da wasu jerin lambobin da aka adana a cikin littafin processor processor. Misali, idan kuna son canja wurin jerin farashin ko umarni daga kantin sayar da kan layi. A cikin yanayin yayin jerin suna da ƙananan, to ana iya tura su da hannu, amma menene idan sun ƙunshi ɗaruruwan abubuwa? Domin hanzarta hanyar, zaku iya komawa zuwa wasu ƙarin fasaloli.

Kusan dukkan nau'ikan takaddun sun dace don shigarwa ta atomatik:

• Jerin abubuwan;
• Jerin takwarorinsu;
• Jerin farashi;
• Jerin umarni;
• Bayanai game da siye ko siyarwa, da sauransu.

Ya kamata a sani yanzunnan cewa a cikin 1C babu kayan aikin ginannun da zasu ba ku damar canja wurin bayanai daga Excel. Don waɗannan dalilai, kuna buƙatar haɗa bootloader na waje, wanda shine fayil a cikin tsari epf.

Shirya bayanai

Muna buƙatar shirya bayanai a cikin babbar falle da kanta.

1. Duk wani jeri da aka ɗora a cikin 1C ya kamata ya kasance mai tsari ɗaya. Ba za ku iya zazzagewa ba idan akwai nau'ikan bayanai da yawa a cikin shafi ɗaya ko kwayar, misali, sunan mutum da lambar waya. A wannan yanayin, irin waɗannan bayanan rikodin dole ne a rarrabe zuwa bangarori daban-daban.



2. Ba a yarda da sel da aka haɗa ba, har ma da kai. Wannan na iya haifar da sakamakon da ba daidai ba lokacin canja wurin bayanai. Saboda haka, idan ana haɗu da ƙwayoyin da ke hade, dole ne a raba su.



3. Idan kun sanya teburin tushe a matsayin mai sauƙi kuma madaidaiciya kamar yadda zai yiwu ba tare da yin amfani da kayan fasahar daɗaɗɗa ba (macros, dabaru, sharhi, ƙasan ƙafa, abubuwan ƙarin tsara abubuwa, da sauransu), wannan zai taimaka don hana matsaloli a matakan na gaba na canja wuri.



4. Tabbatar kawo sunan kowane adadi zuwa tsari ɗaya. Ba a ba da izinin yin zane ba, alal misali, kilogram ta hanyar shigar daban-daban: kilogiram, "kilogram", "kg.". Shirin zai fahimce su a matsayin dabi'u daban-daban, saboda haka kuna buƙatar zaɓar zaɓi ɗaya rakodi, kuma gyara ragowar don wannan samfurin.



5. Musamman masu gano abubuwa ana buƙata. Matsayi na iya buga shi ta abubuwan da ke cikin kowane shafi wanda ba a maimaita shi akan sauran layin ba: lambar haraji mutum, lambar labarin, da sauransu. Idan tebur ɗin da ke yanzu ba shi da shafi tare da darajar daidai, to, zaku iya ƙara ƙarin shafi kuma ku yi adadi mai sauƙi a can. Wannan ya zama dole don shirin zai iya tantance bayanan a cikin kowane layi daban, kuma ba '' haɗa 'su tare.



6. Yawancin masu kula da fayil ɗin Excel ba su aiki tare da tsari xlsx, amma tare da tsarin xls. Sabili da haka, idan takaddarmu tana da tsawa xlsx, sannan kuna buƙatar canza shi. Don yin wannan, je zuwa shafin Fayiloli kuma danna maballin Ajiye As.

   

   Wurin ajiyewa yana buɗewa. A fagen Nau'in fayil Tsarin zai bayyana shi ta tsohuwa xlsx. Canza shi zuwa "Kundin littafi mai kyau 97-2003" kuma danna maballin Ajiye.

   

   Bayan haka, za a adana takaddun a tsarin da ake so.

Bayan waɗannan ayyuka na duniya don shirya bayanai a cikin littafin Excel, zai kuma zama wajibi a kawo takaddun daidai da buƙatun takamaiman bootloader, wanda zamu yi amfani da shi, amma zamuyi magana game da wannan kadan.

Haɗa bootloader na waje

Haɗa bootloader na waje tare da mai tsawo epf zuwa aikace-aikacen 1C mai yiwuwa ne, duka biyu kafin shiri na fayil ɗin Excel, da kuma bayan. Babban abu shi ne cewa duka waɗannan matakan shirye-shiryen ya kamata a warware su ta farkon tsarin saukarwa.

Akwai masu saukar tebur na Excel na waje da yawa don 1C, waɗanda masu haɓaka haɓaka daban-daban suka kirkiresu. Za muyi la'akari da misali amfani da kayan aiki don sarrafa bayanai "Ana loda bayanai daga takaddara falle" don sigar 1C 8.3.

1. Bayan fayil ɗin yana cikin tsari epf sauke da adana a cikin rumbun kwamfutarka, gudanar da shirin 1C. Idan fayil epf kunshe a cikin kayan adana kayan tarihin, dole ne a fara fitar da shi daga can. A saman kwance a saman aikace-aikace, danna maɓallin da ke buɗe menu. A fasalin 1C 8.3 an gabatar dashi azaman alwatika a rubuce a cikin da'irar Orange, an juye juye. A lissafin da ya bayyana, tafi cikin abubuwan Fayiloli da "Bude".



2. Fayil bude taga yana farawa. Je zuwa wurin shugabanci na matsayinta, zaɓi abin da kuma danna maballin "Bude".



3. Bayan haka, bootloader zai fara a 1C.

Sauke aiki "Ana loda bayanai daga takaddun falle"

Ana saka bayanai

Daya daga cikin manyan bayanan bayanan da 1C ke aiki da su shine jerin abubuwan kayatarwa da ayyuka. Sabili da haka, don bayyana tsarin ɗora daga Excel, bari muyi la'akari da misalin canja wurin wannan nau'in bayanan.

1. Mun koma taga aiki. Tunda zamu sauke kewayon samfurin, a cikin sigogi "Zazzagewa" Wajibi ya kamata ya kasance cikin matsayi "Tunani". Koyaya, an shigar dashi ta tsohuwa. Ya kamata ku canza shi kawai lokacin da kuke shirin canja wurin wani nau'in bayanai: sashen yanki ko rajistar bayanan. Ci gaba a fagen "Tsarin adireshi" danna maɓallin da ke nuna ellipsis. Lissafin faɗakarwa yana buɗewa. A ciki ya kamata mu zaba "Mazanci".



2. Bayan haka, mai aikin yakan shirya wadancan filayen da shirin yayi amfani da shi ta wannan nau'in. Ya kamata a sani yanzunnan cewa ba lallai ba ne a cika dukkan filayen.



3. Yanzu sake sake buɗe takardar takaddar Excel. Idan sunan laƙabinsa ya bambanta da sunan filayen da ke cikin 1C directory, wanda ke ɗauke da waɗanda suka yi daidai, to kuna buƙatar sake sunan waɗannan ginshiƙan a cikin Excel saboda sunayen suna gaba ɗaya. Idan akwai ginshikai a cikin teburin wanda babu analogues a cikin kundin, to ya kamata a share su. A cikin lamarinmu, irin waɗannan ginshiƙai sune "Yawan" da "Farashin". Hakanan za'a kara da cewa umarnin ginshiƙai a cikin takaddun dole ne yayi daidai da wanda aka gabatar a cikin aikin. Idan don wasu ginshiƙai da aka nuna a cikin bootloader, ba ku da bayanai, to za a iya barin waɗannan ginshiƙan ba komai, amma lambobin waɗancan ginshiƙai inda bayanai suke akwai ya zama iri ɗaya ne. Don dacewa da saurin gyara, zaku iya amfani da fasalin Excel na musamman don motsa ginshiƙai cikin sauri.

   Bayan an gama waɗannan ayyukan, danna kan gunkin Ajiye, wanda aka gabatar azaman gunkin da ke nuni da faifan floppy disk a saman kusurwar hagu na taga. Sannan rufe fayil ɗin ta danna maɓallin rufewa na yau da kullun.



4. Mun koma zuwa kan taga 1C. Latsa maballin "Bude", wanda aka nuna azaman jaka mai launin rawaya.



5. Fayil bude taga yana farawa. Mun je kan jagora inda takaddar Excel da muke buƙata ta kasance. An saita canjin nuni na tsohuwar fayil don fadada mxl. Domin nuna fayil ɗin da muke buƙata, ana buƙatar sake shirya shi Takardar aiki mai kyau. Bayan haka, zaɓi ɗan daftarin aiki kuma danna maɓallin "Bude".



6. Bayan wannan, an buɗe abubuwan da ke cikin mai amfani. Don bincika daidaito na cika bayanai, danna maɓallin "Cika iko".



7. Kamar yadda kake gani, kayan aikin sarrafawa cike yake gaya mana cewa ba a sami kurakurai ba.



8. Yanzu matsar da shafin "Saiti". A Akwatin Bincike saka alama a cikin layi wanda zai zama na musamman ga duk abubuwan da aka lissafa a cikin jerin mutanen da basu san su ba. Mafi sau da yawa, ana amfani da filaye don wannan. "Labari" ko "Suna". Dole ne a yi wannan saboda lokacin da aka ƙara sababbin matsayi a cikin lissafin, bayanan ba su ninka biyu.



9. Bayan an shigar da bayanan duka kuma an gama saitunan, zaku iya ci gaba zuwa ɗakin bayanan kai tsaye a cikin directory. Don yin wannan, danna kan rubutun "Zazzage bayanai".



10. Tsarin saukarwa yana ci gaba. Bayan an kammala shi, zaku iya zuwa kundin adireshi na tabbatarwa sannan kuma a tabbata cewa an hada dukkan bayanan da suka wajaba a wurin.

Darasi: Yadda ake canza ginshiƙai a cikin Excel

Mun bi hanya don ƙara bayanai a cikin littafin mutanen da ke cikin 1C 8.3. Ga wasu kundin adireshi da takardu, za a aiwatar da zazzagewar a kan manufa ɗaya, amma tare da wasu lambobi waɗanda mai amfani zasu iya tantance kansu. Hakanan ya kamata a lura cewa hanyar na iya bambanta ga masu ɗaukar nauyin ɓangare na uku, amma janar ɗin ya kasance iri ɗaya ne ga kowa da kowa: na farko, mai ɗaukar nauyin ya ɗora bayanan daga fayil ɗin zuwa taga inda aka shirya shi, kuma kawai sai an ƙara kai tsaye zuwa cikin bayanan 1C.