Import a manufacturing component CSV file into NetSuite using task.CsvImportTask inside a scheduled script, linking a secondary file for multi-file imports

In-depth guide

Steps

1. Create or locate the saved CSV import mapping in Setup > Import/Export; note its numeric internal ID (mappingId).
2. In a SuiteScript 2.x scheduled script, require N/task and N/file; load the primary CSV from the file cabinet using file.load({id: primaryFileId}).
3. If the import uses linked files (e.g., sublist data in a separate CSV), load each linked file and pass them as a key-value object: {linkedFiles: {'Secondary File': linkedFileObj}}.
4. Create the task: var csvTask = task.create({taskType: task.TaskType.CSV_IMPORT, mappingId: MAPPING_ID, importFile: primaryFile, linkedFiles: linkedFilesObj}); var taskId = csvTask.submit();
5. Poll status by calling task.checkStatus({taskId: taskId}) in a subsequent scheduled run; status values include PENDING, PROCESSING, COMPLETE, and FAILED.
6. Log errors from the returned MappingTaskStatus object; retrieve the error file via the job's output file cabinet location for row-level diagnostics.