{"id":3324,"date":"2019-03-25T17:43:45","date_gmt":"2019-03-25T20:43:45","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/how-to-create-a-historic\/"},"modified":"2019-07-05T16:27:44","modified_gmt":"2019-07-05T19:27:44","slug":"how-to-create-a-historic","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/","title":{"rendered":"How to create a Historic?"},"content":{"rendered":"<div align=\"justify\">\n<p>To create a Historic, first make sure the Domain has a DBServer. To add one to the Domain, right-click the project and select the option <b>Insert &#8211; > Database<\/b>, and set it up to access a valid database.<\/p>\n<p>After the DBServer has been checked, insert a new historic to the project following similar guidelines: right-click the project, and select the option <b>Insert &#8211; > Historic<\/b>. The <b>Hist1 <\/b>item will be created, and a settings window will be displayed. On it, create the historic fields and set up how they should be saved. In the figure below, three new fields have been created:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5012\/1.png\" alt=\"\" width=\"500\" height=\"119\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>These fields will be linked to the project&#8217;s tags or properties. To do so, click the <b>[&#8230;]<\/b> button, and chose the desired tags on App Browser window.<\/p>\n<p>For each field, select the data type equivalent to the data the source will contain. The available options are:<\/p>\n<ul>\n<li><b>fdTExt <\/b>= text<\/li>\n<li><b>fdInteger <\/b>= integer<\/li>\n<li><b>fdDouble <\/b>= double<\/li>\n<li><b>fdDateTime <\/b>= date\/time<\/li>\n<\/ul>\n<p>For text fields, you must also select the font type and size.<\/p>\n<p>After selecting the data sources and types, click the table&#8217;s properties window and the following window will be displayed:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5012\/2.png\" alt=\"\" width=\"477\" height=\"519\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>In the first field, set up the name of the database server used by the historic, and then chose a name for the table where the data and the write time will be saved for this historic. This time&#8217;s value is in milliseconds, and if it is zero, the historic&#8217;s automatic write will be disabled, which will require events to be recorded manually.<\/p>\n<p>On <b>Advanced <\/b>tab, set up the amount of data that will be kept in disk. You can, for example, set up a historic to keep all data from last month in disk, and to discard them when a new month begins and a new table begins. To do so, just select the amount of data that will be part of the table (1 hour, 1 day, 1 month, etc.) and the number of tables to be kept in disk. In this case, there will be a new table every month, and the last 12 tables will be kept in disk.<\/p>\n<p>Once it&#8217;s done, click <b>OK<\/b>. On the main window, click the button that creates the data structure in the historic. With this, the historic is ready to record data. If you selected to record data per events, just select the desired event and insert the following code line:<br \/>\n<span style=\"font-family: Courier New;\"><br \/>\nApplication.GetObject(&#8220;Hist1&#8221;).WriteRecord<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>To create a Historic, first make sure the Domain has a DBServer. To add one to the Domain, right-click the project and select the option Insert &#8211; > Database, and&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[749],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to create a Historic? - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to create a Historic?\" \/>\n<meta property=\"og:description\" content=\"To create a Historic, first make sure the Domain has a DBServer. To add one to the Domain, right-click the project and select the option Insert &#8211; &gt; Database, and&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:43:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-05T19:27:44+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5012\/1.png\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"How to create a Historic?\",\"datePublished\":\"2019-03-25T20:43:45+00:00\",\"dateModified\":\"2019-07-05T19:27:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\"},\"wordCount\":405,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Historic\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\",\"name\":\"[:pt]How to create a Historic?[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:43:45+00:00\",\"dateModified\":\"2019-07-05T19:27:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to create a Historic?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to create a Historic? - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]How to create a Historic?[:] - Elipse Knowledgebase","og_description":"To create a Historic, first make sure the Domain has a DBServer. To add one to the Domain, right-click the project and select the option Insert &#8211; > Database, and&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:43:45+00:00","article_modified_time":"2019-07-05T19:27:44+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5012\/1.png"}],"author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"How to create a Historic?","datePublished":"2019-03-25T20:43:45+00:00","dateModified":"2019-07-05T19:27:44+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/"},"wordCount":405,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Historic"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/","url":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/","name":"[:pt]How to create a Historic?[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:43:45+00:00","dateModified":"2019-07-05T19:27:44+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/how-to-create-a-historic\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"How to create a Historic?"}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3324"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3324"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3324\/revisions"}],"predecessor-version":[{"id":7589,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3324\/revisions\/7589"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}