{"id":9243,"date":"2021-12-02T19:31:00","date_gmt":"2021-12-02T18:31:00","guid":{"rendered":"https:\/\/www.martin-fleischer.com\/?p=9243"},"modified":"2023-06-02T17:58:21","modified_gmt":"2023-06-02T15:58:21","slug":"the-gofarbot","status":"publish","type":"post","link":"https:\/\/www.martin-fleischer.com\/en\/consultancies\/the-gofarbot\/","title":{"rendered":"The \u00abgoFARbot\u00bb"},"content":{"rendered":"\n<p>With the completion of the <em>\u00ab<\/em><strong><em><a href=\"https:\/\/www.martin-fleischer.com\/en\/consultancies\/project-gofar\/\" target=\"_blank\" rel=\"noreferrer noopener\">goFAR<\/a><\/em><\/strong><em>\u00bb<\/em> project and after the transfer of all data to the <em>\u00ab<\/em><strong><em>CREATE<\/em><\/strong><em>\u00bb<\/em> platform, which allows the entire article database to be synchronised with the company website and e-shop via special <strong>API<\/strong><em>s<\/em>&nbsp;(<strong>A<\/strong>pplication&nbsp;<strong>P<\/strong>rogramming&nbsp;<strong>I<\/strong>nterface<em>s<\/em>), it seemed appropriate to carry out a further external check on the consistency of the synchronised data.<\/p>\n\n\n\n<p>The <em>\u00ab<strong>goFARbot<\/strong>\u00bb<\/em>, VBA (Visual Basic for Applications) script on an EXCEL platform:<\/p>\n\n\n\n<ol>\n<li>downloads the entire content of the database contained in \u00abCREATE\u00bb via an XML protocol<\/li>\n\n\n\n<li>scans all the URLs contained therein (more than 700 articles in 4 languages on the website and several hundred articles on the e-shop for a total of more than 3,000 URLs), retrieving data such as article codes and\/or prices and comparing them with the contents of <strong><em>\u00abCREATE\u00bb<\/em><\/strong> itself<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>With the completion of the \u00abgoFAR\u00bb project and after the transfer of all data to the \u00abCREATE\u00bb platform, which allows the entire article database to be synchronised with the company website and e-shop via special APIs&nbsp;(Application&nbsp;Programming&nbsp;Interfaces), it seemed appropriate to carry out a further external check on the consistency of the synchronised data. The \u00abgoFARbot\u00bb, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":9246,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[136],"tags":[],"_links":{"self":[{"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/posts\/9243"}],"collection":[{"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/comments?post=9243"}],"version-history":[{"count":2,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/posts\/9243\/revisions"}],"predecessor-version":[{"id":9748,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/posts\/9243\/revisions\/9748"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/media\/9246"}],"wp:attachment":[{"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/media?parent=9243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/categories?post=9243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.martin-fleischer.com\/en\/wp-json\/wp\/v2\/tags?post=9243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}