{"id":3117,"date":"2017-08-21T15:01:33","date_gmt":"2017-08-21T15:01:33","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-resoudre-les-erreurs-cle-de-reference-doption-de-matrice-non-valide-lors-de-limportation-csv\/"},"modified":"2026-07-28T18:25:30","modified_gmt":"2026-07-28T18:25:30","slug":"comment-resoudre-les-erreurs-cle-de-reference-doption-de-matrice-non-valide-lors-de-limportation-csv","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-resoudre-les-erreurs-cle-de-reference-doption-de-matrice-non-valide-lors-de-limportation-csv\/","title":{"rendered":"Comment r\u00e9soudre les erreurs \u00ab Cl\u00e9 de r\u00e9f\u00e9rence d&rsquo;option de matrice non valide \u00bb lors de l&rsquo;importation CSV"},"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":"D\u00e9couvrez une solution simple pour \u00e9viter les \u00e9checs courants d'importation CSV des articles matriciels NetSuite caus\u00e9s par des caract\u00e8res sp\u00e9ciaux.","ga_short_answer":"Lors de l'importation d'options d'articles matriciels via un fichier CSV, les valeurs contenant des guillemets doubles (\") peuvent d\u00e9clencher des erreurs du type \u00ab Cl\u00e9 de r\u00e9f\u00e9rence d'option matricielle non valide \u00bb. Une solution fiable consiste \u00e0 remplacer le caract\u00e8re \u00ab \" \u00bb par une cha\u00eene de caract\u00e8res alternative, telle que \u00ab in \u00bb, avant de proc\u00e9der \u00e0 l'importation.","ga_scenario":"Les utilisateurs qui tentent d\u2019<a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-import-item-matrix-pricing-with-quantity-and-multiple-price-levels-in-netsuite\/\">importer des options d\u2019articles matriciels via un fichier CSV<\/a> peuvent rencontrer des erreurs indiquant une \u00ab cl\u00e9 de r\u00e9f\u00e9rence matrixoptioncustitemX non valide \u00bb. Ce probl\u00e8me survient g\u00e9n\u00e9ralement lorsque les valeurs des options contiennent des caract\u00e8res sp\u00e9cifiques, tels que des guillemets doubles (\"), qui peuvent perturber <a class=\"ga-interlink\" href=\"https:\/\/answers.gurussolutions.com\/fr\/answers\/how-to-ensure-accurate-item-references-in-netsuite-csv-imports\/\">le processus d\u2019analyse du fichier CSV par<\/a> NetSuite. Par exemple, une option telle que \u00ab 1\/8\" \u00bb peut entra\u00eener l'affichage d'un message d'erreur.","ga_solution":"Les importations CSV dans NetSuite peuvent rencontrer des erreurs lors du traitement de valeurs contenant des guillemets doubles (\") au sein des options d\u2019un \u00e9l\u00e9ment de matrice si ces caract\u00e8res ne sont pas correctement format\u00e9s ou \u00e9chapp\u00e9s. Par exemple, une valeur telle que `1\/8\"` pourrait entra\u00eener l\u2019erreur suivante :n\n\n```\n\n\nInvalid matrixoptioncustitem6 reference key 1\/8\u201dn\n```\n\n\n\nPour r\u00e9soudre ce probl\u00e8me, il est recommand\u00e9 de remplacer le caract\u00e8re \u00ab \u00bb par une cha\u00eene alternative, telle que `in`, dans les donn\u00e9es CSV avant l\u2019importation.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T11:01:33-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Matrix item csv import errors","ga_ans_id":"ANS-1378","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The claim that NetSuite 'doesn't like values containing double quotes' is an oversimplification; current CSV import guidelines suggest that double quotes can be handled if properly escaped (doubled within a quoted field).","ga_final_category":"CSV Import & Data Migration","footnotes":""},"ga_category":[20,96,96],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-3117","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-niveau-intermediaire"],"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":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\/3117","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\/3117\/revisions"}],"predecessor-version":[{"id":5037,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3117\/revisions\/5037"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3117"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3117"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3117"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3117"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}