ANS-1232 · CSV IMPORT & DATA MIGRATION
Why is the Mapping Screen Missing in NetSuite CSV Import Assistant?
Hidden carriage returns or line feeds in CSV header fields can prevent the NetSuite CSV Import Assistant from displaying the mapping screen.
Short answer
The NetSuite CSV Import Assistant's mapping screen may not appear due to hidden carriage returns or line feeds in the CSV file's header fields. These invisible characters prevent NetSuite from correctly parsing the file. Inspect the CSV using a text editor like Notepad++ to identify and remove any extraneous characters, such as unexpected double quotes or line breaks within headers.
Scenario
Users attempting to import data via the NetSuite CSV Import Assistant may encounter an issue where the mapping screen, which allows users to match CSV columns to NetSuite fields, fails to appear. This prevents the import process from proceeding, as the system cannot interpret the CSV file's structure.
Solution
The absence of the mapping screen in the NetSuite CSV Import Assistant is typically caused by hidden carriage returns or line feeds embedded within the header fields of the CSV file. These invisible characters interfere with NetSuite's ability to correctly parse the file's structure.
Open the problematic CSV file using a plain text editor such as Notepad++.
Carefully inspect the header row for any unexpected characters, such as double quotes that might indicate a hidden line feed or carriage return within a field.
Remove any identified hidden carriage returns or line feeds from the header fields.
Save the corrected CSV file and attempt the import again.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support