MODCOMP Database Translator

CADP2CSV2 is the second re-write (hence the trailing '2') of the CADP2CSV program. The purpose of the program is to read a text file that contains output captured from the ANALST, DIGLST and SMKLST programs on the MODCOMP central computer. The MODCOMP programs should be run for ALL buildings and units so that the entire point database is represented.

CADP2CSV2 makes a best effort to identify all of the data point entries and translate them into entries for the PICS static database. The program actually emits a set of CSV (comma separated value) text files suitable for importing into the PICS databases using the DBIO utility. The files produced are:

• point.csv - primary point data file
• realtime.csv - secondary point data file, generally this contains things that are tunable at runtime
• AlarmMst.csv - Alarm Master data file, contains information about all alarm records, analog or didital
• aAlarm.csv - Analog Alarm data file
• dAlarm.csv - Digital Alarm data file

CADP2CSV2 also filters out some specific points (such as % utilization) which were once computed by the Unit Computers.

CADP2CSV2 creates a number of points that have been added especially for PICS, such as byte/packet counts for serial 8800s, line recorder points, and the plant gradient set.

CADP2CSV2 also generates all of the internal PICS points, like time, mode, subsystem status points, etc.

CADP2CSV2 is a command line program. That means that it is designed to run from a command shell and it does TTY-style output to the command shell window. It takes one parameter on the command line: the name of the capture file containing the MODCOMP database.