Expert Netsuite Consulting Services | Csv Import Analysis

By Author: Yantra Inc
Total Articles: 42
Comment this article

In such conditions, our NetSuite Consulting Services providers build customizations to automate these processes with the help of SuiteScript.
NetSuite implementation thankfully provides us a feature to perform that task using SuiteScript in every SuiteScript version. But for every version of this API, we found a few limitations as well.
So here we will discuss achieving CSV Import through SuiteScript with different versions and limitations of each version and when and where to use a certain specific version in detail.
Before we create SuiteScript to perform CSV Import, we need to create a “Saved CSV Import” record.
Creation of Saved CSV Import Record:
For that Got To Setup > Import/Export > Import CSV Record
Step 1: Select Import Type, Record Type, and other file-related setup. Select the sample CSV file to further map file columns with NetSuite record fields.
Step 2: Click “NEXT” and select Import options among “Add”, “Update” & “Add OR Update” as per your requirement.
ADD: To create a new record.
UPDATE: Update existing records
ADD OR UPDATE: ...
... If a record exists, then update the existing record, else create a new record.
Step 3: There are a few more setups under “Advanced Options” that can be set like:
Validate Mandatory Custom Fields: Enable this option to require mandatory custom field data to be present for records to be created.
Overwrite Sublists: For updates, enable this option to cause imported sublist data to completely replace existing sublist data, instead of selectively updating or being appended.
Run Server SuiteScript and trigger WorkFlows: Check to specify that any server-side SuiteScripts and workflows should be triggered for the current CSV import. Note that running server SuiteScript slows the save process and some more.
To read full blog- Expert NetSuite Consulting Services | CSV Import Analysis