{"id":1240,"date":"2015-10-10T01:22:22","date_gmt":"2015-10-10T01:22:22","guid":{"rendered":"http:\/\/elbsolutions.com\/projects\/?p=1240"},"modified":"2022-02-03T11:24:36","modified_gmt":"2022-02-03T17:24:36","slug":"a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off","status":"publish","type":"post","link":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/","title":{"rendered":"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can&#8217;t believe I pulled this off"},"content":{"rendered":"<p>So, for now this article is a list of links that I used to pull this off. It is VERY rough \u00a0but, I have LOTS of VBA code in Excel that I want to <strong>reuse but have Excel VBA triggered FROM THE WEB when a piping designer clicks on it<\/strong>. [Update: it fully works and is in use!] The link drives the existing VBA in excel which in turn, drives the running instance of Autocad and does lots of things &#8211; in this case I want to reuse my code that opens an autocad drawing, iterates through all the components\u00a0until the one you want is found, then it zooms into an AutoCad component of the currently selected cell.<\/p>\n<p>This link is in a SSRS (Report Services) page that we already have to find components based on the long and short description from AutoPLANT. Here is the round trip discussion and the links I used are at the bottom. I can&#8217;t believe I did this. Super cool.<!--more--><\/p>\n<ul>\n<li>user puts in a description\/key word into the report query<\/li>\n<li>a report comes up &#8211; user clicks on the component of choice (it is a custom url scheme)\u00a0&#8220;<a href=\"\/\/zoomInThisComponent?component_id=BASE64ENCODEDSTRING&amp;drawingName=BASE64ENCODEDSTRING\" target=\"_blank\" rel=\"noopener noreferrer\">mycustomapp:\/\/zoomInThisComponent?component_id=BASE64ENCODEDSTRING&amp;drawingName=BASE64ENCODEDSTRING<\/a>&#8221;\n<ul>\n<li>note there is some coding to do in T-SQL to base 64 encode stuff<\/li>\n<\/ul>\n<\/li>\n<li>a c# app that is linked to that registered custom url scheme is triggered<\/li>\n<li>the current version of excel is accessed or it complains you don&#8217;t have excel started\n<ul>\n<li>it decodes the strings above and uses them to open the correct autocad files etc.<\/li>\n<\/ul>\n<\/li>\n<li>the ALREADY WRITTEN VBA code in Excel then does what it always did\n<ul>\n<li>(that is why I have Excel in the mix &#8211; really you can do it all in .net &#8211; but why redo code? Well &#8211; ok because you can justify\u00a0your client\u00a0paying you for it <strong>but<\/strong> reusing it means you can move ahead and do cool things like this <strong>instead<\/strong>.<\/li>\n<li>this code iterates through all components, looks at the AutoPLANT dictionary and finds the componetn id that matches the one you clicked on<\/li>\n<li>then it zooms in<\/li>\n<li>lots of code exists that closes the orignal drawing if it is open and IGNORES re-opening it if it is already loaded<\/li>\n<li>again &#8211; I am reusing lots of code.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Super cool and it works like a charm. VERY EASY &#8211; not so straight forward. I have a working prototype in about 3 hours.<\/p>\n<p>&nbsp;<\/p>\n<h3>Here are my links:<\/h3>\n<ul>\n<li><a href=\"http:\/\/elbsolutions.com\/projects\/piggy-backing-on-an-excel-instance-even-when-there-are-a-few-in-task-manager\/\">How to iterate through ALL instances of Excel (my article)<\/a><\/li>\n<li>Command line parameters in VBA<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.vbforums.com\/showthread.php?366559-Excel-How-to-Pass-Command-Line-Parameter-DKenny-is-KING\">http:\/\/www.vbforums.com\/showthread.php?366559-Excel-How-to-Pass-Command-Line-Parameter-DKenny-is-KING<\/a>!<\/p>\n<p><a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/office\/en-US\/6124691b-a5ce-4fc0-a648-e85b4a32f77a\/excel-vba-to-read-command-line-parameters-and-copy-in-a-cell?forum=exceldev\">https:\/\/social.msdn.microsoft.com\/Forums\/office\/en-US\/6124691b-a5ce-4fc0-a648-e85b4a32f77a\/excel-vba-to-read-command-line-parameters-and-copy-in-a-cell?forum=exceldev<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Odd that I had to google this \u2013 but selecting a simple cell in c# has some sommands that do NOT pull up with intellisense.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/2513968\/how-to-focus-a-cell-in-excel-vsto-using-c-how-to-select-first-cell-using-c-sha\">http:\/\/stackoverflow.com\/questions\/2513968\/how-to-focus-a-cell-in-excel-vsto-using-c-how-to-select-first-cell-using-c-sha<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>How to fake highlighting autoCad components since .Highlight() just could care less about doing its job (Transient Graphics)<\/li>\n<\/ul>\n<p><a href=\"http:\/\/drive-cad-with-code.blogspot.ca\/\">http:\/\/drive-cad-with-code.blogspot.ca\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Excel Command line options<\/li>\n<\/ul>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/Command-line-switches-for-Excel-321cf55a-ace4-40b3-9082-53bd4bc10725\">https:\/\/support.office.com\/en-us\/article\/Command-line-switches-for-Excel-321cf55a-ace4-40b3-9082-53bd4bc10725<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Registering an application handler for a custom uri scheme<\/li>\n<\/ul>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/aa767914%28VS.85%29.aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/aa767914%28VS.85%29.aspx<\/a><\/p>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/3057576\/launch-application-from-a-browser\">http:\/\/stackoverflow.com\/questions\/3057576\/launch-application-from-a-browser<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Running a macro in VBA from .net<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/14248592\/running-an-excel-macro-via-c-run-a-macro-from-one-workbook-on-another\">http:\/\/stackoverflow.com\/questions\/14248592\/running-an-excel-macro-via-c-run-a-macro-from-one-workbook-on-another<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Running excel functions on a local computer from .net using Interop.Excel<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/10477977\/what-reference-do-i-need-to-use-microsoft-office-interop-excel-in-net\">http:\/\/stackoverflow.com\/questions\/10477977\/what-reference-do-i-need-to-use-microsoft-office-interop-excel-in-net<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Get the current running version of Excel using GetObject \u2026 but in c#<\/li>\n<\/ul>\n<p><a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/vstudio\/en-US\/71044a7d-5424-4c84-94d3-3b29f84b1d2f\/net-equivalent-of-createobject-and-getobject\">https:\/\/social.msdn.microsoft.com\/Forums\/vstudio\/en-US\/71044a7d-5424-4c84-94d3-3b29f84b1d2f\/net-equivalent-of-createobject-and-getobject<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Adding a pause to the command line app<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/7280591\/read-user-input-from-console\">http:\/\/stackoverflow.com\/questions\/7280591\/read-user-input-from-console<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Confirming command line arguments in c# app<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/7280591\/read-user-input-from-console\">http:\/\/stackoverflow.com\/questions\/7280591\/read-user-input-from-console<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>VBA version of Base64Decoder class<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.source-code.biz\/snippets\/vbasic\/Base64Coder.bas.txt\">http:\/\/www.source-code.biz\/snippets\/vbasic\/Base64Coder.bas.txt<\/a><\/p>\n<p><a href=\"http:\/\/www.globaliconnect.com\/excel\/index.php?option=com_content&amp;view=article&amp;id=267:excel-vba-empty-zls-null-nothing-missing&amp;catid=79&amp;Itemid=475\">http:\/\/www.globaliconnect.com\/excel\/index.php?option=com_content&amp;view=article&amp;id=267:excel-vba-empty-zls-null-nothing-missing&amp;catid=79&amp;Itemid=475<\/a><\/p>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/11675454\/how-to-parse-url-parameters-in-vba\">http:\/\/stackoverflow.com\/questions\/11675454\/how-to-parse-url-parameters-in-vba<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Calling VBA Functions from c#<\/li>\n<\/ul>\n<p><a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/microsoft.office.interop.excel._application.run.aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/microsoft.office.interop.excel._application.run.aspx<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>c# encoding base64<\/li>\n<\/ul>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/11743160\/how-do-i-encode-and-decode-a-base64-string\">http:\/\/stackoverflow.com\/questions\/11743160\/how-do-i-encode-and-decode-a-base64-string<\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>I had to do the encoding in SQL by making a scalar function \u2013 why? Because doing it in SSRS is too much \u2013 why not do it in SSRS<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.falafel.com\/t-sql-easy-base64-encoding-and-decoding\/\">http:\/\/blog.falafel.com\/t-sql-easy-base64-encoding-and-decoding\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, for now this article is a list of links that I used to pull this off. It is VERY rough \u00a0but, I have LOTS of VBA code in Excel that I want to reuse but have Excel VBA triggered FROM THE WEB when a piping designer clicks on it. [Update: it fully works and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1240","post","type-post","status-publish","format-standard","hentry","category-general"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can&#039;t believe I pulled this off - ELB Solutions.com Inc.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can&#039;t believe I pulled this off - ELB Solutions.com Inc.\" \/>\n<meta property=\"og:description\" content=\"So, for now this article is a list of links that I used to pull this off. It is VERY rough \u00a0but, I have LOTS of VBA code in Excel that I want to reuse but have Excel VBA triggered FROM THE WEB when a piping designer clicks on it. [Update: it fully works and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/\" \/>\n<meta property=\"og:site_name\" content=\"ELB Solutions.com Inc.\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-10T01:22:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-02-03T17:24:36+00:00\" \/>\n<meta name=\"author\" content=\"Etienne Bley\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Etienne Bley\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. 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:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/\"},\"author\":{\"name\":\"Etienne Bley\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"headline\":\"A custom clickable url opens autocad and zooms into a specific AutoPLANT\\\/AutoCad part. I can&#8217;t believe I pulled this off\",\"datePublished\":\"2015-10-10T01:22:22+00:00\",\"dateModified\":\"2022-02-03T17:24:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/\"},\"wordCount\":776,\"articleSection\":[\"General\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/\",\"name\":\"A custom clickable url opens autocad and zooms into a specific AutoPLANT\\\/AutoCad part. I can't believe I pulled this off - ELB Solutions.com Inc.\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\"},\"datePublished\":\"2015-10-10T01:22:22+00:00\",\"dateModified\":\"2022-02-03T17:24:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A custom clickable url opens autocad and zooms into a specific AutoPLANT\\\/AutoCad part. I can&#8217;t believe I pulled this off\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#website\",\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/\",\"name\":\"ELB Solutions.com Inc.\",\"description\":\"Bringing all your IT Pieces together\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/#\\\/schema\\\/person\\\/51e717c68f4f5917c63baf88f0896c39\",\"name\":\"Etienne Bley\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g\",\"caption\":\"Etienne Bley\"},\"url\":\"https:\\\/\\\/elbsolutions.com\\\/projects\\\/author\\\/etienne-bley\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can't believe I pulled this off - ELB Solutions.com Inc.","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:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/","og_locale":"en_US","og_type":"article","og_title":"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can't believe I pulled this off - ELB Solutions.com Inc.","og_description":"So, for now this article is a list of links that I used to pull this off. It is VERY rough \u00a0but, I have LOTS of VBA code in Excel that I want to reuse but have Excel VBA triggered FROM THE WEB when a piping designer clicks on it. [Update: it fully works and [&hellip;]","og_url":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/","og_site_name":"ELB Solutions.com Inc.","article_published_time":"2015-10-10T01:22:22+00:00","article_modified_time":"2022-02-03T17:24:36+00:00","author":"Etienne Bley","twitter_misc":{"Written by":"Etienne Bley","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/#article","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/"},"author":{"name":"Etienne Bley","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"headline":"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can&#8217;t believe I pulled this off","datePublished":"2015-10-10T01:22:22+00:00","dateModified":"2022-02-03T17:24:36+00:00","mainEntityOfPage":{"@id":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/"},"wordCount":776,"articleSection":["General"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/","url":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/","name":"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can't believe I pulled this off - ELB Solutions.com Inc.","isPartOf":{"@id":"https:\/\/elbsolutions.com\/projects\/#website"},"datePublished":"2015-10-10T01:22:22+00:00","dateModified":"2022-02-03T17:24:36+00:00","author":{"@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39"},"breadcrumb":{"@id":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/elbsolutions.com\/projects\/a-custom-clickable-url-opens-autocad-and-zooms-into-a-specific-autoplant-part-i-cant-believe-i-pulled-this-off\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/elbsolutions.com\/projects\/"},{"@type":"ListItem","position":2,"name":"A custom clickable url opens autocad and zooms into a specific AutoPLANT\/AutoCad part. I can&#8217;t believe I pulled this off"}]},{"@type":"WebSite","@id":"https:\/\/elbsolutions.com\/projects\/#website","url":"https:\/\/elbsolutions.com\/projects\/","name":"ELB Solutions.com Inc.","description":"Bringing all your IT Pieces together","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/elbsolutions.com\/projects\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/elbsolutions.com\/projects\/#\/schema\/person\/51e717c68f4f5917c63baf88f0896c39","name":"Etienne Bley","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f8971dfb65b25b768415568f83247df4057f15d037137e386928a804e2c997b9?s=96&d=mm&r=g","caption":"Etienne Bley"},"url":"https:\/\/elbsolutions.com\/projects\/author\/etienne-bley\/"}]}},"_links":{"self":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/comments?post=1240"}],"version-history":[{"count":7,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1240\/revisions"}],"predecessor-version":[{"id":2723,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/posts\/1240\/revisions\/2723"}],"wp:attachment":[{"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/media?parent=1240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/categories?post=1240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elbsolutions.com\/projects\/wp-json\/wp\/v2\/tags?post=1240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}