Data Dictionary Maintenance

Bulk Edit Data Elements

The Bulk Edit Data Elements utility allows bulk changes to be made to data elements in the PxPlus data dictionary and applied simultaneously to multiple selected tables. This utility provides a way to quickly update data elements values, which are common or similar in multiple tables, or easily correct any inconsistencies in the data dictionary.

The utility loads the Element Definitions grid based on the tables selected in the Select Tables tree view. The grid columns are based only on certain fields in the data element definition, not all the fields. The utility uses the data elements values in the grid columns to determine how to display the data elements and tables. It does not check all the fields in the data dictionary record.

A data element with the same values across multiple (*All*) tables will be listed once in the grid. If an element value in the grid columns is slightly different in two (or more) tables, the data element will be listed with the same name more than once. An example of this is shown in the screen shot below where ContactName is listed twice because of the different Description in the two tables.

A log showing the applied data element changes is also available.

(The Bulk Edit Data Elements utility was added in PxPlus 2023.)

To invoke this utility, use one of the following methods:

Location	Method
From Data Dictionary Maintenance	Click the Bulk Edit tool bar button.
From Data Dictionary Maintenance	Enter or select the name of an existing data dictionary table. From the menu bar, select Edit > Bulk Edit Elements.

The Bulk Edit Data Elements window is displayed below with a sample entry:

This window consists of the following:

Select Tables

Tree view list of tables in the data dictionary, sorted by group, in alphabetical order.

To select/deselect all the tables, click the All tables check box at the top of the tree view.

To select/deselect a single table, click the check box beside the table name.

To select/deselect all the tables within a group, click the check box beside the group name. Tables that are not assigned to a group are listed under "No group assigned" at the top of the tree view.

Element Definitions

Grid that lists all the data elements in alphabetical order for all the tables selected in the Select Tables tree view. Once tables are selected, the Load Table Elements button is used to load the grid.

When a value in a cell changes, the cell shows a blue background. To put back the previous value, right click on the cell and select Reset Value. The value can only be reset if the change has not been applied.

This grid consists of the following:

Element	*(Display Only)* Name of the data element.
Type	*(Display Only)* Type of data element (Numeric or String).
Size	*(Display Only)* Maximum length of the data element.
Class	Name of the Data Class currently assigned to the data element, if applicable. A predefined data class can be entered or selected using the Query button. Only data classes defined with correct values for Type and Size based on the data element are allowed. When a data class is entered, a message will display about updating the element. Responding Yes will automatically apply the changes to the selected table(s). A data class can also be created on the fly, using the element's Type and Size values. Enter a new Class name and respond Yes to the displayed message, which launches Data Class Definitions maintenance. When the new data class is added, a message will display about updating the element. Responding Yes will automatically update the element. Responding No or Cancel will not update the element.
Description	Current description assigned to the data element.
Format	Current Format assigned to the data element.
U/C	Check box that indicates the current uppercase property for the data element.
Update Tables	If a single table is being updated, the table name will be shown (e.g. ClientMaster). If multiple tables are being updated with the same data elements values, the word *All* will be shown. Click the drop down arrow to see all the tables that will be updated.
Dtl	Button that invokes the Element Description window (similar to the Element Description window in Data Dictionary Maintenance). Data element details are displayed based on the Update Tables cell. If this cell shows the word All, the element details from the first table in the drop down list will display. Clicking this button automatically applies any pending changes in the grid row (cells will have a blue background). The changes are applied either to a single table or to multiple (All) tables, based on the Update Tables cell. *Example:* This example shows a change to the Description value for the City element. Clicking the Dtl button invokes the Element Description window for the ClientContacts table with this change automatically applied to all tables containing this element: When the Update Tables field shows the word All, hovering over this field displays a list of all the files that were updated or will be updated if changes are made.

Collapse/Expand

Toggle button used to collapse/expand the list of tables in the Select Tables tree view.

Load Table Elements

Button that loads the grid with data elements based on the tables selected in the Select Tables tree view.

If the grid is already loaded and has pending changes (cells will have a blue background), a message will display about applying the changes.

Update Physical Files

Button that invokes the Update Physical Files utility. If there are data element changes that have not been applied, a message will display.

View Log

(Available when data element changes are applied)

Button that displays a log of the changes applied. The log can also be printed and saved, if desired. The log accumulates the changes until you exit the utility.

Apply

(Available when changes are entered in the Element Definitions grid)

Button that is used to update tables with the changes made to the element values in the grid columns.

If the Update Tables column for an element shows the word *All*, changes will be applied to all tables in the drop down list.

Exit

Button that closes the Bulk Edit Data Elements utility. If there are data element changes that have not been applied, a message will display.