{"id":209,"date":"2022-10-26T06:52:40","date_gmt":"2022-10-26T04:52:40","guid":{"rendered":"https:\/\/datastorms.eu\/?p=209"},"modified":"2023-03-15T21:24:38","modified_gmt":"2023-03-15T20:24:38","slug":"importeren-zonder-programmeren","status":"publish","type":"post","link":"https:\/\/datastorms.eu\/en\/2022\/10\/26\/importeren-zonder-programmeren\/","title":{"rendered":"Importing without programming"},"content":{"rendered":"<p><strong><span><i>User-friendly wizard to import data by the end user within boundary conditions set by the functional administrator<\/i><\/span><\/strong>.<\/p>\n\n\n\n<p><strong>Easily import a large amount of data from another application? You can do that in Datastorms without programming. Just use the menu-driven interface that is available by default. As a user, you do not need any knowledge of the underlying structures to have large amounts of data at your disposal in a controlled and fast manner.<\/strong><\/p>\n\n\n\n<p>Importing data is done in three clear steps.<\/p>\n\n\n\n<!--more-->\n\n\n\n<h3 class=\"wp-block-heading\">1. <strong>Preparing the import template<\/strong><\/h3>\n\n\n\n<p>Importing data is always done based on an import definition that you define yourself. The user can create this definition himself in the application. Based on the available fields in the project, the user can specify which fields are or are not required in the template. The definition can then be downloaded as an import template in excel. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. <strong>Filling the import template<\/strong><\/h3>\n\n\n\n<p>The data to be imported can be placed in the template and saved. In this step, it is important that the format of the template remains unchanged. Once all the data has been processed in the template, it can be saved.<strong><br><\/strong><br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"248\" class=\"wp-image-212\" style=\"width: 700px;\" src=\"https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel.png\" alt=\"Prepare excel\" srcset=\"https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel.png 2092w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-300x106.png 300w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-1024x363.png 1024w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-768x272.png 768w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-1536x545.png 1536w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-2048x726.png 2048w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-18x6.png 18w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/prepare-excel-860x305.png 860w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. <strong>Validating the content of the import template<\/strong><\/h3>\n\n\n\n<p>Finally, the upload button can be used to offer the data-filled import template. The offered data is loaded as a preview. Datastorms then validates the content of the file at a number of points.<br>- Check the offered template: matched the offered import template with the project.<br>- Controls that also apply to manual entries. If all data in the preview meets the requirements for the respective fields, everything will be colored white. Colors are used to make found errors or points of interest easily findable. Any adjustments can be made directly in the preview.<br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>To illustrate, here are two examples where the import function supports the end user in importing the correct data:<\/strong><\/h3>\n\n\n\n<p>Example 1: The status field is empty in most lines.<br>The green color indicates that this is not wrong ansich. In the settings of the field there is no indication that it should be filled with a value by default. However, the red field does indicate that the value entered is incorrect. In the preview this can be corrected for both the green field and the red field.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-1024x439.png\" alt=\"\" class=\"wp-image-215\" width=\"780\" height=\"334\" srcset=\"https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-1024x439.png 1024w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-300x128.png 300w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-768x329.png 768w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-1536x658.png 1536w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-18x8.png 18w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list-860x368.png 860w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validaation-pick-from-list.png 1672w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><figcaption>Status need not be filled; otherwise, select a value from the list<\/figcaption><\/figure>\n\n\n\n<p>Example 2: The content of the name field must be unique.<br>The yellow color indicates that the field is correctly filled, but that this value already exists in the dataset or in the database. If no action is taken, the older data will be overwritten. In the preview, the value of the Name can be changed immediately if it does involve new data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"520\" src=\"https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-1024x520.png\" alt=\"\" class=\"wp-image-216\" srcset=\"https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-1024x520.png 1024w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-300x152.png 300w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-768x390.png 768w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-1536x781.png 1536w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-18x9.png 18w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1-860x437.png 860w, https:\/\/datastorms.eu\/wp-content\/uploads\/2022\/10\/validation-double-name-1.png 1696w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once all offered data is within the tolerances of the controls or the erroneous lines are removed, the import button becomes available.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Learn more<\/h3>\n\n\n\n<p>The import functionality is one of the innovative new features Datastorms has. Discover more of these features: check out <a href=\"https:\/\/datastorms.eu\/en\/2022\/08\/29\/krachtige-rapportages-in-datastorms\/\" title=\"\">here<\/a> for more information on the powerful reporting feature. <\/p>","protected":false},"excerpt":{"rendered":"<p>Gebruikersvriendelijke wizard om gegevens te importeren door de eindgebruiker binnen door de functioneel beheerder gestelde randvoorwaarden. Vanuit een andere applicatie eenvoudig een grote hoeveelheid gegevens importeren? Dat kan in Datastorms zonder te programmeren. Gebruik hiervoor de menu-gestuurde interface die standaard beschikbaar is. Je hebt hiervoor als gebruiker geen kennis van de onderliggende structuren nodig om&hellip;&nbsp;<a href=\"https:\/\/datastorms.eu\/en\/2022\/10\/26\/importeren-zonder-programmeren\/\" rel=\"bookmark\">Read More \u00bb<span class=\"screen-reader-text\">Importing without programming<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":215,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-209","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news-headlines"],"_links":{"self":[{"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":11,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/posts\/209\/revisions"}],"predecessor-version":[{"id":227,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/posts\/209\/revisions\/227"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/media\/215"}],"wp:attachment":[{"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/categories?post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datastorms.eu\/en\/wp-json\/wp\/v2\/tags?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}