{"id":18458,"date":"2024-03-22T09:32:05","date_gmt":"2024-03-22T08:32:05","guid":{"rendered":"https:\/\/rebub.u-bordeaux.fr\/?page_id=18458"},"modified":"2025-02-24T11:12:01","modified_gmt":"2025-02-24T10:12:01","slug":"exporter-les-resultats-dune-requete-dans-excel","status":"publish","type":"page","link":"https:\/\/rebub.u-bordeaux.fr\/index.php\/alma\/procedures\/generalites\/la-recherche\/exporter-les-resultats-dune-requete-dans-excel\/","title":{"rendered":"Exporter les r\u00e9sultats d\u2019une requ\u00eate dans Excel"},"content":{"rendered":"<div id='wpig-floatingbar' class='wpig-floatingbar'><div id='wpig-switch-wrapper' class='wpig-switch-wrapper'><span id='wpig-floating-switch' class='wpig-floating-switch'><img src='https:\/\/rebub.u-bordeaux.fr\/wp-content\/plugins\/sticky-toc-advance-table-of-contents\/\\assets\\menu.png'><\/span><\/div><\/div><p><\/p>\n<p>Pour exporter les r\u00e9sultats d\u2019une requ\u00eate dans Alma vers un fichier Excel, vous avez deux formes d&rsquo;exports disponibles : <\/p>\n\n\n\n<ul>\n<li>Un export complet de tous les champs disponibles (Tous champs)<\/li>\n\n\n\n<li>Un export de donn\u00e9es que vous aurez s\u00e9lectionn\u00e9 avant (Vue actuelle)<\/li>\n<\/ul>\n\n\n\n<p>Pour param\u00e9trer les donn\u00e9es \u00e0 exporter :<\/p>\n\n\n\n<p>Cliquer sur<img decoding=\"async\" loading=\"lazy\" width=\"44\" height=\"27\" class=\"alignnone wp-image-8548 size-full\" src=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Roue.png\" alt=\"\"><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"546\" src=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-roue-1024x546.png\" alt=\"\" class=\"wp-image-23364\" srcset=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-roue-1024x546.png 1024w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-roue-300x160.png 300w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-roue-768x410.png 768w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-roue.png 1429w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>La liste exhaustive des colonnes qu\u2019il est possible d\u2019obtenir dans le fichier excel appara\u00eet. Pour visualiser l\u2019ensemble des champs cliquer sur \u00ab&nbsp;Afficher tout&nbsp;\u00bb.<\/p>\n\n\n\n<p>S\u00e9lectionner ou d\u00e9s\u00e9lectionner les cases en fonction des informations qui devront figurer dans le fichier Excel (cliquer sur les cases)<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Personnaliser_Vue.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" width=\"1153\" height=\"398\" src=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Personnaliser_Vue.png\" alt=\"\" class=\"wp-image-8551\" srcset=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Personnaliser_Vue.png 1153w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Personnaliser_Vue-300x104.png 300w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Personnaliser_Vue-1024x353.png 1024w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Personnaliser_Vue-768x265.png 768w\" sizes=\"(max-width: 1153px) 100vw, 1153px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Persobnnaliser_Vue_2.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" width=\"1145\" height=\"701\" src=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Persobnnaliser_Vue_2.png\" alt=\"\" class=\"wp-image-8552\" srcset=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Persobnnaliser_Vue_2.png 1145w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Persobnnaliser_Vue_2-300x184.png 300w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Persobnnaliser_Vue_2-1024x627.png 1024w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Persobnnaliser_Vue_2-768x470.png 768w\" sizes=\"(max-width: 1145px) 100vw, 1145px\" \/><\/a><\/figure>\n\n\n\n<p>Puis enregistrer.<\/p>\n\n\n\n<div class=\"is-layout-constrained wp-block-group bord-bloc-reutilisable\"><div class=\"wp-block-group__inner-container\">\n<div class=\"is-layout-flex wp-container-3 wp-block-columns alignfull are-vertically-aligned-top bord-bloc-reutilisable has-background\" style=\"background-color:#ff303047\">\n<div class=\"is-layout-flow wp-block-column is-vertically-aligned-top\" style=\"flex-basis:7%\">\n<figure class=\"wp-block-image alignfull size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"512\" height=\"512\" src=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2024\/04\/point-dexclamation.png\" alt=\"\" class=\"wp-image-19898\" srcset=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2024\/04\/point-dexclamation.png 512w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2024\/04\/point-dexclamation-300x300.png 300w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2024\/04\/point-dexclamation-150x150.png 150w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/figure>\n<\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column is-vertically-aligned-top\" style=\"flex-basis:85%\">\n<p><strong>Attention !<\/strong> Ce param\u00e9trage restera enregistr\u00e9 et sera valide pour les prochaines extractions.<\/p>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n<p>Pour exporter vers un fichier Excel : cliquer sur <img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-8553\" src=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Exporter_3.png\" alt=\"\" width=\"44\" height=\"25\">.<\/p>\n\n\n\n<p>Puis cliquer sur :<\/p>\n\n\n\n<ul>\n<li>Excel (Vue actuelle) pour exporter les donn\u00e9es s\u00e9lectionn\u00e9es pr\u00e9c\u00e9demment,<\/li>\n\n\n\n<li>Excel (tous champs) qui propose une extraction ne tenant pas compte des param\u00e8tres s\u00e9lectionn\u00e9s.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Exporter_4.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" loading=\"lazy\" width=\"218\" height=\"116\" src=\"http:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2020\/03\/Exporter_4.png\" alt=\"\" class=\"wp-image-8554\"\/><\/a><\/figure><\/div>\n\n\n<p>Le fichier se t\u00e9l\u00e9charge, vous pouvez le retrouver dans votre navigateur.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"239\" src=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-fichier-1024x239.png\" alt=\"\" class=\"wp-image-23365\" srcset=\"https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-fichier-1024x239.png 1024w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-fichier-300x70.png 300w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-fichier-768x179.png 768w, https:\/\/rebub.u-bordeaux.fr\/wp-content\/uploads\/2025\/02\/export-fichier.png 1505w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Ouvrir le fichier ou enregistrer.<\/p>\n\n\n\n<div class=\"is-layout-flex wp-container-10 wp-block-columns bord-bloc-reutilisable has-background\" style=\"background-color:#d9edf7\">\n<div class=\"is-layout-flow wp-block-column is-vertically-aligned-center\" style=\"font-size:15px;flex-basis:20%\">\n<p style=\"font-size:15px\"><strong>Date de publication<\/strong> <\/p>\n\n\n<div style=\"font-size:15px;\" class=\"wp-block-post-date\"><time datetime=\"2024-03-22T09:32:05+01:00\">22 mars 2024<\/time><\/div><\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column is-vertically-aligned-center\" style=\"font-size:15px;flex-basis:20%\">\n<p><strong>Mis \u00e0 jour le <\/strong><\/p>\n\n\n<div style=\"font-size:15px;\" class=\"wp-block-post-date\"><time datetime=\"2025-02-24T11:12:01+01:00\">24 f\u00e9vrier 2025<\/time><\/div><\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column is-vertically-aligned-center\" style=\"font-size:15px;flex-basis:40%\">\n<p><\/p>\n\n\n\n<p><strong>Attention ! <\/strong>Certains \u00e9tablissements utilisent parfois de proc\u00e9dures compl\u00e9mentaires <\/p>\n<\/div>\n\n\n\n<div class=\"is-layout-flow wp-block-column is-vertically-aligned-center\" style=\"font-size:15px;flex-basis:25%\">\n<div class=\"is-horizontal is-content-justification-center is-layout-flex wp-container-8 wp-block-buttons alignfull has-custom-font-size\" style=\"font-size:16px\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-75 has-custom-font-size is-style-fill\" style=\"font-size:15px\"><a class=\"wp-block-button__link has-white-color has-text-color has-background wp-element-button\" href=\"mailto:scoop@u-bordeaux.fr\" style=\"border-radius:65px;background-color:#000000db\"><strong>Signaler une erreur<\/strong><\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Pour exporter les r\u00e9sultats d\u2019une requ\u00eate dans Alma vers un fichier Excel, vous avez deux formes d&rsquo;exports disponibles : Pour param\u00e9trer les donn\u00e9es \u00e0 exporter : Cliquer sur La liste exhaustive des colonnes qu\u2019il est possible d\u2019obtenir dans le fichier&#8230;<\/p>\n","protected":false},"author":46,"featured_media":4793,"parent":18443,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/18458"}],"collection":[{"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/users\/46"}],"replies":[{"embeddable":true,"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/comments?post=18458"}],"version-history":[{"count":5,"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/18458\/revisions"}],"predecessor-version":[{"id":23366,"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/18458\/revisions\/23366"}],"up":[{"embeddable":true,"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/pages\/18443"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/media\/4793"}],"wp:attachment":[{"href":"https:\/\/rebub.u-bordeaux.fr\/index.php\/wp-json\/wp\/v2\/media?parent=18458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}