Use Microsoft Excel to Edit DBF Tables

Plant SCADA allows you to edit and save .dbf files (tables) used in Plant SCADA by opening them in Microsoft® Office Excel®.

Microsoft Office Excel 2016 does not allow you to save files in .dbf format though you may open and edit them using the File > Open command. In order to overcome this limitation Plant SCADA includes an Add-In for Microsoft Excel called the Plant SCADA Project DBF AddIn. When this add-In is loaded into Excel, it allows you to browse, open, edit and save Plant SCADA .dbf files in the correct format.

The Project DBF AddIn is an optional component included in the installation of Plant SCADA and is accessed from the installer. If you did not select installation of the add-In during installation, you can install it at a later time by navigating to the ProjectDBFAddIn folder of your Plant SCADA installation and running the setup.exe in that folder.

Compatibility

This add-In is specifically designed for use with Microsoft Excel 2016 or later. Earlier versions of Excel are not supported.

Integration with Microsoft Excel

When you open Microsoft Excel, an additional toolbar, or an additional tab, called Project DBF Addin is available depending on the version of Excel that you are using.

The fields and buttons on this toolbar allow you to choose:

1. The path to the master.dbf.

2. A Plant SCADA project from the master.dbf .

3. A .dbf file (table) belonging to the selected project.

4. Save changes made to a .dbf file (table).

5. Save changes without re-indexing the table, or save and re-index.

6. Save a dbf file with a different name.

7. Open a dbf file in any location

However, you can also open .dbf files using the File > Open command.

Protected Tables

The installation of the add-In incorporates a list of tables that by default are excluded from being opened using the add-In interface. This list is in a file called ExcludedProjectTables.xml and can be found in the add-In installation directory.

These tables are system tables that are maintained by Plant SCADA, and it is recommended that these files are not edited externally in Microsoft Excel. To minimize the likelihood of additional tables being edited with Microsoft Excel you can add their names to the ExcludedProjectTables file using a text editor. You can also view the default list of tables using a text editor, or an XML compliant browser.

Read Only Tables

Projects which are read only, or contain read only tables, are displayed in the list of tables when selected from the Add-In buttons. If you try to open a read-only table (.dbf file) an alert (sometimes referred to as a "warning") message is displayed advising that the table is read only. You can still open and edit a read only table but you will not be able to save it.

A table could be read-only for the following reasons:

• The project is read-only.

• The table is open in the Plant SCADA Studio.

• The user trying to edit the file does not have read and/or write privileges.

If you attempt to save a read-only table an alert message is displayed advising that the table is read only.

See Also

Project DBF AddIn Functionality