Manifest Tab in the vMedia Spectrum Exporter

Overview

Manifest creation functionality added, new Manifest Tab in Spectrum Exporter.

Procedure

1. "Create and Include Manifest File" when checked, a manifest file will be created and included in the export according to the specified settings. When unchecked, no manifest file will be created.
2. File Name - must be non-blank. Name of manifest file to create, string literal not an expression. The extension used is dictated by the file format and should not be typed.
3. Manifest File Format - Selecting the format the contents of the file.
   • HTML - Produces a self-contained HTML file with the HTM extension. Each configured column represents a field of data, the 1st row of the table contains descriptive headers derived from the Data Entry Prompt (for vMedia database fields) or a custom user defined string (for user defined fields) or a fixed format string (for internal fields). If the media file name is included in the manifest file, it is tagged as a hyperlink. Clicking on the hyperlink will open the corresponding media object using the local handler for the file type.
   • CSV - Produces a text file that is delimited as follows: Each column is separated by a comma, character fields are quoted, and each row is terminated by a carriage return line feed ASCII combination. There is no header row, just data rows.

   XLS - Produces an Excel 5.0 Format Workbook. Sheet #1 contains the data.

4. Configuring Columns
   The Configure Columns button brings up the column editor. See below for detailed editor instructions:

• Database Field Picker - Contains special fields, user defined fields, and under the Index Field header vMedia database fields that have not already been used in the definition.
• Column Definitions - Contains an ordered list of columns that will be exported into the manifest file. The order of the columns can be changed by clicking on the grey squares to the left of the field name to change the relative order.

 

Functions

• Add All - Moves all the remaining fields from the DFP to the end of the CD list, after any existing entries.
• Remove All - Moves all CD fields up to the DFP list. The items will be moved in order into the corresponding section within the DFP.
• Add Selected - Moves the selected entry from the DFP to the bottom of the CD list.
• Remove Selected - Moves the selected entry from the CD list to the corresponding section within the DFP.
• Create Custom Column - Creates a user defined function column (Not available for testing yet)
• Save - Saves the changes to the Column Definition and returns to the main SE dialog
• Cancel - Discards any changes to the column definition and returns to the main SE dialog. The previous column definitions (if any) take effect.

NOTE: When the column definition is empty, a warning message is displayed in the SE Dialog.