{"id":2954,"date":"2017-08-21T14:48:38","date_gmt":"2017-08-21T14:48:38","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-importer-plusieurs-valeurs-dans-un-seul-champ-netsuite-via-un-fichier-csv\/"},"modified":"2026-07-28T18:25:21","modified_gmt":"2026-07-28T18:25:21","slug":"comment-importer-plusieurs-valeurs-dans-un-seul-champ-netsuite-via-un-fichier-csv","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-importer-plusieurs-valeurs-dans-un-seul-champ-netsuite-via-un-fichier-csv\/","title":{"rendered":"Comment importer plusieurs valeurs dans un seul champ NetSuite via un fichier 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":"Importez avec succ\u00e8s plusieurs valeurs dans les champs \u00e0 s\u00e9lection multiple de NetSuite via un fichier CSV.","ga_short_answer":"Pour importer plusieurs valeurs dans un champ \u00e0 s\u00e9lection multiple de NetSuite via un fichier CSV, utilisez des identifiants internes ou des valeurs d\u00e9limit\u00e9es par une barre verticale. Chaque valeur doit \u00eatre s\u00e9par\u00e9e par une barre verticale (|). Veillez \u00e0 respecter scrupuleusement le formatage, car les espaces autour des d\u00e9limiteurs peuvent compromettre la r\u00e9ussite de l\u2019importation. Cette m\u00e9thode s\u2019applique aussi bien aux champs \u00e0 s\u00e9lection multiple standard qu\u2019aux champs personnalis\u00e9s.","ga_scenario":"Les utilisateurs rencontrent souvent des difficult\u00e9s lorsqu\u2019ils tentent d\u2019importer des donn\u00e9es dans les champs \u00e0 s\u00e9lection multiple de NetSuite \u00e0 l\u2019aide de fichiers CSV. La principale difficult\u00e9 r\u00e9side dans le formatage correct de la colonne CSV afin de permettre au syst\u00e8me de reconna\u00eetre et d\u2019attribuer plusieurs s\u00e9lections \u00e0 un seul enregistrement, ce qui entra\u00eene des importations incompl\u00e8tes ou infructueuses<\/a>.","ga_solution":"Pour r\u00e9ussir l\u2019importation de plusieurs valeurs dans un champ \u00e0 s\u00e9lection multiple de NetSuite via un fichier CSV, il est essentiel d\u2019utiliser des identifiants internes ou des valeurs d\u00e9limit\u00e9s par des barres verticales. Cette m\u00e9thode garantit que NetSuite analyse correctement les donn\u00e9es et attribue toutes les s\u00e9lections sp\u00e9cifi\u00e9es \u00e0 l\u2019enregistrement cible.\n\nConsid\u00e9rez les exemples suivants pour le champ \u00e0 s\u00e9lection multiple d\u2019un enregistrement de contact :\n\n1. **Utilisation d\u2019identifiants internes d\u00e9limit\u00e9s par des barres verticales (sans espaces) :**\n Lors de l\u2019importation d\u2019identifiants internes, veillez \u00e0 ce qu\u2019aucun espace ne figure entre l\u2019identifiant et le d\u00e9limiteur \u00ab | \u00bb.\n\n```\ninternal id,Category (mutli-select standard field)\n 10150,3|53\n```\n\n2. **Utilisation de valeurs d\u00e9limit\u00e9es par des barres verticales (sans espaces) :**\n Lors de l\u2019importation de valeurs r\u00e9elles, veillez \u00e0 ce qu\u2019aucun espace ne figure entre la valeur et le d\u00e9limiteur \u00ab | \u00bb.\n\n```\ninternal id,Categories\n 10150,BOR|CGA\n```\n\nBien que la documentation officielle de NetSuite sugg\u00e8re d\u2019inclure un espace entre chaque valeur et son d\u00e9limiteur pour les champs \u00e0 s\u00e9lection multiple lors des importations CSV, la r\u00e9ussite des importations d\u00e9pend souvent d\u2019un formatage pr\u00e9cis afin d\u2019\u00e9viter les probl\u00e8mes caus\u00e9s par des espaces suppl\u00e9mentaires involontaires. Il est g\u00e9n\u00e9ralement recommand\u00e9 de tester les deux formats en cas de probl\u00e8me, en privil\u00e9giant l\u2019approche \u00ab sans espace \u00bb pour des raisons de coh\u00e9rence, sauf si des configurations de champs sp\u00e9cifiques l\u2019exigent autrement.","ga_source_author":"Phoebe Zhang","ga_source_author_email":"","ga_date_original":"2017-08-21T10:48:38-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"CSV Data import, how is it possible to import multiple values in a single field?","ga_ans_id":"ANS-1215","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The original answer states that the official help's advice to 'leave spaces between the delimiter and the values' is 'obviously NOT valid in all cases.' However, current NetSuite documentation explicitly states, 'In your CSV files' multi-select fields, leave a space between each value and each delimiter.' This contradicts the original answer's definitive dismissal of spaced syntax, although other current sources warn against 'Extra Spaces' causing import failure.","ga_final_category":"CSV Import & Data Migration","footnotes":""},"ga_category":[20,96,96],"ga_audience":[89],"ga_difficulty":[92],"class_list":["post-2954","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\/2954","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\/2954\/revisions"}],"predecessor-version":[{"id":4874,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2954\/revisions\/4874"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2954"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2954"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2954"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}