{"id":1583,"date":"2012-05-11T09:30:00","date_gmt":"2012-05-11T07:30:00","guid":{"rendered":"https:\/\/blogs.autodesk.com\/villagebim\/2012\/05\/autocad-plant-3d-2013-extraction-des-cataloguesclasses-de-tuyauterie-sqlite.html"},"modified":"2012-05-11T09:30:00","modified_gmt":"2012-05-11T07:30:00","slug":"autocad-plant-3d-2013-extraction-des-cataloguesclasses-de-tuyauterie-sqlite","status":"publish","type":"post","link":"https:\/\/blogs.autodesk.com\/villagebim\/2012\/05\/autocad-plant-3d-2013-extraction-des-cataloguesclasses-de-tuyauterie-sqlite.html","title":{"rendered":"AutoCAD Plant 3D 2013 : extraction des catalogues\/classes de tuyauterie &#8211; SQLite"},"content":{"rendered":"<p>Dans ce billet, nous allons d\u00e9crire le fonctionnement d\u2019une partie des bases de donn\u00e9es <span style=\"text-decoration: underline\">SQLite<\/span> (format de projet <span style=\"text-decoration: underline\">par d\u00e9faut d\u2019AutoCAD Plant 3D 2013<\/span>)&#160;: <em>les catalogues<\/em> et les <em>classes de tuyauteries<\/em> (specs).<\/p>\n<p>Pour illustrer cela, nous allons nous appuyer sur un cas client qui m\u2019a \u00e9t\u00e9 pos\u00e9 derni\u00e8rement&#160;: <strong>\u00ab&#160;pour des pi\u00e8ces ayant des param\u00e8tres diff\u00e9rents en entr\u00e9e\/sortie (schedule par exemple), on souhaite extraire ces informations dans un tableur&#160;\u00bb<\/strong>. Dans un second temps, ces extraits pourront \u00eatre utilis\u00e9s\/li\u00e9s \u00e0 un programme de gestion, par exemple.<\/p>\n<p>Vous aurez besoin d\u2019installer le <span style=\"text-decoration: underline\">pilote ODBC SQLite3<\/span> (voir &quot; Bibliographie &quot;&#160;plus bas), <span style=\"text-decoration: underline\">Microsoft\u00ae Access\u00ae<\/span> et <span style=\"text-decoration: underline\">un tableur<\/span>.<\/p>\n<p>La vid\u00e9o suivante d\u00e9crit les \u00e9tapes de cette m\u00e9thode, utilisable m\u00eame sans \u00eatre un expert en bases de donn\u00e9es (m\u00eame s\u2019il est pr\u00e9f\u00e9rable d\u2019avoir quelques notions tout de m\u00eame :-))&#160;:<\/p>\n<p>&#160;<\/p>\n<p style=\"text-align: center\">\n<p><strong>Bibliographie :<\/strong><\/p>\n<p>Voici la liste des aides et autres documents ayant inspir\u00e9 la r\u00e9daction de cet article :<\/p>\n<ul>\n<li>Site SQLite&#160;:<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.sqlite.org\/\">http:\/\/www.sqlite.org\/<\/a><\/p>\n<ul>\n<li>Pilote ODBC SQLite 3:<\/li>\n<\/ul>\n<p><a href=\"http:\/\/www.ch-werner.de\/sqliteodbc\/\">http:\/\/www.ch-werner.de\/sqliteodbc\/<\/a><\/p>\n<p>L\u2019aide pr\u00e9cieuse de mon coll\u00e8gue norv\u00e9gien Dag Austrheim qui m\u2019a mis sur la voie, merci \u00e0 lui \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans ce billet, nous allons d\u00e9crire le fonctionnement d\u2019une partie des bases de donn\u00e9es SQLite (format de projet par d\u00e9faut d\u2019AutoCAD Plant 3D 2013)&#160;: les catalogues et les classes de tuyauteries (specs). Pour illustrer cela, nous allons nous appuyer sur un cas client qui m\u2019a \u00e9t\u00e9 pos\u00e9 derni\u00e8rement&#160;: \u00ab&#160;pour des pi\u00e8ces ayant des param\u00e8tres diff\u00e9rents [&hellip;]<\/p>\n","protected":false},"author":52099,"featured_media":2472,"menu_order":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[15,28,6,43],"tags":[2747,1584,2967,1893],"class_list":["post-1583","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-autodesk-revit","category-gestion-de-donnees","category-trucs-et-astuces","category-tuyauterie-industrielle","tag-autocad-plant-3d-2013","tag-base-de-donnees","tag-microsoft-access","tag-sqlite","dhig-theme--light"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/1583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/users\/52099"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/comments?post=1583"}],"version-history":[{"count":0,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/1583\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/media\/2472"}],"wp:attachment":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/media?parent=1583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/categories?post=1583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/tags?post=1583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}