{"id":42636,"date":"2022-04-20T11:19:58","date_gmt":"2022-04-20T14:19:58","guid":{"rendered":"https:\/\/suporte.quattrus.com\/?p=42636"},"modified":"2024-07-15T16:54:00","modified_gmt":"2024-07-15T19:54:00","slug":"importing-measurements-on-gestiona","status":"publish","type":"post","link":"https:\/\/suporte.quattrus.com\/en\/importing-measurements-on-gestiona\/","title":{"rendered":"Importing Measurements on Gestiona"},"content":{"rendered":"\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">You can import Measurements for your KPIs and subordinates. Instead of registering the measurements one by one, you can perform this operation only once, via import.<\/span><\/em><\/p>\n<p>\u00a0<\/p>\n<p><span style=\"font-weight: 400;\">In this article we will see:<\/span><\/p>\n<p><!-- \/divi:paragraph --><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Import Instruction and Mask<\/span><\/li>\n<li><span style=\"font-weight: 400;\">Import Measurements<\/span><\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<h3><span style=\"background-color: #ffffff; font-size: 22px; letter-spacing: normal; text-align: center;\"><b>Import Instruction and Mask<\/b><\/span><\/h3>\n<p><span style=\"font-weight: 400;\">You can export the Measurements and use the file as an import template, or download the Import Mask:<\/span><\/p>\n<p><a href=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2018\/12\/M\u00e1scara-Importa\u00e7\u00e3o-Medi\u00e7\u00f5es.xlsx\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-27155 alignnone size-full\" style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2020\/07\/826px-Microsoft_Office_Excel_2018\u2013present.svg.png\" alt=\"\" width=\"70\" height=\"65\" srcset=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2020\/07\/826px-Microsoft_Office_Excel_2018\u2013present.svg.png 826w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2020\/07\/826px-Microsoft_Office_Excel_2018\u2013present.svg-300x279.png 300w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2020\/07\/826px-Microsoft_Office_Excel_2018\u2013present.svg-768x714.png 768w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2020\/07\/826px-Microsoft_Office_Excel_2018\u2013present.svg-480x446.png 480w\" sizes=\"auto, (max-width: 70px) 100vw, 70px\" \/><\/a><\/p>\n<p style=\"padding-left: 60px; text-align: center;\"><a href=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2023\/09\/Import-Mask-Measurements.xlsx\" rel=\"attachment wp-att-2542\">Import Mask &#8211; Measurements<\/a><\/p>\n<p><span style=\"font-weight: 400;\">Check below the way to fill the mask to perform the import correctly:<\/span><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-32476 alignnone size-full\" src=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/04\/Snap-2021-04-27-at-16.49.47.png\" alt=\"\" width=\"818\" height=\"871\" srcset=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/04\/Snap-2021-04-27-at-16.49.47.png 818w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/04\/Snap-2021-04-27-at-16.49.47-282x300.png 282w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/04\/Snap-2021-04-27-at-16.49.47-768x818.png 768w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/04\/Snap-2021-04-27-at-16.49.47-480x511.png 480w\" sizes=\"auto, (max-width: 818px) 100vw, 818px\" \/><\/p>\n<p><!-- \/divi:paragraph --> <!-- divi:image {\"id\":1366} --><\/p>\n<figure class=\"wp-block-image\"><\/figure>\n<p>\u00a0<\/p>\n<blockquote>\n<p><b>NOTE:<\/b><\/p>\n<\/blockquote>\n<ul>\n<li>\n<blockquote><em><span style=\"font-weight: 400;\">It must be included in the file from column A (KPI ID) to column N (Type), the remaining columns are for consultation.<\/span><\/em><\/blockquote>\n<\/li>\n<li>\n<blockquote><em><span style=\"font-weight: 400;\">The first three columns (KPI ID, month and year) must contain the corresponding information.<\/span><\/em><\/blockquote>\n<\/li>\n<li>\n<blockquote><em><span style=\"font-weight: 400;\">When the measurement columns and band are blank, the value in the ICG will be considered, so that, if there is no change in values, there is no need to fill in.<\/span><\/em><\/blockquote>\n<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<h3>Import Measurements<\/h3>\n<p><span style=\"font-weight: 400;\">Click on the icon indicated below:<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31759 alignnone size-full\" src=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.52.47.png\" alt=\"\" width=\"424\" height=\"383\" srcset=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.52.47.png 424w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.52.47-300x271.png 300w\" sizes=\"auto, (max-width: 424px) 100vw, 424px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">Then:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select the measurement type<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Search for the completed file as shown above<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click Submit<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31762 alignnone size-full\" src=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.59.02.png\" alt=\"\" width=\"869\" height=\"239\" srcset=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.59.02.png 869w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.59.02-300x83.png 300w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.59.02-768x211.png 768w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-15.59.02-480x132.png 480w\" sizes=\"auto, (max-width: 869px) 100vw, 869px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">You can click the Update button to see the file upload status. When ready, the status will show the message: \u201c(100%) Import was successful\u201d.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-31765 alignnone size-full\" src=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-16.04.10.png\" alt=\"\" width=\"878\" height=\"523\" srcset=\"https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-16.04.10.png 878w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-16.04.10-300x179.png 300w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-16.04.10-768x457.png 768w, https:\/\/suporte.quattrus.com\/wp-content\/uploads\/2021\/03\/Snap-2021-03-31-at-16.04.10-480x286.png 480w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">The ICG will indicate if the importation has not taken place correctly. If in your file there is any change in the data already registered, the message of how many records have been updated will appear.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">At the end of the import, an email notification of the completion of the process will be sent.<\/span><\/p>\n<blockquote>\n<p><em><strong>Important<\/strong>: <span style=\"font-weight: 400;\">In KPIs of type 1C, the user must register the bands according to the \u201cgood for\u201d, if the KPI is good for less, the user must register the upper green band as mandatory, if the item is good for more, the user must register the lower green band as mandatory. This is used for the ICG to paint the KPI\u2019s goal color.<\/span><\/em><\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<blockquote>\n<p><strong><em><b>REMINDER:<\/b><\/em><\/strong><br \/><em><span style=\"font-weight: 400;\">You will receive, along with the completion email, the restoration file containing the data prior to import. If you want to check an information or return with some value, you can consult this file.<\/span><\/em><\/p>\n<\/blockquote>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[2771,2708,2710],"tags":[2714,2714],"class_list":["post-42636","post","type-post","status-publish","format-standard","hentry","category-importar-dados-usuario-quattrus-en","category-quattrus-en","category-usuario-quattrus-en","tag-quattrus-en"],"_links":{"self":[{"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/posts\/42636","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/comments?post=42636"}],"version-history":[{"count":6,"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/posts\/42636\/revisions"}],"predecessor-version":[{"id":56334,"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/posts\/42636\/revisions\/56334"}],"wp:attachment":[{"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/media?parent=42636"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/categories?post=42636"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/suporte.quattrus.com\/en\/wp-json\/wp\/v2\/tags?post=42636"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}