{"id":361,"date":"2020-06-10T20:10:02","date_gmt":"2020-06-10T19:10:02","guid":{"rendered":"https:\/\/bxproject.co.uk\/blog\/?p=361"},"modified":"2021-01-10T11:27:11","modified_gmt":"2021-01-10T11:27:11","slug":"step-by-step-import-a-busmaster-log-to-excel","status":"publish","type":"post","link":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/","title":{"rendered":"Step by Step – Import a BusMaster Log in Excel"},"content":{"rendered":"<\/span> 3<\/span> min. read<\/span><\/span>\n

In previous articles<\/a>, we looked at taking a CANBus log using BusMaster. Getting useable information from the Logs can be a little bit daunting. In this article, we’ll take a step by step look at converting the BusMaster Log into a Microsoft Excel<\/a> spreadsheet.

I apologise now if you’re already proficient with Excel, some aren’t, and importing and filtering are not common tasks for all. Hopefully, this step by step guide will help those with less experience with Excel and might be a memory jog for those that need it.<\/em><\/p>\n\n\n\n

Step 1 – Importing a log file to Excel<\/h3>\n\n\n\n

Okay, first up open Excel and save your workbook somewhere you can find it again!. <\/p>\n\n\n\n

\"Excel
In Excel, us the ‘Get External Data’ controls<\/figcaption><\/figure><\/div>\n\n\n\n

In the workbook, we are going to use the data import feature. This can be found in the ‘Data’ tab of the navigation ribbon. Then we will use the ‘From Text’ function in the ‘Get External Data’ group.<\/p>\n\n\n\n

\"Using
Load the log file into the Text Importer<\/figcaption><\/figure>\n\n\n\n

We will then need to tell the ‘Text Import’ tool which files we want to import. Although the BusMaster log file is a simple text file, it used a file type of .LOG. We need to ensure ‘All Files (*.*)’ is selected, as shown, in order to select the log file.<\/p>\n\n\n\n

\"Select
Select Text Import options in Excel<\/figcaption><\/figure>\n\n\n\n

We want to make some changes to the default import options. 1) We want to use ‘Delimited’ import as our log has a space between each recorded field. 2) We want to start importing at row 14 which save a little time tidying up later. 3) Okay, that’s everything for this page, select next.<\/p>\n\n\n\n

\"Set
Set the import delimiter to ‘Space’<\/figcaption><\/figure>\n\n\n\n

Make sure to select the ‘Space’ delimiter on Step 2 of 3 before selecting ‘Finish’. The default import location is ‘=$A$1’ which is fine for us so we can go ahead and import the data. Hopefully, the log we are importing is only short or this could take a very long time.

It is unusual to need a log of more than 60 seconds for any data review. The slowest messages are sent every 50ms, and the longest chain I have seen is around 40 cycles long, so it takes around 2 seconds on the medium speed bus for all messages to be captured!<\/p>\n\n\n\n

Step 2 – Formatting and Filtering the data<\/h3>\n\n\n\n
\"Apply
Apply filtering to all columns<\/figcaption><\/figure>\n\n\n\n

