{"id":444434,"date":"2023-11-28T18:12:01","date_gmt":"2023-11-28T17:12:01","guid":{"rendered":"https:\/\/www.kafinea.com\/documentation\/uncategorized\/data-import-export\/"},"modified":"2023-11-28T18:12:01","modified_gmt":"2023-11-28T17:12:01","password":"","slug":"data-import-export","status":"publish","type":"docs","link":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/","title":{"rendered":"Data Import\/Export"},"content":{"rendered":"<blockquote class=\"bq-exemple\">\n<p>\ud83d\udccd <strong>Context<\/strong><br \/><em>Kafinea General Interface<\/em><\/p>\n<\/blockquote>\n<p>Kafinea allows you to import and export data in several ways, depending on your needs: manually via CSV files, or automatically through the API. This guide walks you through each method, whether you want to load your existing data when setting up Kafinea or export information on an ad hoc basis. <\/p>\n<hr>\n<h2>1. Import Data from a CSV File<\/h2>\n<p>CSV import is the most common method for integrating a large volume of data into Kafinea. The process takes place in three steps. <\/p>\n<h3>Launch the Import<\/h3>\n<p>From any module, click the <strong>Import<\/strong> button located at the top right of the <a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/lists\/\">list<\/a>. The import form opens for this module. <\/p>\n<h3>Step 1 \u2014 Load the CSV File<\/h3>\n<p>Select your CSV file, then specify:<\/p>\n<ul>\n<li>whether the file contains a <strong>header row<\/strong><\/li>\n<li>the <strong>character encoding<\/strong> (UTF-8, ISO-8859-1\u2026)<\/li>\n<li>the <strong>delimiter symbol<\/strong> (comma, semicolon, pipe, or caret)<\/li>\n<\/ul>\n<h3>Step 2 \u2014 Manage Duplicates<\/h3>\n<p>Choose how to handle records that already exist in Kafinea:<\/p>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Option<\/th>\n<th>Behavior<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Overwrite<\/strong><\/td>\n<td>Replaces existing records with new data<\/td>\n<\/tr>\n<tr>\n<td><strong>Merge<\/strong><\/td>\n<td>Updates only the fields provided in the file<\/td>\n<\/tr>\n<tr>\n<td><strong>Ignore<\/strong><\/td>\n<td>Keeps existing records as they are<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>You select the fields used to detect the match between a CSV row and an existing record (for example: email address, customer reference\u2026).<\/p>\n<blockquote class=\"bq-note\">\n<p><strong>Note:<\/strong> This step is optional. If your data is entirely new, you can skip it. <\/p>\n<\/blockquote>\n<h3>Step 3 \u2014 Map the Fields<\/h3>\n<p>Associate each column of your CSV file with a field in the Kafinea module. You can also: <\/p>\n<ul>\n<li><strong>Provide a default value<\/strong> for a field not present in the file<\/li>\n<li><strong>Save the mapping<\/strong> (<em>Save this mapping<\/em> checkbox) to reuse it for future imports with a similar file structure<\/li>\n<\/ul>\n<blockquote class=\"bq-astuce\">\n<p><strong>Tip:<\/strong> If a field is missing in Kafinea, you can create it directly from <a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/the-layout-manager\/\">the layout manager<\/a> without leaving the import process.<\/p>\n<\/blockquote>\n<p>Click <strong>Import<\/strong> to launch the operation.<\/p>\n<hr>\n<h2>2. Export Data in CSV Format<\/h2>\n<p>You can export data at any time from any module.<\/p>\n<h3>Launch the Export<\/h3>\n<p>From the <a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/lists\/\">list<\/a> of a module, click <strong>More<\/strong> &gt; <strong>Export<\/strong>. Three options are available: <\/p>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Option<\/th>\n<th>Scope<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Export selected records<\/strong><\/td>\n<td>Only the records checked in the list<\/td>\n<\/tr>\n<tr>\n<td><strong>Export data from the current page<\/strong><\/td>\n<td>All records visible on the active page<\/td>\n<\/tr>\n<tr>\n<td><strong>Export all data<\/strong><\/td>\n<td>All records in the module<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>The generated CSV file can then be opened in a spreadsheet or imported into another system.<\/p>\n<hr>\n<h2>3. Automate Data Exchange via the API<\/h2>\n<p>Beyond manual operations, Kafinea has an API that allows you to automate data imports and exports with your other business software.<\/p>\n<h3>What the API Enables<\/h3>\n<ul>\n<li><strong>Automatic import:<\/strong> external software sends data to Kafinea (for example, orders from an online store)<\/li>\n<li><strong>Automatic export:<\/strong> Kafinea transmits data to an external system (for example, a list of parts to manufacture to production software)<\/li>\n<li><strong>Workflow triggering:<\/strong> Kafinea&#8217;s <a href=\"https:\/\/www.kafinea.com\/en\/documentation\/automation\/workflows\/\">workflows<\/a> can automatically trigger these exchanges according to business rules you define<\/li>\n<\/ul>\n<blockquote class=\"bq-exemple\">\n<p><strong>Example:<\/strong> A company with a robotic assembly line can benefit from the Kafinea API: for each new customer order, Kafinea automatically sends the list of products to manufacture (export), then receives confirmation that manufacturing is complete (import). A workflow then sends a notification to the customer to inform them that their order is being shipped. <\/p>\n<\/blockquote>\n<blockquote class=\"bq-note\">\n<p><strong>Note:<\/strong> The API enables real-time or scheduled exchanges. For more information, consult the <a href=\"https:\/\/www.kafinea.com\/en\/documentation\/api\/rest-api-introduction\/\">Kafinea API documentation<\/a>. <\/p>\n<\/blockquote>\n<hr>\n<h2>4. Frequently Asked Questions<\/h2>\n<p><strong>What file formats are accepted for import?<\/strong><\/p>\n<p>Kafinea only accepts files in CSV format. If your data is in a spreadsheet (Excel, Google Sheets\u2026), export it to CSV first. <\/p>\n<p><strong>Can I cancel an import?<\/strong><\/p>\n<p>No, an import cannot be canceled automatically. Carefully check your file and mapping parameters before launching the operation. In case of error, you will need to correct the records manually or perform a new import with the <em>Overwrite<\/em> option.  <\/p>\n<blockquote class=\"bq-important\">\n<p><strong>Important:<\/strong> Before any bulk import, it is recommended to test with a file containing only a few rows to validate the mapping and duplicate handling.<\/p>\n<\/blockquote>\n<p><strong>Does the import handle relationships between modules?<\/strong><\/p>\n<p>Yes, you can map a field from your CSV to a relationship field (for example, associate a contact with an existing organization). The match is made based on the field you choose as the matching key. <\/p>\n<p><strong>Can I schedule a recurring automatic import?<\/strong><\/p>\n<p>CSV imports are manual. For recurring and automated imports, use the Kafinea API, which allows you to schedule data exchanges with your other systems. <\/p>\n<p><strong>How do I export only certain records?<\/strong><\/p>\n<p>Use <a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/lists\/\">lists<\/a> to filter the desired records, check them, then click <strong>More<\/strong> &gt; <strong>Export<\/strong> &gt; <strong>Export selected records<\/strong>.<\/p>\n<hr>\n<h2>Related References \ud83d\udd17<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/lists\/\">Lists<\/a><\/li>\n<li><a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/records\/\">Records<\/a><\/li>\n<li><a href=\"https:\/\/www.kafinea.com\/en\/documentation\/kafinea-interface\/the-layout-manager\/\">The Layout Manager<\/a><\/li>\n<li><a href=\"https:\/\/www.kafinea.com\/en\/documentation\/automation\/workflows\/\">Workflows<\/a><\/li>\n<li><a href=\"https:\/\/www.kafinea.com\/en\/documentation\/api\/rest-api-introduction\/\">Kafinea API<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\ud83d\udccd ContextKafinea General Interface Kafinea allows you to import and export data in several ways, depending on your needs: manually via CSV files, or automatically through the API. This guide walks you through each method, whether you want to load your existing data when setting up Kafinea or export information on an ad hoc basis&#8230;.<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"doc_category":[763],"doc_tag":[],"class_list":["post-444434","docs","type-docs","status-publish","hentry","doc_category-kafinea-interface"],"year_month":"2026-08","word_count":738,"total_views":"1","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Kenny Legros","author_nicename":"kenny-legros","author_url":"https:\/\/www.kafinea.com\/en\/author\/kenny-legros\/"},"doc_category_info":[{"term_name":"Kafinea interface","term_url":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Help - Data Import\/Export &#8226; Kafinea<\/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:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Help - Data Import\/Export &#8226; Kafinea\" \/>\n<meta property=\"og:description\" content=\"\ud83d\udccd ContextKafinea General Interface Kafinea allows you to import and export data in several ways, depending on your needs: manually via CSV files, or automatically through the API. This guide walks you through each method, whether you want to load your existing data when setting up Kafinea or export information on an ad hoc basis....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/\" \/>\n<meta property=\"og:site_name\" content=\"Kafinea\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/help\\\/kafinea-interface\\\/data-import-export\\\/\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/help\\\/kafinea-interface\\\/data-import-export\\\/\",\"name\":\"Help - Data Import\\\/Export &#8226; Kafinea\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/#website\"},\"datePublished\":\"2023-11-28T17:12:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/help\\\/kafinea-interface\\\/data-import-export\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.kafinea.com\\\/en\\\/help\\\/kafinea-interface\\\/data-import-export\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/help\\\/kafinea-interface\\\/data-import-export\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data Import\\\/Export\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/\",\"name\":\"Kafinea\",\"description\":\"Une solution unique pour toutes vos ambitions\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/#organization\",\"name\":\"Kafinea\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.kafinea.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo-Kafinea-SVG-orange-bleu.svg\",\"contentUrl\":\"https:\\\/\\\/www.kafinea.com\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo-Kafinea-SVG-orange-bleu.svg\",\"width\":296.31,\"height\":66.48,\"caption\":\"Kafinea\"},\"image\":{\"@id\":\"https:\\\/\\\/www.kafinea.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/kafinea\\\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Help - Data Import\/Export &#8226; Kafinea","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:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/","og_locale":"en_US","og_type":"article","og_title":"Help - Data Import\/Export &#8226; Kafinea","og_description":"\ud83d\udccd ContextKafinea General Interface Kafinea allows you to import and export data in several ways, depending on your needs: manually via CSV files, or automatically through the API. This guide walks you through each method, whether you want to load your existing data when setting up Kafinea or export information on an ad hoc basis....","og_url":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/","og_site_name":"Kafinea","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/","url":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/","name":"Help - Data Import\/Export &#8226; Kafinea","isPartOf":{"@id":"https:\/\/www.kafinea.com\/en\/#website"},"datePublished":"2023-11-28T17:12:01+00:00","breadcrumb":{"@id":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.kafinea.com\/en\/help\/kafinea-interface\/data-import-export\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.kafinea.com\/en\/"},{"@type":"ListItem","position":2,"name":"Data Import\/Export"}]},{"@type":"WebSite","@id":"https:\/\/www.kafinea.com\/en\/#website","url":"https:\/\/www.kafinea.com\/en\/","name":"Kafinea","description":"Une solution unique pour toutes vos ambitions","publisher":{"@id":"https:\/\/www.kafinea.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.kafinea.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.kafinea.com\/en\/#organization","name":"Kafinea","url":"https:\/\/www.kafinea.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.kafinea.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.kafinea.com\/wp-content\/uploads\/2024\/10\/Logo-Kafinea-SVG-orange-bleu.svg","contentUrl":"https:\/\/www.kafinea.com\/wp-content\/uploads\/2024\/10\/Logo-Kafinea-SVG-orange-bleu.svg","width":296.31,"height":66.48,"caption":"Kafinea"},"image":{"@id":"https:\/\/www.kafinea.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/kafinea\/"]}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Kenny Legros","author_link":"https:\/\/www.kafinea.com\/en\/author\/kenny-legros\/"},"uagb_comment_info":0,"uagb_excerpt":"\ud83d\udccd ContextKafinea General Interface Kafinea allows you to import and export data in several ways, depending on your needs: manually via CSV files, or automatically through the API. This guide walks you through each method, whether you want to load your existing data when setting up Kafinea or export information on an ad hoc basis....","_links":{"self":[{"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/docs\/444434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/comments?post=444434"}],"version-history":[{"count":0,"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/docs\/444434\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/media?parent=444434"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/doc_category?post=444434"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.kafinea.com\/en\/wp-json\/wp\/v2\/doc_tag?post=444434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}