Working with DataGrid Tables

Most tabs in FactoryStudio display information in a table. All tables use the same method to manipulate, copy, paste, and import data.

Editing Tables

Most configurations from the Edit menu (such as tags, alarms, and users) are stored in tables. In most tables, you can add and edit information the same way. 

To add a new table item (row):

  • Click the first column of the insertion row. The insertion row is the first row of the table and has an asterisk (star) next to it.

After you click a column in the row, the * becomes a pencil icon, showing that you are now editing that row. 

You can do one of the following for you column you selected:

  • If the column is a text field, enter the information.
  • If the column is a selection field, click the same spot again and select items from the drop-down list or pop-up window that displays.
  • Press Tab to move through the columns in the row.

To edit an existing table row, click the column in the row that you want to change and do one of the following:

  • If the column is a text field, enter the new information. The system overwrites the text that was in the field. To change part of the text, click again and make your changes.
  • If the column is a selection field, click again and select items from the drop-down list or pop-up window that displays.

More than one person can edit a project at the same time. The system saves all changes to the project server and propagates the changes to other users. If two users modify the same configuration table or document, the changes from the last person who saves would overwrite any previous changes. 

Tooltips and Validation

Throughout FactoryStudio, fields and buttons have tooltips that contain information about the field or button. Tooltips appear when you move your cursor over the related field or button. Some tooltips include an example that can help you.

The system also validates whatever you enter into most fields, especially in tables. Validation rules may check that the input is in a correct format, that values are within the appropriate range, and other factors. The exact rules depend on the specific item. If you see a red outline around the table cell, the entry is not valid.

Sorting, Filtering, and Grouping

Information in many tabs is shown in tables that you can sort, filter, and group. By default, items in a table are listed in the order in which you created them.

To sort a table:

  • From any table, click the column heading you want to use to sort. The items now sort in ascending alphanumeric order based on that column.

  • Click the column heading again to sort in descending alphanumeric order.
  • Click the column heading again to return to the default order.

To filter a table:

  • From any table, hover over the column heading you want to use to filter.
  • An arrow for a drop-down list displays next to the column heading.

  • Click the arrow to see the list of items in the column.

  • Select the items you want to include in the filter.
  • To remove the filter, click the drop-down list and click (Clear Filter).

To group items in a table:

  • From any table, drag a column heading to the area above the columns to group the table by the column you moved.

  • To remove the grouping, drag the column name back to the column headers area.

Adding and Removing Columns

Tables in FactoryStudio display a default set of columns. Every table has additional columns that you can display, and you can remove any of the default columns. You can also change the order of the columns.

To add or remove a column:

  • From any table, right-click in the column heading area.
  • A list of all available columns for that table displays. Columns with a check mark next to them currently display in the table.
  • Select or deselect columns in the list.
  • Click outside the list to close it.
  • To change the order of the columns, drag a column heading to a new location.
  • To reset the columns to the default, click  Reset Grid to Default Settings.

Common Column Definitions

Several common columns are available in most tables. These columns are defined below.




Database ID assigned to the object in the table. Numbers are assigned starting from 1 for the first object created and continue as needed. The IDs are unique only to a specific table.


Select the level you want to associate with the tag on the Assets tab. See Creating Assets in the chapter Tags, Assets, and Templates.


Select one or more categories for this attribute. See Categories Dictionary below.


Date the object was last changed.


Date the object was created.


Enter a description of the object.

Copying and Pasting Rows

You can copy and paste rows into and from tables in FactoryStudio. The smart copy/paste functions let you copy rows from one table to another within FactoryStudio. For example, you can copy tags and paste them into the Historian tab or the Items tab under Alarms. You can also copy and paste to and from a spreadsheet. In addition, you can import a comma-separated values (.csv) file into any table. Column headings must match the table you are importing into. The best way to ensure that the headings match is to copy rows into a spreadsheet first, then edit the spreadsheet. 

Copying and Pasting Within FactoryStudio 

To copy rows to another tab in FactoryStudio:

  • From any table, select one or more rows.
  • Right-click and select Copy Selected Rows.
  • Go to another tab in FactoryStudio.
  • Right-click and select Paste Rows.

Copying and Pasting To or From a Spreadsheet 

To copy rows to a spreadsheet:

  • From any table, select one or more rows.
  • Right-click and select Copy Selected Rows.
  • The copy automatically includes all available column headings for the tab you are in.
  • Go to a spreadsheet and paste.

To paste rows from a spreadsheet:

  • Set up the spreadsheet columns by following the copy steps above.
  • Enter the information you want.
  • Copy the information, including the headings, from the spreadsheet.
  • From the corresponding table, right-click and select Paste Rows.
  • The paste automatically places the data into the corresponding columns. Any empty cells are ignored.

Importing Data 

  • Create the data in a spreadsheet. If you are creating tags or other objects, you can name the objects as needed. If you are populating other columns, the data in the columns must match what FactoryStudio expects.
  • Save the file as a .csv.
  • From the corresponding table in FactoryStudio, click  Import from a CSV file.
  • Navigate to the .csv file and select it.
  • Click Open.

The system imports the data into the table. 

  • No labels