Create CSV imports

This sample includes two scripts used to creates CSV imports. These samples can be used as a custom module or as individual function within a user event or other server script, so no JSDoc or define statement or return statement or entry point function is needed. But you will need to load the N/task and N/file modules for the function to work.

The conversion of this script from SuiteScript 1.0 to SuiteScript 2.0 includes the following:

The nlapiLoadFile function is changed to the file.load method.
The nlapiCreateCSVImport function is changed to the task.create method using the task.TaskType.CSV_Import type value.
The job.setMapping function is changed to the job.mappingId property.
The job.setsetPrimaryFile function is changed to the job.importFile property.
The job.setLinkedFile function is changed to the job.linkedFiles property (which is an Object).
The job.setOption function is changed to the job.name property.
The nlapiSubmitCSVImport function is changed to the job.submit method.

SuiteScript 1.0 Script	SuiteScript 2.0 Script
`var mappingFileId = 2; var primaryFile = nlapiLoadFile(73); var job = nlapiCreateCSVImport(); job.setMapping(mappingFileId); job.setPrimaryFile(primaryFile); job.setOption("jobName", "jobImport"); var jobId = nlapiSubmitCSVImport(job);`	`function CSVImport() { var mappingFieldId = 2; var primaryFile = file.load({ id: 73 }); var job = task.create({ taskType: task.TaskType.CSV_IMPORT }); job.mappingId = mappingFileId; job.importFile = primaryFile; job.name = 'jobImport'; var jobId = job.submit(); }`
`var mappingFileId = "CUSTIMPORTentityMultiFile"; var job = nlapiCreateCSVImport(); job.setMapping(mappingFileId); job.setPrimaryFile(nlapiLoadFile(73)); job.setLinkedFile("addressbook", nlapiLoadFile(74)); job.setOption("jobName", "jobImport"); var jobId = nlapiSubmitCSVImport(job);`	`function CSVMultiFileImport() { var mappingFieldId = 'CUSTIMPORTentityMultiFile'; var job = task.create({ taskType: task.TaskType.CSV_IMPORT }); job.mappingId = mappingFileId; var primaryFile = file.load({ id: 73 }); job.importFile = primaryFile; var linkedFile = file.load({ id: 74 }); job.linkedFiles = {'addresbook': linkedFile}; job.name = 'jobImport'; var jobId = job.submit(); }`

SuiteScript 1.0 Script

SuiteScript 2.0 Script

                    var mappingFileId = 2;
var primaryFile = nlapiLoadFile(73);
 
var job = nlapiCreateCSVImport();
job.setMapping(mappingFileId);
job.setPrimaryFile(primaryFile);
job.setOption("jobName", "jobImport");
 
var jobId = nlapiSubmitCSVImport(job);

                    function CSVImport() {
    var mappingFieldId = 2;
    var primaryFile = file.load({
        id: 73
    });

    var job = task.create({
        taskType: task.TaskType.CSV_IMPORT
    });

    job.mappingId = mappingFileId;
    job.importFile = primaryFile;
    job.name = 'jobImport';

    var jobId = job.submit();
}

                    var mappingFileId = "CUSTIMPORTentityMultiFile"; 
 
var job = nlapiCreateCSVImport(); 
job.setMapping(mappingFileId); 
 
job.setPrimaryFile(nlapiLoadFile(73)); 
 
job.setLinkedFile("addressbook", nlapiLoadFile(74)); 
job.setOption("jobName", "jobImport");
 
var jobId = nlapiSubmitCSVImport(job);

                    function CSVMultiFileImport() {
    var mappingFieldId = 'CUSTIMPORTentityMultiFile';

    var job = task.create({
        taskType: task.TaskType.CSV_IMPORT
    });
    
    job.mappingId = mappingFileId;

    var primaryFile = file.load({
        id: 73
    });
    job.importFile = primaryFile;

    var linkedFile = file.load({
        id: 74
    });

    job.linkedFiles = {'addresbook': linkedFile};

    job.name = 'jobImport';

    var jobId = job.submit();
}

General Notices