{"id":15006,"date":"2001-08-05T12:00:04","date_gmt":"2001-08-05T12:00:04","guid":{"rendered":"http:\/\/www.teoalida.com\/cardatabase\/?p=15006"},"modified":"2025-03-02T13:01:20","modified_gmt":"2025-03-02T13:01:20","slug":"interoperability","status":"publish","type":"post","link":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/","title":{"rendered":"Interoperability with other products"},"content":{"rendered":"\n
\n

As an independent data provider, I do not guarantee interoperability of my databases with other products available online.<\/strong> Actually there is no interoperability between my own car databases, being made from different sources.<\/p>\n\n\n\n

Combining data from multiple tables into one can be done in Excel using VLOOKUP function<\/a>, if both tables have a common identifier.<\/strong> For example I use a scraper to extract Make, Model, Trim, Trim ID and another scraper to input Trim ID and extract specifications from same website, then I combine 2 tables into one by VLOOKUP-ing by Trim ID.<\/p>\n\n\n\n

Combining data from multiple websites cannot be automatized due to lack of a common identifier.<\/strong> Having car names matching is a coincidence rather than a rule. If you check major automobile websites like Edmunds.com, KBB.com, TheCarConnection.com, Redbook.com.au, Parkers.co.uk, ADAC.de, eBay, ACES, JATO, TecDoc, etc, you will see lots of hierarchy or spelling differences, because each one developed their database independently.<\/p>\n\n\n\n

Most common conflicts are at BMW and Mercedes, some have model “BMW 3-Series saloon” with trim\/variant “320i”, others have model “320i” with trim\/variant “saloon, touring, coupe, cabrio”, others have model simply “3-Series” with trim\/variant “320i saloon”, among those having 3-Series as model, some put M3 as separate model and others put M3 as trim\/variant under 3-Series.<\/p>\n\n\n\n

In the original databases<\/a> started in 2003<\/strong> for Europe: Car Models List, Car Models Encyclopedia, Car Models Database, Car Models & Engines Database, over years I done numerous changes to make model hierarchy as efficient is possible based on parts compatibility, so M and AMG models are not listed separately than their base model. If you find differences between mine and other databases, do not claim that my database is wrong and yours is correct, because NOBODY is correct in relation with others. Even if I adapt my database to match your data, tomorrow someone else may attempt to combine my database with some other data and complain again about differences.<\/p>\n\n\n\n

An example of argue with an American customer is whenever WRX is a trim of Subaru Impreza or a separate model. Edmunds website itself list same car in 3 different ways: trim WRX under Impreza model for 2002-2012, then Impreza WRX as model for 2013-2014, then WRX without Impreza badge for 2015-present. This because in the recent years Subaru USA is marketing WRX more individually. And there are thousands of such conflicts.<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

As an independent data provider, I do not guarantee interoperability with other products available online.<\/strong><\/p>\n

Most common conflicts are at BMW and Mercedes, some have model “BMW 3-Series saloon” with trim\/variant “320i”, others have model “320i” with trim\/variant “saloon, touring, coupe, cabrio”, others have model simply “3-Series” with trim\/variant “320i saloon”, among those having 3-Series as model, some put M3 as separate model and others put M3 as trim\/variant under 3-Series.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"off","neve_meta_content_width":70,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-15006","post","type-post","status-publish","format-standard","hentry","category-faq"],"yoast_head":"\nInteroperability with other products - The most updated car database<\/title>\n<meta name=\"description\" content=\"If you check major automobile websites you will see lots of hierarchy or spelling differences, because each one built their database independently.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Interoperability with other products - The most updated car database\" \/>\n<meta property=\"og:description\" content=\"If you check major automobile websites you will see lots of hierarchy or spelling differences, because each one built their database independently.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/\" \/>\n<meta property=\"og:site_name\" content=\"The most updated car database\" \/>\n<meta property=\"article:published_time\" content=\"2001-08-05T12:00:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-02T13:01:20+00:00\" \/>\n<meta name=\"author\" content=\"Teoalida\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Teoalida\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/\"},\"author\":{\"name\":\"Teoalida\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#\\\/schema\\\/person\\\/c2415643f15210772f04fee87c702d99\"},\"headline\":\"Interoperability with other products\",\"datePublished\":\"2001-08-05T12:00:04+00:00\",\"dateModified\":\"2025-03-02T13:01:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/\"},\"wordCount\":405,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#organization\"},\"articleSection\":[\"F.A.Q. & important info\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/\",\"url\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/\",\"name\":\"Interoperability with other products - The most updated car database\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#website\"},\"datePublished\":\"2001-08-05T12:00:04+00:00\",\"dateModified\":\"2025-03-02T13:01:20+00:00\",\"description\":\"If you check major automobile websites you will see lots of hierarchy or spelling differences, because each one built their database independently.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/interoperability\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Interoperability with other products\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#website\",\"url\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/\",\"name\":\"The most updated car database\",\"description\":\"Developed by Teoalida since 2003 - Excel, CSV, SQL files for download\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#organization\",\"name\":\"Teoalida\",\"url\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/wp-content\\\/uploads\\\/Car-Models-Engines-All-Details-Database.png\",\"contentUrl\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/wp-content\\\/uploads\\\/Car-Models-Engines-All-Details-Database.png\",\"width\":3200,\"height\":1800,\"caption\":\"Teoalida\"},\"image\":{\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teoalida.com\\\/cardatabase\\\/#\\\/schema\\\/person\\\/c2415643f15210772f04fee87c702d99\",\"name\":\"Teoalida\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/28b2c5f4ff41c4a68a4086e8aff9c0b4fb6ad57bba029d76b119585352d7a639?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/28b2c5f4ff41c4a68a4086e8aff9c0b4fb6ad57bba029d76b119585352d7a639?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/28b2c5f4ff41c4a68a4086e8aff9c0b4fb6ad57bba029d76b119585352d7a639?s=96&d=mm&r=g\",\"caption\":\"Teoalida\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Interoperability with other products - The most updated car database","description":"If you check major automobile websites you will see lots of hierarchy or spelling differences, because each one built their database independently.","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:\/\/www.teoalida.com\/cardatabase\/interoperability\/","og_locale":"en_US","og_type":"article","og_title":"Interoperability with other products - The most updated car database","og_description":"If you check major automobile websites you will see lots of hierarchy or spelling differences, because each one built their database independently.","og_url":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/","og_site_name":"The most updated car database","article_published_time":"2001-08-05T12:00:04+00:00","article_modified_time":"2025-03-02T13:01:20+00:00","author":"Teoalida","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Teoalida","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/#article","isPartOf":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/"},"author":{"name":"Teoalida","@id":"https:\/\/www.teoalida.com\/cardatabase\/#\/schema\/person\/c2415643f15210772f04fee87c702d99"},"headline":"Interoperability with other products","datePublished":"2001-08-05T12:00:04+00:00","dateModified":"2025-03-02T13:01:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/"},"wordCount":405,"commentCount":2,"publisher":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/#organization"},"articleSection":["F.A.Q. & important info"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teoalida.com\/cardatabase\/interoperability\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/","url":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/","name":"Interoperability with other products - The most updated car database","isPartOf":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/#website"},"datePublished":"2001-08-05T12:00:04+00:00","dateModified":"2025-03-02T13:01:20+00:00","description":"If you check major automobile websites you will see lots of hierarchy or spelling differences, because each one built their database independently.","breadcrumb":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teoalida.com\/cardatabase\/interoperability\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teoalida.com\/cardatabase\/interoperability\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teoalida.com\/cardatabase\/"},{"@type":"ListItem","position":2,"name":"Interoperability with other products"}]},{"@type":"WebSite","@id":"https:\/\/www.teoalida.com\/cardatabase\/#website","url":"https:\/\/www.teoalida.com\/cardatabase\/","name":"The most updated car database","description":"Developed by Teoalida since 2003 - Excel, CSV, SQL files for download","publisher":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teoalida.com\/cardatabase\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.teoalida.com\/cardatabase\/#organization","name":"Teoalida","url":"https:\/\/www.teoalida.com\/cardatabase\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.teoalida.com\/cardatabase\/#\/schema\/logo\/image\/","url":"https:\/\/www.teoalida.com\/cardatabase\/wp-content\/uploads\/Car-Models-Engines-All-Details-Database.png","contentUrl":"https:\/\/www.teoalida.com\/cardatabase\/wp-content\/uploads\/Car-Models-Engines-All-Details-Database.png","width":3200,"height":1800,"caption":"Teoalida"},"image":{"@id":"https:\/\/www.teoalida.com\/cardatabase\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.teoalida.com\/cardatabase\/#\/schema\/person\/c2415643f15210772f04fee87c702d99","name":"Teoalida","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/28b2c5f4ff41c4a68a4086e8aff9c0b4fb6ad57bba029d76b119585352d7a639?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/28b2c5f4ff41c4a68a4086e8aff9c0b4fb6ad57bba029d76b119585352d7a639?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/28b2c5f4ff41c4a68a4086e8aff9c0b4fb6ad57bba029d76b119585352d7a639?s=96&d=mm&r=g","caption":"Teoalida"}}]}},"_links":{"self":[{"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/posts\/15006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/comments?post=15006"}],"version-history":[{"count":0,"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/posts\/15006\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/media?parent=15006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/categories?post=15006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teoalida.com\/cardatabase\/wp-json\/wp\/v2\/tags?post=15006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}