WCCOAtoolCreateDb

This program creates a new database based on the entries of the configuration file config.

The status indications and the error messages from WCCOAtoolCreateDb are written into the file createDb.log under the path <proj_path>/log/.

WCCOAtoolCreateDbSQLite

In the same way as, for example, the WCCOAtoolCreateDb tool is available for the RAIMA database, tools for SQLite are available in the: wincc_oa_path/bin directory. For example, WCCOAtoolCreateDbSQLite.exe.

The parameters of WCCOAtoolCreateDb are:
```
-config <proj_path>\config\config { -lang <lang> } 
-help -system <Systemnummer> <Systemname> -yes
```
If no system name is entered, then WCCOAtoolCreateDb will automatically add a name.
During a WinCC OA project creation it is possible to pass the data point lists (which are normally imported by the ASCII manager) directly to the WCCOAtoolCreateDb tool and consequently import them automatically.
```
-importAsciidplist/<File>
```
For <File> enter a data point list file. Per command line the import of only one file is allowed. The data point lists will be imported in this sequence they have been entered to the operating system command lines.
Either an absolute path or a relative path can be entered. In case of a relative path, the /dplist project folder will be browsed.

Enter e.g. the following commands to the command line:

WCCOAtoolCreateDB -system <otherOptions> 
-importAscii dplist/testFile1.txt
-importAscii dplist/testFile2.txt
-importAscii dplist/testFile3.txt

Command line options

-apar (ASCII manager),
-dpar (Data manager),
-epar (Event manager), 
-spar (Simulation manager)

If other data and event host names and port numbers are used than the default host names and ports, these host names and port numbers must be specified by using -apar, -dpar, -epar and -spar.

The following example shows how to create a database by using other port numbers than the default ports:

wincc_oa_path\bin>WCCOAtoolCreateDb 
-yes -config D:\WinCC_OA_Proj\DBCreateTest\config\config 
-lang en_US.utf8  -system 402 mySystem1 
-apar "-data localhost:5897 -event localhost:5998" 
-dpar "-data localhost:5897 -event localhost:5998" 
-epar "-data localhost:5897 -event localhost:5998" 
-spar "-data localhost:5897 -event localhost:5998"

Note: Note that the host names and port numbers used for -dpar, -epar, -apar and -spar, MUST correspond to the host names and port numbers specified by using the "data" and event" config entries in the project config file.

data = "localhost:5897"

event = "localhost:5998"

When you create a database by using the WCCOAtoolCreateDb.exe tool, the languages are listed including the parameters

{Active}{Para}{Meta}:

{Active} is the "lang" entry of the config file,

{Meta} is the "metaLang" entry of the config file and

{Para} is an obsolete entry.

Driver numbers for WCCOAtoolCreateDb and WCCOAtoolCreateDbSQLite

You can specify Simulator (SIM) driver numbers to be used as parameters for WCCOAtoolCreateDb and WCCOAtoolCreateDbSQLite. The driver numbers can be separated by commas (e.g. 3,5,8,12) or specified as ranges (e.g. 1-5) or as a combination of both (e.g. 1,3-5,10).

Note: Spaces are not permitted between these numbers.

To start SIM drivers with specific driver numbers, enter at least two driver numbers. However, you can also specify the number of SIM drivers to be started (maximum 95) by specifying the number you want to start, e.g. -sim 95.

Examples for WCCOAtoolCreateDb and WCCOAtoolCreateDbSQLite

.\WCCOAtoolCreateDb.exe -sim 5 -proj myProj
Creates 5 WCCILsims, namely from 1 to 5.
.\WCCOAtoolCreateDb.exe -sim 2,3,4 -proj myProj
Creates 3 WCCILsims, namely 2, 3 and 4.
.\WCCOAtoolCreateDb.exe -sim 1-3,6 -proj myProj
Creates 4 WCCILsims, namely 1, 2, 3 and 6.
.\WCCOAtoolCreateDb.exe -sim 1-3,4,5,6-8,10-12 -proj myProj
Creates 11 WCCILsims, namely from 1 to 12 but with leaving out the 9.