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 and return to auto or last saved mappings, click Reset.
-
You’ll see available sublists at the bottom of the NetSuite Fields pane. Map sublist fields just like any other fields. At first, you get one instance per sublist, but you can add more by clicking Add New (
). Up to 99 instances are supported per sublist. Add New isn’t available for sublists with 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.