Scheduled script to import multiple CSV files into Netsuite

Scheduled script to import multiple CSV (customer,item) files 

Scheduled script: 

1. Create a CSV file for Customer  

                         

2. Create a CSV file for Items

                        

 

Note : In items CSV file Create a linked column (i.e Customer in sample)

3.Create a saved import in Netsuite

it will act as Mapping in scripting.

4.Load the CSV Files in the file cabinet and get files Internal IDs

5.Get the Saved Import id

6. Lets create a code to import 

function scheduledimporting(type) 

{
var import1 = nlapiCreateCSVImport();
import1.setMapping(412);
        // 412 is Internal id for mapping

import1.setPrimaryFile(nlapiLoadFile(26793));
        // 26793 is Internal id for customer file

import1.setLinkedFile("item",nlapiLoadFile(29368));
        //29368 is Internal id for item file

import1.setOption("jobName","Multiple CSV Data Importing");
        //Naming the mapping


nlapiSubmitCSVImport(import1);
        // Importing is Done
}