{"id":2734,"date":"2023-08-22T18:14:19","date_gmt":"2023-08-22T18:14:19","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/pourquoi-lidentifiant-externe-nest-il-pas-disponible-pour-le-mappage-lors-de-limportation-csv-dans-netsuite\/"},"modified":"2026-07-28T18:25:10","modified_gmt":"2026-07-28T18:25:10","slug":"pourquoi-lidentifiant-externe-nest-il-pas-disponible-pour-le-mappage-lors-de-limportation-csv-dans-netsuite","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/pourquoi-lidentifiant-externe-nest-il-pas-disponible-pour-le-mappage-lors-de-limportation-csv-dans-netsuite\/","title":{"rendered":"Pourquoi l&rsquo;identifiant externe n&rsquo;est-il pas disponible pour le mappage lors de l&rsquo;importation CSV dans NetSuite ?"},"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":"La pr\u00e9sence de caract\u00e8res sp\u00e9ciaux dans les en-t\u00eates des fichiers CSV peut emp\u00eacher NetSuite de reconna\u00eetre les identifiants externes et autres types de r\u00e9f\u00e9rence pour le mappage des champs.","ga_short_answer":"L'impossibilit\u00e9 de mapper un identifiant externe ou d'autres types de r\u00e9f\u00e9rence lors d'une importation CSV dans NetSuite est g\u00e9n\u00e9ralement due \u00e0 la pr\u00e9sence de caract\u00e8res sp\u00e9ciaux dans les en-t\u00eates de votre fichier CSV. Pour r\u00e9soudre ce probl\u00e8me, v\u00e9rifiez si votre fichier CSV contient des en-t\u00eates comportant des caract\u00e8res tels que \u00ab # \u00bb ou \u00ab & \u00bb, puis modifiez-les en supprimant ces caract\u00e8res sp\u00e9ciaux. Par exemple, remplacez \u00ab SG&A \u00bb par \u00ab SGA \u00bb afin de garantir une reconnaissance correcte des champs.","ga_scenario":"Lors <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-effectively-use-external-ids-for-netsuite-csv-imports\/\">d\u2019une importation CSV dans NetSuite<\/a>, les utilisateurs peuvent \u00eatre confront\u00e9s \u00e0 une situation o\u00f9 certains champs ne peuvent pas \u00eatre mapp\u00e9s. Ce probl\u00e8me peut se traduire par l\u2019absence de types de r\u00e9f\u00e9rence attendus, tels que \u00ab Noms \u00bb, \u00ab ID interne \u00bb ou \u00ab ID externe \u00bb, au cours du processus de mappage. Par cons\u00e9quent, l\u2019importation ne peut pas se d\u00e9rouler comme pr\u00e9vu, ce qui emp\u00eache les donn\u00e9es d\u2019\u00eatre correctement associ\u00e9es aux enregistrements NetSuite.","ga_solution":"La cause principale de cette limitation de mappage r\u00e9side dans la pr\u00e9sence de caract\u00e8res sp\u00e9ciaux dans les en-t\u00eates de colonnes du fichier d\u2019importation CSV. Pour r\u00e9soudre ce probl\u00e8me, proc\u00e9dez comme suit :\n1. Examinez le fichier d\u2019importation CSV afin d\u2019identifier les en-t\u00eates de colonnes contenant les caract\u00e8res sp\u00e9ciaux suivants : # &\n2. Modifiez les valeurs des en-t\u00eates identifi\u00e9es en supprimant ces caract\u00e8res sp\u00e9ciaux. Par exemple, si un en-t\u00eate est nomm\u00e9 `SG&A`, il doit \u00eatre modifi\u00e9 en `SGA`.","ga_source_author":"Joseph Ofoluwa","ga_source_author_email":"","ga_date_original":"2023-08-22T11:14:19-07:00","ga_date_verified":"","ga_source_subject":"External ID Option is not Available During CSV Import mapping - Resolution Process","ga_ans_id":"ANS-0995","ga_publish_decision":"publish","ga_staleness_risk":"low","ga_review_priority":"trust_default","ga_tier2_verdict":"","ga_tier2_concerns":"","ga_final_category":"CSV Import & Data Migration","footnotes":""},"ga_category":[20,96,96],"ga_audience":[89],"ga_difficulty":[93],"class_list":["post-2734","qa_entry","type-qa_entry","status-publish","hentry","ga_category-csv-import-data-migration","ga_category-import-csv-et-migration-de-donnees","ga_audience-administrateur-netsuite","ga_difficulty-debutant"],"taxonomy_info":{"ga_category":[{"value":20,"label":"CSV Import & Data Migration"},{"value":96,"label":"Import CSV et migration de donn\u00e9es"},{"value":96,"label":"Import CSV et migration de donn\u00e9es"}],"ga_audience":[{"value":89,"label":"Administrateur NetSuite"}],"ga_difficulty":[{"value":93,"label":"D\u00e9butant"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2734","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\/2734\/revisions"}],"predecessor-version":[{"id":4654,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2734\/revisions\/4654"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2734"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2734"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2734"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}