Now we have some log data we can start to do some formatting.<\/p>\n\n\n\n

  • Delete the last two rows from the data file (file end information)<\/li>
  • Insert a row before the first line<\/li>
  • Type in column headers
    • Time TX\/RX Ch Addr Type Len d0 d1 d2 d3 d4 d5 d6 d7<\/li><\/ul><\/li>
    • Select all populated columns and apply a filter (as shown above)<\/li><\/ul>\n\n\n\n
      \"Applying
      Applying formatting to the data columns<\/figcaption><\/figure>\n\n\n\n

      Next, we want to format the data columns to give them a more traditional ‘HEX’ appearance. This simply means we have two characters in each box. To do this we will select a custom format as shown in the steps above.
      1) Select the formatting drop down from the ‘Home’ tab.
      2) Select more number formats.
      3) Select ‘Custom’.
      4) Select the ‘0’ pre-defined format
      5) Modify the ‘Type’ to show ’00’ (Zero, Zero).<\/p>\n\n\n\n

      \"Filtering
      Filtering out unwanted ‘ghost’ messages<\/figcaption><\/figure>\n\n\n\n

      Now we have something we can pretty much work with. Go ahead and filter the order of the data so that we have the received data first.
      1) Click the drop-down next to the ‘Tx\/Rx’ column title
      2) Select ‘sort A to Z’<\/p>\n\n\n\n

      Have a little scroll up and down and you might see some rows with no data values in, like the box highlighted above. This is another quirk of BusMaster. While it doesn’t seem to lose messages, when comparing against industry-standard software, it does seem to gain some.

      This does happen on a vehicle which is why I think there is an issue with BusMaster, but these ghost lines in the data occur far more on bench testing. Perhaps the 120Ohm termination resistor needs to be less. Either way, filtering the ‘Length’ column to only include ‘0’ then deleting all the remain lines will tidy up our log.<\/p>\n\n\n\n

      Make sure to save regularly between changes. If you import a lot of data, you’ll end up with a very big file which can make Excel unstable and crash.

      Hopefully, you are now confident to import and filter your own data!<\/p>\n\n\n\n

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

      Step by Step – Import a BusMaster Log in Excel<\/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,89,114,115],"class_list":["post-361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-canbus","category-electronics","tag-busmaster","tag-canbus","tag-excel","tag-step-by-step"],"yoast_head":"\nStep by Step - Import a BusMaster Log in Excel - BX Project<\/title>\n<meta name=\"description\" content=\"BusMaster logs can be tough to learn from. In this article, we'll look at simplifying data analysis with Excel, step by step.\" \/>\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\/step-by-step-import-a-busmaster-log-to-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Step by Step - Import a BusMaster Log in Excel - BX Project\" \/>\n<meta property=\"og:description\" content=\"BusMaster logs can be tough to learn from. In this article, we'll look at simplifying data analysis with Excel, step by step.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/\" \/>\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-10T19:10:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-10T11:27:11+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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/\"},\"author\":{\"name\":\"Admin_M\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/cdb60b055febb747294e9606dc156e1b\"},\"headline\":\"Step by Step – Import a BusMaster Log in Excel\",\"datePublished\":\"2020-06-10T19:10:02+00:00\",\"dateModified\":\"2021-01-10T11:27:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/\"},\"wordCount\":736,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/CANBusShort.png\",\"keywords\":[\"BusMaster\",\"CANBus\",\"Excel\",\"Step by Step\"],\"articleSection\":[\"CAN Bus\",\"Electronics\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/\",\"url\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/\",\"name\":\"Step by Step - Import a BusMaster Log in Excel - BX Project\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/CANBusShort.png\",\"datePublished\":\"2020-06-10T19:10:02+00:00\",\"dateModified\":\"2021-01-10T11:27:11+00:00\",\"description\":\"BusMaster logs can be tough to learn from. In this article, we'll look at simplifying data analysis with Excel, step by step.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#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\\\/step-by-step-import-a-busmaster-log-to-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bxproject.co.uk\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Step by Step – Import a BusMaster Log in Excel\"}]},{\"@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":"Step by Step - Import a BusMaster Log in Excel - BX Project","description":"BusMaster logs can be tough to learn from. In this article, we'll look at simplifying data analysis with Excel, step by step.","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\/step-by-step-import-a-busmaster-log-to-excel\/","og_locale":"en_GB","og_type":"article","og_title":"Step by Step - Import a BusMaster Log in Excel - BX Project","og_description":"BusMaster logs can be tough to learn from. In this article, we'll look at simplifying data analysis with Excel, step by step.","og_url":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/","og_site_name":"BX Project","article_publisher":"https:\/\/www.facebook.com\/BXProjectFB","article_author":"BXProjectFB","article_published_time":"2020-06-10T19:10:02+00:00","article_modified_time":"2021-01-10T11:27:11+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#article","isPartOf":{"@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/"},"author":{"name":"Admin_M","@id":"https:\/\/bxproject.co.uk\/blog\/#\/schema\/person\/cdb60b055febb747294e9606dc156e1b"},"headline":"Step by Step – Import a BusMaster Log in Excel","datePublished":"2020-06-10T19:10:02+00:00","dateModified":"2021-01-10T11:27:11+00:00","mainEntityOfPage":{"@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/"},"wordCount":736,"commentCount":1,"publisher":{"@id":"https:\/\/bxproject.co.uk\/blog\/#organization"},"image":{"@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","keywords":["BusMaster","CANBus","Excel","Step by Step"],"articleSection":["CAN Bus","Electronics"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/","url":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/","name":"Step by Step - Import a BusMaster Log in Excel - BX Project","isPartOf":{"@id":"https:\/\/bxproject.co.uk\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#primaryimage"},"image":{"@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/bxproject.co.uk\/blog\/wp-content\/uploads\/2020\/06\/CANBusShort.png","datePublished":"2020-06-10T19:10:02+00:00","dateModified":"2021-01-10T11:27:11+00:00","description":"BusMaster logs can be tough to learn from. In this article, we'll look at simplifying data analysis with Excel, step by step.","breadcrumb":{"@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bxproject.co.uk\/blog\/step-by-step-import-a-busmaster-log-to-excel\/#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\/step-by-step-import-a-busmaster-log-to-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bxproject.co.uk\/blog\/"},{"@type":"ListItem","position":2,"name":"Step by Step – Import a BusMaster Log in Excel"}]},{"@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":344,"url":"https:\/\/bxproject.co.uk\/blog\/building-a-can-database-from-a-busmaster-log-file\/","url_meta":{"origin":361,"position":0},"title":"BusMaster – Building a CAN database from a log file","author":"Admin_M","date":"11 June 2020","format":false,"excerpt":"In this article, we will look at a few simple tips to help start building your own CAN database. We'll start with the BusMaster log file that we took from the stand-alone module in the previous article. We will import this to Excel to do some initial data mining. Then\u2026","rel":"","context":"In "CAN Bus"","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":361,"position":1},"title":"CANBus – 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 "CAN Bus"","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":315,"url":"https:\/\/bxproject.co.uk\/blog\/wake-a-stand-alone-module-with-busmaster-log-replay\/","url_meta":{"origin":361,"position":2},"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 "CAN Bus"","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":361,"position":3},"title":"CANBus – 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 "CAN Bus"","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":361,"position":4},"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 "CAN Bus"","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":[]},{"id":261,"url":"https:\/\/bxproject.co.uk\/blog\/canbus-data-frames\/","url_meta":{"origin":361,"position":5},"title":"CANBus – 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 "CAN Bus"","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":[]}],"_links":{"self":[{"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/posts\/361","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=361"}],"version-history":[{"count":0,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/posts\/361\/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=361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bxproject.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}