{"id":668,"date":"2026-10-07T15:47:07","date_gmt":"2026-10-07T13:47:07","guid":{"rendered":"https:\/\/datenquelle.at\/?page_id=668"},"modified":"2026-10-08T07:10:22","modified_gmt":"2026-10-08T05:10:22","slug":"chyby-pri-importu-csv-overit-format-a-hodnoty","status":"publish","type":"page","link":"https:\/\/cz.datenquelle.at\/index.php\/chyby-pri-importu-csv-overit-format-a-hodnoty\/","title":{"rendered":"Chyby p\u0159i importu CSV: ov\u011b\u0159it form\u00e1t a hodnoty"},"content":{"rendered":"<div class=\"et_pb_section_0 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_0 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_0 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_0 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-hero\" id=\"dq-main\"><div class=\"dq-wrap\"><nav class=\"dq-breadcrumbs\" aria-label=\"Drobe\u010dkov\u00e1 navigace\"><a href=\"https:\/\/cz.datenquelle.at\/\">\u00davod<\/a><span>\/<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/\">Chyby & \u0158e\u0161en\u00ed<\/a><span>\/<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/#import\">Import & Export<\/a><\/nav><p class=\"dq-eyebrow\"><span class=\"dq-dot\" aria-hidden=\"true\"><\/span>Import & Export<\/p><h1>Chyby p\u0159i importu CSV: posunut\u00e9 sloupce, zm\u011bn\u011bn\u00e9 hodnoty?<\/h1><p class=\"dq-lead\">Soubor CSV popisuje hodnoty jako text. P\u0159i otev\u0159en\u00ed nebo importu c\u00edlov\u00fd program ur\u010duje, jak interpretuje sloupce a datov\u00e9 typy. Stejn\u00fd soubor proto m\u016f\u017ee v n\u00e1hledu vypadat spr\u00e1vn\u011b, zat\u00edmco dal\u0161\u00ed program zm\u011bn\u00ed \u010d\u00edsla polo\u017eek nebo \u010d\u00edseln\u00e9 hodnoty.<\/p><ol class=\"dq-help-flow\" aria-label=\"Cesta dat a kontroln\u00ed bod\"><li><span>Zdroj<\/span><strong>P\u016fvodn\u00ed export<\/strong><\/li><li class=\"is-checkpoint\"><span>Ov\u011b\u0159it propojen\u00ed<\/span><strong>Form\u00e1t & Pravidla pol\u00ed<\/strong><\/li><li><span>C\u00edl<\/span><strong>Import do c\u00edle<\/strong><\/li><\/ol><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_1 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_1 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_1 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_1 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-body\"><div class=\"dq-wrap\"><div class=\"dq-help-layout\"><article class=\"dq-help-article\"><section class=\"dq-help-situation\"><h2>Jak se to projevuje v praxi<\/h2><p>Export z ERP je p\u0159ipraven. P\u0159i importu je najednou v\u0161e v jednom sloupci, diakritika je chybn\u00e1 nebo se z 00123 stane 123. Za\u010dn\u011bte s nezm\u011bn\u011bnou kopi\u00ed p\u016fvodn\u00edho souboru. Soubor u\u017e otev\u0159en\u00fd a znovu ulo\u017een\u00fd v Excelu nen\u00ed spolehliv\u00fdm z\u00e1kladem pro porovn\u00e1n\u00ed.<\/p><\/section><section id=\"ursachen\"><h2>Rozli\u0161it typick\u00e9 p\u0159\u00ed\u010diny<\/h2><div class=\"dq-help-causes\"><div><h3>Jin\u00fd odd\u011blova\u010d<\/h3><p>Zdroj a c\u00edl mohou odli\u0161n\u011b o\u010dek\u00e1vat \u010d\u00e1rku nebo st\u0159edn\u00edk. N\u00e1hled importu pom\u00e1h\u00e1 s orientac\u00ed.<\/p><\/div><div><h3>Znakov\u00e1 sada nebo odd\u011blova\u010d textu<\/h3><p>Diakritika, uvozovky a odd\u011blova\u010de uvnit\u0159 pole mus\u00ed odpov\u00eddat o\u010dek\u00e1van\u00e9mu zpracov\u00e1n\u00ed.<\/p><\/div><div><h3>Automatick\u00fd p\u0159evod datov\u00e9ho typu<\/h3><p>Excel m\u016f\u017ee odstranit po\u010d\u00e1te\u010dn\u00ed nuly nebo zm\u011bnit dlouh\u00e1 \u010d\u00edsla. Identifik\u00e1tory polo\u017eek b\u00fdvaj\u00ed text, i kdy\u017e obsahuj\u00ed pouze \u010d\u00edslice.<\/p><\/div><\/div><\/section><section id=\"pruefen\"><h2>Co m\u016f\u017eete nejprve zkontrolovat<\/h2><ol class=\"dq-help-checks\"><li><h3>Uchovat p\u016fvodn\u00ed soubor beze zm\u011bny<\/h3><p>Pracujte s kopi\u00ed a poznamenejte si, ze kter\u00e9ho programu poch\u00e1z\u00ed a s jak\u00fdm nastaven\u00edm byla exportov\u00e1na.<\/p><\/li><li><h3>Pou\u017e\u00edt n\u00e1hled m\u00edsto p\u0159\u00edm\u00e9ho importu<\/h3><p>Ov\u011b\u0159te sloupce, znakovou sadu a prvn\u00ed reprezentativn\u00ed \u0159\u00e1dky. V Excelu lze import p\u0159es \u201eZ textu\/CSV\u201c p\u0159ipravit c\u00edlen\u011bji ne\u017e pouh\u00fdm dvojklikem.<\/p><\/li><li><h3>Porovnat probl\u00e9mov\u00e9 \u0159\u00e1dky<\/h3><p>Vyberte b\u011b\u017en\u00fd \u0159\u00e1dek a jeden s diakritikou, pr\u00e1zdnou hodnotou, dlouh\u00fdm identifik\u00e1torem nebo po\u010d\u00e1te\u010dn\u00ed nulou. Produk\u010dn\u00ed c\u00edl p\u0159i t\u00e9to kontrole z\u016fst\u00e1v\u00e1 nezm\u011bn\u011bn.<\/p><\/li><\/ol><\/section><section id=\"tiefer\"><h2>Kdy\u017e je probl\u00e9m hlub\u0161\u00ed<\/h2><p>Syntakticky \u010diteln\u00fd import m\u016f\u017ee b\u00fdt p\u0159esto v\u011bcn\u011b chybn\u00fd: \u010d\u00edslo polo\u017eky, jednotka nebo datum nemus\u00ed odpov\u00eddat c\u00edli. Proto dohodneme p\u0159i\u0159azen\u00ed pol\u00ed, povinn\u00e9 hodnoty a zpracov\u00e1n\u00ed odm\u00edtnut\u00fdch \u0159\u00e1dk\u016f. Opakovan\u00e9 ru\u010dn\u00ed opravy pak lze p\u0159ev\u00e9st na \u0159\u00edzen\u00fd proces.<\/p><div class=\"dq-help-details\"><details><summary>Rozli\u0161it identifik\u00e1tory od \u010d\u00edsel<\/summary><p>\u010c\u00edslo polo\u017eky je identifik\u00e1tor. To, \u017ee obsahuje jen \u010d\u00edslice, neur\u010duje jeho datov\u00fd typ. Tot\u00e9\u017e plat\u00ed pro po\u0161tovn\u00ed sm\u011brovac\u00ed \u010d\u00edsla nebo z\u00e1kaznick\u00e9 k\u00f3dy. Zdroj a c\u00edl mus\u00ed zachovat stejn\u00fd v\u00fdznam; samotn\u00e9 hezk\u00e9 zobrazen\u00ed nesta\u010d\u00ed.<\/p><\/details><details><summary>Opakovateln\u00fd import m\u00edsto m\u011bs\u00ed\u010dn\u00edch dodate\u010dn\u00fdch oprav<\/summary><p>U pl\u00e1novan\u00e9ho postupu zaznamen\u00e1me vstupn\u00ed form\u00e1t, v\u00fdsledek kontroly a zp\u011btnou vazbu. Neplatn\u00e9 \u0159\u00e1dky pot\u0159ebuj\u00ed rozpoznateln\u00e9 zpracov\u00e1n\u00ed. Nov\u00fd n\u00e1zev souboru nebo op\u011btovn\u00e9 odesl\u00e1n\u00ed nesm\u00ed nepozorovan\u011b vytvo\u0159it stejnou zak\u00e1zku podruh\u00e9.<\/p><\/details><\/div><\/section><section id=\"weiter\"><h2>Kdy d\u00e1v\u00e1 podpora smysl<\/h2><p>Pokud je nutn\u00e9 ka\u017ed\u00fd soubor ru\u010dn\u011b upravovat nebo se chybn\u00e9 hodnoty projev\u00ed a\u017e pozd\u011bji, d\u00e1v\u00e1 smysl definovan\u00fd import. Na za\u010d\u00e1tek sta\u010d\u00ed anonymizovan\u00fd uk\u00e1zkov\u00fd soubor a popis c\u00edlov\u00e9ho programu.<\/p><a class=\"dq-help-service\" href=\"https:\/\/cz.datenquelle.at\/index.php\/automatizovat-data\/\"><span>Vhodn\u00e9 \u0159e\u0161en\u00ed<\/span><strong>Automatizovat zpracov\u00e1n\u00ed soubor\u016f a import dat<\/strong><span class=\"dq-ui-arrow\" aria-hidden=\"true\"><\/span><\/a><aside class=\"dq-help-cross\"><p>Pro slo\u017eit\u00e1 p\u0159i\u0159azen\u00ed pol\u00ed, datov\u00e9 modely a v\u00edcef\u00e1zov\u00e9 zpracov\u00e1n\u00ed nab\u00edz\u00ed DataSource technick\u00e9 prohlouben\u00ed.<\/p><a href=\"https:\/\/datasource.at\/\" rel=\"noopener\">Dal\u0161\u00ed informace u DataSource<span class=\"dq-ui-external\" aria-hidden=\"true\"><\/span><\/a><\/aside><\/section><section class=\"dq-help-sources\"><h2>Zdroje pro technickou orientaci<\/h2><ul><li><a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/get-started\/import-or-export-text-txt-or-csv-files\" rel=\"noopener\">Microsoft: Import textov\u00fdch soubor\u016f a CSV<\/a><\/li><li><a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/keeping-leading-zeros-and-large-numbers\" rel=\"noopener\">Microsoft: Zachov\u00e1n\u00ed po\u010d\u00e1te\u010dn\u00edch nul a velk\u00fdch \u010d\u00edsel<\/a><\/li><\/ul><p>Odborn\u011b ov\u011b\u0159eno 7. \u0159\u00edjna 2026. Informace v\u00fdrobc\u016f se vztahuj\u00ed k uveden\u00fdm produkt\u016fm; nenahrazuj\u00ed ov\u011b\u0159en\u00ed va\u0161\u00ed konkr\u00e9tn\u00ed konfigurace.<\/p><\/section><\/article><aside class=\"dq-help-toc\"><nav aria-label=\"Na t\u00e9to str\u00e1nce n\u00e1pov\u011bdy\"><span class=\"dq-kicker\">Na t\u00e9to str\u00e1nce<\/span><a href=\"#ursachen\">Typick\u00e9 p\u0159\u00ed\u010diny<\/a><a href=\"#pruefen\">Prvn\u00ed kontroly<\/a><a href=\"#tiefer\">Technick\u00e9 souvislosti<\/a><a href=\"#weiter\">Vhodn\u00e9 \u0159e\u0161en\u00ed<\/a><\/nav><div><span class=\"dq-kicker\">Souvisej\u00edc\u00ed probl\u00e9my<\/span><a href=\"https:\/\/cz.datenquelle.at\/index.php\/nezname-nebo-nedokumentovane-rozhrani\/\">Nezn\u00e1m\u00e9 nebo nedokumentovan\u00e9 rozhran\u00ed<\/a><a href=\"https:\/\/cz.datenquelle.at\/index.php\/prevzit-data-ze-stareho-programu\/\">P\u0159evz\u00edt data ze star\u00e9ho programu<\/a><a href=\"https:\/\/cz.datenquelle.at\/index.php\/chyby-a-reseni-pro-vase-data\/\">Na p\u0159ehled t\u00e9mat<\/a><\/div><\/aside><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div><div class=\"et_pb_section_2 et_pb_section et_section_regular et_flex_section\">\n<div class=\"et_pb_row_2 et_pb_row et_flex_row\">\n<div class=\"et_pb_column_2 et_pb_column et-last-child et_flex_column et_pb_css_mix_blend_mode_passthrough et_flex_column_24_24 et_flex_column_24_24_tablet et_flex_column_24_24_phone\">\n<div class=\"et_pb_code_2 et_pb_code et_pb_module\"><div class=\"et_pb_code_inner\"><section class=\"dq-section dq-help-contact-section\"><div class=\"dq-wrap\"><div class=\"dq-help-contact\"><div><h2>Spole\u010dn\u011b vyjasnit dal\u0161\u00ed krok.<\/h2><p>Na za\u010d\u00e1tek sta\u010d\u00ed n\u00e1zvy program\u016f a stru\u010dn\u00fd popis probl\u00e9mu.<\/p><\/div><a class=\"dq-button\" href=\"https:\/\/cz.datenquelle.at\/index.php\/proberme-vas-problem-s-daty\/\" aria-haspopup=\"dialog\" aria-controls=\"dq-booking-modal\" data-dq-booking>Domluvit \u00favodn\u00ed rozhovor<\/a><\/div><\/div><\/section><\/div><\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Vymezte probl\u00e9my importu CSV s odd\u011blova\u010di, diakritikou, \u010d\u00edsly polo\u017eek a datov\u00fdmi typy. Uchovejte zdrojov\u00fd soubor a p\u0159ipravte opakovateln\u00fd import.<\/p>\n","protected":false},"author":2,"featured_media":709,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-668","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/comments?post=668"}],"version-history":[{"count":4,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/668\/revisions"}],"predecessor-version":[{"id":811,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/pages\/668\/revisions\/811"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media\/709"}],"wp:attachment":[{"href":"https:\/\/cz.datenquelle.at\/index.php\/wp-json\/wp\/v2\/media?parent=668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}