CSV Field Mapping Tasks
On the Field Mapping page of the Import Assistant, complete the following tasks:
-
To add a field to the mappings, highlight a line in the center pane and single-click a field in the right or left pane, or drag a field from the right or left pane to the center pane.
-
To provide a default value, null value, or reference type for a field, click its edit icon, and:
-
Choose Provide Default Value, and select or enter a value. For more information, see Assign Default Values during Field Mapping.
-
Choose the Set Value to Null option. This option is available only for fields that can have null values. You can set fields with no values in CSV files to null instead of enabling the Overwrite Missing Fields advanced option on updates. For more information, see Assign Null Values during Field Mapping.
-
Select a reference type. This option is available only for mapped fields that can have one or more list values, such as dropdown lists and multi-selects. For more information, see Select Reference Types.
After you have made a selection, click Done to close the popup.
-
-
To delete a row in the center mappings pane, click the small X button.
-
If at any point you want to undo changes to field mappings and return to auto mappings or to the most recently saved mappings, click Reset.
-
Available sublists are displayed at the bottom of the NetSuite Fields pane. You can map sublist fields in the same manner that you map other fields. Initially, the Field Mapping page provides one instance node per sublist. You can dynamically add sublist instances by clicking Add New (
). Up to 99 instances are supported per sublist. (Add New is not available for sublists with associated linked files.) For more information, see Required Fields for Sublist Import Mapping.
-
For some transaction imports, transaction item options may be included as a flat list under the Items sublist folder. Item options are custom fields that can be set up in your NetSuite account and may be included in transaction line items to represent item-specific choices. You can map item options to columns in your CSV file, and you can set default or null values for them. For more information, see Importing Transaction Item Options.