{"id":5533,"date":"2025-08-15T17:53:23","date_gmt":"2025-08-15T14:53:23","guid":{"rendered":"https:\/\/wiki.alldevice.com\/?post_type=docs&#038;p=5533"},"modified":"2026-02-23T10:43:06","modified_gmt":"2026-02-23T07:43:06","password":"","slug":"kuidas-exceli-tabeli-abil-varuosi-alldevice-keskkonda-importida","status":"publish","type":"docs","link":"https:\/\/wiki.alldevice.com\/et\/d\/kuidas-exceli-tabeli-abil-varuosi-alldevice-keskkonda-importida","title":{"rendered":"Varuosade import Exceli tabeli abil"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong><a href=\"#eksport-faili-kasutamine\">Eksport faili kasutamine<\/a> | <a href=\"#impordi-n\u00e4idisfail\">Impordi n\u00e4idisfaili kasutamine<\/a> | <a href=\"#kasulik-teada\">Kasulik teada<\/a> | <a href=\"#soovitused\">Soovitused <\/a>| <a href=\"#enamlevinud-vead\">Enamlevinud vead<\/a><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kuidas Exceli tabeli abil varuosi Alldevice keskkonda importida?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Varuosade andmeid v\u00f5ib Alldevice CMMS keskkonda importida kahel eesm\u00e4rgil, uute varuosade lisamiseks v\u00f5i olemasolevate varuosade andmete (mass) uuendamiseks, v\u00f5i m\u00f5lemat korraga.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Selleks, et andmeid importida peame esmalt hankima n\u00e4idisfaili, millesse andmeid lisada v\u00f5i eksportima olemasolevate varuosade andmed, milles teha muudatused ning seej\u00e4rel tagasi importida.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Suvalises formaadis Exceli faili importimine Alldevice rakendusse ei ole v\u00f5imalik.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"eksport-faili-kasutamine\"><strong>Olemasoleva eksport faili kasutamine<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Varuosa andmete eksport faili hankimiseks kliki \u00fclemisel men\u00fc\u00fcribal nupule \u201cVaruosad\u201d. Vajadusel seadista filtrid ning seej\u00e4rel vajuta lehe paremal \u00fclemises nurgas olevale nupule \u201cEksport\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1175\" height=\"223\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-eksport-cmms-keskkonnast.png\" alt=\"\" class=\"wp-image-7084\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-eksport-cmms-keskkonnast.png 1175w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-eksport-cmms-keskkonnast-300x57.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-eksport-cmms-keskkonnast-1024x194.png 1024w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-eksport-cmms-keskkonnast-768x146.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-eksport-cmms-keskkonnast-360x68.png 360w\" sizes=\"auto, (max-width: 1175px) 100vw, 1175px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>NB!<\/strong> Kui te ei n\u00e4e \u201cEksport\u201d ja\/v\u00f5i \u201cImport\u201d nuppu, puuduvad teie kasutajal \u00f5igused vastava toimingu teostamiseks.<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">Eksporditud Exceli failis n\u00e4ete k\u00f5iki varuosakaardiga seotud andmete tulpasid mille olete tabelis n\u00e4htavaks teinud.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"116\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/Varuosade-xls-fail-importimiseks.png\" alt=\"\" class=\"wp-image-7116\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/Varuosade-xls-fail-importimiseks.png 940w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/Varuosade-xls-fail-importimiseks-300x37.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/Varuosade-xls-fail-importimiseks-768x95.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/Varuosade-xls-fail-importimiseks-360x44.png 360w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tehke muudatused soovitud lahtrites soovitud ridadel ning salvestage fail.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pea meeles, et fail sisaldab k\u00f5iki varuosakaardil olevaid andmeid (tulpasid), kuid mitte k\u00f5ik neist ei ole imporditavad\/muudetavad, vaid informatiivsed (neid v\u00e4lju impordi k\u00e4igus ignoreeritakse).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tulpade kogus ning j\u00e4rjestus eksporditud failis s\u00f5ltub sellest, kuidas olete varuosa tabeli vaate seadistanud.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>ID: <\/strong>Varuosakaardi andmebaasi tunnus (seda numbrit ei tohi muuta ega ise sisestada)<\/li>\n\n\n\n<li><strong>Kood: <\/strong>Varuosa kood (muudetav)<\/li>\n\n\n\n<li><strong>Nimetus: <\/strong>Varuosa nimetus (muudetav)<\/li>\n\n\n\n<li><strong>Kategooria: <\/strong>Varuosa kategooria (muudetav)<\/li>\n\n\n\n<li><strong>Tootja: <\/strong>Varuosa tootja \/ br\u00e4nd (muudetav)<\/li>\n\n\n\n<li><strong>Langes alla min varu: <\/strong>Kuup\u00e4ev, millal nimetatud varuosa kogus langes alla miinimum koguse v\u00e4\u00e4rtuse (informatiivne)<\/li>\n\n\n\n<li><strong>Viimati kasutatud: <\/strong>Kuup\u00e4ev, millal nimetatud varuosa viimati kasutati (informatiivne)<\/li>\n\n\n\n<li><strong>Minimaalkogus: <\/strong>Varuosa miinimum kogus, mida soovite laos hoida (muudetav)<\/li>\n\n\n\n<li><strong>Laos: <\/strong>Varuosa kogus laos (informatiivne) <sup data-fn=\"da7c310e-a22c-49e5-acdd-2463eb34159d\" class=\"fn\"><a href=\"#da7c310e-a22c-49e5-acdd-2463eb34159d\" id=\"da7c310e-a22c-49e5-acdd-2463eb34159d-link\">1<\/a><\/sup><\/li>\n\n\n\n<li><strong>Broneeritud: <\/strong>Varuosade kogus, mis on juba t\u00f6\u00f6k\u00e4skudele broneeritud (informatiivne)<\/li>\n\n\n\n<li><strong>Saadaval: <\/strong>Vakantsete varuosade kogus. Laos \u2013 Broneeritud = Saadaval (informatiivne)<\/li>\n\n\n\n<li><strong>Km%: <\/strong>M\u00fc\u00fcgihinna k\u00e4ibemaksu protsent (muudetav)<\/li>\n\n\n\n<li><strong>M\u00fc\u00fcgihind (0% km): <\/strong>Varuosa m\u00fc\u00fcgihind(muudetav) <sup data-fn=\"d62d7236-7c16-400e-a3c6-8529a43ec3ca\" class=\"fn\"><a href=\"#d62d7236-7c16-400e-a3c6-8529a43ec3ca\" id=\"d62d7236-7c16-400e-a3c6-8529a43ec3ca-link\">2<\/a><\/sup><\/li>\n\n\n\n<li><strong>M\u00fc\u00fcgihind (+km): <\/strong>Varuosa m\u00fc\u00fcgihind koos k\u00e4ibemaksuga (informatiivne) <sup data-fn=\"69bafbb8-4faa-4d7c-9d3f-5744ade9d80a\" class=\"fn\"><a href=\"#69bafbb8-4faa-4d7c-9d3f-5744ade9d80a\" id=\"69bafbb8-4faa-4d7c-9d3f-5744ade9d80a-link\">3<\/a><\/sup><\/li>\n\n\n\n<li><strong>Pealadu: <\/strong>Varuosade kogus pealaos (informatiivne)<\/li>\n\n\n\n<li><strong><em>Ladu 1: <\/em><\/strong>Varuosade koguskliendi poolt loodud laos&nbsp; (informatiivne) <sup data-fn=\"b9b45173-925d-42fa-842e-5da2fadf7229\" class=\"fn\"><a href=\"#b9b45173-925d-42fa-842e-5da2fadf7229\" id=\"b9b45173-925d-42fa-842e-5da2fadf7229-link\">4<\/a><\/sup><\/li>\n\n\n\n<li><strong><em>Ladu 2:<\/em> \u2026<\/strong><\/li>\n\n\n\n<li><strong>Maksumus: <\/strong>Varuosa soetusmaksumus (muudetav v\u00f5i informatiivne) <sup data-fn=\"44145816-1582-4f65-a3ee-4a596da8acab\" class=\"fn\"><a href=\"#44145816-1582-4f65-a3ee-4a596da8acab\" id=\"44145816-1582-4f65-a3ee-4a596da8acab-link\">5<\/a><\/sup><\/li>\n\n\n\n<li><strong>EAN: <\/strong>Varuosa triipkoodi kood (muudetav)<\/li>\n\n\n\n<li><strong><em>Lisav\u00e4li 1<\/em>: <\/strong>Kliendi poolt varuosakaardile loodud lisav\u00e4li (muudetav) <sup data-fn=\"efa79087-f2ab-49e7-97e9-b2b6710eab7d\" class=\"fn\"><a href=\"#efa79087-f2ab-49e7-97e9-b2b6710eab7d\" id=\"efa79087-f2ab-49e7-97e9-b2b6710eab7d-link\">6<\/a><\/sup><\/li>\n\n\n\n<li><strong><em>Lisav\u00e4li 2<\/em>: <\/strong>\u2026<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>NB! <\/strong>Kui teie ekspordi fail ei sisalda m\u00f5nda \u00fclal loetletud v\u00e4ljadest, siis ei olnud need tulbad teil tabelis aktiveeritud (n\u00e4htavad). Tulpade aktiveerimise kohta saad lugeda <a href=\"\/et\/d\/tabelvaated\">SIIT<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>T\u00c4HTIS MEELES PIDADA!!!<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00c4rge muutke tabeli tulpade peakirju<\/li>\n\n\n\n<li>\u00c4rge muutke \u201cID_\u201d tulbas olevat (v\u00f5i puuduvat) numbrit.\n<ul class=\"wp-block-list\">\n<li>Kui ID v\u00e4li on t\u00e4idetud, toimub importimisel viidatud ID\u2019ga varuosakaardi andmete muutmine andmebaasis. Kui muudate ID numbrit v\u00f5ib import \u00fcle kirjutada varuosa andmed, mida te ei soovinud muuta.<\/li>\n\n\n\n<li>Kui ID v\u00e4li on t\u00e4itmata, toimub uue varuosa lisamine andmebaasi<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Exceli impordi abil ei ole v\u00f5imalik varuosi kustutada. Kui kustutate eksporditud failist m\u00f5ned read ning impordite selle faili tagasi Alldevice rakendusse, siis tabelist eemaldatud ridu andmebaasist ei eemaldata.<\/li>\n\n\n\n<li>Varuosa kategooriad ja tootja nimetused peavad olema eelnevalt rakendusse sisestatud<\/li>\n\n\n\n<li>Korraga saab importida maksimaalselt 3000 rida<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Muudetud faili importimiseks klikkige lehe paremas nurgas olevale nupule \u201cImport\u201d. Avanenud lehel kliki kausta ikoonile ning otsi \u00fcles soovitud Exceli dokument, mida soovid importida.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"149\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-import-faili-upload.png\" alt=\"\" class=\"wp-image-7122\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-import-faili-upload.png 938w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-import-faili-upload-300x48.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-import-faili-upload-768x122.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-import-faili-upload-360x57.png 360w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Peale faili valimist laetakse see serverisse ning asetatakse \u201cOstukorvi\u201d impordi eelseks \u00fclevaatuseks \/ kontrolliks.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"177\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-valideerimine.png\" alt=\"\" class=\"wp-image-7127\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-valideerimine.png 938w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-valideerimine-300x57.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-valideerimine-768x145.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-valideerimine-360x68.png 360w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui andmetes on vigu, kuvatakse vastava rea eest punane kolmnurga ikoon (k\u00f5ik veaga read kuvatakse alati alguses) ning mittesobilik andmev\u00e4li m\u00e4rgistatakse punase punktiirjoonega (\u00fclal olevas n\u00e4idises \u201cKategooria\u201d). Vead kuvatakse, kui vastavat tootjat v\u00f5i kategooriat ei ole Alldevice andmebaasi loodud v\u00f5i on tulnud sisse kirjaviga v\u00f5i kui andmed on vales formaadis (n\u00e4iteks proovite numbri v\u00e4ljale importida teksti).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vigade parandamiseks kliki v\u00e4ljal ning tee muudatused v\u00f5i soorita valik (tootja nimetuse v\u00f5i kategooria puhul). V\u00f5ite ka parandused teha l\u00e4hte failis ning selle uuesti \u00fcles laadida, kuid siis \u00e4rge unustage eelnevalt vajutada nupule \u201cEemalda k\u00f5ik\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Soovikorral v\u00f5ite ka vigase rea tabelist eemaldada. Selleks tehke vastaval real parem klikk ning valige \u201cKustuta\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui soovitud tootja v\u00f5i varuosa kategooria puudub, ei ole vaja importi katkestada. V\u00f5ite minna otse seadistustesse ning soovitud kirjed lisada ning seej\u00e4rel naasta varuosade impordi lehele (kui olete lehe vahepeal sulgenud, j\u00e4\u00e4vad andmed siiski meelde ning lehe avamisel, saate j\u00e4tkata sealt, kus pooleli j\u00e4i). Muudatuste n\u00e4gemiseks vajutage lehe all servas olevale v\u00e4rskendamise nupule.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"484\" height=\"128\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/impordi-andmete-varskendamine.png\" alt=\"\" class=\"wp-image-7132\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/impordi-andmete-varskendamine.png 484w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/impordi-andmete-varskendamine-300x79.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/impordi-andmete-varskendamine-360x95.png 360w\" sizes=\"auto, (max-width: 484px) 100vw, 484px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui tabel sisaldab v\u00e4hemalt \u00fchte vigast rida, ei lubata importi l\u00f5pule viia. Teile kuvatakse ka vastav veateade ning import katkestatakse koheselt (mitte \u00fchtegi rida ei impordita).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"152\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/viga-varuosade-importimisel.png\" alt=\"\" class=\"wp-image-7135\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/viga-varuosade-importimisel.png 772w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/viga-varuosade-importimisel-300x59.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/viga-varuosade-importimisel-768x151.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/viga-varuosade-importimisel-360x71.png 360w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui k\u00f5ik read on ilusasti \u201crohelised\u201d, vajutage nupule \u201cAlusta importimist\u201d.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tehtud \ud83d\ude0a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"impordi-n\u00e4idisfail\"><strong>Impordi n\u00e4idisfaili kasutamine<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Uute varuosade importimiseks v\u00f5ib kasutada varuosade ekspordi faili ja lisada uued lisatavad read faili l\u00f5ppu. V\u00f5ib ka eespool olevad read kustutada ning t\u00e4ita sama faili, nagu kirjeldasime \u00fclalpool aga v\u00f5ib alla laadida ka impordi n\u00e4idisfaili.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Selleks kliki \u00fclemiselt men\u00fc\u00fcribal nupule \u201cVaruosad\u201d, avanenud lehe paremas nurgas vali \u201cImport\u201d ning sealt omakorda \u201cImpordi n\u00e4idisfail\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"139\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-xls-naidisfaili-allalaadimine.png\" alt=\"\" class=\"wp-image-7140\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-xls-naidisfaili-allalaadimine.png 940w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-xls-naidisfaili-allalaadimine-300x44.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-xls-naidisfaili-allalaadimine-768x114.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-xls-naidisfaili-allalaadimine-360x53.png 360w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui avate impordi n\u00e4idisfaili, leiate sealt kolm t\u00f6\u00f6lehte (Sheet)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"938\" height=\"236\" src=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-naidisfail.png\" alt=\"\" class=\"wp-image-7143\" srcset=\"https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-naidisfail.png 938w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-naidisfail-300x75.png 300w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-naidisfail-768x193.png 768w, https:\/\/wiki.alldevice.com\/wp-content\/uploads\/2025\/08\/varuosade-impordi-naidisfail-360x91.png 360w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Spares<\/strong> \u2013 Siia lehele sisestate andmed, mida soovite importida<\/li>\n\n\n\n<li><strong>Categories<\/strong> \u2013 Siit leiad spikriks k\u00f5ikide varuosa kategooriate nimetused, mis on Alldevice rakendusse sisestatud. Vajadusel saab siit kopeerida kategooria nimetusi varuosade (Spares) lehel kasutamiseks<\/li>\n\n\n\n<li><strong>Manufacturers<\/strong> \u2013 Siit leiad spikriks k\u00f5ikide teostajate nimetused, mis on Alldevice rakendusse sisestatud.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tulbad impordi faili \u201cSpares\u201d lehel:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>ID: <\/strong>Varuosakaardi andmebaasi tunnus (seda numbrit ei tohi muuta ega ise sisestada)<\/li>\n\n\n\n<li><strong>Kood: <\/strong>Varuosa kood<\/li>\n\n\n\n<li><strong>EAN: <\/strong>Varuosa triipkoodi kood<\/li>\n\n\n\n<li><strong>Nimetus: <\/strong>Varuosa nimetus<\/li>\n\n\n\n<li><strong>Kategooria: <\/strong>Varuosa kategooria<\/li>\n\n\n\n<li><strong>Tootja: <\/strong>Varuosa tootja \/ br\u00e4nd<\/li>\n\n\n\n<li><strong>Minimaalkogus: <\/strong>Varuosa miinimum kogus, mida soovite laos hoida<\/li>\n\n\n\n<li><strong>Maksumus: <\/strong>Varuosa soetusmaksumus <sup data-fn=\"8ec5a12a-7ddb-49ab-ab32-b7fb70f3923f\" class=\"fn\"><a href=\"#8ec5a12a-7ddb-49ab-ab32-b7fb70f3923f\" id=\"8ec5a12a-7ddb-49ab-ab32-b7fb70f3923f-link\">7<\/a><\/sup><\/li>\n\n\n\n<li><strong>M\u00fc\u00fcgihind (0% km): <\/strong>Varuosa m\u00fc\u00fcgihind <sup data-fn=\"cdf77d28-9bf2-4994-8db2-0f5a29078bc8\" class=\"fn\"><a href=\"#cdf77d28-9bf2-4994-8db2-0f5a29078bc8\" id=\"cdf77d28-9bf2-4994-8db2-0f5a29078bc8-link\">8<\/a><\/sup><\/li>\n\n\n\n<li><strong>Km%: <\/strong>M\u00fc\u00fcgihinna k\u00e4ibemaksu protsent<\/li>\n\n\n\n<li><strong><em>Lisav\u00e4li 1<\/em>: <\/strong>Kliendi poolt varuosakaardile loodud lisav\u00e4li <sup data-fn=\"9e601252-a543-4abb-902f-5637ab7c4a11\" class=\"fn\"><a href=\"#9e601252-a543-4abb-902f-5637ab7c4a11\" id=\"9e601252-a543-4abb-902f-5637ab7c4a11-link\">9<\/a><\/sup><\/li>\n\n\n\n<li><strong><em>Lisav\u00e4li 2<\/em>: <\/strong>\u2026<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Kui failis on k\u00f5ik soovitud read t\u00e4idetud, salvesta see ning impordi Alldevice rakendusse, nagu on juba kirjeldatud eespool.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"kasulik-teada\">Kasulik teada<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kui m\u00f5ne lahtri \u00fcmbris on oraan\u017e, juhib see t\u00e4helepanu duplikaadi olemasolule aga see ei blokeeri impordi l\u00e4biviimist.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui m\u00f5ne lahtri \u00fcmbris on punane, juhib see t\u00e4helepanu kriitilisele <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Alldevice lubab importida identse koodiga erinevaid varuosi. Erinevate tootjate erinevatel varuosadel v\u00f5ivad tootekoodid kattuda. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Alldevice lubab importida identse nimega erinevaid varuosi. Sama varuosa aga erinevalt tootjalt. Ikka tuleb ette.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Alldevice EI LUBA importida sama nime ja koodiga varuosa. Seda loetakse duplikaadiks ning see ei ole lubatud.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Alldevice EI LUBA importida duplikaat EAN koodi. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"soovitused\"><strong>Soovitused<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kui kasutate importimiseks eksport faili, salvestage muudetav fail uue nimega, et vigade korral oleks v\u00f5imalik originaal fail uuesti tagasi importida ja algne olukord taastada.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kui kasutate impordi funktsiooni esimest korda, proovige esialgu m\u00f5ne reaga, et aru saada, kuidas s\u00fcsteem toimib. Kui midagi l\u00e4heb valesti, on m\u00f5nda \u00fcksikut rida \/ varuosa Alldevices korrigeerida lihtsam, kui sadu v\u00f5i tuhandeid varuosi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"enamlevinud-vead\"><strong>Enamlevinud vead<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kui importisite uued varuosad Alldevice rakendusse ja seej\u00e4rel avastasite, te midagi j\u00e4i andmetes puudu v\u00f5i l\u00e4ks valesti, siis \u00e4rge tehke muudatusi\/parandusi samasse faili ning \u00e4rge importige seda faili uuesti. Kui te seda teete, saate dubleeritud andmed. Seda seet\u00f5ttu, et algfail ei sisalda varuosa ID\u2019d ning rakendus k\u00e4itleb seda soovina lisada uusi varuosi.<br><br>Kui on vaja korrigeerida imporditud andmeid, tehke varuosadest eksport, muutke andmed selles failis ning importige see tagasi rakendusse. Sellisel juhul sisaldab tabel ID_ tulbas ka korrektseid andmebaasi ID numbreid, mille alusel teab rakendus, et soovite varuosa andmeid uuendada ja mitte uusi varuosasid lisada.<\/li>\n\n\n\n<li>\u00c4rge kasutage impordi failis valemeid.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><br><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n\n\n<ol class=\"wp-block-footnotes\"><li id=\"da7c310e-a22c-49e5-acdd-2463eb34159d\">Laoseisu muutmine toimub ainult l\u00e4bi laoliikumiste. Selle kohta saad lisaks lugeda <a href=\"\/et\/d\/kuidas-suurendada-varuosade-laoseisu\">SIIT<\/a>. <a href=\"#da7c310e-a22c-49e5-acdd-2463eb34159d-link\" aria-label=\"Jump to footnote reference 1\">\u21a9\ufe0e<\/a><\/li><li id=\"d62d7236-7c16-400e-a3c6-8529a43ec3ca\">K\u00e4ibemaks ja m\u00fc\u00fcgihind on n\u00e4htaval siis, kui varuosade mooduli funktsionaalsusest on aktiveeritud m\u00fc\u00fcgihinna kuvamine varuosakaardil. See funktsioon on suunatud teenuse pakkujatele. <a href=\"#d62d7236-7c16-400e-a3c6-8529a43ec3ca-link\" aria-label=\"Jump to footnote reference 2\">\u21a9\ufe0e<\/a><\/li><li id=\"69bafbb8-4faa-4d7c-9d3f-5744ade9d80a\">K\u00e4ibemaks ja m\u00fc\u00fcgihind on n\u00e4htaval siis, kui varuosade mooduli funktsionaalsusest on aktiveeritud m\u00fc\u00fcgihinna kuvamine varuosakaardil. See funktsioon on suunatud teenuse pakkujatele.\u00a0 <a href=\"#69bafbb8-4faa-4d7c-9d3f-5744ade9d80a-link\" aria-label=\"Jump to footnote reference 3\">\u21a9\ufe0e<\/a><\/li><li id=\"b9b45173-925d-42fa-842e-5da2fadf7229\">Antud tulbad on kuvatud juhul, kui olete lisanud Alldevice keskkonda t\u00e4iendavaid ladusid. Tulpade arv s\u00f5ltub sisestatud ladude arvust ning tulpade nimed vastavad teie poolt sisestatud ladude nimetustele (Ladu 1, Ladu 2 on toodud n\u00e4idisena). <a href=\"#b9b45173-925d-42fa-842e-5da2fadf7229-link\" aria-label=\"Jump to footnote reference 4\">\u21a9\ufe0e<\/a><\/li><li id=\"44145816-1582-4f65-a3ee-4a596da8acab\">Maksumus on imporditav \/ muudetav, kui antud toote laoseis on null. Sellisel juhul omab maksumus informatiivset t\u00e4hendust (eeldatav maksumus). Kui varuosade kogus laos on erinev nullist, kujuneb toote maksumus vastavalt sisseostu hindadele (kaalutud keskmine).<br> <a href=\"#44145816-1582-4f65-a3ee-4a596da8acab-link\" aria-label=\"Jump to footnote reference 5\">\u21a9\ufe0e<\/a><\/li><li id=\"efa79087-f2ab-49e7-97e9-b2b6710eab7d\">Kliendi poolt Alldevice keskkonda sisestatud varuosade lisav\u00e4ljad. T\u00e4psemalt saad lugeda <a href=\"\/et\/d\/varuosakaardi-lisavaljade-loomine\">SIIT<\/a> <a href=\"#efa79087-f2ab-49e7-97e9-b2b6710eab7d-link\" aria-label=\"Jump to footnote reference 6\">\u21a9\ufe0e<\/a><\/li><li id=\"8ec5a12a-7ddb-49ab-ab32-b7fb70f3923f\">Maksumus on imporditav \/ muudetav, kui antud toote laoseis on null. Sellisel juhul omab maksumus informatiivset t\u00e4hendust (eeldatav maksumus). Kui varuosade kogus laos on erinev nullist, kujuneb toote maksumus vastavalt sisseostu hindadele (kaalutud keskmine). <a href=\"#8ec5a12a-7ddb-49ab-ab32-b7fb70f3923f-link\" aria-label=\"Jump to footnote reference 7\">\u21a9\ufe0e<\/a><\/li><li id=\"cdf77d28-9bf2-4994-8db2-0f5a29078bc8\">M\u00fc\u00fcgihind ja k\u00e4ibemaks on n\u00e4htavad siis, kui varuosade mooduli funktsionaalsusest on aktiveeritud m\u00fc\u00fcgihinna kuvamine varuosakaardil <em>(Funktsioon on suunatud teenuse pakkujatele)<\/em>. <a href=\"#cdf77d28-9bf2-4994-8db2-0f5a29078bc8-link\" aria-label=\"Jump to footnote reference 8\">\u21a9\ufe0e<\/a><\/li><li id=\"9e601252-a543-4abb-902f-5637ab7c4a11\">Kliendi poolt Alldevice keskkonda sisestatud varuosade lisav\u00e4ljad. T\u00e4psemalt saad lugeda <a href=\"\/et\/d\/varuosakaardi-lisavaljade-loomine\">SIIT<\/a> <a href=\"#9e601252-a543-4abb-902f-5637ab7c4a11-link\" aria-label=\"Jump to footnote reference 9\">\u21a9\ufe0e<\/a><\/li><\/ol>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Eksport faili kasutamine | Impordi n\u00e4idisfaili kasutamine | Kasulik teada | Soovitused | Enamlevinud vead Kuidas Exceli tabeli abil varuosi [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"bd_labels":[],"footnotes":"[{\"content\":\"Laoseisu muutmine toimub ainult l\u00e4bi laoliikumiste. Selle kohta saad lisaks lugeda <a href=\\\"\/et\/d\/kuidas-suurendada-varuosade-laoseisu\\\">SIIT<\/a>.\",\"id\":\"da7c310e-a22c-49e5-acdd-2463eb34159d\"},{\"content\":\"K\u00e4ibemaks ja m\u00fc\u00fcgihind on n\u00e4htaval siis, kui varuosade mooduli funktsionaalsusest on aktiveeritud m\u00fc\u00fcgihinna kuvamine varuosakaardil. See funktsioon on suunatud teenuse pakkujatele.\",\"id\":\"d62d7236-7c16-400e-a3c6-8529a43ec3ca\"},{\"content\":\"K\u00e4ibemaks ja m\u00fc\u00fcgihind on n\u00e4htaval siis, kui varuosade mooduli funktsionaalsusest on aktiveeritud m\u00fc\u00fcgihinna kuvamine varuosakaardil. See funktsioon on suunatud teenuse pakkujatele.\u00a0\",\"id\":\"69bafbb8-4faa-4d7c-9d3f-5744ade9d80a\"},{\"content\":\"Antud tulbad on kuvatud juhul, kui olete lisanud Alldevice keskkonda t\u00e4iendavaid ladusid. Tulpade arv s\u00f5ltub sisestatud ladude arvust ning tulpade nimed vastavad teie poolt sisestatud ladude nimetustele (Ladu 1, Ladu 2 on toodud n\u00e4idisena).\",\"id\":\"b9b45173-925d-42fa-842e-5da2fadf7229\"},{\"content\":\"Maksumus on imporditav \/ muudetav, kui antud toote laoseis on null. Sellisel juhul omab maksumus informatiivset t\u00e4hendust (eeldatav maksumus). Kui varuosade kogus laos on erinev nullist, kujuneb toote maksumus vastavalt sisseostu hindadele (kaalutud keskmine).<br>\",\"id\":\"44145816-1582-4f65-a3ee-4a596da8acab\"},{\"content\":\"Kliendi poolt Alldevice keskkonda sisestatud varuosade lisav\u00e4ljad. T\u00e4psemalt saad lugeda <a href=\\\"\/et\/d\/varuosakaardi-lisavaljade-loomine\\\">SIIT<\/a>\",\"id\":\"efa79087-f2ab-49e7-97e9-b2b6710eab7d\"},{\"content\":\"Maksumus on imporditav \/ muudetav, kui antud toote laoseis on null. Sellisel juhul omab maksumus informatiivset t\u00e4hendust (eeldatav maksumus). Kui varuosade kogus laos on erinev nullist, kujuneb toote maksumus vastavalt sisseostu hindadele (kaalutud keskmine).\",\"id\":\"8ec5a12a-7ddb-49ab-ab32-b7fb70f3923f\"},{\"content\":\"M\u00fc\u00fcgihind ja k\u00e4ibemaks on n\u00e4htavad siis, kui varuosade mooduli funktsionaalsusest on aktiveeritud m\u00fc\u00fcgihinna kuvamine varuosakaardil <em>(Funktsioon on suunatud teenuse pakkujatele)<\/em>.\",\"id\":\"cdf77d28-9bf2-4994-8db2-0f5a29078bc8\"},{\"content\":\"Kliendi poolt Alldevice keskkonda sisestatud varuosade lisav\u00e4ljad. T\u00e4psemalt saad lugeda <a href=\\\"\/et\/d\/varuosakaardi-lisavaljade-loomine\\\">SIIT<\/a>\",\"id\":\"9e601252-a543-4abb-902f-5637ab7c4a11\"}]"},"doc_category":[194],"doc_tag":[184,183,48],"class_list":["post-5533","docs","type-docs","status-publish","hentry","doc_category-kkk-varuosad","doc_tag-excel","doc_tag-import","doc_tag-varuosad"],"year_month":"2026-05","word_count":1222,"total_views":"186","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Veiko Kelk","author_nicename":"veiko","author_url":"https:\/\/wiki.alldevice.com\/et\/archives\/author\/veiko"},"doc_category_info":[{"term_name":"Varuosad","term_url":"https:\/\/wiki.alldevice.com\/et\/dc\/kkk-varuosad"}],"doc_tag_info":[{"term_name":"Excel","term_url":"https:\/\/wiki.alldevice.com\/et\/dt\/excel"},{"term_name":"Import","term_url":"https:\/\/wiki.alldevice.com\/et\/dt\/import"},{"term_name":"Varuosad","term_url":"https:\/\/wiki.alldevice.com\/et\/dt\/varuosad"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs\/5533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/comments?post=5533"}],"version-history":[{"count":1,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs\/5533\/revisions"}],"predecessor-version":[{"id":8756,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/docs\/5533\/revisions\/8756"}],"wp:attachment":[{"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/media?parent=5533"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/doc_category?post=5533"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/wiki.alldevice.com\/et\/wp-json\/wp\/v2\/doc_tag?post=5533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}