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