Database requirements

Database requirements

BuildPlus can process .xls or .xlsx databases that meet these criteria:

  • The worksheet must look like a database, with the first row containing the field names, then multiple rows of field values
  • Blank rows are supported
  • Multiple sheets can be built in from one xls file
  • Fancy features, such as filters, drop-downs, macros, and other formatting are ignored
  • Emerson Ovation taglists exported as .xls files are supported in DBDOC 10.6 and later

Note: Data in .xls files can be linked to other file types included in the build, for example .pdf, .dwg (AutoCAD)


The following table shows the fields that are required in order for various database types to be recognized:

Database Type DBtype requirements Hyperlink requirements Aliases
PI database(.xls/.xlsx) LOCATION2
LOCATION3
LOCATION4
TAGNAME
LOOP
MODULE
BLOCK
TAGTYPE
TAGDESC
POINTSOURCE
TAGNAME→ TAG or Name
LOOP→ LOCATION2(actually 256 x Loop+PCU)
MODULE→ LOCATION3
BLOCK→ LOCATION4
TAGTYPE→ LOCATION5 or PTTYPE or POINTTYPE
TAGDESC→ DESCRIPTOR or DESCRIPTION
POINTSOURCE→ POINTSOURC or PTSOURCE
SPlus Tag Database(.xls/.xlsx) INDEX
NAME
DESC
TAGNAME
TAGDESC
LOOP
PCU
MODULE
BLOCK
TAGNAME→ NAME
TAGDESC→ DESC
Generic Tag Database(.xls/.xlsx) LOOP
TAGNAME
TAGINDEX
TAGNAME
DESC
LOOP
PCU
MODULE
BLOCK
PCU→ NODE
Emerson Ovation Database(.xls/.xlsx) POINTNAME
INDEX
DESCRIPTION
TAGNAME
DESC
LOOP
PCU
MODULE
BLOCK
TAGNAME→ POINTNAME
DESC→ DESCRIPTION
LOOP→ RING
HOPC Database(.xls/.xlsx) INDEX
TAG
TAGDESC
TAGNAME
TAGDESC
LOOP
PCU
MODULE
BLOCK
TAGNAME→ TAG
PCU→ NODE
Trend Database(.xls/.xlsx) TRLOOP
TAGNAME
TRINDEX
TAGNAME
TRINDEX
LOOP
PCU
MODULE
BLOCK
LOOP→ TRLOOP
PCU→ TRPCU
MODULE→ TRMODULE
BLOCK→ TRBLOCK
PTT Database(.xls/.xlsx) LOOP
TAGNAME
TAG_ID
CITECT Database(.xls/.xlsx) NAME
COMMENT
ADDR
Instrument Database(.xls/.xlsx) TAGNAME
COMPONENT
TAGNAME→ TAG


See also