{"id":124,"date":"2020-02-03T09:00:00","date_gmt":"2020-02-03T07:00:00","guid":{"rendered":"https:\/\/blogs.autodesk.com\/villagebim\/2020\/02\/tutoriel-autodesk-navisworks-ajoutez-des-donnees-utilisateurs-a-partir-de-microsoft-excel-22.html"},"modified":"2021-02-04T20:07:33","modified_gmt":"2021-02-04T18:07:33","slug":"tutoriel-autodesk-navisworks-ajoutez-des-donnees-utilisateurs-a-partir-de-microsoft-excel-22","status":"publish","type":"post","link":"https:\/\/blogs.autodesk.com\/villagebim\/2020\/02\/tutoriel-autodesk-navisworks-ajoutez-des-donnees-utilisateurs-a-partir-de-microsoft-excel-22.html","title":{"rendered":"[Tutoriel] Autodesk Navisworks : Ajoutez des donn\u00e9es utilisateurs \u00e0 partir de Microsoft Excel 2\/2"},"content":{"rendered":"<p><strong><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2e3200c-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image002[5]\" border=\"0\" height=\"309\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2e7200c-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image002[5]\" width=\"454\" \/><\/a><\/strong><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;<a href=\"https:\/\/villagebim.typepad.com\/villagebim\/2020\/01\/tutoriel-autodesk-navisworks-ajouter-des-donnes-utilisateur-a-un-objet-12.html\">Dans cet article<\/a>, j\u2019expliquais comment, \u00e0 partir du logiciel Autodesk Navisworks, cr\u00e9er des variables utilisateurs \u00e0 un \u00e9l\u00e9ment sp\u00e9cifique. Bien que cette m\u00e9thode soit tr\u00e8s simple \u00e0 mettre \u00e0 place, elle est quand m\u00eame tr\u00e8s limit\u00e9e quant \u00e0 la propagation des variables aux autres \u00e9l\u00e9ments.<\/p>\n<p style=\"text-align: justify\">C\u2019est pour cette raison que je vous propose une autre m\u00e9thode, d\u00e9crite ci-dessous.<\/p>\n<p style=\"text-align: justify\"><strong><u>0- Pr\u00e9requis :<\/u><\/strong><\/p>\n<p style=\"text-align: justify\">Le workflow propos\u00e9 commence par l\u2019importation de donn\u00e9es \u00e0 partir du logiciel Microsoft Excel, ce qui impose une certaine homog\u00e9n\u00e9it\u00e9 en termes de versions :<\/p>\n<ul>\n<li>Ordinateur 32 bits (drivers ODBC 32 bits) :<\/li>\n<\/ul>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Autodesk Navisworks 32 bits<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Microsoft Excel 32 bits<\/p>\n<ul>\n<li>Ordinateur 64 bits (drivers ODBC 64 bits) :<\/li>\n<\/ul>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Autodesk Navisworks 64 bits<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Microsoft Excel 64 bits<\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;Pour connaitre le type de version Autodesk Navisworks,cliquez sur la petite fl\u00e8che puis \u00ab <em>A propos de Autodesk Navisworks\u2026<\/em> \u00bb<\/p>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeaa8200d-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image004[5]\" border=\"0\" height=\"450\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a50392ee200b-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image004[5]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;Pour connaitre le type de version Microsoft Excel, cliquez sur \u00ab <em>Compte<\/em> \u00bb puis \u00ab <em>A propos d\u2019Excel<\/em> \u00bb<\/p>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2ed200c-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image006[5]\" border=\"0\" height=\"375\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeaac200d-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image006[5]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;Comme vous pouvez le constater sur mon ordinateur, je ne pourrai pas utiliser le workflow \u00e0 moins de r\u00e9aliser l\u2019installation de Microsoft Office 64 bits (ce que je ne vais pas faire ).<\/p>\n<p style=\"text-align: justify\"><u>Nota :<\/u> La derni\u00e8re version disponible en 32 bits \u00e9tait Autodesk Navisworks 2014.<\/p>\n<p style=\"text-align: justify\"><strong><u>1- Export du logiciel Autodesk Navisworks vers Microsoft Excel :<\/u><\/strong><\/p>\n<p style=\"text-align: justify\">&#160;&#160;&#160;&#160;Afin d\u2019avoir la structuration du fichier Excel pour communiquer avec le logiciel Autodesk Navisworks, nous allons effectuer un export depuis Navisworks.<\/p>\n<ul>\n<li>S\u00e9lectionnez les \u00e9l\u00e9ments dont les donn\u00e9es doivent \u00eatre export\u00e9es<\/li>\n<li>Ouvrez \u00ab l\u2019<em>Inspecteur de s\u00e9lection<\/em> \u00bb, dans l\u2019onglet \u00ab <em>D\u00e9but<\/em> \u00bb<\/li>\n<\/ul>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2f2200c-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image008[4]\" border=\"0\" height=\"100\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2f4200c-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image008[4]\" width=\"454\" \/><\/a><\/p>\n<ul>\n<li>Dans la fen\u00eatre qui s\u2019affiche, cliquez sur le bouton \u00ab <em>D\u00e9finitions de propri\u00e9t\u00e9s rapides<\/em> \u00bb<\/li>\n<li>Dans la fen\u00eatre qui appara\u00eet, supprimez toutes les cat\u00e9gories (croix rouge) et cr\u00e9ez de nouvelles. Dans mon cas, j\u2019en ai mis deux :<\/li>\n<\/ul>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Identifiant de l\u2019\u00e9l\u00e9ment<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Le nom de l\u2019\u00e9l\u00e9ment<\/p>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a50392f2200b-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image010[4]\" border=\"0\" height=\"246\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a50392f6200b-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image010[4]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Puis cliquez sur le bouton \u00ab <em>Ok<\/em> \u00bb<\/p>\n<p style=\"text-align: justify\"><u>Nota :<\/u> vous pouvez ajouter autant de cat\u00e9gories disponibles dans l\u2019interface.<\/p>\n<ul>\n<li>De retour dans la fen\u00eatre \u00ab <em>Inspecteur de s\u00e9lection<\/em> \u00bb, cliquez sur le bouton \u00ab <em>Exporter au format CSV<\/em> \u00bb<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><u>2- Manipulation dans le fichier Excel :<\/u><\/strong><\/p>\n<ul>\n<li>Ouvrez le fichier CSV cr\u00e9\u00e9 \u00e0 l\u2019\u00e9tape pr\u00e9c\u00e9dente et enregistrez-le au format XLSX<\/li>\n<\/ul>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeab0200d-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image014[4]\" border=\"0\" height=\"215\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2f6200c-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image014[4]\" width=\"454\" \/><\/a><\/p>\n<ul>\n<li>Dans le fichier XLSX, ajoutez des colonnes suppl\u00e9mentaires avec des donn\u00e9es, comme montr\u00e9 ci-dessous :<\/li>\n<\/ul>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeab5200d-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image016[4]\" border=\"0\" height=\"215\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2fa200c-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image016[4]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\"><u>Nota :<\/u> \u00e9vitez les espaces et les accents dans les noms.<\/p>\n<ul>\n<li>Enregistrez et fermez le fichier XLSX<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><u>3 \u2013 Import des nouvelles donn\u00e9es Excel vers Navisworks : <\/u><\/strong><\/p>\n<ul>\n<li>Cliquez sur le bouton \u00ab <em>Data Tools<\/em> \u00bb, disponible dans l\u2019onglet \u00ab <em>D\u00e9but<\/em> \u00bb<\/li>\n<\/ul>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c2fe200c-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image018[4]\" border=\"0\" height=\"62\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeab9200d-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image018[4]\" width=\"454\" \/><\/a><\/p>\n<ul>\n<li>Dans la fen\u00eatre \u00ab <em>DataTools<\/em> \u00bb, cliquez sur le bouton \u00ab <em>Nouveau<\/em> \u00bb<\/li>\n<li>Dans le fen\u00eatre \u00ab <em>Nouveau lien<\/em> \u00bb :<\/li>\n<\/ul>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Donnez un nom au lien, Exemple \u00ab <em>VillageBIM<\/em> \u00bb<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Pilote ODBC, choisissez \u201c<em>Microsoft Excel Drivers<\/em>\u201d<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Cliquez sur le bouton \u201c<em>Configuration<\/em>\u2026 \u00bb, puis sur \u00ab <em>Select Workbook\u2026<\/em> \u00bb et enfin indiquez le fichier XLSX cr\u00e9\u00e9 \u00e0 l\u2019\u00e9tape pr\u00e9c\u00e9dente<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Activez l\u2019option \u00ab <em>Maintenir ouvert pour la dur\u00e9e de vie de l\u2019application <\/em>\u00bb : permet de s\u2019assurer que Excel reste ouvert tant que Navisworks est en cours d\u2019utilisation<\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Chaine SQL :<strong> SELECT * FROM [<\/strong><em>nom de l\u2019onglet du fichier Excel<\/em><strong>$] WHERE &quot;<\/strong> ID_element<strong> &quot;=%prop(<\/strong>&quot;ID_element &quot;, &quot;Valeur&quot;<strong>);*<\/strong><\/p>\n<p style=\"text-align: justify\">&#160; &#160; &#160; &#160; &#160; &#160;o Dans la partie \u00ab Champs \u00bb, double-cliquez sur la premi\u00e8re ligne et entrez le nom des champs correspondants aux nouvelles colonnes dans le fichier Excel (attention les appellations doivent \u00eatre identiques). Les noms dans la colonne \u00ab <em>Nom d\u2019affichage<\/em> \u00bb peuvent \u00eatre modifi\u00e9s \u2013 c\u2019est ceux qui appara\u00eetront dans le logiciel Navisworks<\/p>\n<p style=\"text-align: justify\"><u>R\u00e9sultat de param\u00e9trage :<\/u><\/p>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeabd200d-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image019[4]\" border=\"0\" height=\"299\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeac1200d-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image019[4]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">* Je n\u2019ai pas pu tester la cha\u00eene SQL que je vous propose, du fait de ma non-compatibilit\u00e9 \u00e9voqu\u00e9e au chapitre 0. Pour plus de renseignement cliquez <a href=\"http:\/\/help.autodesk.com\/view\/NAV\/2020\/FRA\/?guid=GUID-D6EE4C1A-A9BB-4839-B171-FFC887ACE44D\">ici<\/a>.<\/p>\n<ul>\n<li>Cliquez sur le bouton \u00ab <em>Ok<\/em> \u00bb<\/li>\n<li>Avant de quitter le fen\u00eatre \u00ab <em>DataTools<\/em> \u00bb, n\u2019oubliez pas d\u2019activer le lien<\/li>\n<\/ul>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a5039303200b-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image020[4]\" border=\"0\" height=\"544\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4deeac6200d-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image020[4]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\"><strong><u>4- R\u00e9sultats :<\/u><\/strong><\/p>\n<p><a href=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c305200c-pi\"><img loading=\"lazy\" decoding=\"async\" alt=\"clip_image022[4]\" border=\"0\" height=\"238\" src=\"https:\/\/villagebim.typepad.com\/.a\/6a015391e15a28970b0240a4b5c309200c-pi\" style=\"background-image: none;margin-left: auto;margin-right: auto\" title=\"clip_image022[4]\" width=\"454\" \/><\/a><\/p>\n<p style=\"text-align: justify\">Pour plus d\u2019informations, voici la vid\u00e9o ci-dessous d\u2019o\u00f9 j\u2019ai tir\u00e9 toute la proc\u00e9dure :<\/p>\n<p class=\"asset-video\" style=\"text-align: center\">\n<p style=\"text-align: justify\">&#160;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#160;&#160;&#160;&#160;Dans cet article, j\u2019expliquais comment, \u00e0 partir du logiciel Autodesk Navisworks, cr\u00e9er des variables utilisateurs \u00e0 un \u00e9l\u00e9ment sp\u00e9cifique. Bien que cette m\u00e9thode soit tr\u00e8s simple \u00e0 mettre \u00e0 place, elle est quand m\u00eame tr\u00e8s limit\u00e9e quant \u00e0 la propagation des variables aux autres \u00e9l\u00e9ments. C\u2019est pour cette raison que je vous propose une autre [&hellip;]<\/p>\n","protected":false},"author":4760,"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":[10,6],"tags":[20,44,102,238],"class_list":["post-124","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-collaboration","category-trucs-et-astuces","tag-autodesk","tag-bim","tag-navisworks","tag-sql","dhig-theme--light"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/124","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\/4760"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":0,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/posts\/124\/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=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.autodesk.com\/villagebim\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}