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
- Fill out the applicable information in the Cross-Validation Rules Import Template. Each tab in the file is imported separately: Rules, Filters, and Requirements.
Transfer from sandbox to production
Configure permissions and settings
Prior to transferring your Cross-Validation Rules, all permissions and system settings should be configured in production as they were configured in sandbox. See Cross-Validation Rules Permissions and Settings.
- In sandbox, navigate to Netgain > Setup > System Setup > Cross-Validation Rules > Import Tools.
- Export each of the three files via the Search Links.
Update condition IDs that differ in production
The Condition column holds the internal IDs of the NetSuite records a filter or requirement checks, such as subsidiary, entity, department, or account IDs. Both import methods bring these values in as they are, so if a record has a different internal ID in production, update the Condition value in the file before importing. The Field column must also reference fields that exist in production, including custom fields and custom segments.
The Cross-Validation Rule column does not need to change. It exports the rule name, and both import methods can match each filter and requirement to the production rule by name.
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)
- 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.
- 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.
- 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.
- 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.
- Repeat step 4 for the requirements, using the Netgain Tools Rule Requirement record type.
- Lastly, validate your rules via Netgain > Cross-Validation Rules > Rules.
Option 2: NetSuite CSV Import
- Save each file, or each tab of the import template, as its own CSV file.
- In the account you are importing into, navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records.
- For Import Type, choose Custom Records and for Record Type, choose Netgain Tools Cross-Validation Rule.
- Under the CSV files section, click Select and upload the rules CSV file.
- On Import Options, make sure Add is selected and Run Server SuiteScript and Trigger Workflows is checked.
- Follow the prompts to finish the import.
- 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.
- Lastly, validate your rules via Netgain > Cross-Validation Rules > Rules.
