ANS-1281 · CSV IMPORT & DATA MIGRATION
How to Resolve CSV Import Encoding Issues for Mac Users in NetSuite?
Mac users encountering garbled characters during NetSuite CSV imports can resolve encoding discrepancies by adjusting a specific import setting.
Short answer
To fix CSV import encoding problems on a Mac in NetSuite, users must select "Western (Mac Roman)" under the Character Encoding option in the CSV Import assistant. This specific encoding setting ensures that data from Mac-generated CSV files is correctly interpreted by NetSuite, preventing garbled text and data corruption during the import process.
Scenario
Users attempting to import CSV files into NetSuite from an Apple computer may encounter issues where characters appear garbled or incorrect after the import. This typically indicates a mismatch between the character encoding used by the Mac-generated CSV file and the encoding expected by NetSuite's CSV Import assistant.
Solution
To resolve character encoding issues when importing CSV files generated on a Mac into NetSuite, users should follow these steps:
Navigate to the CSV Import assistant in NetSuite.
Locate the 'Character Encoding' setting within the import assistant.
From the available options, select "Western (Mac Roman)".This selection ensures that the CSV file's characters are correctly interpreted, thereby resolving any encoding discrepancies.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support