User-defined export, import, and bulk editing > The bulk edit add in

Install the Bulk Edit Excel Add-in

Note

The Bulk Edit Excel Add-in requires Excel 2013 software and Visual Basic for Applications.

  1. Open Excel.
  2. Select File → Options.
  3. Click Add-Ins.
  4. Make sure Excel Add-Ins is selected in the Manage field, and then click Go.
  5. On the Add-Ins dialog, click Browse and navigate to \DeltaV\DVData\BulkEdit.
  6. Select BulkEdit_Support.xla and click OK.
  7. Click OK on the Add-Ins dialog.
  8. Close and relaunch Excel.

Loading the add-in creates the Bulk Edit menu command and the DeltaV Bulk Edit toolbar on the DeltaV group on the Excel Add-Ins tab.

The BulkEdit menu has the following selections:

  • Select Entry — Select from list of valid entries.

  • Header Comments — Display header comments.

  • Open Data File — Open a user-defined text export file.

  • Save Data File — Save the current worksheet as a tab-delimited text file.

  • Bulk Edit Help — Open the Bulk Edit help file.

The DeltaV Bulk Edit toolbar buttons invoke the same commands as the menu.

You can edit the data files in a text editor, but the Bulk Edit Excel Add-in has several features that simplify bulk editing.

Note

The output data .txt files from the User-Defined Export utility are in Unicode. The sample .txt files in the BulkEdit directory are plain ASCII. The User-Defined Import utility accepts both Unicode and ASCII files. Though you can edit the Unicode data files in a text editor, it is much easier to open and edit the text files from the Bulk Edit Excel Add-in. 

If you use a text editor be sure to use one that is Unicode compliant on the data files you export. Preserve the field separators in the data and save the file with Unicode encoding.