Most tabs in FactoryStudio display information in a table. All tables use the same method to manipulate, copy, paste, and import data.
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):
After you click a column in the row, the * becomes a pencil icon, showing that you are now editing that row.
To edit an existing table row, click the column in the row that you want to change and do one of the following:
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:
To filter a table:
To group items in a table:
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:
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:
Copying and Pasting To or From a Spreadsheet
To copy rows to a spreadsheet:
To paste rows from a spreadsheet:
The system imports the data into the table.