WP_Query Object
(
[query] => Array
(
[paged] => 8
[pagename] => about-us/news
)
[query_vars] => Array
(
[paged] => 8
[pagename] => about-us/news
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
[0] => 1047
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[orderby] => date
[post_type] => Array
(
[0] => post
[1] => developer_blog
)
[post_status] => publish
[order] => DESC
[tax_query] => Array
(
[0] => Array
(
[taxonomy] => blog-group
[field] => slug
[terms] => Array
(
[0] => public
)
[operator] => IN
)
[1] => Array
(
[taxonomy] => blog-group
[field] => slug
[terms] => Array
(
[0] => general-user
[1] => technical-asociate
[2] => qualified-sales-representative
[3] => kvaser-internal
)
[operator] => NOT IN
)
)
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[posts_per_page] => 10
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => blog-group
[term] => public
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[0] => Array
(
[taxonomy] => blog-group
[terms] => Array
(
[0] => public
)
[field] => slug
[operator] => IN
[include_children] => 1
)
[1] => Array
(
[taxonomy] => blog-group
[terms] => Array
(
[0] => general-user
[1] => technical-asociate
[2] => qualified-sales-representative
[3] => kvaser-internal
)
[field] => slug
[operator] => NOT IN
[include_children] => 1
)
[2] => Array
(
[taxonomy] => category
[terms] => Array
(
[0] => 1047
)
[field] => term_id
[operator] => NOT IN
[include_children] =>
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)
[queried_terms] => Array
(
[blog-group] => Array
(
[terms] => Array
(
[0] => public
)
[field] => slug
)
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)
[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)
[clauses:protected] => Array
(
)
[has_or_relation:protected] =>
)
[date_query] =>
[queried_object] => WP_Post Object
(
[ID] => 1277
[post_author] => 38
[post_date] => 2014-11-21 12:03:40
[post_date_gmt] => 2013-12-19 15:28:51
[post_content] =>
[post_title] => News
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => open
[post_password] =>
[post_name] => news
[to_ping] =>
[pinged] =>
[post_modified] => 2021-08-12 09:14:30
[post_modified_gmt] => 2021-08-12 09:14:30
[post_content_filtered] =>
[post_parent] => 23
[guid] => https://www.kvaser.com/?page_id=1277
[menu_order] => 5
[post_type] => page
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[queried_object_id] => 1277
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (1026)
AND
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (1025,1027,1028,1029)
)
AND
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (1058)
)
) AND wp_posts.post_type IN ('post', 'developer_blog') AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 70, 10
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 38152
[post_author] => 38400
[post_date] => 2022-04-08 12:33:41
[post_date_gmt] => 2022-04-08 12:33:41
[post_content] => [vc_row][vc_column][vc_video link="https://www.youtube.com/watch?v=Rfha9AYQ0QM"][vc_column_text]UPDATE: This event is over. You can watch the archive of the event by clicking the video above.[/vc_column_text][vc_column_text]Accurate Technologies (ATI) and Kvaser held a joint webinar in March to explain the benefits of Kvaser’s LIN interfaces and ATI’s CANLab software.[/vc_column_text][vc_column_text]View the recording to learn how to use these toolchains to log, import, and analyze vehicle LIN data. Adam Raymer, Kvaser Technical support, introduces LIN and explains the specifics of using the Kvaser Leaf Professional with LIN and Kvaser Hybrid, while Maxwell Church, ATI Business Development Manager, provides a tutorial on handling the data in ATI's CANLab software.
View here >[/vc_column_text][/vc_column][/vc_row]
[post_title] => View Accurate Technologies & Kvaser’s free LIN Fundamentals virtual class
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => view-ati-kvasers-free-lin-fundamentals-virtual-class
[to_ping] =>
[pinged] =>
[post_modified] => 2022-05-18 23:43:41
[post_modified_gmt] => 2022-05-18 23:43:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=38152
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 38115
[post_author] => 14616
[post_date] => 2022-04-07 21:15:54
[post_date_gmt] => 2022-04-07 21:15:54
[post_content] => [vc_row][vc_column][vc_column_text]Most of us have Microsoft Office installed on our Windows PC and we use Microsoft Excel for lists and calculations, but did you know that you can:[/vc_column_text][vc_column_text]
- Send data from any cell in your Excel sheet on the CAN bus.
- Receive data from the CAN bus to any cell in Excel.
[/vc_column_text][vc_column_text]Kvaser CANlib can be used in Visual Basic for Applications (VBA). This versatile library supports every Kvaser CAN interface and allows you to write advanced and innovative solutions.[/vc_column_text][vc_column_text]So why use VBA when there are so many other languages available? First, it is available to you already if you have Microsoft Office and it is relatively easy to start with. Excel is broadly used and by using its VBA you will have everything that Excel offers, together with your own creative and innovative ideas. If you already have and use Excel, then the cost is of course one thing that comes to my mind as well. Data is easily shared within the organization; many companies have a process involving Microsoft file formats.[/vc_column_text][/vc_column][/vc_row][vc_row css=".vc_custom_1649364671152{margin-top: 15px !important;}"][vc_column][vc_header_raket header_type="h2" header="What do I need to use this blog?"][vc_column_text]To follow the steps in this blog article and to use Excel VBA with Kvaser CANlib you’ll need to have a version of Microsoft Office installed. It doesn’t matter which version of Microsoft Office you have but preferably, it is at least Office 2010 since that is when VBA 7 was introduced. Both 64-bit and 32-bit Office works (please see chapter 2.2 32 vs 64-bit Microsoft Office). I have used Office 365 with Excel version 2202 Build 16.0.14931.20116) 64-bit when writing this.
You also need to have “Kvaser Drivers for Windows” installed. Please find the latest version available here: https://www.kvaser.com/download/ and follow the step-by-step installation guide.
Nothing else is required, but if you want to go deeper and further with CANlib, I do recommend you to download the “Kvaser CANlib SDK”, also available from the same download page.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header="Introduction"][vc_column_text]Visual Basic for Applications (VBA) is an event-driven programming language used by Microsoft to extend their Office applications. With VBA, you can extend processes with automation, Windows APIs and custom functions. You can also control the user interface features of the host application.
VBA is an implementation of Microsoft’s programming language Visual Basic 6 and it uses a stripped down version of that same editor together with similar debugging capabilities. So, if you know VB6, you’ll also know your way around in VBA. Visual Basic was created to simplify programming, which means that programming in VBA is not hard, it uses English-like statements in order to tell the computer what to do.[/vc_column_text][vc_code_raket language="clike" code="QXBwbGljYXRpb24uQWN0aXZlRG9jdW1lbnQuU2F2ZUFzJTIwJTI4JTIyTmV3JTIwRG9jdW1lbnQlMjBOYW1lLmRvY3glMjIlMjk="][vc_column_text]
Save the active document as “New Document Name.docx”.
[/vc_column_text][vc_column_text]Worth mentioning is that VBA is single threaded, which means that it will execute one task at a time. Please read more about this in chapter 2.3 Multitasking.
Office does not show the Developer tab by default, you must enable it:[/vc_column_text][vc_column_text]
- From the File tab, select Options to open the Options dialog box.
- Select “Customize Ribbon” on the left side of the dialog box.
- In “Choose Commands From” on the left side of the dialog box, select “Common Commands”.
- In “Customize the ribbon” on the right side, select “Main Tab” from the drop-down list, and then check the “Developer” box.
- Select OK.
[/vc_column_text][vc_column_text]
From the developer tab you can open the editor and create buttons, drop-down menus etc. There is also a shortcut to just open the editor from anywhere in an Office application: ALT+F11.
The VBA community is really large. Searching the Internet will almost always give you a VBA example that does, if not exactly, at least something similar to what you want to do.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header="VBA Example"][vc_column_text]
The first example will show how to react when a certain cell is changed and send that value on the CAN bus.
In the VBA editor double click on the sheet where the cell is located that you want to react on and select the “Change” procedure for that worksheet.[/vc_column_text][vc_single_image image="38120"][vc_column_text]
The worksheet change event will execute every time something changes in that sheet and to narrow it to a specific cell, I use the Intersect() function in VBA. This function determines whether the changed cell “intersects” with the cell we have specified. To simplify the example I assume that the worksheet is active and that the value we want to send is in between 0-255. For more information about the arguments used in canWrite and how to receive data from the CAN bus, please follow on to the next example.
In my other example I have imported a log file into Excel (in my case it is an .ASC file). I do this just to have data to send on the CAN bus. [/vc_column_text][vc_single_image image="38119"][vc_column_text]
Your data can of course come from any source, opening a file in VBA, have a few specific frames written in Excel that always should be sent etc.
I won’t go through CANlib very thoroughly. This example is simply to give you a hint of what’s possible when it comes to VBA and CANlib.
I will show how to send data from any cell in Excel and how to receive data into any cell in Excel, using Kvaser CANlib.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h2" header="Code"][vc_header_raket header_type="h3" header="CANlib API- and handles declaration"][vc_code_raket language="clike" code="T3B0aW9uJTIwRXhwbGljaXQlMjAlMjdGb3JjZSUyMGV4cGxpY2l0JTIwdmFyaWFibGUlMjBkZWNsYXJhdGlvbiUyMHNvJTIwdGhhdCUyMGFuJTIwdW5kZWNsYXJlZCUyMHZhcmlhYmxlJTIwZ2VuZXJhdGVzJTIwZXJyb3IuJTBBJTIwJTBBJTIwJTBBJTIzSWYlMjBWQkE3JTIwVGhlbiUwQSUyMCUyMFByaXZhdGUlMjBEZWNsYXJlJTIwUHRyU2FmZSUyMFN1YiUyMGNhbkluaXRpYWxpemVMaWJyYXJ5JTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4JTI5JTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBQdHJTYWZlJTIwRnVuY3Rpb24lMjBjYW5VbmxvYWRMaWJyYXJ5JTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4JTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBQdHJTYWZlJTIwRnVuY3Rpb24lMjBjYW5HZXROdW1iZXJPZkNoYW5uZWxzJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlSZWYlMjBjaGFubmVsQ291bnQlMjBBcyUyMExvbmclMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMFB0clNhZmUlMjBGdW5jdGlvbiUyMGNhbkdldENoYW5uZWxEYXRhJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBjaGFubmVsJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBpdGVtJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjBidWZmZXIlMjBBcyUyMEFueSUyQyUyMEJ5VmFsJTIwYnVmc2l6ZSUyMEFzJTIwTG9uZyUyOSUyMEFzJTIwTG9uZyUwQSUyMCUyMFByaXZhdGUlMjBEZWNsYXJlJTIwUHRyU2FmZSUyMEZ1bmN0aW9uJTIwY2FuT3BlbkNoYW5uZWwlMjBMaWIlMjAlMjJDQU5MSUIzMi5ETEwlMjIlMjAlMjhCeVZhbCUyMGhhbmRsZSUyMEFzJTIwTG9uZyUyQyUyMEJ5VmFsJTIwRmxhZ3MlMjBBcyUyMExvbmclMjklMjBBcyUyMExvbmdQdHIlMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMFB0clNhZmUlMjBGdW5jdGlvbiUyMGNhbkNsb3NlJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmdQdHIlMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMFB0clNhZmUlMjBGdW5jdGlvbiUyMGNhbkJ1c09uJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmdQdHIlMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMFB0clNhZmUlMjBGdW5jdGlvbiUyMGNhbkJ1c09mZiUyMExpYiUyMCUyMkNBTkxJQjMyLkRMTCUyMiUyMCUyOEJ5VmFsJTIwaGFuZGxlJTIwQXMlMjBMb25nUHRyJTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBQdHJTYWZlJTIwRnVuY3Rpb24lMjBjYW5TZXRCdXNQYXJhbXMlMjBMaWIlMjAlMjJDQU5MSUIzMi5ETEwlMjIlMjAlMjhCeVZhbCUyMGhhbmRsZSUyMEFzJTIwTG9uZ1B0ciUyQyUyMEJ5VmFsJTIwZnJlcSUyMEFzJTIwTG9uZyUyQyUyMEJ5VmFsJTIwdHNlZzElMjBBcyUyMExvbmclMkMlMjBCeVZhbCUyMHRzZWcyJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBzanclMjBBcyUyMExvbmclMkMlMjBCeVZhbCUyMG5vU2FtcCUyMEFzJTIwTG9uZyUyQyUyMEJ5VmFsJTIwc3luY01vZGUlMjBBcyUyMExvbmclMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMFB0clNhZmUlMjBGdW5jdGlvbiUyMGNhbldyaXRlJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmdQdHIlMkMlMjBCeVZhbCUyMGlkJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjBtc2clMjBBcyUyMEFueSUyQyUyMEJ5VmFsJTIwZGxjJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBmbGFnJTIwQXMlMjBMb25nJTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBQdHJTYWZlJTIwRnVuY3Rpb24lMjBjYW5SZWFkV2FpdCUyMExpYiUyMCUyMkNBTkxJQjMyLkRMTCUyMiUyMCUyOEJ5VmFsJTIwaGFuZGxlJTIwQXMlMjBMb25nUHRyJTJDJTIwQnlSZWYlMjBpZCUyMEFzJTIwTG9uZyUyQyUyMEJ5UmVmJTIwbXNnJTIwQXMlMjBBbnklMkMlMjBCeVJlZiUyMGRsYyUyMEFzJTIwTG9uZyUyQyUyMEJ5UmVmJTIwZmxhZyUyMEFzJTIwTG9uZyUyQyUyMEJ5UmVmJTIwdGltZSUyMEFzJTIwTG9uZyUyQyUyMEJ5UmVmJTIwdGltZW91dCUyMEFzJTIwTG9uZyUyOSUyMEFzJTIwTG9uZyUwQSUyM0Vsc2UlMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMFN1YiUyMGNhbkluaXRpYWxpemVMaWJyYXJ5JTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4JTI5JTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBGdW5jdGlvbiUyMGNhblVubG9hZExpYnJhcnklMjBMaWIlMjAlMjJDQU5MSUIzMi5ETEwlMjIlMjAlMjglMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMEZ1bmN0aW9uJTIwY2FuR2V0TnVtYmVyT2ZDaGFubmVscyUyMExpYiUyMCUyMkNBTkxJQjMyLkRMTCUyMiUyMCUyOEJ5UmVmJTIwY2hhbm5lbENvdW50JTIwQXMlMjBMb25nJTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBGdW5jdGlvbiUyMGNhbkdldENoYW5uZWxEYXRhJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBjaGFubmVsJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBpdGVtJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjBidWZmZXIlMjBBcyUyMEFueSUyQyUyMEJ5VmFsJTIwYnVmc2l6ZSUyMEFzJTIwTG9uZyUyOSUyMEFzJTIwTG9uZyUwQSUyMCUyMFByaXZhdGUlMjBEZWNsYXJlJTIwRnVuY3Rpb24lMjBjYW5PcGVuQ2hhbm5lbCUyMExpYiUyMCUyMkNBTkxJQjMyLkRMTCUyMiUyMCUyOEJ5VmFsJTIwaGFuZGxlJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBGbGFncyUyMEFzJTIwTG9uZyUyOSUyMEFzJTIwTG9uZyUwQSUyMCUyMFByaXZhdGUlMjBEZWNsYXJlJTIwRnVuY3Rpb24lMjBjYW5DbG9zZSUyMExpYiUyMCUyMkNBTkxJQjMyLkRMTCUyMiUyMCUyOEJ5VmFsJTIwaGFuZGxlJTIwQXMlMjBMb25nJTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBGdW5jdGlvbiUyMGNhbkJ1c09uJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmclMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMEZ1bmN0aW9uJTIwY2FuQnVzT2ZmJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmclMjklMjBBcyUyMExvbmclMEElMjAlMjBQcml2YXRlJTIwRGVjbGFyZSUyMEZ1bmN0aW9uJTIwY2FuU2V0QnVzUGFyYW1zJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmclMkMlMjBCeVZhbCUyMGZyZXElMjBBcyUyMExvbmclMkMlMjBCeVZhbCUyMHRzZWcxJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjB0c2VnMiUyMEFzJTIwTG9uZyUyQyUyMEJ5VmFsJTIwc2p3JTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBub1NhbXAlMjBBcyUyMExvbmclMkMlMjBCeVZhbCUyMHN5bmNNb2RlJTIwQXMlMjBMb25nJTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBGdW5jdGlvbiUyMGNhbldyaXRlJTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmclMkMlMjBCeVZhbCUyMGlkJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjBtc2clMjBBcyUyMEFueSUyQyUyMEJ5VmFsJTIwZGxjJTIwQXMlMjBMb25nJTJDJTIwQnlWYWwlMjBmbGFnJTIwQXMlMjBMb25nJTI5JTIwQXMlMjBMb25nJTBBJTIwJTIwUHJpdmF0ZSUyMERlY2xhcmUlMjBGdW5jdGlvbiUyMGNhblJlYWRXYWl0JTIwTGliJTIwJTIyQ0FOTElCMzIuRExMJTIyJTIwJTI4QnlWYWwlMjBoYW5kbGUlMjBBcyUyMExvbmclMkMlMjBCeVJlZiUyMGlkJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjBtc2clMjBBcyUyMEFueSUyQyUyMEJ5UmVmJTIwZGxjJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjBmbGFnJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjB0aW1lJTIwQXMlMjBMb25nJTJDJTIwQnlSZWYlMjB0aW1lb3V0JTIwQXMlMjBMb25nJTI5JTIwQXMlMjBMb25nJTBBJTIzRW5kJTIwSWYlMEElMjAlMEElMjdDb25zdGFudCUyMGRlY2xhcmF0aW9ucyUwQVByaXZhdGUlMjBDb25zdCUyMGNhbk9LJTIwJTNEJTIwMCUwQVByaXZhdGUlMjBDb25zdCUyMGNhbk9QRU5fQUNDRVBUX1ZJUlRVQUwlMjAlM0QlMjAlMjZIMjAlMEFQcml2YXRlJTIwQ29uc3QlMjBjYW5CSVRSQVRFXzI1MEslMjAlM0QlMjAtMyUwQVByaXZhdGUlMjBDb25zdCUyMGNhbkNIQU5ORUxEQVRBX0NBUkRfU0VSSUFMX05PJTIwJTNEJTIwNyUwQSUyMCUwQSUyMCUwQSUyN0RlY2xhcmF0aW9uJTIwb2YlMjBDQU4lMjBoYW5kbGVzJTBBJTIzSWYlMjBWQkE3JTIwVGhlbiUwQSUyMCUyMFByaXZhdGUlMjBobmQwJTJDJTIwaG5kMSUyMEFzJTIwTG9uZ1B0ciUwQSUyM0Vsc2UlMEElMjAlMjBQcml2YXRlJTIwaG5kMCUyQyUyMGhuZDElMjBBcyUyMExvbmclMEElMjNFbmQlMjBJZg=="][vc_column_text]
The declarations are required in order to specify which dll calls should be available and point out where this dll is located. CANlib32.dll is in the system path when installed through Kvaser’s installer. This means that you will not have to specify exactly where it is located.
[ Public | Private ] Declare Sub name Lib "libname" [ ( [ arglist ] ) ]
[ Public | Private ] Declare Function name Lib "libname" [ ( [ arglist ] ) ] [ As type ]
Using Private tells that this will only be accessible in the module where it is declared.
The Kvaser CANlib SDK doesn’t include any VB or VBA declarations at this moment, so you’ll have to write these as needed. For the online Kvaser CANlib SDK please go to: https://www.kvaser.com/canlib-webhelp/index.html
You can of course contact me or our support and we will try to do our best to help you. The contact information is available at the end of this article.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Calling CANlib API"][vc_column_text]
Initialize CANlib and get the number of available channels[/vc_column_text][vc_code_raket language="clike" code="U3ViJTIwQ0FOTGliX1N0YXJ0JTI4JTI5JTBBJTIwJTIwRGltJTIwY2hDb3VudCUyQyUyMHN0YXQlMkMlMjBpJTIwQXMlMjBMb25nJTBBJTIwJTIwRGltJTIwYnVmZmVyJTIwQXMlMjBTdHJpbmclMEElMjAlMjBEaW0lMjBteUFyciUyODMyJTI5JTIwQXMlMjBCeXRlJTBBJTIwJTIwRGltJTIwd3MlMjBBcyUyMFdvcmtzaGVldCUwQSUwOSUwQSUyMCUyMGNhbkluaXRpYWxpemVMaWJyYXJ5JTBBJTIwJTIwc3RhdCUyMCUzRCUyMGNhbkdldE51bWJlck9mQ2hhbm5lbHMlMjhjaENvdW50JTI5JTBBJTIwJTIwSWYlMjBzdGF0JTIwJTNDJTNFJTIwY2FuT0slMjBUaGVuJTIwR29UbyUyMEVycm9ySGFuZGxlcg=="][vc_column_text]
The canInitializeLibrary function must be called before any other functions are used. It will initialize the driver.
canGetNumberOfChannels, this function returns the number of available CAN channels in the computer. The virtual channels are included in this number.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Prepare the workbook for reading out some device information[/vc_column_text][vc_code_raket language="clike" code="U2hlZXRzLkFkZCUyOEJlZm9yZSUzQSUzRFNoZWV0cyUyODElMjklMjkubmFtZSUyMCUzRCUyMCUyMkRldmljZSUyMGluZm8lMjIlMjAlMjclMjBBZGQlMjBhJTIwc2hlZXQlMjBjYWxsZWQlMjAlMjJEZXZpY2UlMjBpbmZvJTIyJTIwdG8lMjB0aGUlMjBmaXJzdCUyMHBvc2l0aW9uJTBBJTIwJTBBUmFuZ2UlMjglMjJBMSUyMiUyOS5WYWx1ZSUyMCUzRCUyMCUyMk5vZiUyMGNoYW5uZWxzJTIyJTBBUmFuZ2UlMjglMjJCMSUyMiUyOS5WYWx1ZSUyMCUzRCUyMGNoQ291bnQ="][vc_column_text]
Here we add a new sheet to the first position and write how many channels that we have available in cell B1 of that sheet.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Read some device information for each channel available[/vc_column_text][vc_code_raket language="clike" code="Rm9yJTIwaSUyMCUzRCUyMDAlMjBUbyUyMGNoQ291bnQlMjAtJTIwMSUwQSUyMCUyMHN0YXQlMjAlM0QlMjBjYW5HZXRDaGFubmVsRGF0YSUyOGklMkMlMjBjYW5DSEFOTkVMREFUQV9DQVJEX1NFUklBTF9OTyUyQyUyMG15QXJyJTI4MCUyOSUyQyUyMDMyJTI5JTBBJTIwJTIwYnVmZmVyJTIwJTNEJTIwU3RyQ29udiUyOG15QXJyJTI4JTI5JTJDJTIwdmJVbmljb2RlJTI5JTBBJTIwJTIwSWYlMjBidWZmZXIlMjAlM0MlM0UlMjBFbXB0eSUyMFRoZW4lMEElMjAlMjAlMjAlMjBDZWxscyUyOGklMjAlMkIlMjAyJTJDJTIwMSUyOS5WYWx1ZSUyMCUzRCUyMCUyMlNlcmlhbCUyMiUwQSUyMCUyMCUyMCUyMENlbGxzJTI4aSUyMCUyQiUyMDIlMkMlMjAyJTI5LlZhbHVlJTIwJTNEJTIwYnVmZmVyJTBBJTIwJTIwRW5kJTIwSWYlMEFOZXh0JTIwaQ=="][vc_column_text]
Here we go through every available channel and ask for the device’s serial number, which we write to a new row for each channel in the second column (i.e. “B”). [/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Open channels, set parameters and go bus on[/vc_column_text][vc_code_raket language="clike" code="aG5kMCUyMCUzRCUyMGNhbk9wZW5DaGFubmVsJTI4MCUyQyUyMGNhbk9QRU5fQUNDRVBUX1ZJUlRVQUwlMjklMEFobmQxJTIwJTNEJTIwY2FuT3BlbkNoYW5uZWwlMjgxJTJDJTIwY2FuT1BFTl9BQ0NFUFRfVklSVFVBTCUyOSUwQXN0YXQlMjAlM0QlMjBjYW5TZXRCdXNQYXJhbXMlMjhobmQwJTJDJTIwY2FuQklUUkFURV8yNTBLJTJDJTIwMCUyQyUyMDAlMkMlMjAwJTJDJTIwMCUyQyUyMDAlMjklMEFJZiUyMHN0YXQlMjAlM0MlM0UlMjBjYW5PSyUyMFRoZW4lMjBHb1RvJTIwRXJyb3JIYW5kbGVyJTBBc3RhdCUyMCUzRCUyMGNhblNldEJ1c1BhcmFtcyUyOGhuZDElMkMlMjBjYW5CSVRSQVRFXzI1MEslMkMlMjAwJTJDJTIwMCUyQyUyMDAlMkMlMjAwJTJDJTIwMCUyOSUwQUlmJTIwc3RhdCUyMCUzQyUzRSUyMGNhbk9LJTIwVGhlbiUyMEdvVG8lMjBFcnJvckhhbmRsZXIlMEElMDklMEFzdGF0JTIwJTNEJTIwY2FuQnVzT24lMjhobmQwJTI5JTBBSWYlMjBzdGF0JTIwJTNDJTNFJTIwY2FuT0slMjBUaGVuJTIwR29UbyUyMEVycm9ySGFuZGxlciUwQXN0YXQlMjAlM0QlMjBjYW5CdXNPbiUyOGhuZDElMjklMEFJZiUyMHN0YXQlMjAlM0MlM0UlMjBjYW5PSyUyMFRoZW4lMjBHb1RvJTIwRXJyb3JIYW5kbGVy"][vc_column_text]
Here we open the first and second channel to get the required handles needed in all other calls. We also prepare the two opened channels by setting them to the same bit rate. [/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Prepare a sheet for read data[/vc_column_text][vc_code_raket language="clike" code="RGVsZXRlU2hlZXQlMjAlMjglMjJSZWFkJTIwZGF0YSUyMiUyOSUwQVNldCUyMHdzJTIwJTNEJTIwU2hlZXRzLkFkZCUyOCUyOSUwQXdzLm5hbWUlMjAlM0QlMjAlMjJSZWFkJTIwZGF0YSUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDElMjkuVmFsdWUlMjAlM0QlMjAlMjJJRCUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDIlMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhMSUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDMlMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhMiUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDQlMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhMyUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDUlMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhNCUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDYlMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhNSUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDclMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhNiUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDglMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhNyUyMiUwQXdzLkNlbGxzJTI4MSUyQyUyMDklMjkuVmFsdWUlMjAlM0QlMjAlMjJEYXRhOCUyMg=="][vc_column_text]
Here we prepare a sheet to store the read data. I first delete the “Read data”-sheet in case it already exists. I then create the sheet and name it, whilst also adding some headlines so as to better understand the output. [/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Send, receive, and populate cells[/vc_column_text][vc_code_raket language="clike" code="U3ViJTIwQ0FObGliX1RyYWZmaWMlMjglMjklMEElMjAlMjBEaW0lMjB0YiUyMEFzJTIwTGlzdE9iamVjdCUwQSUyMCUyMERpbSUyMGlDb2wlMkMlMjBpUm93JTIwQXMlMjBJbnRlZ2VyJTBBJTIwJTIwRGltJTIwc0RhdGElMjgxJTIwVG8lMjA4JTI5JTJDJTIwc0NvbCUyMEFzJTIwU3RyaW5nJTBBJTIwJTIwRGltJTIwYkRhdGFUeCUyODElMjBUbyUyMDglMjklMjBBcyUyMEJ5dGUlMEElMjAlMjBEaW0lMjBiRGF0YVJ4JTI4MSUyMFRvJTIwOCUyOSUyMEFzJTIwQnl0ZSUwQSUyMCUyMERpbSUyMHN0YXQlMkMlMjBsSUQlMkMlMjBsRGxjJTJDJTIwbEZsYWdzJTJDJTIwbFRpbWUlMjBBcyUyMExvbmclMEElMDklMEElMDklMEElMjAlMjBXb3Jrc2hlZXRzJTI4JTIySW1wb3J0ZWQlMjBBU0MlMjIlMjkuQWN0aXZhdGUlMEElMjAlMjBTZXQlMjB0YiUyMCUzRCUyMEFjdGl2ZVNoZWV0Lkxpc3RPYmplY3RzJTI4JTIyVGVzdExvZyUyMiUyOSUwQSUyMCUwQSUyMCUyMEZvciUyMGlSb3clMjAlM0QlMjAxJTIwVG8lMjB0Yi5SYW5nZS5Sb3dzLkNvdW50JTBBJTIwJTIwJTIwJTIwbERsYyUyMCUzRCUyMHRiLkRhdGFCb2R5UmFuZ2UuQ2VsbHMlMjhpUm93JTJDJTIwdGIuTGlzdENvbHVtbnMlMjglMjJETEMlMjIlMjkuSW5kZXglMjklMjAlMjclMjBHZXQlMjBob3clMjBtYW55JTIwZGF0YSUyMGJ5dGVzJTBBJTIwJTIwJTIwJTIwRm9yJTIwaUNvbCUyMCUzRCUyMDElMjBUbyUyMGxEbGMlMEElMjAlMjAlMjAlMjAlMjAlMjBzQ29sJTIwJTNEJTIwJTIyRGF0YSUyMiUyMCUyQiUyMFRyaW0lMjhTdHIlMjhpQ29sJTI5JTI5JTIwJTI3Q3JlYXRlJTIwdGhlJTIwaGVhZGxpbmUlMjB0byUyMHJlYWQlMjBmcm9tJTBBJTIwJTIwJTIwJTIwJTIwJTIwc0RhdGElMjhpQ29sJTI5JTIwJTNEJTIwdGIuRGF0YUJvZHlSYW5nZS5DZWxscyUyOGlSb3clMkMlMjB0Yi5MaXN0Q29sdW1ucyUyOHNDb2wlMjkuSW5kZXglMjklMEElMjAlMjAlMjAlMjAlMjAlMjBiRGF0YVR4JTI4aUNvbCUyOSUyMCUzRCUyMENCeXRlJTI4JTIyJTI2SCUyMiUyMCUyNiUyMHNEYXRhJTI4aUNvbCUyOSUyOSUyMCUyNyUyMENvbnZlcnQlMjB0aGUlMjBIZXglMjB2YWx1ZSUyMHRvJTIwZGVjaW1hbCUwQSUyMCUyMCUyMCUyME5leHQlMjBpQ29sJTBBJTIwJTIwJTIwJTIwJTI3JTIwU2VuZCUyMHRoZSUyMGJ5dGUlMjBzdHJlYW0lMjBvZiUyMENBTiUyMGRhdGElMjBvbiUyMHRoZSUyMGZpcnN0JTIwY2hhbm5lbCUyMCUyMCUyMCUwOSUwQSUyMCUyMCUyMCUyMHN0YXQlMjAlM0QlMjBjYW5Xcml0ZSUyOGhuZDAlMkMlMjBDTG5nJTI4aVJvdyUyOSUyQyUyMGJEYXRhVHglMjgxJTI5JTJDJTIwbERsYyUyQyUyMDAlMjklMEElMjAlMjAlMjAlMjBEb0V2ZW50cyUwQSUyMCUyMCUyMCUyMCUyNyUyMFJlYWQlMjBvdXQlMjB0aGUlMjByZWNlaXZlZCUyMGRhdGElMjBvbiUyMHRoZSUyMHNlY29uZCUyMGNoYW5uZWwlMEElMjAlMjAlMjAlMjBzdGF0JTIwJTNEJTIwY2FuUmVhZFdhaXQlMjhobmQxJTJDJTIwbElEJTJDJTIwYkRhdGFSeCUyODElMjklMkMlMjBsRGxjJTJDJTIwbEZsYWdzJTJDJTIwbFRpbWUlMkMlMjA1MCUyOSUwQSUyMCUyMCUyMCUyMElmJTIwc3RhdCUyMCUzRCUyMGNhbk9LJTIwVGhlbiUwQSUyMCUyMCUyMCUyMCUyMCUyMFdpdGglMjBXb3Jrc2hlZXRzJTI4JTIyUmVhZCUyMGRhdGElMjIlMjklMjAlMjclMjBQb3B1bGF0ZSUyMGNlbGxzJTIwaW4lMjBFeGNlbCUyMHdpdGglMjByZWFkJTIwQ0FOJTIwZGF0YSUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMC5DZWxscyUyOGxJRCUyMCUyQiUyMDElMkMlMjAxJTI5LlZhbHVlJTIwJTNEJTIwbElEJTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTI3JTIwLkNlbGxzJTI4bElEJTIwJTJCJTIwMSUyQyUyMDIlMjkuVmFsdWUlMjAlM0QlMjBDU3RyJTI4SGV4JTI4YkRhdGFSeCUyODElMjklMjklMjklMjAlMjclMjBVc2UlMjB0aGlzJTIwaWYlMjB2YWx1ZSUyMHNob3VsZCUyMGJlJTIwaW4lMjBoZXhhZGVjaW1hbCUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMC5DZWxscyUyOGxJRCUyMCUyQiUyMDElMkMlMjAyJTI5LlZhbHVlJTIwJTNEJTIwYkRhdGFSeCUyODElMjklMEElMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAuQ2VsbHMlMjhsSUQlMjAlMkIlMjAxJTJDJTIwMyUyOS5WYWx1ZSUyMCUzRCUyMGJEYXRhUnglMjgyJTI5JTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwLkNlbGxzJTI4bElEJTIwJTJCJTIwMSUyQyUyMDQlMjkuVmFsdWUlMjAlM0QlMjBiRGF0YVJ4JTI4MyUyOSUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMC5DZWxscyUyOGxJRCUyMCUyQiUyMDElMkMlMjA1JTI5LlZhbHVlJTIwJTNEJTIwYkRhdGFSeCUyODQlMjklMEElMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAuQ2VsbHMlMjhsSUQlMjAlMkIlMjAxJTJDJTIwNiUyOS5WYWx1ZSUyMCUzRCUyMGJEYXRhUnglMjg1JTI5JTBBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwLkNlbGxzJTI4bElEJTIwJTJCJTIwMSUyQyUyMDclMjkuVmFsdWUlMjAlM0QlMjBiRGF0YVJ4JTI4NiUyOSUwQSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMC5DZWxscyUyOGxJRCUyMCUyQiUyMDElMkMlMjA4JTI5LlZhbHVlJTIwJTNEJTIwYkRhdGFSeCUyODclMjklMEElMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAuQ2VsbHMlMjhsSUQlMjAlMkIlMjAxJTJDJTIwOSUyOS5WYWx1ZSUyMCUzRCUyMGJEYXRhUnglMjg4JTI5JTBBJTIwJTIwJTIwJTIwJTIwJTIwRW5kJTIwV2l0aCUwQSUyMCUyMCUyMCUyMEVuZCUyMElmJTBBJTIwJTIwTmV4dCUyMGlSb3clMEElMDklMEElMjAlMjBNc2dCb3glMjAlMjJUcmFmZmljJTIwZG9uZSUyMSUyMiUwQUVuZCUyMFN1Yg=="][vc_column_text]
First make sure the sheet from where we are going to read is activated. In my example I have named the table of imported data to “TestLog” which I set to a ListObject variable. I do this to make it easier to loop through when fetching values to be sent, by doing this I can use the table’s headlines to specify which column I’m reading from. The first loop is set to go through the complete range of imported data. I read the data length code (dlc) value to know how many bytes to read and later send. The second loop iterates through the data bytes, converts them from text formatted hex into decimal values and stores the values in a byte array.
The byte array of CAN data is then sent together with a message id (in this case the row number) and a data length code (dlc) by calling the CANlib function canWrite.
DoEvents makes it easier to stop the running macro. The DoEvents function enables interruption of executing code and lets the computer processor simultaneously run other tasks. Using DoEvents will slow the execution time down but will on the other hand give a chance to stop a running macro.
canReadWait reads a message from the receive buffer. If no message is available, the function waits until a message arrives or a timeout occurs.
Lastly I populate the previously created “Read data”-sheet with the read values. I use the message id to specify the cell row. By using a named sheet when writing to the cells I don’t have to activate that sheet (Worksheets("Read data").Cells(Row, Column).Value) and can keep the sheet holding imported data active.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Cleaning up afterwards[/vc_column_text][vc_code_raket language="clike" code="U3ViJTIwQ0FOTGliX1N0b3AlMjglMjklMEElMjAlMjBjYW5CdXNPZmYlMjAlMjhobmQwJTI5JTBBJTIwJTIwY2FuQnVzT2ZmJTIwJTI4aG5kMSUyOSUwQSUyMCUyMGNhblVubG9hZExpYnJhcnklMEElMjAlMjBNc2dCb3glMjAlMjJDQU5saWIlMjBpcyUyMHVubG9hZGVkJTIxJTIyJTBBRW5kJTIwU3Vi"][vc_column_text]
canBusOff will take the specified handle off-bus. If no other handle is active on the same channel, the channel will also be taken off-bus. canUnloadLibrary will free allocated memory, unload the DLLs canlib32.dll has loaded and de-initialize data structures.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Result"][vc_column_text]
The result in this example looks like this:[/vc_column_text][vc_single_image image="38117"][vc_column_text]
I could have chosen to have the output data formatted in hexadecimal for easier comparisons, then the cells would have been required to be formatted as text: ws.Columns("A:I").NumberFormat = "@" and when putting values into these cells, that would require a conversion like: Cells(col, row).Value = CStr(Hex(MyDecValue)).
But instead I chose to have it in decimal only to simplify further analysis. It is possible with hexadecimal values as well but would require a conversion at some point, since the chart objects in VBA and in Excel want their values to be in decimal format.
Excel graphs can be used to visualize the data, for example:[/vc_column_text][vc_single_image image="38118"][vc_column_text]
Graphs can be made either in your VBA code or afterwards using the toolbar in Excel. For further and deeper understanding of what’s possible in VBA, please see Microsoft’s documentation: https://docs.microsoft.com/en-us/office/vba/api/overview/. [/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="32 vs 64-bit Microsoft Office"][vc_column_text]
Both Office versions work fine, but worth mentioning is that in VBA version 7 some new 64-bit features were added.[/vc_column_text][vc_single_image image="38121"][vc_column_text]
There are no unsigned data types in VBA, except for the data type Byte. But this is not a completely closed door - it is possible to read unsigned values in VBA, such as this example of how to use the Double type for values above 2147483647.[/vc_column_text][vc_code_raket language="clike" code="UHJpdmF0ZSUyMENvbnN0JTIwTUFYX1VJTlQzMiUyMCUzRCUyMDQyOTQ5NjcyOTYlMjMlMEFQcml2YXRlJTIwQ29uc3QlMjBNQVhfSU5UMzIlMjAlM0QlMjAyMTQ3NDgzNjQ3JTBBRnVuY3Rpb24lMjBMb25nVG9VbnNpZ25lZCUyOEJ5VmFsJTIwVmFsdWUlMjBBcyUyMExvbmclMjklMjBBcyUyMERvdWJsZSUwQSUyMCUyMElmJTIwVmFsdWUlMjAlM0MlMjAwJTIwVGhlbiUwQSUyMCUyMCUyMCUyMExvbmdUb1Vuc2lnbmVkJTIwJTNEJTIwVmFsdWUlMjAlMkIlMjBNQVhfVUlOVDMyJTBBJTIwJTIwRWxzZSUwQSUyMCUyMCUyMCUyMExvbmdUb1Vuc2lnbmVkJTIwJTNEJTIwVmFsdWUlMEElMjAlMjBFbmQlMjBJZiUwQUVuZCUyMEZ1bmN0aW9uJTBBJTIwJTBBRnVuY3Rpb24lMjBVbnNpZ25lZFRvTG9uZyUyOEJ5VmFsJTIwVmFsdWUlMjBBcyUyMERvdWJsZSUyOSUyMEFzJTIwTG9uZyUwQSUyMCUyMElmJTIwVmFsdWUlMjAlM0MlMjAwJTIwT3IlMjBWYWx1ZSUyMCUzRSUzRCUyME1BWF9VSU5UMzIlMjBUaGVuJTIwRXJyb3IlMjA2JTBBJTIwJTIwSWYlMjBWYWx1ZSUyMCUzQyUzRCUyME1BWF9JTlQzMiUyMFRoZW4lMEElMjAlMjAlMjAlMjBVbnNpZ25lZFRvTG9uZyUyMCUzRCUyMFZhbHVlJTBBJTIwJTIwRWxzZSUwQSUyMCUyMCUyMCUyMFVuc2lnbmVkVG9Mb25nJTIwJTNEJTIwVmFsdWUlMjAtJTIwTUFYX1VJTlQzMiUwQSUyMCUyMEVuZCUyMElmJTBBRW5kJTIwRnVuY3Rpb24="][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Multitasking"][vc_column_text]
VBA is single threaded, which means that it’ll execute one task at a time. It is still possible to create a thread or use a callback function, like the kvSetNotifyCallback in CANlib, but I don’t recommend it. Creating one thread should probably be okay if it gets closed and waited for in the main thread, but creating more threads or trying to write to cells outside the main thread might cause Excel to freeze and shut down. To save you the headache and extra time, keep it simple and in the main thread.
For those with experience in VBA, there are ways to get round this, such as starting a new instance of Excel from within a loop in your code and call a procedure in your main workbook from that new instance.
My recommendation is to stay in the main thread. [/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header="Summary"][vc_column_text]
In this article we have briefly looked into how to receive and send data on the CAN bus using CANlib and VBA in Microsoft Excel.
I hope that this example has opened your eyes to what’s possible, even though it doesn’t cover Kvaser CANlib, VBA or Microsoft Excel that deeply.
Do you need more information or do you have questions?
Please feel free to contact us. Your comments and questions are welcome!
You can find us here:
[email protected]
Or, if you like, you can contact me directly:
Dan Arvidson
Customer Software Manager
[email protected][/vc_column_text][/vc_column][/vc_row]
[post_title] => Using Excel Visual Basic for Applications with Kvaser CANlib
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => using-excel-visual-basic-for-applications-with-kvaser-canlib
[to_ping] =>
[pinged] =>
[post_modified] => 2022-04-07 21:15:54
[post_modified_gmt] => 2022-04-07 21:15:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?post_type=developer_blog&p=38115
[menu_order] => 0
[post_type] => developer_blog
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 29245
[post_author] => 23
[post_date] => 2022-03-08 10:43:24
[post_date_gmt] => 2022-03-08 10:43:24
[post_content] => [vc_row][vc_column][vc_single_image image="44560"][/vc_column][/vc_row][vc_row css=".vc_custom_1598309766839{margin-bottom: 30px !important;}"][vc_column][vc_column_text]Automotive endurance testing creates 100,000s of hours of test data per vehicle. Kvaser’s DIN Rail Ethernet to CAN/CAN FD interface and RA Consulting’s DiagRA D diagnostic software ensure reliable collection of diagnostic data on Audi’s test benches.[/vc_column_text][/vc_column][/vc_row][vc_row css=".vc_custom_1598309774890{margin-bottom: 30px !important;}"][vc_column][vc_header_raket header_type="h4" header="The challenge:"][vc_column_text]In automotive endurance testing, whilst engineers are in physical proximity to oversee the test process, sufficient distance is required to isolate the engineers from the constant cycling of noise, vibration and harshness (NVH) tests that characterise the standard physical testing of new vehicles, along with crash behaviour and aerodynamics. As with most test systems, data collection and post-analysis are rarely carried out in the same place, but endurance tests require a particular combination of guaranteed real-time data acquisition and reliability when connecting the two locations.
Explained Patrick Guhl, responsible for vehicle measurement technology and test bench automation for vehicle emissions, consumption and range testing in the Audi test facility in Neckarsulm:
“We were looking for a CAN FD-capable module that could reliably bridge a distance of up to 100 metres between the vehicle on a test bench and the computer on which the DiagRA D diagnostic software is operated. The module needed to ensure a stable connection, with no interruptions in communication between the tool to access the car’s diagnostics data and the PC.” An important additional requirement was an independent connection after voltage drops or computer restarts.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column width="1/2"][vc_single_image image="44562" img_size="medium"][/vc_column][vc_column width="1/2"][vc_single_image image="44565" img_size="medium" alignment="right"][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h4" header="The solution:"][vc_column_text]As a long-term user of DiagRA D diagnostic software to collect CAN and CAN FD data, Audi’s endurance test team turned to RA Consulting for advice on a bridging solution. RA Consulting (RAC), a Kvaser technical associate, had tested Kvaser’s recently-launched
DIN Rail SE400S-X10, a multichannel, programmable Ethernet to CAN/CAN FD interface for DIN Rail mounting. The SE400S-X10 uses Kvaser’s standard universal driver, enabling RAC to guarantee a future-proof integration between their DiagRA D software and Kvaser’s DIN Rail series.
Commented Mario Hoppe, marketing and sales manager at RAC: “Whilst Wi-Fi and Bluetooth are fast enough to transmit data in many test scenarios, the long distances involved, building layout and environmental conditions would have made them unsuitable in this instance. The DIN Rail SE400S-X10 proved a versatile alternative, with programmable Ethernet to four CAN/CAN FD channels and all major CAN protocol types supported. Ethernet cabling also made it simple to assign many DIN Rail modules to their respective test benches.”
Audi was able to source software and hardware from one source, with a central contact person for questions and support. Noted Guhl: “The DIN Rail SE400S-X10 promised low installation effort, as it was voltage, LAN and OBD ready, and it’s top-hat rail mounted form-factor meant that it could be easily integrated into existing systems.”
With tests running 24/7 across a bank of dynamometers in Audi’s Neckarsulm and Ingolstadt test facilities, Kvaser’s DIN Rail SE400S-X10 ensures that CAN/CAN-FD data is gathered reliably from Audi’s test subjects. RA Consulting’s DiagRA D software combines this data and uses OEM specific diagnostic routines for data collection and troubleshooting. With DiagRA D’s advanced developer functionality and firmware updateability in Kvaser’s DIN Rail modules, the system can evolve as new features are added or Audi’s diagnostics testing needs change.[/vc_column_text][/vc_column][/vc_row][vc_row css=".vc_custom_1707702548878{margin-bottom: 30px !important;}"][vc_column width="1/3"][vc_column_text]Get the Case Study :[/vc_column_text][/vc_column][vc_column width="1/3"][vc_raw_html]JTNDcCUyMGNsYXNzJTNEJTIyYWxpZ25fY2VudGVyJTIyJTNFJTNDYSUyMGNsYXNzJTNEJTIyYnRuJTIwYnRuLWJyYW5kLWRlZmF1bHQlMjIlMjB0aXRsZSUzRCUyMkVuZHVyYW5jZSUyMFNwZWNpYWxpc3RzJTIwQTQlMjIlMjBocmVmJTNEJTIyaHR0cHMlM0ElMkYlMkZ3d3cua3Zhc2VyLmNvbSUyRndwLWNvbnRlbnQlMkZ1cGxvYWRzJTJGMjAyNCUyRjAyJTJGa3ZycmFjYXVkaWNzYTQucGRmJTIyJTIwb25jbGljayUzRCUyMmdhJTI4JTI3c2VuZCUyNyUyQyUyMCUyN2V2ZW50JTI3JTJDJTIwJTI3RW5kdXJhbmNlU3BlY2lhbGlzdHNBNCUyNyUyQyUyMCUyN0NsaWNrJTI3JTJDJTIwJTI3SW50ZXJlc3RlZF9FbmR1cmFuY2VfU3BlY2lhbGlzdHNfQTQlMjclMjklM0IlMjIlM0VQREYtQTQlM0MlMkZhJTNFJTNDJTJGcCUzRQ==[/vc_raw_html][/vc_column][vc_column width="1/3"][vc_raw_html]JTNDcCUyMGNsYXNzJTNEJTIyYWxpZ25fY2VudGVyJTIyJTNFJTNDYSUyMGNsYXNzJTNEJTIyYnRuJTIwYnRuLWJyYW5kLWRlZmF1bHQlMjIlMjB0aXRsZSUzRCUyMkVuZHVyYW5jZSUyMFNwZWNpYWxpc3RzJTIwVVMlMjBMZXR0ZXIlMjIlMjBocmVmJTNEJTIyaHR0cHMlM0ElMkYlMkZ3d3cua3Zhc2VyLmNvbSUyRndwLWNvbnRlbnQlMkZ1cGxvYWRzJTJGMjAyNCUyRjAyJTJGa3ZycmFjYXVkaWNzbGV0dGVyLnBkZiUyMiUyMG9uY2xpY2slM0QlMjJnYSUyOCUyN3NlbmQlMjclMkMlMjAlMjdldmVudCUyNyUyQyUyMCUyN0VuZHVyYW5jZVNwZWNpYWxpc3RzVVNMZXR0ZXIlMjclMkMlMjAlMjdDbGljayUyNyUyQyUyMCUyN0ludGVyZXN0ZWRfRW5kdXJhbmNlX1NwZWNpYWxpc3RzX1VTX0xldHRlciUyNyUyOSUzQiUyMiUzRVBERiUyMC0lMjBVUyUyMExldHRlciUzQyUyRmElM0UlM0MlMkZwJTNF[/vc_raw_html][/vc_column][/vc_row]
[post_title] => Stable, CAN communication modules ensure that Audi’s diagnostics data always gets through
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => stable-can-communication-modules-ensure-that-audis-diagnostics-data-always-gets-through
[to_ping] =>
[pinged] =>
[post_modified] => 2024-02-13 10:22:56
[post_modified_gmt] => 2024-02-13 10:22:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=29245
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 37970
[post_author] => 23
[post_date] => 2022-03-01 22:55:30
[post_date_gmt] => 2022-03-01 22:55:30
[post_content] => [vc_row][vc_column][vc_single_image image="37973"][vc_column_text]
New to Kvaser’s product portfolio is the Kvaser Hybrid CAN/LIN (01284-4) and the Kvaser Hybrid Pro CAN/LIN (01288-2). With a standard USB connector on one side and a CAN/LIN channel with a 9-pin D-SUB connector on the other, these high-speed interfaces connect a PC to CAN, CAN FD or LIN.
The Pro version offers advanced features such as support for Silent Mode, Error Frame Detection and Generation and Kvaser MagiSync™ automatic clock synchronization. Silent Mode allows you to listen in on a CAN bus without injecting new information that other nodes will detect, whilst Kvaser MagiSync™ synchronizes timestamps across multiple Kvaser MagiSync™-enabled devices without needing extra wires.
[/vc_column_text][vc_column_text]
- Flexible CAN/LIN switching: use the channel for either CAN or LIN.
- Supports high-speed CAN (ISO 11898-2), CAN 2.0 A and CAN 2.0 B active.
- Supports LIN 2.2
- Compatible with industry standards, including J1939, CANopen, NMEA 2000 and DeviceNet.
- Supports ISO compliant CAN FD
[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][vc_header_raket header_type="h3" header="Visit Product Page"][/vc_column][/vc_row][vc_row][vc_column width="1/2"][vc_raket_product post_id="36995"][/vc_column][vc_column width="1/2"][vc_raket_product post_id="36996"][/vc_column][/vc_row]
[post_title] => Introducing the Kvaser Hybrid CAN/LIN and Kvaser Hybrid Pro
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => introducing-the-kvaser-hybrid-can-lin-and-kvaser-hybrid-pro
[to_ping] =>
[pinged] =>
[post_modified] => 2022-03-23 23:02:45
[post_modified_gmt] => 2022-03-23 23:02:45
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=37970
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 37977
[post_author] => 23
[post_date] => 2022-02-27 23:04:33
[post_date_gmt] => 2022-02-27 23:04:33
[post_content] => [vc_row][vc_column][vc_single_image image="37077"][vc_column_text]There are no major updates within this release, but noteworthy changes include:
Python CANlib package (v1.20.360):
Python 3.10 is now officially supported and documentation has been extended. New validation of bus parameter limits has been added, allowing developers to validate bus parameters when using BusParamsTq.
N.b. The updated documentation can be viewed online at
https://pycanlib.readthedocs.io/
Kvaser Drivers for Windows and CANlib SDK (v5.38):
The representation of 'time' has been clarified in the documentation. Timestamps can be set at microsecond and millisecond intervals.
The handling of database files has been enhanced, with new error handling for invalid int signals in database files.
Kvaser Linux driver and SDK (v5.38):
The same changes for Windows (see above) are available in Linux. In addition, fixes were made to accommodate newer kernels such as the one used in Ubuntu 21.10.
Kvaser mhydra firmware (Memorator 2nd gen., U100, USBcan) (v3.26.108):
Second-generation Memorator devices using
t programs will benefit from a bug fix to canWrite which stalled after buffering 1000 CAN messages due to no acknowledgement being received.[/vc_column_text][/vc_column][/vc_row]
[post_title] => Kvaser’s February 2022 Software Release
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => kvasers-february-2022-software-release
[to_ping] =>
[pinged] =>
[post_modified] => 2022-10-04 05:49:28
[post_modified_gmt] => 2022-10-04 05:49:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=37977
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 37411
[post_author] => 23
[post_date] => 2022-02-18 00:43:42
[post_date_gmt] => 2022-02-18 00:43:42
[post_content] => [vc_row][vc_column][vc_single_image image="37458"][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Located in Manyoni, Tanzania, VTC Mechanic School is a three year program teaching mechanical troubleshooting, repair, and maintenance to young adults eager to learn a trade in a primarily agrarian landscape.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column width="1/2"][vc_column_text]
Like the rest of the world, the electronic component within vehicles in Tanzania is increasing, a skill that is lacking at VTC. Zuragon and Kvaser teamed up to provide a laptop vehicle diagnostic system consisting of ViCANdo software and a Kvaser Memorator Pro 2xHS v2 interface. With it the students will learn to diagnose issues by installing a Memorator in a vehicle and capturing drive data for post-analysis by ViCANdo. Initially the data will be off-loaded by SD card with the expectation that Tanzania’s 3G network can be used for remote vehicle diagnostics in the future.[/vc_column_text][vc_column_text]
The students come from impoverished backgrounds, hoping to learn a trade that will improve their income and lives, as electronics skills are highly valued by future employers.[/vc_column_text][/vc_column][vc_column width="1/2"][vc_single_image image="37449"][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Over the past ten years Mike Doseck has worked in Tanzania to bring X-ray, power generation, modern bee-keeping and dental clinics. For more information on how to contribute to the Tanzania VTC Mechanic School, contact Mike at the link below.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column width="1/6"][/vc_column][vc_column width="2/3"][vc_dd_contact_person _name="Mike Doseck" _role="daVinci Technology Group" _email="
[email protected]" _phone="260-414-3307" profile_images="37465"][/vc_column][vc_column width="1/6"][/vc_column][/vc_row][vc_row disable_element="yes"][vc_column width="1/6"][vc_single_image image="37462"][/vc_column][vc_column width="2/3"][vc_column_text]
Mike Doseck
daVinci Technology Group
260 -414-3307
[email protected]
[/vc_column_text][/vc_column][vc_column width="1/6"][/vc_column][/vc_row]
[post_title] => Kvaser and Zuragon team up with daVinci Technology Group to bring education opportunities to Tanzania
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => kvaser-and-zuragon-team-up-with-davinci-technology-group-to-bring-education-opportunities-to-tanzania
[to_ping] =>
[pinged] =>
[post_modified] => 2022-02-18 00:44:50
[post_modified_gmt] => 2022-02-18 00:44:50
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=37411
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[6] => WP_Post Object
(
[ID] => 37333
[post_author] => 5
[post_date] => 2022-02-08 14:14:53
[post_date_gmt] => 2022-02-08 14:14:53
[post_content] => [vc_row][vc_column][vc_single_image image="37336"][vc_column_text]Kvaser AB has announced that Softing Automotive Electronics GmbH has recommended the Kvaser U100 CAN/CAN FD to USB interface as its preferred vehicle communication interface (VCI) to pair with Softing TDX, a diagnostic test development suite that enables the servicing and repair of road-vehicles and mobile machinery. Softing Automotive provides diagnostic and test solutions for electronic control units and vehicle systems.
Kvaser AB, experts in CAN interface and data logger design, developed the Kvaser U100 CAN/CAN FD to USB interface as a VCI for the entire vehicle lifecycle. Robust and with reinforced galvanic isolation, the U100 represents a ground-up redesign of Kvaser’s popular rugged Leaf CAN to USB interfaces to respond to a wider incidence of higher voltage environment in automotive, marine, industrial, heavy-duty vehicle and heavy industries.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]“The Kvaser U100 will be used to request diagnostic data from the vehicle or machine’s electrical system for fault identification, localisation and repair, and for ECU software updates or reprogramming. Stable, fast and reliable, it is the perfect fit for Softing TDX”, said Peter Subke, Softing Automotive’s Director of Business Development. He added: “The extremely rugged housing, IP67 rating and reinforced galvanic isolation make this ideally suited to hard, aftersales environments, yet with the stand-out performance that is increasingly expected of VCIs today.”[/vc_column_text][vc_column_text]Lars-Berno Fredriksson, President of Kvaser AB commented: “Softing Automotive Electronics and Kvaser AB have a long history of working together, participating in an open ecosystem of CAN hardware and software. Kvaser is best known for high-performance CAN interfaces that are used in CAN system design, and we have extensive experience supplying VCI for production and after-sales. The Kvaser U100 series unites these requirements. Combined with Softing’s TDX, automotive and machine OEMs can rely on a highly reliable, secure diagnostics toolchain for service and repair.”
Comprehensive diagnostic and troubleshooting routines are typically time-consuming and costly to build for OEMs, and even more so for sector start-ups. TDX enables customisable diagnostic tester solutions to be created and maintained through a toolbox that follows a
DESIGN, MANAGE, WORK workflow. Based on the Qt modeling language (QML), known for its suitability for user interface design across platforms, TDX’s underlying diagnostics and operating logic are implemented via OTX scripts. Ease of use is ensured by templates and the ability to import existing data and processes.[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]As a long-term Kvaser Technical Associate (TA), Softing’s products were compatible with prior versions of Kvaser’s hardware TDX support. With the release of TDX v2.5 in December 2021, Softing Automotive integrated the U100 drivers into its software eco-system, creating a combined workshop licence and VCI package for a
one-stop purchase that is entirely ‘plug and play’.[/vc_column_text][/vc_column][/vc_row]
[post_title] => Softing Automotive selects Kvaser U100 as Vehicle Communication Interface for after-sales service diagnostics
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => softing-automotive-selects-kvaser-u100-as-vehicle-communication-interface-for-after-sales-service-diagnostics
[to_ping] =>
[pinged] =>
[post_modified] => 2022-02-14 16:29:04
[post_modified_gmt] => 2022-02-14 16:29:04
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=37333
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[7] => WP_Post Object
(
[ID] => 37253
[post_author] => 23
[post_date] => 2022-02-01 20:43:40
[post_date_gmt] => 2022-02-01 20:43:40
[post_content] => [vc_row][vc_column][vc_single_image image="37254"][vc_column_text]
The Kvaser U100P is the Precision version of Kvaser’s U100 range of CAN to USB interfaces. This version is designed for users engaged in CAN system development, or with difficult troubleshooting applications where the analysis of an entire system's data is required.
[/vc_column_text][vc_column_text]
Precision features include Silent Mode, allowing the device to listen on-bus without interfering with the traffic, and MagiSync™, which synchronises time stamps across multiple Kvaser MagiSync™-enabled devices without requiring extra wires. Object Buffers, hardware buffers that are used for auto transmit and auto response messages, complete the precision feature-set.
[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_button_raket title="Find out more" page_id="https://www.kvaser.com/product/kvaser-u100p/"][/vc_column][/vc_row]
[post_title] => Introducing a U100 with Precision features
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => introducing-a-u100-with-precision-features
[to_ping] =>
[pinged] =>
[post_modified] => 2022-02-01 20:43:40
[post_modified_gmt] => 2022-02-01 20:43:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=37253
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[8] => WP_Post Object
(
[ID] => 37150
[post_author] => 5
[post_date] => 2022-01-28 21:16:44
[post_date_gmt] => 2022-01-28 21:16:44
[post_content] => [vc_row][vc_column][vc_single_image image="37171"][vc_column_text]
Microchip University is using the Kvaser Hybrid 2xCAN/LIN interface, the Kvaser T Cannector and K2L’s OptoLyzer® Studio software in a free online Microchip training course for CAN FD network developers.
[/vc_column_text][vc_column_text]
‘Designing and Implementing a CAN FD Network’ devised by Microchip specialist Wilhelm Leichtfried, CAN/LIN interface products applications team lead, combines discussion and demonstration to provide practical insight into topics such as MCU CAN FD peripheral configuration, database development, firmware, network commissioning and debugging.
[/vc_column_text][vc_column_text]
“Learning the CAN FD serial protocol and studying the ISO 11898 standards can be a challenging task,” comments Leichtfried. “The CAN and CAN FD Protocol and Physical Layer Basics class teaches the CAN FD protocol in great detail. The Designing and Implementing a CAN FD Network class deepens the understanding of the CAN FD protocol by guiding the student through a complete network design. It takes a hands-on approach and incorporates answers to questions that were asked by students in the Microchip live classes. The two Microchip University classes together aim to teaching the student everything needed to successfully design their CAN FD network.”
[/vc_column_text][vc_column_text]
Those who register for the free class can order the Kvaser CAN/LIN hardware kit at a special price. Details are available upon sign-up.
[/vc_column_text][vc_column_text]
Register for the free class here.
[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Find out about the products used:"][/vc_column][/vc_row][vc_row css=".vc_custom_1643314538913{margin-bottom: 10px !important;}"][vc_column width="1/2"][vc_raket_product post_id="39638"][/vc_column][vc_column width="1/2"][vc_raket_product post_id="39618"][/vc_column][/vc_row][vc_row][vc_column width="1/2"][vc_column_text css=".vc_custom_1643317607271{border-top-width: 1px !important;border-right-width: 1px !important;border-bottom-width: 1px !important;border-left-width: 1px !important;padding-top: 15px !important;padding-right: 15px !important;padding-bottom: 40px !important;padding-left: 15px !important;border-left-color: #e9e9e9 !important;border-left-style: solid !important;border-right-color: #e9e9e9 !important;border-right-style: solid !important;border-top-color: #e9e9e9 !important;border-top-style: solid !important;border-bottom-color: #e9e9e9 !important;border-bottom-style: solid !important;border-radius: 1px !important;}"]
Curiosity Development Board
[/vc_column_text][/vc_column][vc_column width="1/2"][vc_raket_software post_id="39803"][/vc_column][/vc_row]
[post_title] => Microchip University course uses Kvaser hardware to teach CAN FD
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => microchip-university-course-uses-kvaser-hardware-to-teach-can-fd
[to_ping] =>
[pinged] =>
[post_modified] => 2023-01-18 03:42:34
[post_modified_gmt] => 2023-01-18 03:42:34
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=37150
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[9] => WP_Post Object
(
[ID] => 37120
[post_author] => 4840
[post_date] => 2022-01-26 01:33:15
[post_date_gmt] => 2022-01-26 01:33:15
[post_content] => [vc_row][vc_column][vc_column_text]
In this document I will compare some single channel Kvaser CAN interfaces:[/vc_column_text][vc_column_text]
- Kvaser U100 73-30130-01173-1
- Kvaser U100P 73-30130-01174-8
- Kvaser Leaf Pro HS v2 73-30130-00843-4
- Kvaser Leaf Light HS v2 73-30130-00685-0
[/vc_column_text][vc_column_text]
My aim is to show how much faster the new Kvaser U100/U100P interfaces are, when compared to Kvaser's existing Leaf interface product line. These figures will provide you with a good performance benchmark for CAN interfaces from other manufacturers. If your application needs speed of response, the Kvaser U100/U100P's response times need to be seen to be believed ...[/vc_column_text][vc_column_text]
I will show that in some extreme cases the Kvaser U100 can be up to four times faster than the Leaf Light and almost twice as fast as the Kvaser Leaf Pro interface.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Kvaser Leaf Interfaces
- Kvaser Leaf Light HS v2 (73-30130-00685-0)
- Kvaser Leaf Pro HS v2 (73-30130-00843-4)
[/vc_column_text][vc_column_text]
The Kvaser LEAF interfaces have proven to be very robust and very reliable CAN interfaces. They are used in almost all applications. It is only in situations where extremely short latencies are required that they are outperformed by Kvaser PCIe interfaces.
The LIGHT series delivers basic functionality and is used in many standard applications. The PRO series adds some advanced functionality and extended performance, i.e. error frame generation and silent mode.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
Kvaser U100 Interfaces
- Kvaser U100 (73-30130-01173-1)
- Kvaser U100P (73-30130-01174-8)
[/vc_column_text][vc_column_text]
The Kvaser U100 and U100P series introduce some very interesting features:
- Lightweight, glass fibre reinforced polyamide IP67 housing
- Reinforced galvanic isolation
- intuitive LED UI
- Extended temperature range (-40 °C to +85 °C)
- Available with four different connectors, DB9, OBD-II, M12 and J1939-II.
[/vc_column_text][vc_column_text]
Both Kvaser U100 and Kvaser U100P support CAN FD.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="What's new with the Kvaser U100 and U100P?"][vc_column_text]
Besides the features mentioned above, the Kvaser U100 and U100P have a key new feature:
- Quick USB response handling.
The Kvaser U100 USB communication is much more optimized, compared to the Kvaser Leaf series. There is no need to do any smart “repacking and bundling” of the CAN frames as the U100 has the capacity to handle both USB and CAN communication at the same time.
This has a significant impact on higher level protocols The U100 series can be up to 75% faster than the Kvaser Leaf Pro. The U100 can in some cases be compared with Kvaser PCIe CAN interfaces.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Test method CAN Q&A"][vc_single_image image="37124"][vc_column_text]
When sending a message on a CAN bus, let an opponent receive it, and let this opponent send back a corresponding answer. Now we have the definition of CAN Q&A.
How many Q&A can we send during a second?
There are some factors that limit the amount of messages we can handle:
- CAN message length
- CAN bus Bitrate
- CAN interface hardware delay
- Software delays
I will use four different settings when comparing the interfaces.[/vc_column_text][vc_code_raket language="t" code="Qml0cmF0ZSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMElEJTIwJTIwJTIwJTIwJTIwJTIwJTIwRExDJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwTWF4JTIwbm8lMjBvZiUyMFElMjZBJTJGcyUwQTEwMDAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAxMWJpdCUyMCUyMCUyMCUyMCUyMCUyMDAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAxMDQxNiUwQTEwMDAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAxMWJpdCUyMCUyMCUyMCUyMCUyMCUyMDglMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA0NDY0JTBBJTIwNTAwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwMTFiaXQlMjAlMjAlMjAlMjAlMjAlMjA4JTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwMjIzMiUwQSUyMDI1MCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMDExYml0JTIwJTIwJTIwJTIwJTIwJTIwOCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMDExMTYlMEE="][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="“Max no of Q&A/s”, what is that?"][vc_column_text]
When sending CAN frames with 1000 kbit/s bitrate, 11 bits ID and 0 bytes as payload, then no more than 20833 CAN frames per second can exist on the bus. So the maximum number of Q&A/s is 20833 / 2 = 10416 PP/s.
If my software has absolutely no delays and the interface also has no delays, then I should be able to get up to 10416 PP per second.
I love that idea. No delays in the software and in the interfaces! Well, until we are able to build hardware based on superconductivity and quantum computing, we must accept that there are delays in software and hardware. (Yes, you are right, there are no delays in software because they are executed in hardware, but you get the point).[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
How many Q&A/s can I expect?
I created a simple test software written in DELPHI (Pascal) and using the Global Callback functionality in Kvaser CANlib SDK. I have not tried to optimize my program because it should behave as a typical CAN application.
The procedure is quite simple. Send a message, wait for the reply, and then repeat the procedure. Count how many times the software does it per second.
Q&A opponent
When running the PingPong sequence, there must be an opponent present.
I use a standard Windows 10 workstation, equipped with a Kvaser PCIEcan HS v2 interface. The software that runs on the machine checks if there are any CAN messages on the bus, reads them and immediately sends them back (return to sender).
This software is also just naively written and not optimized.[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Typical test sequence"][vc_single_image image="37123"][vc_column_text]
Diagram 1, Kvaser U100, 1Mbit/s, 0 byte DLC
[/vc_column_text][vc_column_text]
The test lasts for 2.5 seconds (x-axis is time in seconds). I start sending 100 PP/s and aim to send 10000 PP/s at the end of the test.
We can see that we start at 100 PP/s (right axis) and the curve flattens at approx 4750 PP/s (right axis).[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Results of the Q&A test"][vc_single_image image="37122"][vc_code_raket language="t" code="JTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwMU1iaXQlMkZzJTJDJTIwMCUyMERMQyUyMCUyMCUyMCUyMDFNYml0JTJGcyUyQyUyMDglMjBETEMlMjAlMjAlMjAlMjA1MDBLYml0JTJGcyUyQyUyMDglMjBETEMlMjAlMjAlMjAlMjAyNTBLYml0JTJGcyUyQyUyMDglMjBETEMlMEFVMTAwJTJGVTEwMFAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA0NzU4JTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwMjc4NyUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMDE2NzglMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA5MzQlMEFMZWFmJTIwUHJvJTIwSFMlMjB2MiUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMDI3MTklMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAyMDAyJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwMTMzNSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMDgwMiUwQUxlYWYlMjBMaWdodCUyMEhTJTIwdjIlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA5ODglMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA5ODglMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA5ODglMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjA0OTYlMEE="][vc_column_text]
As we can see in the test above, the Kvaser U100 and Kvaser U100P always have higher throughput than Leaf Light and Leaf Pro.
They are almost as fast as fixed mounted Kvaser PCIEcan HS v2. When I compare them, the Kvaser U100 and Kvaser U100P reach approximately 85-95% of the PCIe cards capacity.[/vc_column_text][vc_code_raket language="t" code="JTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwQml0cmF0ZSUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMCUyMElEJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwRExDJTBBU2V0dGluZyUyMDElM0ElMjAlMjAlMjAlMjAlMjAlMjAlMjAlMjAxJTIwTWJpdCUyRnMlMjAlMjAlMjAlMjAlMjAlMjAxMWJpdCUyMCUyMCUyMCUyMDAlMjBieXRlcyUwQVNldHRpbmclMjAyJTNBJTIwJTIwJTIwJTIwJTIwJTIwJTIwJTIwMSUyME1iaXQlMkZzJTIwJTIwJTIwJTIwJTIwJTIwMTFiaXQlMjAlMjAlMjAlMjA4JTIwYnl0ZXMlMEFTZXR0aW5nJTIwMyUzQSUyMCUyMCUyMCUyMCUyMCUyMDUwMCUyMGtiaXQlMkZzJTIwJTIwJTIwJTIwJTIwJTIwMTFiaXQlMjAlMjAlMjAlMjA4JTIwYnl0ZXMlMjAlMEFTZXR0aW5nJTIwNCUzQSUyMCUyMCUyMCUyMCUyMCUyMDI1MGslMjBiaXQlMkZzJTIwJTIwJTIwJTIwJTIwJTIwMTFiaXQlMjAlMjAlMjAlMjA4JTIwYnl0ZXM="][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Q & A"][vc_column_text]
Can I migrate from Kvaser Leaf Light HS v2 to Kvaser U100?
The Kvaser U100 supports all features that the Kvaser Leaf Light HS v2 can handle. Normally no adjustments of the software is needed.
Can I Migrate from Kvaser Leaf Pro HS v2 to Kvaser U100P?
The Kvaser U100P supports all features that the Kvaser Leaf Pro can handle except one; the U100P does not support t programs.
Do I need new Drivers and SDK?
All Kvaser interfaces share the same Drivers and SDK package. A software that has been written for the Kvaser Leaf light or Kvaser Leaf Pro can often be used with Kvaser U100 and Kvaser U100P without any changes. (But it is never wrong to update/recompile the software with the latest Kvaser SDK).
Why is the Kvaser U100 faster than Kvaser Leaf Light and Leaf Pro?
Internally: The Kvaser U100 uses a much more powerful processor compared to the Kvaser Pro and Light interfaces. Even though it is more powerful, it still consumes less power.
Externally: The USB communication is much more optimized, both in the Kvaser U100 hardware and also in the Kvaser Drivers. There is no need to do any smart “repacking and bundling” of the CAN frames as the Kvaser U100 has the capacity to handle both USB and CAN communication at the same time.
Will a USB connected interface ever be as fast as an internal mounted interface card?
The currently used technologies will always favor an internally mounted CAN interface before an externally connected CAN interface.
U100 uses USB2, will it be faster if it uses USB3 in the future?
Switching to USB3 will probably not give the interface higher throughput. USB2 is a very reliable communication method that fulfills the requirements we have today and for many years to come. Most of the communication delay is caused by the computer, by the interface circuits and the CPU.
Does the Kvaser U100 require a fast host computer?
The Kvaser U100 will run on almost any hardware. With no repacking and bundling in the USB communication, the Kvaser U100 creates more USB packets when compared to a Kvaser Leaf Pro or Leaf Light. The load on the host CPU will be higher, so it is recommended that the host application has access to enough CPU cores. The Kvaser U100 also requires USB controllers and hubs that are quick and have adequate capacity. (Almost all PCs sold in the last 5 years will have the proper capacity).[/vc_column_text][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row][vc_row][vc_column][vc_header_raket header_type="h3" header="Do you need more information or do you have questions?"][vc_column_text]
Please feel free to contact us, your comments and questions are welcome!
You can find us here: [email protected]
Or, if you like, you can contact me directly:[/vc_column_text][vc_dd_contact_person _name="Lars-Göran “HELGE” Fredriksson" _role="Field Application Engineer" _email="
[email protected]" profile_images="37125"][vc_raw_html]JTNDYnIlMjAlMkYlM0U=[/vc_raw_html][/vc_column][/vc_row]
[post_title] => Comparing the new Kvaser U100 with the Kvaser Leaf Pro HS v2
[post_excerpt] => My aim is to show how much faster than new Kvaser U100/U100P interfaces are, when compared to Kvaser's existing Leaf interface product line.
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => comparing-new-kvaser-u100-with-kvaser-leaf-pro-hs-v2
[to_ping] =>
[pinged] =>
[post_modified] => 2022-01-31 15:29:54
[post_modified_gmt] => 2022-01-31 15:29:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?post_type=developer_blog&p=37120
[menu_order] => 0
[post_type] => developer_blog
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 10
[current_post] => -1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 38152
[post_author] => 38400
[post_date] => 2022-04-08 12:33:41
[post_date_gmt] => 2022-04-08 12:33:41
[post_content] => [vc_row][vc_column][vc_video link="https://www.youtube.com/watch?v=Rfha9AYQ0QM"][vc_column_text]
UPDATE: This event is over. You can watch the archive of the event by clicking the video above.[/vc_column_text][vc_column_text]Accurate Technologies (ATI) and Kvaser held a joint webinar in March to explain the benefits of Kvaser’s LIN interfaces and ATI’s CANLab software.[/vc_column_text][vc_column_text]View the recording to learn how to use these toolchains to log, import, and analyze vehicle LIN data. Adam Raymer, Kvaser Technical support, introduces LIN and explains the specifics of using the Kvaser Leaf Professional with LIN and Kvaser Hybrid, while Maxwell Church, ATI Business Development Manager, provides a tutorial on handling the data in ATI's CANLab software.
View here >[/vc_column_text][/vc_column][/vc_row]
[post_title] => View Accurate Technologies & Kvaser’s free LIN Fundamentals virtual class
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => view-ati-kvasers-free-lin-fundamentals-virtual-class
[to_ping] =>
[pinged] =>
[post_modified] => 2022-05-18 23:43:41
[post_modified_gmt] => 2022-05-18 23:43:41
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://www.kvaser.com/?p=38152
[menu_order] => 0
[post_type] => post
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 469
[max_num_pages] => 47
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] =>
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] =>
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] => 1
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] => 1
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_favicon] =>
[is_posts_page] => 1
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => 353c3ba18c2e6436331859f2a8bfb0d3
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
View Accurate Technologies & Kvaser’s free LIN Fundamentals virtual class
08/04/2022
UPDATE: This event is over. You can watch the archive of the event by clicking the video above. Accurate Technologies… Read More
Read More
Using Excel Visual Basic for Applications with Kvaser CANlib
07/04/2022
Most of us have Microsoft Office installed on our Windows PC and we use Microsoft Excel for lists and calculations,… Read More
Read More
Stable, CAN communication modules ensure that Audi’s diagnostics data always gets through
08/03/2022
Automotive endurance testing creates 100,000s of hours of test data per vehicle. Kvaser’s DIN Rail Ethernet to CAN/CAN FD interface… Read More
Read More
Introducing the Kvaser Hybrid CAN/LIN and Kvaser Hybrid Pro
01/03/2022
New to Kvaser’s product portfolio is the Kvaser Hybrid CAN/LIN (01284-4) and the Kvaser Hybrid Pro CAN/LIN (01288-2). With a… Read More
Read More
Kvaser’s February 2022 Software Release
27/02/2022
There are no major updates within this release, but noteworthy changes include: Python CANlib package (v1.20.360): Python 3.10 is now… Read More
Read More
Kvaser and Zuragon team up with daVinci Technology Group to bring education opportunities to Tanzania
18/02/2022
Located in Manyoni, Tanzania, VTC Mechanic School is a three year program teaching mechanical troubleshooting, repair, and maintenance to young… Read More
Read More
Softing Automotive selects Kvaser U100 as Vehicle Communication Interface for after-sales service diagnostics
08/02/2022
Kvaser AB has announced that Softing Automotive Electronics GmbH has recommended the Kvaser U100 CAN/CAN FD to USB interface as… Read More
Read More
Introducing a U100 with Precision features
01/02/2022
The Kvaser U100P is the Precision version of Kvaser’s U100 range of CAN to USB interfaces. This version is designed… Read More
Read More
Microchip University course uses Kvaser hardware to teach CAN FD
28/01/2022
Microchip University is using the Kvaser Hybrid 2xCAN/LIN interface, the Kvaser T Cannector and K2L’s OptoLyzer® Studio software in a… Read More
Read More
Comparing the new Kvaser U100 with the Kvaser Leaf Pro HS v2
26/01/2022
In this document I will compare some single channel Kvaser CAN interfaces: Kvaser U100 73-30130-01173-1 Kvaser U100P 73-30130-01174-8 Kvaser Leaf… Read More
Read More
youku