{"id":2803,"date":"2017-08-21T14:53:11","date_gmt":"2017-08-21T14:53:11","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/how-do-user-event-scripts-handle-record-values-during-csv-imports-2\/"},"modified":"2026-07-28T18:25:13","modified_gmt":"2026-07-28T18:25:13","slug":"comment-les-scripts-devenements-utilisateur-gerent-ils-les-valeurs-des-enregistrements-lors-des-importations-csv","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-les-scripts-devenements-utilisateur-gerent-ils-les-valeurs-des-enregistrements-lors-des-importations-csv\/","title":{"rendered":"Comment les scripts d’\u00e9v\u00e9nements utilisateur g\u00e8rent-ils les valeurs des enregistrements lors des importations 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 comment les scripts d'\u00e9v\u00e9nements utilisateur NetSuite g\u00e8rent les valeurs des enregistrements lors des importations CSV, en particulier au cours des phases \u00ab Avant soumission \u00bb et \u00ab Apr\u00e8s soumission \u00bb.","ga_short_answer":"Lors d\u2019une importation CSV, la variable context.oldRecord est vide pour les nouveaux champs, tandis que context.newRecord contient la valeur import\u00e9e. Si un champ est modifi\u00e9 dans un script \u00ab Before Submit \u00bb \u00e0 l\u2019aide de la m\u00e9thode context.newRecord.setValue(), cette nouvelle valeur sera r\u00e9percut\u00e9e dans context.newRecord lors de l\u2019ex\u00e9cution du script \u00ab After Submit \u00bb, ce qui risque de remplacer les donn\u00e9es import\u00e9es \u00e0 l\u2019origine.","ga_scenario":"Un utilisateur de NetSuite effectue une importation CSV afin de mettre \u00e0 jour un enregistrement de commande client (SO). L'importation vise \u00e0 remplir un champ personnalis\u00e9 initialement vide avec une nouvelle valeur, par exemple \u00ab abc \u00bb.","ga_solution":"Les scripts d\u2019\u00e9v\u00e9nements utilisateur NetSuite s\u2019ex\u00e9cutent \u00e0 diff\u00e9rentes phases du traitement des enregistrements, principalement \u00ab Avant soumission \u00bb et \u00ab Apr\u00e8s soumission \u00bb. Bien que la phase \u00ab Avant chargement \u00bb soit \u00e9galement disponible, pour comprendre les modifications apport\u00e9es aux valeurs des enregistrements lors des importations CSV, il convient de se concentrer sur les phases de soumission. Prenons le cas d\u2019une importation CSV effectu\u00e9e sur une commande client (SO) afin de mettre \u00e0 jour un champ personnalis\u00e9 actuellement vide. Le fichier CSV import\u00e9 fournit une nouvelle valeur, telle que \u00ab abc \u00bb, pour ce champ. Valeurs de champ inchang\u00e9es lors de la phase \u00ab Avant soumission \u00bb*   Au cours de la phase \u00ab Avant soumission \u00bb :    *   L\u2019objet context.oldRecord correspondant au champ sera vide (par exemple, \u00ab \u00bb).    *   L\u2019objet context.newRecord correspondant au champ contiendra la valeur import\u00e9e (par exemple, \u00ab abc \u00bb).*   Au cours de la phase \u00ab Apr\u00e8s soumission \u00bb :    *   L\u2019objet context.oldRecord correspondant au champ sera toujours vide (par exemple, \u00ab \u00bb).    *   L\u2019objet context.newRecord associ\u00e9 \u00e0 ce champ contiendra la valeur import\u00e9e (par exemple, \u00ab abc \u00bb).Valeurs de champ avec modification lors de la phase \u00ab Before Submit \u00bb : Consid\u00e9rez \u00e0 pr\u00e9sent la m\u00eame importation CSV, mais un script d\u2019\u00e9v\u00e9nement utilisateur est configur\u00e9 pour modifier la valeur du champ lors de la phase \u00ab Before Submit \u00bb (par exemple, pour la mettre \u00e0 jour ou la concat\u00e9ner avec une autre valeur).*   Au cours de la phase \u00ab Before Submit \u00bb :    *   L\u2019objet context.oldRecord associ\u00e9 au champ sera vide (par exemple, '').    *   L\u2019objet context.newRecord associ\u00e9 au champ contiendra la valeur import\u00e9e (par exemple, \u00ab abc \u00bb).    *   Si le script d\u00e9finit ensuite la valeur du champ \u00e0 l\u2019aide de SuiteScript 2.x :\n\nGA_KEEP_0001*\n\n   Au cours de la phase \u00ab After Submit \u00bb :    *   L\u2019objet context.oldRecord correspondant au champ sera toujours vide (par exemple, '').    *   L\u2019objet context.newRecord correspondant au champ refl\u00e9tera d\u00e9sormais la valeur d\u00e9finie dans le script \u00ab Before Submit \u00bb (par exemple, \u00ab CCC \u00bb). Il est essentiel de faire preuve de prudence lorsque vous modifiez les valeurs des champs dans les scripts \u00ab Before Submit \u00bb lors d\u2019importations CSV. De telles modifications peuvent \u00e9craser les donn\u00e9es destin\u00e9es \u00e0 l\u2019importation, ce qui peut entra\u00eener une perte de donn\u00e9es si elles ne sont pas g\u00e9r\u00e9es avec soin.","ga_source_author":"","ga_source_author_email":"","ga_date_original":"2017-08-21T10:53:11-04:00","ga_date_verified":"2026-07-05","ga_source_subject":"Using a csv file. What will be my Before, and After submit field value if I use nlapiGetoldRecord and nlapiGetNewRecord, and what happens if I change the field value in before submit.","ga_ans_id":"ANS-1064","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"spot_check","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The answer uses SuiteScript 1.0 functions (nlapiGetOldRecord, nlapiGetNewRecord, nlapiSetFieldValue), which are considered legacy. Current NetSuite development uses SuiteScript 2.x, where these functionalities are accessed via the script context object (context.newRecord, context.oldRecord) and record methods (record.setValue()).; The syntax 'my_field.nlapiGetOldRecord()' and 'my_field.nlapiGetNewRecord()' is incorrect; in SuiteScript 1.0, these are global functions, not methods of a field object.","ga_final_category":"SuiteScript Development","footnotes":""},"ga_category":[108,23,108],"ga_audience":[10],"ga_difficulty":[92],"class_list":["post-2803","qa_entry","type-qa_entry","status-publish","hentry","ga_category-developpement-suitescript","ga_category-suitescript-development","ga_audience-developer-suitescript","ga_difficulty-niveau-intermediaire"],"taxonomy_info":{"ga_category":[{"value":108,"label":"D\u00e9veloppement SuiteScript"},{"value":23,"label":"SuiteScript Development"},{"value":108,"label":"D\u00e9veloppement SuiteScript"}],"ga_audience":[{"value":10,"label":"Developer\/SuiteScript"}],"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\/2803","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\/2803\/revisions"}],"predecessor-version":[{"id":4723,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/2803\/revisions\/4723"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=2803"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=2803"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=2803"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=2803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}