Can anyone show me where I can find details of the tag database which is exported from Conductor NT5.0? I need to find the column headings.

Failing that, is there a way to convert the tag database (*.mdb or *.ttg) to DBIII (*.dbf)?

Many thanks.

Nick

 

I am no expert - we use a system 6 DCS with ConductorNT, so what I say may not work for you if you use something else.

I think you can extract all the tag data from the dcu modules. Using a small script (we use python to do this part) you can then generate the database you need.

There is also the historical database which can be dumped. Have a look in the bin folder at some of the commands there.

Can't help much more than that though - sorry

Mick

 

There are a couple of ways I do it. Either use the wonderful product DBDOC from www.gmcl.com which creates what they call a "flat" database which has good headings and is a lot easier to navigate.

Or export the database in .ttg format and import it into the Wintools 2.X program Console Tools Executive. This has a Tag database bit that allows you to import the .ttg file and you will need all the other database info (like engineering units, alarm comments etc). I just did this recently to sync my CAD documents to the tag database (there is no other way to do this if you are using Wintools and Conductor NT).

If you need further info. E-mail me at [email protected]

 

You can use de command xdcdump in the dos prompt

With this command you can dump de HDB file you can also use xdcload (load to the DCU)

 

the command "xdcdump -hdb" is for the historical database. If the tags are not added to the dabase then they won't appear. The two database are mutually exclusive. The original poster asked for tag database, which I believe exists in the dcu module (does for system 6).

There are a lot of switches that can be used with XDCDump, so you not only get the historical database but security info etc. try xdcdump /? to see what is available.

Mick

 

Nick-

When using xdcDump and xdcLoad from the command prompt, use the syntax xdcDump -all (filename, such as "SERVER CONFIG"). For instance, if you wanted to configure alarm vectors, drop to the command prompt and type xdcDump -alarmvec VECTORS <enter>. This will create a file named VECTORS in the directory you are in (or another if you specify the path), which can be edited using Wordpad, etc. This is a faster config utility than configuring point by point in the ConductorNT-configure-network parameters-alarm vectors.

When finished, save the file, then use xdcLoad -alarmvec VECTORS <enter>, and the new config is loaded.

This is also the fastest way to edit the historical database. Be aware not to change any formatting, spacing, etc.

Also, when making server backups, I always use this utility with the xdcDump -all filename(SERVER1 BU, for instance), export the database from the tag configuration utility (export the OPC database seperatly, if you are using). You can also edit the *.ttg file with a text editor, if necessary.

Hope that helps.

 

Your last paragraph is something we have been trying to do automatically. The problem we have come across is that conductor NT needs to be logged in with the correct privledges to be able to execute the command, but we don't know how to do this at the command line. Any clues/hints?

Mick