"Execute with Local File..." using Local Data

Tuesday, 24 March 2009 14:39
Print

Here is an alternate way to load records with minimal Excel data manipulation – this example also leverages the “create area release rule policy” command:

  1. Create and save a .csv file with required data including the field headers on your local machine.

    Or

  2. Paste command that will be run using the file as input into the LextEdit editor.

  3. Select ‘Tools’ then ‘Execute with Local File’

  4. Locate the .csv file on your local machine and select ‘Open’

  5. LextEdit will provide a sample ‘Publish Data’ example for your validation prior to proceeding, if everything looks correct select ‘Ok’.

  6. LextEdit will execute the command on screen for all records in single execution.

Last Updated on Wednesday, 21 August 2013 16:23