1. SuiteCloud Platform
  2. SuiteScript
  3. SuiteScript 2.x
  4. Transitioning from SuiteScript 1.0 to SuiteScript 2.x
  5. Sample SuiteScript 1.0 to SuiteScript 2.0 and SuiteScript 2.1 Conversions
  6. Create CSV imports

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'll 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.x includes the following:

SuiteScript 1.0 Script

SuiteScript 2.x 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