Cross-Validation Rules Importing rules

Overview

Cross-Validation Rules, rule filters, and rule requirements can be imported in bulk with the Data Import Wizard (recommended) or with NetSuite's CSV Import Assistant. Use this process to load a new set of rules from the import template, or to transfer rules from sandbox to production once user acceptance testing is complete. The import steps are the same in both cases; only the source of the files differs.

For a full walkthrough of each wizard step, see Cross-Validation Rules - Data Import Wizard.

Step-by-step process

1. Prepare the files

New rules
Transfer from sandbox to production
  1. In sandbox, navigate to Netgain > Setup > System Setup > Cross-Validation Rules > Import Tools.
  2. Export each of the three files via the Search Links.

2. Import the files

Run these steps in the account you are importing into. Import the files in order: rules first, then filters, then requirements.

Option 1: Data Import Wizard (recommended)
  1. Navigate to Netgain > Setup > System Setup, open the Cross-Validation Rules subtab, and click the Link under Data Import Wizard in the Import Tools section.
  2. Import the rules. Select the Netgain Tools Cross-Validation Rule record type, upload the rules file, and choose the Add operation. If you upload the Excel template, select the Rules sheet on the Select Data step. Work through the wizard to Submit.
  3. On the Data Import Status page, wait for the import to show Complete and confirm the Errored count is zero. The rules must exist before their filters and requirements are imported.
  4. Import the filters. Select the Netgain Tools Rule Filter record type, upload the filters file (or select the Filters sheet), and choose Add. To link each filter to its rule, either:
    • Select a rule in the Associated Cross-Validation Rule field to attach every row in the file to that rule, or
    • Leave that field blank and, on the Map Columns step, map the column that identifies each row's rule to the Cross-Validation Rule field. Set Lookup By to match what the column holds. For files exported from sandbox, the Cross-Validation Rule column holds the rule name, so use Name.
  5. Repeat step 4 for the requirements, using the Netgain Tools Rule Requirement record type.
  6. Lastly, validate your rules via Netgain > Cross-Validation Rules > Rules.
Option 2: NetSuite CSV Import
  1. Save each file, or each tab of the import template, as its own CSV file.
  2. In the account you are importing into, navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records.
  3. For Import Type, choose Custom Records and for Record Type, choose Netgain Tools Cross-Validation Rule.
  4. Under the CSV files section, click Select and upload the rules CSV file.
  5. On Import Options, make sure Add is selected and Run Server SuiteScript and Trigger Workflows is checked.
  6. Follow the prompts to finish the import.
  7. Repeat steps 3-6 for Netgain Tools Rule Filter and then Netgain Tools Rule Requirement. On Field Mapping, map the Cross-Validation Rule column to the Cross-Validation Rule field. For files exported from sandbox, click the pencil/edit button on that field and make sure the reference type is Name.
  8. Lastly, validate your rules via Netgain > Cross-Validation Rules > Rules.

Related links


Was this article helpful?