System reset

System reset

On this page you can edit database settings. You can reset, delete and create new databases, create missing tables and import default data into the database. You can also synchronise object ID sequences, test database connections and check the consistency of the database by deleting and creating database constraints

System shutdown

In this section you enter the data that determine which database should be edited.

Diagram	Choice between available databases (Standard: default; statistic: statistic; monitoring: monitor; calculations: Invoice; catalog imports: Import)
User	The DB user for the chosen diagram
Password	The password for the DB user of the chosen diagram
Server Type	DB server name for the JDBC driver: OracleThin, Inet(MSSQL) or DB2
Meta Path	Contains the path name to the file info.xml. This specifies which database version and Impact Ordering version will (should) be used.
DB Character Set	Shows the applied character set of the database
Meta Character Set	Shows the applied character set

Data

The paths shown show the place in which the default and demo data for the system setup listed under the paths can be found. The predefined paths are defined in the configuration file 'config.xml' under 'DefaultDataFilePath' and 'DemoDatFilePath'.

In this first column the default data is listed, in the second column the demo data is listed.

Default Data
01default.sql	Contains, e.g. the regional and language descriptions, the names of the groups as well as both initial system users 'root' and 'system'
02cot.sql	Contains the name of the company types
03schedule.sql	Contains several basic scheduled tasks
05attrib.sql	Contains attributes such as height, weight, width
06messages.sql	Contains news-types
07forms.sql	Contains the forms for print and e-mail exports
09auctionschedule.sql	Contains the basic and scheduled tasks for Impact Auction

Actions to be performed

Messages

In this section displays and messages about performed actions are listed.