{"id":2491,"date":"2017-11-03T13:22:12","date_gmt":"2017-11-03T13:22:12","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-exporter-des-images-a-partir-des-recherches-enregistrees-dans-netsuite-a-des-fins-de-reporting\/"},"modified":"2026-07-28T18:26:01","modified_gmt":"2026-07-28T18:26:01","slug":"comment-exporter-des-images-a-partir-des-recherches-enregistrees-dans-netsuite-a-des-fins-de-reporting","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-exporter-des-images-a-partir-des-recherches-enregistrees-dans-netsuite-a-des-fins-de-reporting\/","title":{"rendered":"Comment exporter des images \u00e0 partir des recherches enregistr\u00e9es dans NetSuite \u00e0 des fins de reporting ?"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Affichez dans vos rapports les images issues des recherches enregistr\u00e9es dans NetSuite gr\u00e2ce \u00e0 une int\u00e9gration simple avec Google Sheets.","ga_short_answer":"Pour exporter et afficher des images \u00e0 partir de recherches enregistr\u00e9es dans NetSuite, ajoutez une colonne de formule \u00e0 votre recherche afin de g\u00e9n\u00e9rer des URL d'images. Exportez les r\u00e9sultats de la recherche au format CSV, puis ouvrez le fichier dans Google Sheets. La fonction IMAGE de Google Sheets affichera les images directement \u00e0 partir des URL fournies.","ga_scenario":"Les utilisateurs ont souvent besoin d\u2019inclure des images issues des enregistrements NetSuite dans leurs rapports de recherche enregistr\u00e9s. Les options d\u2019exportation standard de NetSuite ne permettent pas d\u2019afficher directement les images, ce qui pose un probl\u00e8me pour les besoins en mati\u00e8re de rapports visuels. Ce guide pr\u00e9sente une m\u00e9thode permettant d\u2019afficher efficacement ces images \u00e0 l\u2019aide d\u2019outils externes.","ga_solution":"Il existe deux approches principales pour exporter des images dans une recherche enregistr\u00e9e NetSuite \u00e0 des fins de reporting : 1. Utiliser SuiteScript 2.0 avec un mod\u00e8le FreeMarker pour g\u00e9n\u00e9rer le rapport. 2. Utiliser Google Sheets pour l'affichage des images.La solution recommand\u00e9e consiste \u00e0 utiliser Google Sheets. Pour afficher les images, on utilise la fonction `=IMAGE(\"<URL>\")` de Google Sheets. Suivez ces \u00e9tapes pour mettre en \u0153uvre cette solution : 1. Ajoutez une colonne \u00e0 la recherche enregistr\u00e9e NetSuite avec la formule suivante : `'=IMAGE(\"https:\/\/system.sandbox.netsuite.com' || <Custom field > || '\";1)'`2. Exportez les r\u00e9sultats de la recherche enregistr\u00e9e au format CSV (et non XLS). 3. Ouvrez le fichier CSV export\u00e9 dans Google Sheets. La fonction `IMAGE` affichera alors les images en fonction des URL fournies dans la formule.","ga_source_author":"Jean-Manuel Fiset","ga_source_author_email":"","ga_date_original":"2017-11-03T06:22:12-07:00","ga_date_verified":"2026-07-05","ga_source_subject":"How to export images within a saved search for reporting purposes?","ga_ans_id":"ANS-0015","ga_publish_decision":"publish","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"still_accurate","ga_tier2_concerns":"","ga_final_category":"Saved Searches & Formulas","footnotes":""},"ga_category":[91,3,91],"ga_audience":[89,89],"ga_difficulty":[92,92],"class_list":["post-2491","qa_entry","type-qa_entry","status-publish","hentry","ga_category-recherches-enregistrees-et-formules","ga_category-saved-searches-formulas","ga_audience-administrateur-netsuite","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":91,"label":"Recherches enregistr\u00e9es et formules"},{"value":3,"label":"Saved Searches & Formulas"},{"value":91,"label":"Recherches enregistr\u00e9es et formules"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"},{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":92,"label":"Niveau interm\u00e9diaire"},{"value":92,"label":"Niveau interm\u00e9diaire"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2491\/revisions"}],"predecessor-version":[{"id":2511,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2491\/revisions\/2511"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2491"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2491"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2491"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}