{"id":19520,"date":"2022-05-26T05:48:26","date_gmt":"2022-05-26T05:48:26","guid":{"rendered":"https:\/\/bravocontrols.com\/?p=19520"},"modified":"2022-09-11T22:37:58","modified_gmt":"2022-09-11T22:37:58","slug":"t3000-bms-database-backend","status":"publish","type":"post","link":"https:\/\/bravocontrols.com\/zh\/t3000-bms-database-backend\/","title":{"rendered":"T3000 BMS Database Backend"},"content":{"rendered":"
\n
\"T3000<\/a>
The ‘T3000 Database Backend’ opens up our open source BMS system to external applications. <\/strong><\/em><\/figcaption><\/figure><\/div>\n\n\n

T3000 Database reduces data reentry<\/h2>\n\n\n\n

In my early days of learning the controls business one of my many chores was doing the project quotations. This required a lot of keeping track of data in spreadsheets and my trusty homegrown Building Automation Database application. Assuming my quote was good and we won the project now we had to program all the controllers. That was also one of my tasks and the data I had in the quote was pretty much what I was typing into the controllers. It was frustrating to have to type it all in again. Well finally after a couple decades in the business (ugh) we are getting closer to the dream.<\/p>\n\n\n\n

Fandu, our top T3000 developer here is ready to show off the results of his work. He has migrated all the data from the original binary data format to an industry standard ‘Access’ format database file. All the inputs, outputs, variables, schedules, holidays, trend logs, etc. , even the network communications settings for every controller in the building are included in the database. Any program which can work with ‘Access’ format files can work with this data including Excel and Microsoft Access.<\/p>\n\n\n\n

Future Work<\/h2>\n\n\n\n

With this open access to the inner workings of our system it will be easy to add higher level features. Currently we’re working on building out a library system to further speed up your work on new projects. The T3000 environment also now uses a well defined API which will open our environment to web services, we’ll describe there here soon as well. It has taken 20 plus years to get here but I am proud to be able to finally show these first steps.<\/p>\n\n\n\n

You can see more screen shots and details of the database file system here on the forum:<\/p>\n\n\n\n

https:\/\/forums.temcocontrols.com\/t\/t3000-database-backend\/1369\/2<\/a><\/p>\n\n\n\n

\"\"<\/a><\/p>","protected":false},"excerpt":{"rendered":"

T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files. <\/p>","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"publish_to_discourse":"1","publish_post_category":"7","wpdc_auto_publish_overridden":"1","wpdc_topic_tags":"","wpdc_pin_topic":"","wpdc_pin_until":"","discourse_post_id":"4445","discourse_permalink":"https:\/\/forums.temcocontrols.com\/t\/t3000-bms-database-backend\/1376","wpdc_publishing_response":"","wpdc_publishing_error":"","footnotes":""},"categories":[13,414],"tags":[1821,1820,1823,1824,1822],"acf":[],"yoast_head":"\nT3000 BMS Database Backend - Bravo Controls<\/title>\n<meta name=\"description\" content=\"T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bravocontrols.com\/zh\/t3000-bms-database-backend\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T3000 BMS Database Backend\" \/>\n<meta property=\"og:description\" content=\"T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bravocontrols.com\/zh\/t3000-bms-database-backend\/\" \/>\n<meta property=\"og:site_name\" content=\"Bravo Controls\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/bravocontrols\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-26T05:48:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-11T22:37:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png\" \/>\n<meta name=\"author\" content=\"Maurice Duteau\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bravo_controls\" \/>\n<meta name=\"twitter:site\" content=\"@bravo_controls\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maurice Duteau\" \/>\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:\/\/bravocontrols.com\/t3000-bms-database-backend\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/\"},\"author\":{\"name\":\"Maurice Duteau\",\"@id\":\"https:\/\/bravocontrols.com\/#\/schema\/person\/57cde67c69dd506bd65d64a643020e88\"},\"headline\":\"T3000 BMS Database Backend\",\"datePublished\":\"2022-05-26T05:48:26+00:00\",\"dateModified\":\"2022-09-11T22:37:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/\"},\"wordCount\":323,\"publisher\":{\"@id\":\"https:\/\/bravocontrols.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png\",\"keywords\":[\"BMS\",\"Database\",\"Excel\",\"Microsoft Access\",\"Open source BMS\"],\"articleSection\":[\"Automation\",\"Open Source\"],\"inLanguage\":\"zh-CN\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/\",\"url\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/\",\"name\":\"T3000 BMS Database Backend - Bravo Controls\",\"isPartOf\":{\"@id\":\"https:\/\/bravocontrols.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png\",\"datePublished\":\"2022-05-26T05:48:26+00:00\",\"dateModified\":\"2022-09-11T22:37:58+00:00\",\"description\":\"T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files.\",\"breadcrumb\":{\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#breadcrumb\"},\"inLanguage\":\"zh-CN\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage\",\"url\":\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png\",\"contentUrl\":\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bravocontrols.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T3000 BMS Database Backend\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bravocontrols.com\/#website\",\"url\":\"https:\/\/bravocontrols.com\/\",\"name\":\"Bravo Controls\",\"description\":\"Great building automation products at great prices.\",\"publisher\":{\"@id\":\"https:\/\/bravocontrols.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bravocontrols.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-CN\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bravocontrols.com\/#organization\",\"name\":\"Bravo Controls\",\"url\":\"https:\/\/bravocontrols.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"https:\/\/bravocontrols.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2017\/12\/logo.png\",\"contentUrl\":\"https:\/\/bravocontrols.com\/wp-content\/uploads\/2017\/12\/logo.png\",\"width\":194,\"height\":80,\"caption\":\"Bravo Controls\"},\"image\":{\"@id\":\"https:\/\/bravocontrols.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/bravocontrols\",\"https:\/\/x.com\/bravo_controls\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/bravocontrols.com\/#\/schema\/person\/57cde67c69dd506bd65d64a643020e88\",\"name\":\"Maurice Duteau\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-CN\",\"@id\":\"https:\/\/bravocontrols.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/92e73dd5051b3df82c5fde50a6a66552?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/92e73dd5051b3df82c5fde50a6a66552?s=96&d=mm&r=g\",\"caption\":\"Maurice Duteau\"},\"sameAs\":[\"http:\/\/www.temcocontrols.com\"],\"url\":\"https:\/\/bravocontrols.com\/zh\/author\/maurice\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"T3000 BMS Database Backend - Bravo Controls","description":"T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files.","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:\/\/bravocontrols.com\/zh\/t3000-bms-database-backend\/","og_locale":"zh_CN","og_type":"article","og_title":"T3000 BMS Database Backend","og_description":"T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files.","og_url":"https:\/\/bravocontrols.com\/zh\/t3000-bms-database-backend\/","og_site_name":"Bravo Controls","article_publisher":"https:\/\/www.facebook.com\/bravocontrols","article_published_time":"2022-05-26T05:48:26+00:00","article_modified_time":"2022-09-11T22:37:58+00:00","og_image":[{"url":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png"}],"author":"Maurice Duteau","twitter_card":"summary_large_image","twitter_creator":"@bravo_controls","twitter_site":"@bravo_controls","twitter_misc":{"Written by":"Maurice Duteau","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#article","isPartOf":{"@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/"},"author":{"name":"Maurice Duteau","@id":"https:\/\/bravocontrols.com\/#\/schema\/person\/57cde67c69dd506bd65d64a643020e88"},"headline":"T3000 BMS Database Backend","datePublished":"2022-05-26T05:48:26+00:00","dateModified":"2022-09-11T22:37:58+00:00","mainEntityOfPage":{"@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/"},"wordCount":323,"publisher":{"@id":"https:\/\/bravocontrols.com\/#organization"},"image":{"@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage"},"thumbnailUrl":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png","keywords":["BMS","Database","Excel","Microsoft Access","Open source BMS"],"articleSection":["Automation","Open Source"],"inLanguage":"zh-CN"},{"@type":"WebPage","@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/","url":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/","name":"T3000 BMS Database Backend - Bravo Controls","isPartOf":{"@id":"https:\/\/bravocontrols.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage"},"image":{"@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage"},"thumbnailUrl":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png","datePublished":"2022-05-26T05:48:26+00:00","dateModified":"2022-09-11T22:37:58+00:00","description":"T3000 can now save all the data from our controllers in an external database in Microsoft Acces format. This opens up all the internal workings of the T3000 environment to any program that can read & write to Access format files.","breadcrumb":{"@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#breadcrumb"},"inLanguage":"zh-CN","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bravocontrols.com\/t3000-bms-database-backend\/"]}]},{"@type":"ImageObject","inLanguage":"zh-CN","@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#primaryimage","url":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png","contentUrl":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2022\/05\/T3_Database-800x593.png"},{"@type":"BreadcrumbList","@id":"https:\/\/bravocontrols.com\/t3000-bms-database-backend\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bravocontrols.com\/"},{"@type":"ListItem","position":2,"name":"T3000 BMS Database Backend"}]},{"@type":"WebSite","@id":"https:\/\/bravocontrols.com\/#website","url":"https:\/\/bravocontrols.com\/","name":"Bravo Controls","description":"Great building automation products at great prices.","publisher":{"@id":"https:\/\/bravocontrols.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bravocontrols.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-CN"},{"@type":"Organization","@id":"https:\/\/bravocontrols.com\/#organization","name":"Bravo Controls","url":"https:\/\/bravocontrols.com\/","logo":{"@type":"ImageObject","inLanguage":"zh-CN","@id":"https:\/\/bravocontrols.com\/#\/schema\/logo\/image\/","url":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2017\/12\/logo.png","contentUrl":"https:\/\/bravocontrols.com\/wp-content\/uploads\/2017\/12\/logo.png","width":194,"height":80,"caption":"Bravo Controls"},"image":{"@id":"https:\/\/bravocontrols.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/bravocontrols","https:\/\/x.com\/bravo_controls"]},{"@type":"Person","@id":"https:\/\/bravocontrols.com\/#\/schema\/person\/57cde67c69dd506bd65d64a643020e88","name":"Maurice Duteau","image":{"@type":"ImageObject","inLanguage":"zh-CN","@id":"https:\/\/bravocontrols.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/92e73dd5051b3df82c5fde50a6a66552?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/92e73dd5051b3df82c5fde50a6a66552?s=96&d=mm&r=g","caption":"Maurice Duteau"},"sameAs":["http:\/\/www.temcocontrols.com"],"url":"https:\/\/bravocontrols.com\/zh\/author\/maurice\/"}]}},"_links":{"self":[{"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/posts\/19520"}],"collection":[{"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/comments?post=19520"}],"version-history":[{"count":0,"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/posts\/19520\/revisions"}],"wp:attachment":[{"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/media?parent=19520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/categories?post=19520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bravocontrols.com\/zh\/wp-json\/wp\/v2\/tags?post=19520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}