Here is an alternate way to load records with minimal Excel data manipulation – this example also leverages the “create area release rule policy” command:
- Create and save a .csv file with required data including the field headers on your local machine.
Or
- Paste command that will be run using the file as input into the LextEdit editor.
- Select ‘Tools’ then ‘Execute with Local File’
- Locate the .csv file on your local machine and select ‘Open’
- LextEdit will provide a sample ‘Publish Data’ example for your validation prior to proceeding, if everything looks correct select ‘Ok’.
- LextEdit will execute the command on screen for all records in single execution.