Import steps:

After you have downloaded files of both types, then you must import in the following order:

  1. Import ECO file 
  2. Import ECL files

 

Please remember, that each individual file size can’t exceed 10MB. So split files if necessary.

Script will process all files which are in folder in one execution. One file ~ 8Mb size will process ~ 50min


Open file using Notepad++


ctrl g = go


Use the following value 49999 (NetSuite does not like any records going over 50000)


ctrl + shift + end


ctrl x = cut


ctrl n = new


ctrl v = paste



Remove the last line of the file that says SUB (not needed, see freshdesk ticket #20414)

 

Import of the ECO file:

  1. Check that files are in the file cabinet

 

 

  1. Second step you need run script: 

imgp_mr_updateAllCustomRecords_ECO_File

https://333032.app.netsuite.com/app/common/scripting/scriptrecord.nl?id=16304&e=T

Mouseover Save and choose Save and Execute

System runs script execution and displays progress window, you need to wait until status will be Completed. The process runs in background, but please make sure that script execution is Complete

  1. After the script is completed, file from File cabinet Folder will be moved to archive folder.


 

Import of the ECL file:

  1. Save the files into file cabinet folder: 

 

 

  1. Run the script: 

imgp_mr_updateLabourStandardTime_ECL

https://333032.app.netsuite.com/app/common/scripting/scriptrecord.nl?id=15968&e=T

Mouseover Save and choose Save and Execute

System runs script execution and displays progress window, you need to wait until status will be Completed. The process runs in background, but please make sure that script execution is Complete

  1. After script completed, file from File cabinet Folder will be moved to archive folder.



Checking import Result

ECO:

  1. POSITION CODES (Type in Global search: Page: WARRANTY POSITION CODE)

https://333032.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=1789

  1. FACTORY SERVICE MODEL MASTER (Type in Global search: Page: FACTORY SERVICE MODEL MASTER)

https://333032.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=1794

  1. CAUSE CODES

https://333032.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=1774

  1. NATURE CODES (Type in Global search: Page: NATURE CODE)

https://333032.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=1780

  1. SYMPTOM OCCURRENCE (Type in Global search: Page: SYMPTOM OCCURRENCE)

https://333032.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=1758

 

ECL:

  1. LABOR STANDARD TIME (Type in Global search: Page: LABOR STANDARD TIME)

https://333032.app.netsuite.com/app/common/custom/custrecordentrylist.nl?rectype=1796

 

Checking Processing Errors

Proccessing error You can check in Interface setup log. In field Date created = Today

ECO:

https://333032.app.netsuite.com/app/common/custom/custrecordentry.nl?rectype=588&id=176

ECL:

https://333032.app.netsuite.com/app/common/custom/custrecordentry.nl?rectype=588&id=169