DW Spectrum User Manual

The information provided on this page is specific to the Generic Lookup list type.

Create a Generic List:

1.Open Main Menu > Lists Management,

2.Atop the Lookup Lists dialog, select the New List... button,

3.Enter a name for the new list.

4.Select the Generic List type.

5.Enter a name for the list column (data field).

6.Click the Create button to progress to the list content dialog.

Configure or Delete a Generic List:

1.Open Main Menu > Lists Management.

2.Atop the Lookup Lists dialog select an existing generic list from the pull-down menu.

3.Click on the Settings icon to edit the list and column name.

4.Use the Delete icon to remove the generic list.

Define the Values in a Lookup List:

1.Open Main Menu > Lists Management.

2.Atop the Lookup Lists dialog select an existing generic list using the pull-down menu.

3.Click the +Add button to add a new value to the list.

4.Click on an existing value in the column to edit the value.

5.Use the checkbox to select values to delete, then click the Delete icon.

Import Values to a Generic List:

Generic Lookup Lists can quickly be populated using existing data.

1.Open Main Menu > Lists Management.

2.Atop the Lookup Lists dialog, use the pull-down menu to select an existing (generic) list where the imported data will be placed.

3.Click the icon labeled Import that is between the +Add button and the icon labeled Export.

4.Browse to and select the (list) file to be parsed for import:

a..CSV, .TXT, or .TSV file types can be imported.

b.Select the character that is used to separated values within the imported values.

5.DW Spectrum will attempt to parse the list and generate a preview within the Import Options dialog.

6.Confirm the state of the Data Contains Header checkbox matches the file to import

7.Click the Import button if the preview is correct.

a.Imported data will be appended to existing data.

b.Erroneously imported data and duplicates must be manually removed from the list.

c.Values in the revised list, after import, can be edited before being committed.

8.Click the Apply button to commit and deploy list changes without closing the Lookup List dialog.

9.Click the OK button to close the Lookup List dialog.

Export a Lookup List:

The contents of a list can be export for external modification or other usage.

1.Open Main Menu > Lists Management,

2.Atop the Lookup Lists dialog select an existing list using the pull-down menu.

3.Click the Export button.

4.Browse to the location where the file will be exported.

5.Confirm the file-type and file name the list will be exported to.

6.Click Save to export the Lookup List.

7.The export confirmation dialog includes an option to open the 'save to' location.