
{"id":5835,"date":"2017-10-26T16:58:38","date_gmt":"2017-10-26T14:58:38","guid":{"rendered":"https:\/\/www.minicrm.hu\/help\/?p=5835"},"modified":"2017-11-06T15:24:18","modified_gmt":"2017-11-06T14:24:18","slug":"how-can-i-import-to-the-system","status":"publish","type":"post","link":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/","title":{"rendered":"How can I import to the system?"},"content":{"rendered":"<p>You can import your own xlsx\/CSV database into MiniCRM.<\/p>\n<div class=\"alert alert-danger\">Only <a href=\"..\/user-rights\/\">admins<\/a>\u00a0can import data into MiniCRM.<\/div>\n<div class=\"alert alert-danger\">The header of the file to be imported should include the MiniCRM fields that will be filled out with data.<\/div>\n<h3>The rule is simple:<\/h3>\n<ul>\n<li>One row is one customer<\/li>\n<li>One column is one data of the customer<\/li>\n<\/ul>\n<div class=\"alert alert-info\">Use the following sample to prepare the file: <a href=\"https:\/\/d26cfm2pfnephr.cloudfront.net\/uploads\/2015\/07\/MiniCRM_Import_EN_AutoSalesV2.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">Import sample<\/a><\/div>\n<div class=\"alert alert-danger\">If you are importing <a href=\"..\/what-should-i-do-with-businesses-and-contact-persons\/\">company<\/a>\u00a0data, you have to enter the company\u2019s name. If you are importing a <a href=\"..\/what-should-i-do-with-businesses-and-contact-persons\/\">person\u2019s<\/a>\u00a0data, you have to enter the person\u2019s name.<\/div>\n<h2 id=\"Importlslpsei\">Import steps<\/h2>\n<ol>\n<li>Click on Sales on the blue navigation bar.<\/li>\n<li>Click on the downwards pointing arrow\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-758\" src=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png\" alt=\"betoltes-gomb\" width=\"24\" height=\"30\" \/> next to the New opportunity button and select the Import option.<\/li>\n<li>Click on the\u00a0<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2936\" src=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/04\/upload-e1492692761972.png\" alt=\"upload\" width=\"68\" height=\"25\" \/>\u00a0button and select the file.\n<ul>\n<li>If there is no data in your system yet,\u00a0you don&#8217;t have to change the default setting of the <a href=\"..\/identified-action\/\">Identified action field<\/a>.<\/li>\n<li>If there is data in your system, it is recommended to select the <a href=\"..\/identified-action\/\">Update available Opportunity<\/a>\u00a0option to avoid duplications.<\/li>\n<\/ul>\n<\/li>\n<li>If you have a built, active database, you can leave the <a href=\"..\/how-to-activate-email-addresses-during-import\/\">Activate email addresses<\/a>\u00a0field checked, otherwise, you have to uncheck it.<\/li>\n<li>Read and accept our <a href=\"..\/spam-zero-tolerance\/\">Spam policy<\/a>.<\/li>\n<li>After clicking on Next, you can check the fields that were identified by MiniCRM based on the header of the file.<\/li>\n<li>If every row has a white background, every column has been identified. Compare the <a href=\"..\/field-types\/\">field<\/a>\u00a0names in the middle column with the header name in the left column and check whether the pairings are correct or not.<\/li>\n<li>If they are correct, click Next and the system runs a test to check which data can be imported. <a href=\"..\/what-do-error-messages-mean\/\">The results are displayed on the next page<\/a>.<\/li>\n<li>If everything is all right, click on Next and the data will be imported to the system. By clicking on the imported customers, you can check\u00a0it.<\/li>\n<\/ol>\n<p>Congratulations to the import. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can import your own xlsx\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the MiniCRM fields that will be filled out with data. The rule is simple: One row is one customer One column is one data of the customer Use the following [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[381],"tags":[442,450,452],"class_list":["post-5835","post","type-post","status-publish","format-standard","hentry","category-import-export-form","tag-firststeps-en","tag-import-en","tag-intro-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How can I import to the system? - Documenta\u021bie MiniCRM<\/title>\n<meta name=\"description\" content=\"You can import your own xlsx\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can I import to the system? - Documenta\u021bie MiniCRM\" \/>\n<meta property=\"og:description\" content=\"You can import your own xlsx\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the\" \/>\n<meta property=\"og:url\" content=\"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/\" \/>\n<meta property=\"og:site_name\" content=\"Documenta\u021bie MiniCRM\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-26T14:58:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-11-06T14:24:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png\" \/>\n<meta name=\"author\" content=\"L\u00edvia F\u00fcl\u00f6p\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"L\u00edvia F\u00fcl\u00f6p\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/\"},\"author\":{\"name\":\"L\u00edvia F\u00fcl\u00f6p\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/ceb677e9c50c3b41ea1539b92acfae96\"},\"headline\":\"How can I import to the system?\",\"datePublished\":\"2017-10-26T14:58:38+00:00\",\"dateModified\":\"2017-11-06T14:24:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/\"},\"wordCount\":323,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2017\\\/02\\\/betoltesgomb.png\",\"keywords\":[\"firststeps-en\",\"import-en\",\"intro-en\"],\"articleSection\":[\"Import Export and Form\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/\",\"url\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/\",\"name\":\"How can I import to the system? - Documenta\u021bie MiniCRM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2017\\\/02\\\/betoltesgomb.png\",\"datePublished\":\"2017-10-26T14:58:38+00:00\",\"dateModified\":\"2017-11-06T14:24:18+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/ceb677e9c50c3b41ea1539b92acfae96\"},\"description\":\"You can import your own xlsx\\\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2017\\\/02\\\/betoltesgomb.png\",\"contentUrl\":\"https:\\\/\\\/minicrm-wp-help.s3.amazonaws.com\\\/uploads\\\/2017\\\/02\\\/betoltesgomb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/helpdev.minicrm.io\\\/help\\\/how-can-i-import-to-the-system\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can I import to the system?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#website\",\"url\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/\",\"name\":\"Documenta\u021bie MiniCRM\",\"description\":\"Welcome to MiniCRM\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.minicrm.hu\\\/help\\\/#\\\/schema\\\/person\\\/ceb677e9c50c3b41ea1539b92acfae96\",\"name\":\"L\u00edvia F\u00fcl\u00f6p\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g\",\"caption\":\"L\u00edvia F\u00fcl\u00f6p\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How can I import to the system? - Documenta\u021bie MiniCRM","description":"You can import your own xlsx\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the","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:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/","og_locale":"en_US","og_type":"article","og_title":"How can I import to the system? - Documenta\u021bie MiniCRM","og_description":"You can import your own xlsx\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the","og_url":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/","og_site_name":"Documenta\u021bie MiniCRM","article_published_time":"2017-10-26T14:58:38+00:00","article_modified_time":"2017-11-06T14:24:18+00:00","og_image":[{"url":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png","type":"","width":"","height":""}],"author":"L\u00edvia F\u00fcl\u00f6p","twitter_card":"summary_large_image","twitter_misc":{"Written by":"L\u00edvia F\u00fcl\u00f6p","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#article","isPartOf":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/"},"author":{"name":"L\u00edvia F\u00fcl\u00f6p","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/ceb677e9c50c3b41ea1539b92acfae96"},"headline":"How can I import to the system?","datePublished":"2017-10-26T14:58:38+00:00","dateModified":"2017-11-06T14:24:18+00:00","mainEntityOfPage":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/"},"wordCount":323,"commentCount":0,"image":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#primaryimage"},"thumbnailUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png","keywords":["firststeps-en","import-en","intro-en"],"articleSection":["Import Export and Form"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/","url":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/","name":"How can I import to the system? - Documenta\u021bie MiniCRM","isPartOf":{"@id":"https:\/\/www.minicrm.hu\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#primaryimage"},"image":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#primaryimage"},"thumbnailUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png","datePublished":"2017-10-26T14:58:38+00:00","dateModified":"2017-11-06T14:24:18+00:00","author":{"@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/ceb677e9c50c3b41ea1539b92acfae96"},"description":"You can import your own xlsx\/CSV database into MiniCRM. Only admins\u00a0can import data into MiniCRM. The header of the file to be imported should include the","breadcrumb":{"@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#primaryimage","url":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png","contentUrl":"https:\/\/minicrm-wp-help.s3.amazonaws.com\/uploads\/2017\/02\/betoltesgomb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/helpdev.minicrm.io\/help\/how-can-i-import-to-the-system\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.minicrm.hu\/help\/"},{"@type":"ListItem","position":2,"name":"How can I import to the system?"}]},{"@type":"WebSite","@id":"https:\/\/www.minicrm.hu\/help\/#website","url":"https:\/\/www.minicrm.hu\/help\/","name":"Documenta\u021bie MiniCRM","description":"Welcome to MiniCRM","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.minicrm.hu\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.minicrm.hu\/help\/#\/schema\/person\/ceb677e9c50c3b41ea1539b92acfae96","name":"L\u00edvia F\u00fcl\u00f6p","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f3134b1be47aa2326a775dd7090fd53fb8a694a561ad9cc5ec8f1e66ff8bacc4?s=96&d=mm&r=g","caption":"L\u00edvia F\u00fcl\u00f6p"}}]}},"_links":{"self":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts\/5835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/comments?post=5835"}],"version-history":[{"count":6,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts\/5835\/revisions"}],"predecessor-version":[{"id":5925,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/posts\/5835\/revisions\/5925"}],"wp:attachment":[{"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/media?parent=5835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/categories?post=5835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minicrm.ro\/help\/wp-json\/wp\/v2\/tags?post=5835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}