{"id":1285,"date":"2020-12-04T12:44:08","date_gmt":"2020-12-04T17:44:08","guid":{"rendered":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/?p=1285"},"modified":"2021-02-24T09:00:34","modified_gmt":"2021-02-24T14:00:34","slug":"comment-exporter-des-donnees-de-filemaker","status":"publish","type":"post","link":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/comment-exporter-des-donnees-de-filemaker\/","title":{"rendered":"Comment exporter des donn\u00e9es de FileMaker (04-12-2020)"},"content":{"rendered":"\n<p><em><strong>NB&nbsp;:&nbsp;&nbsp;L\u2019acc\u00e8s pour exporter est limit\u00e9 aux gestionnaires.&nbsp;&nbsp;Si vous ne voyez pas les options mentionn\u00e9es dans ce document, vous n\u2019avez pas cet acc\u00e8s.<\/strong><\/em><\/p>\n\n\n\n<p>1. Aller sur l\u2019\u00e9cran FileMaker qui contient toute l\u2019information que vous voulez exporter et faites une recherche des entr\u00e9es que vous voulez exporter.&nbsp;&nbsp;Uniquement l\u2019information visible sur l\u2019\u00e9cran sera disponible pour votre exportation.<\/p>\n\n\n\n<p>2. Cliquer sur la fl\u00e8che en haut et a gauche de l\u2019\u00e9cran pour acc\u00e9der au menu et choisir l\u2019option Exporter des enregistrements\u2026<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.14-PM.png\" alt=\"\" class=\"wp-image-1286\" width=\"270\" height=\"286\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.14-PM.png 638w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.14-PM-284x300.png 284w\" sizes=\"auto, (max-width: 270px) 100vw, 270px\" \/><\/figure>\n\n\n\n<p>3. Dans la fen\u00eatre qui s\u2019ouvre, mettre le nom du fichier dans la boite \u00ab\u00a0Enregistrer sous\u00a0\u00bb et choisir le \u00ab\u00a0Type\u00a0\u00bb \u00ab\u00a0Texte s\u00e9par\u00e9 par des virgules\u00a0\u00bb et cliquer sur OK.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.21-PM-768x410-1-700x374.png\" alt=\"\" class=\"wp-image-1287\" width=\"407\" height=\"217\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.21-PM-768x410-1-700x374.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.21-PM-768x410-1-300x160.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.21-PM-768x410-1.png 768w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/figure>\n\n\n\n<p>4. Dans la fen\u00eatre qui s\u2019ouvre, s\u00e9lectionner l\u2019information dont vous avez besoin.\u00a0\u00a0Si vous les voulez tous, vous pouvez utiliser le bouton \u00ab\u00a0Tout ajouter\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.32-PM-768x711-1-700x648.png\" alt=\"\" class=\"wp-image-1288\" width=\"401\" height=\"370\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.32-PM-768x711-1-700x648.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.32-PM-768x711-1-300x278.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.32-PM-768x711-1.png 768w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/figure>\n\n\n\n<p>5. Cliquer sur le bouton \u00ab\u00a0Exporter\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.43-PM-768x710-1-700x647.png\" alt=\"\" class=\"wp-image-1289\" width=\"396\" height=\"366\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.43-PM-768x710-1-700x647.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.43-PM-768x710-1-300x277.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.43-PM-768x710-1.png 768w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/figure>\n\n\n\n<p>6. Selon le fureteur que vous utilisez, le fichier sera t\u00e9l\u00e9charg\u00e9 automatiquement ou vous aurez une fen\u00eatre qui s\u2019ouvre o\u00f9 vous devrez cliquer sur le fichier pour le t\u00e9l\u00e9charger.<\/p>\n\n\n\n<p>7. Maintenant il faut transformer le fichier .CSV vers un fichier Excel.&nbsp;&nbsp;Pour le faire, ouvrir un nouveau tableau Excel et choisir l\u2019option Importer.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.54-PM-700x500-1.png\" alt=\"\" class=\"wp-image-1290\" width=\"382\" height=\"273\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.54-PM-700x500-1.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.39.54-PM-700x500-1-300x214.png 300w\" sizes=\"auto, (max-width: 382px) 100vw, 382px\" \/><\/figure>\n\n\n\n<p>8. Dans la fen\u00eatre qui s\u2019ouvre, choisir l\u2019option Fichier CSV et cliquer sur \u00ab\u00a0Importer\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.02-PM-800x461-1-700x403.png\" alt=\"\" class=\"wp-image-1291\" width=\"443\" height=\"255\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.02-PM-800x461-1-700x403.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.02-PM-800x461-1-300x173.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.02-PM-800x461-1-768x443.png 768w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.02-PM-800x461-1.png 800w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/figure>\n\n\n\n<p>9. Dans la fen\u00eatre qui s\u2019ouvre, trouver le fichier CSV que vous avez cr\u00e9\u00e9 dans les \u00e9tapes 1-6 et cliquer sur \u00ab\u00a0Obtenir les donn\u00e9es\u00a0\u00bb<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1-700x283.png\" alt=\"\" class=\"wp-image-1292\" width=\"417\" height=\"168\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1-700x283.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1-300x121.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1-570x228.png 570w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1-380x152.png 380w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1-285x114.png 285w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.09-PM-768x310-1.png 768w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/figure>\n\n\n\n<p>10. Dans la fen\u00eatre qui s\u2019ouvre, choisir l\u2019option \u00ab\u00a0D\u00e9limit\u00e9\u00a0\u00bb et assigner l\u2019 \u00ab\u00a0Origine du fichier\u00a0\u00bb comme \u00ab\u00a0Unicode (UTF-8).\u00a0\u00a0Si vous n\u2019assignez pas UTF-8, les accents ne seront pas pris en compte correctement et vous risquez de ne pas pouvoir lire les entr\u00e9es correctement.\u00a0\u00a0Cliquer \u00ab\u00a0Suivant\u00a0\u00bb pour continuer.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"382\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.19-PM-1-700x382.png\" alt=\"\" class=\"wp-image-1295\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.19-PM-1-700x382.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.19-PM-1-300x164.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.19-PM-1-768x419.png 768w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.19-PM-1.png 1322w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p>11. Dans la fen\u00eatre qui s\u2019ouvre, choisir l\u2019option \u00ab\u00a0Virgule\u00a0\u00bb et cliquer \u00ab\u00a0Suivant\u00a0\u00bb pour continuer.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"373\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.26-PM-700x373.png\" alt=\"\" class=\"wp-image-1294\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.26-PM-700x373.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.26-PM-300x160.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.26-PM-768x409.png 768w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.26-PM.png 1326w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p>12. Dans la fen\u00eatre qui s\u2019ouvre, vous n\u2019avez rien \u00e0 changer.\u00a0\u00a0Simplement cliquer sur \u00ab\u00a0Fin\u00a0\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"387\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.33-PM-700x387.png\" alt=\"\" class=\"wp-image-1296\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.33-PM-700x387.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.33-PM-300x166.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.33-PM-768x425.png 768w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.33-PM.png 1330w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p>13. Dans la fen\u00eatre qui s\u2019ouvre, vous pouvez mettre la cellule du fichier o\u00f9 vous d\u00e9sirez commencer d\u2019ins\u00e9rer des entr\u00e9es.\u00a0\u00a0Dans l\u2019exemple ici, il commence sur A2 (1ere colonne sur le 2<sup>e<\/sup>\u00a0ligne) pour permettre l\u2019ajout des en t\u00eates au besoin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"298\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.40-PM-800x340-1-700x298.png\" alt=\"\" class=\"wp-image-1297\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.40-PM-800x340-1-700x298.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.40-PM-800x340-1-300x128.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.40-PM-800x340-1-768x326.png 768w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-12.40.40-PM-800x340-1.png 800w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p>14. Les donn\u00e9es seront maintenant dans votre fichier Excel.\u00a0\u00a0Vous devrez le sauvegarder et vous pouvez commencer de manipuler des donn\u00e9es selon vos besoins.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"285\" src=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-2.38.33-PM-700x285.png\" alt=\"\" class=\"wp-image-1298\" srcset=\"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-2.38.33-PM-700x285.png 700w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-2.38.33-PM-300x122.png 300w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-2.38.33-PM-768x312.png 768w, https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-content\/uploads\/sites\/6\/2020\/12\/Screen-Shot-2020-03-26-at-2.38.33-PM.png 1392w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<p class=\"has-text-align-right\">(<em>derni\u00e8re maj 26 mars 2020<\/em>)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>NB&nbsp;:&nbsp;&nbsp;L\u2019acc\u00e8s pour exporter est limit\u00e9 aux gestionnaires.&nbsp;&nbsp;Si vous ne voyez pas les options mentionn\u00e9es dans ce document, vous n\u2019avez pas cet acc\u00e8s. 1. Aller sur l\u2019\u00e9cran FileMaker qui contient toute l\u2019information que vous voulez exporter et faites une recherche des entr\u00e9es que vous voulez exporter.&nbsp;&nbsp;Uniquement l\u2019information visible sur l\u2019\u00e9cran sera disponible pour votre exportation. 2. [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[120,90],"tags":[],"class_list":["post-1285","post","type-post","status-publish","format-standard","hentry","category-direction","category-index"],"_links":{"self":[{"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/posts\/1285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/comments?post=1285"}],"version-history":[{"count":3,"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/posts\/1285\/revisions"}],"predecessor-version":[{"id":3225,"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/posts\/1285\/revisions\/3225"}],"wp:attachment":[{"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/media?parent=1285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/categories?post=1285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chuv.umontreal.ca\/intranet\/ti\/wp-json\/wp\/v2\/tags?post=1285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}