{"id":3922,"date":"2022-04-27T09:48:43","date_gmt":"2022-04-27T09:48:43","guid":{"rendered":"http:\/\/the-jena-experiment.de\/?page_id=3922"},"modified":"2022-05-02T12:29:54","modified_gmt":"2022-05-02T12:29:54","slug":"update-append-data","status":"publish","type":"page","link":"https:\/\/the-jena-experiment.de\/index.php\/update-append-data\/","title":{"rendered":"Update\/Append data"},"content":{"rendered":"\n<ul><li><em><strong>Update<\/strong><\/em>: if you want to edit data values, you can update the rows from the files to the dataset.  BEXIS2 allows to identify a specific row and change the values in this row.  It&#8217;s important to identify the row by giving an unique primary key. <\/li><li><strong><em>Append<\/em><\/strong>: Add the NEW rows from the files to the dataset only. If the primary key is new, then new rows will be added to the original data.<\/li><\/ul>\n\n\n\n<p class=\"has-background has-light-green-cyan-background-color\">Primary Data -&gt; <strong>Update or Append<\/strong> -&gt; Select and upload new data (can be the whole new dataset or just the few rows that containing the errors) -&gt; Define an <strong>unique primary key<\/strong> -&gt; Validation<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"has-luminous-vivid-orange-color has-text-color\">Select &#8220;Update or Append&#8221; button.<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" width=\"695\" height=\"400\" src=\"http:\/\/the-jena-experiment.de\/wp-content\/uploads\/image-79.png\" alt=\"\" class=\"wp-image-2780\" srcset=\"\/wp-content\/uploads\/image-79.png 695w, \/wp-content\/uploads\/image-79-300x173.png 300w\" sizes=\"(max-width: 695px) 100vw, 695px\" \/><\/figure>\n\n\n\n<p>Select and upload data step is the same as the <a href=\"\/index.php\/upload-data\/\">Upload<\/a> data procedure.<\/p>\n\n\n\n<h3 class=\"has-luminous-vivid-orange-color has-text-color\"> Define an <strong>unique primary key<\/strong> <\/h3>\n\n\n\n<p class=\"has-background has-luminous-vivid-amber-background-color\"><strong><em>Unique primary key<\/em><\/strong>: an unique identifier to identify each row. It can be just one column (e.g. row name or id name) or combined with several columns (e.g., year, season, plot, treatment). It&#8217;s very important to have an unique primary key in your dataset.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" width=\"959\" height=\"470\" src=\"http:\/\/the-jena-experiment.de\/wp-content\/uploads\/image-80.png\" alt=\"\" class=\"wp-image-2781\" srcset=\"\/wp-content\/uploads\/image-80.png 959w, \/wp-content\/uploads\/image-80-300x147.png 300w, \/wp-content\/uploads\/image-80-768x376.png 768w\" sizes=\"(max-width: 959px) 100vw, 959px\" \/><figcaption> <br> <strong>A unique identifier (primary key, i.e. row) <\/strong> <\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" width=\"1024\" height=\"442\" src=\"http:\/\/the-jena-experiment.de\/wp-content\/uploads\/image-81-1024x442.png\" alt=\"\" class=\"wp-image-2782\" srcset=\"\/wp-content\/uploads\/image-81-1024x442.png 1024w, \/wp-content\/uploads\/image-81-300x129.png 300w, \/wp-content\/uploads\/image-81-768x331.png 768w, \/wp-content\/uploads\/image-81.png 1155w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Update: if you want to edit data values, you can update the rows from the files to the dataset. BEXIS2 allows to identify a specific row and change the values&hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/pages\/3922"}],"collection":[{"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/comments?post=3922"}],"version-history":[{"count":14,"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/pages\/3922\/revisions"}],"predecessor-version":[{"id":3945,"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/pages\/3922\/revisions\/3945"}],"wp:attachment":[{"href":"https:\/\/the-jena-experiment.de\/index.php\/wp-json\/wp\/v2\/media?parent=3922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}