{"id":24137,"date":"2024-06-12T13:30:14","date_gmt":"2024-06-12T11:30:14","guid":{"rendered":"https:\/\/docs.prim.io\/prim-io-user-guide\/initial-data-imports\/common-problems\/"},"modified":"2024-06-12T13:30:14","modified_gmt":"2024-06-12T11:30:14","slug":"common-problems","status":"publish","type":"page","link":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/","title":{"rendered":"Common problems"},"content":{"rendered":"<h2>Common problems<\/h2>\n<blockquote><p><strong>Attention!<\/strong>  The system does not care about logical correctness of the data! If the data you import is in the correct format the corresponding records will be created.<\/p><\/blockquote>\n<p>No undo on already created records after import &#8211; check the data you import carefully. Be careful not to create a large volume of wrong entries that you then have to delete or correct one by one.<\/p>\n<p>The automatic intelligent formatting of the contents of the excel sometimes causes unpleasant problems. Common cases to watch out for:<\/p>\n<ul>\n<li>Fields with content similar to numbers are very often reformatted to a number. For example, a text field with phone numbers starting with &#8220;088&#8221; can be reformatted to &#8220;88&#8221; by dropping the starting &#8220;0&#8221;<\/li>\n<li>Fields with date-like content are reformatted to date. For example &#8220;010203&#8221; can be reformatted to &#8220;01.02.2003&#8221;<\/li>\n<li>Import does not work with formulas and references!<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Common problems Attention! The system does not care about logical correctness of the data! If the data you import is in the correct format the corresponding records will be created. No undo on already created records after import &#8211; check the data you import carefully. Be careful not to create a large volume of wrong [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":23628,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Common problems - PRIM.IO RESOURCE CENTRE<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Common problems - PRIM.IO RESOURCE CENTRE\" \/>\n<meta property=\"og:description\" content=\"Common problems Attention! The system does not care about logical correctness of the data! If the data you import is in the correct format the corresponding records will be created. No undo on already created records after import &#8211; check the data you import carefully. Be careful not to create a large volume of wrong [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/\" \/>\n<meta property=\"og:site_name\" content=\"PRIM.IO RESOURCE CENTRE\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/primioerp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/\",\"url\":\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/\",\"name\":\"Common problems - PRIM.IO RESOURCE CENTRE\",\"isPartOf\":{\"@id\":\"https:\/\/docs.prim.io\/en\/#website\"},\"datePublished\":\"2024-06-12T11:30:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.prim.io\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Prim.IO Resource Centre\",\"item\":\"https:\/\/docs.prim.io\/en\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Initial data imports\",\"item\":\"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Common problems\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.prim.io\/en\/#website\",\"url\":\"https:\/\/docs.prim.io\/en\/\",\"name\":\"\u0423\u043f\u044a\u0442\u0432\u0430\u043d\u0435 \u043d\u0430 \u043f\u043e\u0442\u0440\u0435\u0431\u0438\u0442\u0435\u043b\u044f PRIM.IO\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/docs.prim.io\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.prim.io\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.prim.io\/en\/#organization\",\"name\":\"PRIM.IO\",\"url\":\"https:\/\/docs.prim.io\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.prim.io\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs.prim.io\/content\/uploads\/2019\/07\/cropped-prim_logo_big_icon_transp.png\",\"contentUrl\":\"https:\/\/docs.prim.io\/content\/uploads\/2019\/07\/cropped-prim_logo_big_icon_transp.png\",\"width\":512,\"height\":512,\"caption\":\"PRIM.IO\"},\"image\":{\"@id\":\"https:\/\/docs.prim.io\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/primioerp\",\"https:\/\/www.linkedin.com\/showcase\/primioerp\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Common problems - PRIM.IO RESOURCE CENTRE","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/","og_locale":"en_US","og_type":"article","og_title":"Common problems - PRIM.IO RESOURCE CENTRE","og_description":"Common problems Attention! The system does not care about logical correctness of the data! If the data you import is in the correct format the corresponding records will be created. No undo on already created records after import &#8211; check the data you import carefully. Be careful not to create a large volume of wrong [&hellip;]","og_url":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/","og_site_name":"PRIM.IO RESOURCE CENTRE","article_publisher":"https:\/\/www.facebook.com\/primioerp","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/","url":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/","name":"Common problems - PRIM.IO RESOURCE CENTRE","isPartOf":{"@id":"https:\/\/docs.prim.io\/en\/#website"},"datePublished":"2024-06-12T11:30:14+00:00","breadcrumb":{"@id":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/common-problems\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.prim.io\/en\/"},{"@type":"ListItem","position":2,"name":"Prim.IO Resource Centre","item":"https:\/\/docs.prim.io\/en\/"},{"@type":"ListItem","position":3,"name":"Initial data imports","item":"https:\/\/docs.prim.io\/en\/prim-io-user-guide\/initial-data-imports\/"},{"@type":"ListItem","position":4,"name":"Common problems"}]},{"@type":"WebSite","@id":"https:\/\/docs.prim.io\/en\/#website","url":"https:\/\/docs.prim.io\/en\/","name":"\u0423\u043f\u044a\u0442\u0432\u0430\u043d\u0435 \u043d\u0430 \u043f\u043e\u0442\u0440\u0435\u0431\u0438\u0442\u0435\u043b\u044f PRIM.IO","description":"","publisher":{"@id":"https:\/\/docs.prim.io\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.prim.io\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.prim.io\/en\/#organization","name":"PRIM.IO","url":"https:\/\/docs.prim.io\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.prim.io\/en\/#\/schema\/logo\/image\/","url":"https:\/\/docs.prim.io\/content\/uploads\/2019\/07\/cropped-prim_logo_big_icon_transp.png","contentUrl":"https:\/\/docs.prim.io\/content\/uploads\/2019\/07\/cropped-prim_logo_big_icon_transp.png","width":512,"height":512,"caption":"PRIM.IO"},"image":{"@id":"https:\/\/docs.prim.io\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/primioerp","https:\/\/www.linkedin.com\/showcase\/primioerp"]}]}},"_links":{"self":[{"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/pages\/24137"}],"collection":[{"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/comments?post=24137"}],"version-history":[{"count":0,"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/pages\/24137\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/pages\/23628"}],"wp:attachment":[{"href":"https:\/\/docs.prim.io\/en\/wp-json\/wp\/v2\/media?parent=24137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}