{"id":344,"date":"2020-06-11T14:22:00","date_gmt":"2020-06-11T13:22:00","guid":{"rendered":"https:\/\/bxproject.co.uk\/blog\/?p=344"},"modified":"2022-03-14T22:04:57","modified_gmt":"2022-03-14T22:04:57","slug":"building-a-can-database-from-a-busmaster-log-file","status":"publish","type":"post","link":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/","title":{"rendered":"BusMaster &#8211; Building a CAN database from a log file"},"content":{"rendered":"<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\"><\/span> <span class=\"rt-time\"> 4<\/span> <span class=\"rt-label rt-postfix\">min. read<\/span><\/span>\n<p>In this article, we will look at a few simple tips to help start building your own CAN database. We&#8217;ll start with the BusMaster log file that we took from the stand-alone module in the <a href=\"https:\/\/bxproject.co.uk\/blog\/wake-a-stand-alone-module-with-busmaster-log-replay\/\">previous article<\/a>. We will import this to <a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/excel\" target=\"_blank\">Excel <\/a>to do some initial data mining. Then we can start to construct our own CAN database and put it to use in a BusMaster configuration.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Stand alone module log file<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"521\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_StandaloneSuccessAnno.png\" alt=\"BusMaster message window with TX and RX messages\" class=\"wp-image-321\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_StandaloneSuccessAnno.png 800w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_StandaloneSuccessAnno-600x391.png 600w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_StandaloneSuccessAnno-300x195.png 300w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_StandaloneSuccessAnno-768x500.png 768w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><figcaption>Stand-alone module communication in BusMaster<\/figcaption><\/figure>\n\n\n\n<p>At the end of the previous article, we connected directly to a stand-alone module and woke up the FCDIM. Then, we could interact with the display screen and see some incoming messages from the module, outlined in Red above.<\/p>\n\n\n\n<p>While there are filtering tools in the BusMaster message window, they only work when communication is stopped. Even then, the performance is mixed. I certainly experience problems with filtering by the &#8216;Tx\/Rx&#8217; column. To avoid this and give some flexibility, I usually import the log into Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Importing a log file to Excel<\/h2>\n\n\n\n<p>Rather than risk creating a long and tedious thread about the fundamentals of data import in Excel, I&#8217;ve created a separate post. The article deals with importing as a text file, building structure and cleaning out some &#8216;ghost&#8217; messages. It will also introduce filtering and how to use it to investigate the data. If you need to, have a read a pop back.<\/p>\n\n\n\n<p>Read: <a href=\"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">Step by Step &#8211; Import a BusMaster Log in Excel<\/a><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"277\" height=\"223\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/XL_FilterRX.png\" alt=\"Filtering the received message addresses\" class=\"wp-image-354\"\/><figcaption>Filtering the received message addresses<\/figcaption><\/figure><\/div>\n\n\n\n<p>With the log from the stand-alone module imported and filtered, you should end up with a shortlist of addresses on which the FCDIM is transmitting data, as shown above. We can now start using this list to populate our CAN database.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">A CAN database (CANdb) introduction<\/h2>\n\n\n\n<p>A CAN Database (CANdb) is a structure for describing the content of a message as defined by the CAN specification. A CANdb file usually has a &#8216;.dbc&#8217; file type. A CANdb describes every module by its addresses, every frame that address will send and every signal contained within the frame.<\/p>\n\n\n\n<p>It is unusual for a single module to need to use every single message on the Bus, all 6500ish of them. For example, The HVAC control doesn&#8217;t need to know how much fuel is being injected into an individual cylinder in the engine. The CANdb also describes the relationships the modules have to each other&#8217;s messages, and perhaps critically, if module B needs to receive a message from module A. As you might imagine, this data is not shared by manufacturers or suppliers.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Making a CANdb in BusMaster<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"286\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM-CanDB.png\" alt=\"\" class=\"wp-image-355\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM-CanDB.png 471w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM-CanDB-300x182.png 300w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><figcaption>Creating a new CAN DBF in BusMaster<\/figcaption><\/figure><\/div>\n\n\n\n<p>BusMaster uses a simplified version of the CANdb in a &#8216;.dbf&#8217; file type. By creating our own CANdb, we will be able to identify messages sent by a specific module based on its address. When we start to look for changes in the system, we can quickly find the changed values if we already have the address of the module we expect to change. <\/p>\n\n\n\n<p>With BusMaster open, select &#8216;Tools&#8217;, then &#8216;CAN DBF Editor&#8217;, then &#8216;New&#8217; to start your own CANdb, as shown above. Give it a descriptive name and save it somewhere you&#8217;ll find it again. Personally I try to save all my BusMaster files in one folder for each configuration I create.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"532\" height=\"147\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_NewMsg.png\" alt=\"Create a new message in the database\" class=\"wp-image-358\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_NewMsg.png 532w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_NewMsg-300x83.png 300w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/><figcaption>Create a new message in the database<\/figcaption><\/figure><\/div>\n\n\n\n<p>Once the new database is saved, you&#8217;ll want to start adding messages, to do this right click on the database name and select &#8216;New Message&#8217;.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"245\" height=\"242\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_NewMsg3.png\" alt=\"Entering the new message details\" class=\"wp-image-359\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_NewMsg3.png 245w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_NewMsg3-100x100.png 100w\" sizes=\"auto, (max-width: 245px) 100vw, 245px\" \/><figcaption>Entering the new message details<\/figcaption><\/figure><\/div>\n\n\n\n<p>Next, enter the message details. You can give the message any name you like, but it really needs to describe the module that is sending it. In this case, we will call it &#8216;FCDIM_a&#8217;. As we already know that the FCDIM sends data on multiple messages, we need to give it a suffix. I like to give alphabet suffixes rather than numbers, and I will start with &#8216;_a&#8217; being the lowest address. Remember that list from the Excel filter? The lowest value was &#8216;0x278&#8217;, so this becomes our message ID. We also saw in Excel that the length of the message was 8 bytes, so we can enter that too. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1011\" height=\"284\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_Msg1.png\" alt=\"The start of our own BusMaster CAN database \" class=\"wp-image-357\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_Msg1.png 1011w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_Msg1-960x270.png 960w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_Msg1-300x84.png 300w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/bm_dbf_Msg1-768x216.png 768w\" sizes=\"auto, (max-width: 1011px) 100vw, 1011px\" \/><figcaption>The start of our own CAN database<\/figcaption><\/figure>\n\n\n\n<p>We can build up our CANdb to include the nine addresses we have identified as coming from the FCDIM. At the moment, we have only given the message a name and have not identified signals within it, but we will cover this in a later topic. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Associating our CANdb in BusMaster<\/h2>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"473\" height=\"230\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/Annotation-2020-06-03-175640.png\" alt=\"\" class=\"wp-image-365\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/Annotation-2020-06-03-175640.png 473w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/Annotation-2020-06-03-175640-300x146.png 300w\" sizes=\"auto, (max-width: 473px) 100vw, 473px\" \/><figcaption>Associate a CANdb in BusMaster<\/figcaption><\/figure><\/div>\n\n\n\n<p>Within the BusMaster, we can use this database by associating it with the configuration, as shown above. Once the &#8216;dbf&#8217; file is linked in BusMaster, we will automatically start to see the address of the known module replaced with its name.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"276\" src=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_Associateddbf.png\" alt=\"Rich text in BusMaster Message window\" class=\"wp-image-366\" srcset=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_Associateddbf.png 772w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_Associateddbf-600x215.png 600w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_Associateddbf-300x107.png 300w, https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/BM_Associateddbf-768x275.png 768w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><figcaption>Rich text in BusMaster Message window<\/figcaption><\/figure><\/div>\n\n\n\n<p>Straight away, we will start to see a benefit from having rich text names. Not only can we now relate a message with a module, but we can see duplicate messages we are transmitting from our log file.<\/p>\n\n\n\n<p>In theory, if we were to take every module from a car, wake it up on the bench and associate the message address with the module, we would have a pretty big CANdb. But the link between the message address and the module is only a small amount of the database. It would require a lot more work to identify what each byte in the message controls, and we could make only a guess as to the dependencies each module has on a particular message.<\/p>\n\n\n\n<p>We now have a start point for investigating the communication between modules. The database will allow us to check if a module is communicating on the bus, a very useful diagnostic tool. We&#8217;ve also worked with CAN networks enough to understand how the messages are formed and how they flow around the network.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The end of the Series<\/h2>\n\n\n\n<p>This is the last in this set of CANBus articles.<br><br><em><strong>But it&#8217;s not over until it&#8217;s over!<\/strong><\/em><br><br>To realise some of the extra features we want to use on the FCDIM, we need to understand what they are and what sort of messages they might include. <br><br>We now have enough knowledge to start creating our own hardware. That might come in handy if we want to start quickly interacting with messages on the bench.<br><br>Perhaps most importantly, we will have to start considering the Car Configuration File, which could get complicated.<br><br>So come back for future articles on the Gen2.1 system and consider subscribing by email or Facebook to receive notifications on new posts.<br><br>Thanks for sticking with me to the end. I hope you enjoyed and learned something from this series.<br><br>M<br><\/p>\n\n\n\n<p>NEXT &#8211; <br><a href=\"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/\">PREV &#8211; Import a BusMaster Log in Excel<\/a><br><br><a href=\"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/diagnostics\/\">Back to Diagnostics Articles<\/a><br><a href=\"https:\/\/bxproject.co.uk\/blog\/electronics\/\">Back to Electronics Articles<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will look at a few simple tips to help start building your own CAN database. We&#8217;ll start with the BusMaster log file that we&hellip;<\/p>\n","protected":false},"author":1,"featured_media":258,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[87,16],"tags":[96,88,89,116,117,114],"class_list":["post-344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-canbus","category-electronics","tag-busmaster","tag-can","tag-canbus","tag-candb","tag-database","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>BusMaster - Building a CAN database from a log file - BX Project<\/title>\n<meta name=\"description\" content=\"In this article we will look at how to start building your own CAN database in BusMaster starting with a log file and tips on structure and using Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"BusMaster - Building a CAN database from a log file - BX Project\" \/>\n<meta property=\"og:description\" content=\"In this article we will look at how to start building your own CAN database in BusMaster starting with a log file and tips on structure and using Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/\" \/>\n<meta property=\"og:site_name\" content=\"BX Project\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BXProjectFB\" \/>\n<meta property=\"article:author\" content=\"BXProjectFB\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-11T13:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-14T22:04:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png\" \/>\n\t<meta property=\"og:image:width\" content=\"799\" \/>\n\t<meta property=\"og:image:height\" content=\"394\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Admin_M\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bxprojectT\" \/>\n<meta name=\"twitter:site\" content=\"@BXProjectT\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Admin_M\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/\"},\"author\":{\"name\":\"Admin_M\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/cdb60b055febb747294e9606dc156e1b\"},\"headline\":\"BusMaster &#8211; Building a CAN database from a log file\",\"datePublished\":\"2020-06-11T13:22:00+00:00\",\"dateModified\":\"2022-03-14T22:04:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/\"},\"wordCount\":1162,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/CANBusShort.png\",\"keywords\":[\"BusMaster\",\"CAN\",\"CANBus\",\"CANdb\",\"database\",\"Excel\"],\"articleSection\":[\"CAN Bus\",\"Electronics\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/\",\"url\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/\",\"name\":\"BusMaster - Building a CAN database from a log file - BX Project\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/CANBusShort.png\",\"datePublished\":\"2020-06-11T13:22:00+00:00\",\"dateModified\":\"2022-03-14T22:04:57+00:00\",\"description\":\"In this article we will look at how to start building your own CAN database in BusMaster starting with a log file and tips on structure and using Excel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#primaryimage\",\"url\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/CANBusShort.png\",\"contentUrl\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/CANBusShort.png\",\"width\":799,\"height\":394},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/building-a-can-database-from-a-busmaster-log-file\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"BusMaster &#8211; Building a CAN database from a log file\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/\",\"name\":\"BX Project\",\"description\":\"Automotive Adventures\",\"publisher\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#organization\",\"name\":\"BXProject\",\"url\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/BXP_RJW_banner-300-dpi-800.jpg\",\"contentUrl\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/BXP_RJW_banner-300-dpi-800.jpg\",\"width\":800,\"height\":267,\"caption\":\"BXProject\"},\"image\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/BXProjectFB\",\"https:\\\/\\\/x.com\\\/BXProjectT\",\"https:\\\/\\\/www.instagram.com\\\/bxproject_ig\\\/?hl=en\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCO7rHKgcIafXLItQRGj-BXQ\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/cdb60b055febb747294e9606dc156e1b\",\"name\":\"Admin_M\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d1993dfbb08228583c93eda998592304d6d62589c3c1aaf39555713522778745?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d1993dfbb08228583c93eda998592304d6d62589c3c1aaf39555713522778745?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d1993dfbb08228583c93eda998592304d6d62589c3c1aaf39555713522778745?s=96&d=mm&r=g\",\"caption\":\"Admin_M\"},\"sameAs\":[\"http:\\\/\\\/bxproject.co.uk\\\/blog\",\"BXProjectFB\",\"https:\\\/\\\/www.instagram.com\\\/bxproject_ig\",\"https:\\\/\\\/x.com\\\/bxprojectT\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"BusMaster - Building a CAN database from a log file - BX Project","description":"In this article we will look at how to start building your own CAN database in BusMaster starting with a log file and tips on structure and using Excel.","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:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/","og_locale":"en_GB","og_type":"article","og_title":"BusMaster - Building a CAN database from a log file - BX Project","og_description":"In this article we will look at how to start building your own CAN database in BusMaster starting with a log file and tips on structure and using Excel.","og_url":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/","og_site_name":"BX Project","article_publisher":"https:\/\/www.facebook.com\/BXProjectFB","article_author":"BXProjectFB","article_published_time":"2020-06-11T13:22:00+00:00","article_modified_time":"2022-03-14T22:04:57+00:00","og_image":[{"width":799,"height":394,"url":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","type":"image\/png"}],"author":"Admin_M","twitter_card":"summary_large_image","twitter_creator":"@bxprojectT","twitter_site":"@BXProjectT","twitter_misc":{"Written by":"Admin_M","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#article","isPartOf":{"@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/"},"author":{"name":"Admin_M","@id":"https:\/\/bxproject.co.uk\/blog\/#\/schema\/person\/cdb60b055febb747294e9606dc156e1b"},"headline":"BusMaster &#8211; Building a CAN database from a log file","datePublished":"2020-06-11T13:22:00+00:00","dateModified":"2022-03-14T22:04:57+00:00","mainEntityOfPage":{"@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/"},"wordCount":1162,"commentCount":2,"publisher":{"@id":"https:\/\/bxproject.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#primaryimage"},"thumbnailUrl":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","keywords":["BusMaster","CAN","CANBus","CANdb","database","Excel"],"articleSection":["CAN Bus","Electronics"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/","url":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/","name":"BusMaster - Building a CAN database from a log file - BX Project","isPartOf":{"@id":"https:\/\/bxproject.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#primaryimage"},"image":{"@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#primaryimage"},"thumbnailUrl":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","datePublished":"2020-06-11T13:22:00+00:00","dateModified":"2022-03-14T22:04:57+00:00","description":"In this article we will look at how to start building your own CAN database in BusMaster starting with a log file and tips on structure and using Excel.","breadcrumb":{"@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#primaryimage","url":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","contentUrl":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","width":799,"height":394},{"@type":"BreadcrumbList","@id":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bxproject.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"BusMaster &#8211; Building a CAN database from a log file"}]},{"@type":"WebSite","@id":"https:\/\/bxproject.co.uk\/blog\/#website","url":"https:\/\/bxproject.co.uk\/blog\/","name":"BX Project","description":"Automotive Adventures","publisher":{"@id":"https:\/\/bxproject.co.uk\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bxproject.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/bxproject.co.uk\/blog\/#organization","name":"BXProject","url":"https:\/\/bxproject.co.uk\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bxproject.co.uk\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2021\/07\/BXP_RJW_banner-300-dpi-800.jpg","contentUrl":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2021\/07\/BXP_RJW_banner-300-dpi-800.jpg","width":800,"height":267,"caption":"BXProject"},"image":{"@id":"https:\/\/bxproject.co.uk\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/BXProjectFB","https:\/\/x.com\/BXProjectT","https:\/\/www.instagram.com\/bxproject_ig\/?hl=en","https:\/\/www.youtube.com\/channel\/UCO7rHKgcIafXLItQRGj-BXQ"]},{"@type":"Person","@id":"https:\/\/bxproject.co.uk\/blog\/#\/schema\/person\/cdb60b055febb747294e9606dc156e1b","name":"Admin_M","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/d1993dfbb08228583c93eda998592304d6d62589c3c1aaf39555713522778745?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d1993dfbb08228583c93eda998592304d6d62589c3c1aaf39555713522778745?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d1993dfbb08228583c93eda998592304d6d62589c3c1aaf39555713522778745?s=96&d=mm&r=g","caption":"Admin_M"},"sameAs":["http:\/\/bxproject.co.uk\/blog","BXProjectFB","https:\/\/www.instagram.com\/bxproject_ig","https:\/\/x.com\/bxprojectT"]}]}},"jetpack_featured_media_url":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":315,"url":"https:\/\/bxproject.co.uk\/blog\/wake-a-stand-alone-module-with-busmaster-log-replay\/","url_meta":{"origin":344,"position":0},"title":"Wake a stand-alone module with BusMaster log replay","author":"Admin_M","date":"9 June 2020","format":false,"excerpt":"Now we have an electrical connection to the stand-alone module, we can use BusMaster to replay a log file and wake-up the display screen.","rel":"","context":"In &quot;CAN Bus&quot;","block_context":{"text":"CAN Bus","link":"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/canbus\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":361,"url":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/","url_meta":{"origin":344,"position":1},"title":"Step by Step &#8211; Import a BusMaster Log in Excel","author":"Admin_M","date":"10 June 2020","format":false,"excerpt":"Step by Step - Import a BusMaster Log in Excel","rel":"","context":"In &quot;CAN Bus&quot;","block_context":{"text":"CAN Bus","link":"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/canbus\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":245,"url":"https:\/\/bxproject.co.uk\/blog\/canbus-whispering\/","url_meta":{"origin":344,"position":2},"title":"CANBus &#8211; Whispering With BusMaster","author":"Admin_M","date":"1 June 2020","format":false,"excerpt":"We know what the CANBus is, and what hardware is needed to make the connection will. Lets start listening to the car!","rel":"","context":"In &quot;CAN Bus&quot;","block_context":{"text":"CAN Bus","link":"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/canbus\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/05\/CANBus.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/05\/CANBus.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/05\/CANBus.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/05\/CANBus.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":261,"url":"https:\/\/bxproject.co.uk\/blog\/canbus-data-frames\/","url_meta":{"origin":344,"position":3},"title":"CANBus &#8211; Interpreting Data Frames","author":"Admin_M","date":"3 June 2020","format":false,"excerpt":"What is in a CAN frame, and how do we start to break it down?","rel":"","context":"In &quot;CAN Bus&quot;","block_context":{"text":"CAN Bus","link":"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/canbus\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":253,"url":"https:\/\/bxproject.co.uk\/blog\/canbus-crash-reset\/","url_meta":{"origin":344,"position":4},"title":"CANBus &#8211; How to reset a crash","author":"Admin_M","date":"2 June 2020","format":false,"excerpt":"You've connected to the Land Rover and now it's not happy. How do you reset a CANBus crash? Read on to find out!","rel":"","context":"In &quot;CAN Bus&quot;","block_context":{"text":"CAN Bus","link":"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/canbus\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1133,"url":"https:\/\/bxproject.co.uk\/blog\/diy-can-bus-adapter\/","url_meta":{"origin":344,"position":5},"title":"DIY CAN Bus Adapter","author":"Admin_M","date":"1 January 2021","format":false,"excerpt":"I can't afford to use industry-standard CAN bus hardware, but can I make my own DIY CAN Bus Adapter with simple components?","rel":"","context":"In &quot;CAN Bus&quot;","block_context":{"text":"CAN Bus","link":"https:\/\/bxproject.co.uk\/blog\/category\/electronics\/canbus\/"},"img":{"alt_text":"Can in the middle version 1","src":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/12\/CITM1.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/12\/CITM1.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/12\/CITM1.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/12\/CITM1.jpg?resize=700%2C400&ssl=1 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/posts\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":0,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/media\/258"}],"wp:attachment":[{"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}