{"id":2058,"date":"2023-01-04T22:12:10","date_gmt":"2023-01-04T21:12:10","guid":{"rendered":"https:\/\/www.ems-help.ch\/docs\/ems-customer-addresses\/external-systems-interfaces\/import-customer-data\/"},"modified":"2025-05-06T09:58:56","modified_gmt":"2025-05-06T07:58:56","password":"","slug":"import-customer-data","status":"publish","type":"docs","link":"https:\/\/www.ems-help.online\/en\/docs\/import-customer-data\/","title":{"rendered":"Importing customer data"},"content":{"rendered":"\n

General information on importing data into the ems system can be found here: Importing data<\/a><\/p>\n\n

Import of customer data from Schoch order (Alfred)<\/h3>\n\n

As a first step, export the customer data from Schoch Auftrag to Excel (csv). As Schoch orders have less stringent rules for entry, you may need to make corrections to the data.<\/p>\n\n

Now open the import dialog in ems: Customer addresses \u2192 Advanced menu top right \u2192 Import \/ Export data<\/em><\/p>\n\n

\"\"<\/figure>\n\n
\"\"<\/figure>\n\n

Now drag the file (*.csv) into the upload area. The file is then automatically analyzed and the dialog for linking the fields is displayed. Select the settings as shown in the following image:<\/p>\n\n

\"\"<\/figure>\n\n

You may need to deactivate the “Address verification…” option if the data is not of the required quality.<\/p>\n","protected":false},"excerpt":{"rendered":"

General information on importing data into the ems system can be found here: Importing data Import of customer data from […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","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-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":"","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-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":"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":""},"mobile":{"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":""}},"footnotes":""},"doc_category":[147],"glossaries":[],"doc_tag":[195],"class_list":["post-2058","docs","type-docs","status-publish","hentry","doc_category-customer-management","doc_tag-administrator-en"],"year_month":"2026-05","word_count":122,"total_views":"483","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Daniel Suter","author_nicename":"daniel-sutersubris-ch","author_url":"https:\/\/www.ems-help.online\/en\/author\/daniel-sutersubris-ch\/"},"doc_category_info":[{"term_name":"Customer management","term_url":"https:\/\/www.ems-help.online\/en\/docs-category\/customer-management\/"}],"doc_tag_info":[{"term_name":"Administrator","term_url":"https:\/\/www.ems-help.online\/en\/docs-tag\/administrator-en\/"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/docs\/2058","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/comments?post=2058"}],"version-history":[{"count":9,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/docs\/2058\/revisions"}],"predecessor-version":[{"id":8179,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/docs\/2058\/revisions\/8179"}],"wp:attachment":[{"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/media?parent=2058"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/doc_category?post=2058"},{"taxonomy":"glossaries","embeddable":true,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/glossaries?post=2058"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.ems-help.online\/en\/wp-json\/wp\/v2\/doc_tag?post=2058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}