{"id":2010,"date":"2013-12-10T09:22:38","date_gmt":"2013-12-10T08:22:38","guid":{"rendered":"https:\/\/badgemaker.info\/?page_id=2010"},"modified":"2016-07-15T11:43:19","modified_gmt":"2016-07-15T09:43:19","slug":"import-excel-csv-data","status":"publish","type":"page","link":"https:\/\/badgemaker.info\/nl\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","title":{"rendered":"A. Import Excel or CSV data"},"content":{"rendered":"
A. Import Excel of CSV data<\/h5>\n
BadgeMaker Identity<\/h5>\n

1. Excel bestand<\/strong>
\n\"bm_identity_existing_project_excel_datasource\"<\/a>
\nVoorbeeld van het popup venster: Importeer data vanuit een Excel bestand.<\/em><\/p>\n

A.<\/span> Klik op deze knop, zoek op uw computer en selecteer het Excel\/CSV bestand dat u wilt gebruiken voor het cre\u00ebren van een nieuw BadgeMaker project en selecteer het werkblad dat u wilt gebruiken van uw Excel bestand.
\nB.<\/span>Selecteer de eerste rij die de kolomnamen bevat.
\nC.<\/span>Selecteer de kolom die is gekoppeld aan de unieke namen van de foto\u2019s.(bijvoorbeeld: ID nummer of Index)
\nD.<\/span> Selecteer de folder die de kaarthouder foto\u2019s bevat.
\nE.<\/span> Selecteer de kolom die gekoppeld is aan de unieke namen van de handtekeningen.(bijvoorbeeld: ID nummer of Index)
\nF.<\/span> Selecteer de folder die de handtekeningen bevat.
\nG.<\/span> Klik op de \u201cVolgende<\/span>\u201d knop om door te gaan naar de tweede stap.<\/p>\n

 <\/p>\n

2. Configuratie
\n<\/strong>\"bm_identity_existing_project_excel_data_fields\"
\n<\/a>Fig. Voorbeeld van het popup venster stap2. Configureer de data die ge\u00efmporteerd moet worden vanuit een Excel bestand naar het project.<\/em><\/p>\n

A.<\/span> Check deze box om alleen nieuwe records te importeren, bestaande records zullen niet overschreven worden.
\nB.<\/span> Selecteer wat er moet gebeuren wanneer er een omzet fout optreedt.
\nC.<\/span> Selecteer een van de kolommen uit het Excel bestand die de unieke data bevat waarmee de records ge\u00efdentificeerd worden.
\nD.<\/span> Koppel de bronkolommen van het Excel-bestand aan de kollomen van het BadgeMaker project., BadgeMaker koppelt automatisch de kollomen met dezelfde naam.
\nE.<\/span> Klik op de \u201cVolgende<\/span>\u201d knop om door te gaan naar de tweede stap.<\/p>\n

3. Import gegevens<\/strong>
\nStap 3. De instellingen van de voorgaande stappen wordt verwerkt. A.<\/span> Klik op de \u201cImport gegevens<\/span>\u201d knop om de gegevens uit het Excel bestand te importeren naar uw BadgeMaker project. B.<\/span> Klik op de\u201cVorige stap<\/span>\u201d knop om nog eventuele aanpassingen door te voeren voordat u de gegevens gaat importeren.<\/p>","protected":false},"excerpt":{"rendered":"

A. Import Excel of CSV data BadgeMaker Identity 1. Excel bestand Voorbeeld van het popup venster: Importeer data vanuit een Excel bestand. A. Klik op deze knop, zoek op uw computer en selecteer het Excel\/CSV bestand dat u wilt gebruiken voor het cre\u00ebren van een nieuw BadgeMaker project en selecteer<\/p>\n","protected":false},"author":5,"featured_media":0,"parent":2007,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-user-guide.php","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"class_list":["post-2010","page","type-page","status-publish","hentry"],"yoast_head":"\nA. Import Excel or CSV data - BadgeMaker<\/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:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A. Import Excel or CSV data - BadgeMaker\" \/>\n<meta property=\"og:description\" content=\"A. Import Excel of CSV data BadgeMaker Identity 1. Excel bestand Voorbeeld van het popup venster: Importeer data vanuit een Excel bestand. A. Klik op deze knop, zoek op uw computer en selecteer het Excel\/CSV bestand dat u wilt gebruiken voor het cre\u00ebren van een nieuw BadgeMaker project en selecteer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/\" \/>\n<meta property=\"og:site_name\" content=\"BadgeMaker\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BadgeMakersoftware\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-07-15T09:43:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BadgeMaker_\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/\",\"name\":\"A. Import Excel or CSV data - BadgeMaker\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/bm_identity_import_datasource.png\",\"datePublished\":\"2013-12-10T08:22:38+00:00\",\"dateModified\":\"2016-07-15T09:43:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/bm_identity_import_datasource.png\",\"contentUrl\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/bm_identity_import_datasource.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/import-excel-csv-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BadgeMaker User Guide\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/BadgeMaker-UserGuide-V2.11.18-September-2025.pdf\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BadgeMaker Identity\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Import Data\",\"item\":\"https:\\\/\\\/badgemaker.info\\\/userguide2\\\/badgemaker-identity\\\/import-data\\\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"A. Import Excel or CSV data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/\",\"name\":\"BadgeMaker\",\"description\":\"ScreenCheck presents BadgeMaker ID software\",\"publisher\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#organization\",\"name\":\"ScreenCheck\",\"url\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"ScreenCheck\"},\"image\":{\"@id\":\"https:\\\/\\\/badgemaker.info\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/BadgeMakersoftware\\\/\",\"https:\\\/\\\/x.com\\\/BadgeMaker_\",\"https:\\\/\\\/www.linkedin.com\\\/showcase\\\/9493265\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCL1iI8MU-A2RbWyYGzpVRow\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A. Import Excel or CSV data - BadgeMaker","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:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","og_locale":"nl_NL","og_type":"article","og_title":"A. Import Excel or CSV data - BadgeMaker","og_description":"A. Import Excel of CSV data BadgeMaker Identity 1. Excel bestand Voorbeeld van het popup venster: Importeer data vanuit een Excel bestand. A. Klik op deze knop, zoek op uw computer en selecteer het Excel\/CSV bestand dat u wilt gebruiken voor het cre\u00ebren van een nieuw BadgeMaker project en selecteer","og_url":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","og_site_name":"BadgeMaker","article_publisher":"https:\/\/www.facebook.com\/BadgeMakersoftware\/","article_modified_time":"2016-07-15T09:43:19+00:00","og_image":[{"url":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@BadgeMaker_","twitter_misc":{"Geschatte leestijd":"3 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","url":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/","name":"A. Import Excel or CSV data - BadgeMaker","isPartOf":{"@id":"https:\/\/badgemaker.info\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#primaryimage"},"image":{"@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#primaryimage"},"thumbnailUrl":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png","datePublished":"2013-12-10T08:22:38+00:00","dateModified":"2016-07-15T09:43:19+00:00","breadcrumb":{"@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#primaryimage","url":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png","contentUrl":"https:\/\/badgemaker.info\/wp-content\/uploads\/2016\/04\/bm_identity_import_datasource.png"},{"@type":"BreadcrumbList","@id":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/import-excel-csv-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/badgemaker.info\/"},{"@type":"ListItem","position":2,"name":"BadgeMaker User Guide","item":"https:\/\/badgemaker.info\/wp-content\/uploads\/2025\/09\/BadgeMaker-UserGuide-V2.11.18-September-2025.pdf"},{"@type":"ListItem","position":3,"name":"BadgeMaker Identity","item":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/"},{"@type":"ListItem","position":4,"name":"Import Data","item":"https:\/\/badgemaker.info\/userguide2\/badgemaker-identity\/import-data\/"},{"@type":"ListItem","position":5,"name":"A. Import Excel or CSV data"}]},{"@type":"WebSite","@id":"https:\/\/badgemaker.info\/en\/#website","url":"https:\/\/badgemaker.info\/en\/","name":"BadgeMaker","description":"ScreenCheck presents BadgeMaker ID software","publisher":{"@id":"https:\/\/badgemaker.info\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/badgemaker.info\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/badgemaker.info\/en\/#organization","name":"ScreenCheck","url":"https:\/\/badgemaker.info\/en\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/badgemaker.info\/en\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"ScreenCheck"},"image":{"@id":"https:\/\/badgemaker.info\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BadgeMakersoftware\/","https:\/\/x.com\/BadgeMaker_","https:\/\/www.linkedin.com\/showcase\/9493265\/","https:\/\/www.youtube.com\/channel\/UCL1iI8MU-A2RbWyYGzpVRow"]}]}},"_links":{"self":[{"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/pages\/2010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/comments?post=2010"}],"version-history":[{"count":18,"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/pages\/2010\/revisions"}],"predecessor-version":[{"id":4116,"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/pages\/2010\/revisions\/4116"}],"up":[{"embeddable":true,"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/pages\/2007"}],"wp:attachment":[{"href":"https:\/\/badgemaker.info\/nl\/wp-json\/wp\/v2\/media?parent=2010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}