Configuration file (.ini file)

<< Click to Display Table of Contents >>

Navigation:  Installation >

Configuration file (.ini file)

Brief

The XpertTimer.ini file contains important basic settings for operating the Xpert Timer. The database connection is configured here in particular. Additional settings can also be used to configure special settings for processing hibernation mode, for example.

Search paths

Depending on whether you are using the Basic or Pro version of the Xpert Timer, the configuration file is called either XpertTimer.ini or XpertTimerBASIC.ini.

You can find the file either in the Xpert Timer program directory

C:\Program Files\XpertTimer\

or, if you have restricted user rights, in the user-specific directory under

C:\Documents and Settings\[username]\Local Settings\Application Data\XpertTimer\XpertTimer.ini

It is also possible to specify the location of the file using environment variables. This can offer considerable installation and maintenance advantages for administrators, for example, as they can assign the environment variables via ActiveDirectory according to user roles. The following environment variables are available:

1.XTDBCONFIGPATH

2.HOMEDRIVE + HOMEPATH

 

The environment variables can be queried and set using the "SET" command line command. 

 

Search order

The program checks for the existence of the file in the following order:

1.Program
path C:\Program Files\XpertTimer\

2.Environment variable
XTDBCONFIGPATH

3.Environment variable
HOMEDRIVE + HOMEPATH

4.User-specific program path
C:\Documents and Settings\[username]\Local Settings\Application Data\XpertTimer\

 

Entries

 

[General]

Parameter name

Description

ShowWelcome = 0/1

Show welcome dialog

ShowSplash = 0/1

Display program logo when starting the program

ShowScenario = 0/1

Display selection of trial version scope on first start

SingleInstance = 0/1

Start Xpert Timer multiple times. This would allow, for example, multiple users to record their times simultaneously on the same computer.

WriteLog = 1

A log file is created in the program directory. Used to find startup problems.

 

[Backup]

Parameter name

Description

Path

Backup path for backing up the Access database. e.g. Path=SERVER\Backup\XpertTimer

[DBConnectionCheck]

Parameter

Description

Enabled = 0/1

Connection check via ping to IP address active/inactive

ServerIP

IP address of the server for connection check

ReconnectPingCount

Number of connection attempts via ping (default=2)

InitialDelay

Duration of the initial connection check after waking up from sleep mode in ms (default=100ms)

ReconnectDelay

Repeat interval of the automatic connection check in ms (default=5000ms)

Database configuration [DBConfigxx]

Parameter name

Description

Database type = 0,1,2,3,6

Type of database used 0=Access, 1=MS SQL, 2=MySQL, 3=SQLite, 6=PostgreSQL

Encrypted = 0/1

Store all connection settings encrypted in the INI file. E.g.: Server name, user name, etc.

loginworkplace = OFFICE

When starting the program and using the working time module, the working time is started by setting the work location to "Office".

 

SQL Server

Parameter name

Description

Server name

Name of the database server instance of the MS-SQL server, e.g., DBSERVER\SQLEXPRESS2008

Database name

Name of the database on the database server, e.g., XT

Username

User name for logging on to the MS-SQL server

Pass

Password for logging in to the MS-SQL server (encrypted)

SecuritySQL = 0/1

Login mode for the database server (0 = integrated login, 1 = login via username and password)

Encrypt = 0/1

Encrypt data transfer (0 = off, 1 = on)

Mars = 0/1

Use Mars (0 = Off, 1 = On)

Protocol = 0/1/2

Connection protocol (0 = Automatic, 1 = TCP, 2 = Named Pipes)

 

MySQL server

Parameter name

Description

Server name

Name or IP of the MySQL server database server, e.g., DBSERVER

Database name

Name of the database on the database server, e.g., XT

Username

User name for logging in to the SQL server

Pass

Password for logging in to the SQL server (encrypted)

Port

Connection port of the server (default = 3306)

UseSSL = 0/1

Encrypt data transfer (0 = Off, 1 = On)

KeepConnection = 0/1

Keep DB connection open (0 = Off, 1 = On)

VendorLib

Path and name of the DLL for database drivers. If a specific MySQL version is to be addressed, e.g., libmySQL.dll

 

PostgreSQL

Parameter name

Description

Server name

Name or IP of the database server of the PostgreSQL server, e.g., DBSERVER

Database name

Name of the database on the database server, e.g., XT

Username

User name for logging in to the SQL server

Pass

Password for logging in to the SQL server (encrypted)

Port

Connection port of the server (default = 5432)

 

[Access]

Parameter name

Description

Database name

Name of the Access database file, e.g., C:\Program Files\XpertTimer\xt.mdb

Username

User name for logging into the Access database (default=admin)

Pass

Password for logging into the Access database (encrypted, default=[blank])

 

[SQLite]

Parameter name

Description

Database name

Name of the SQLite database file, e.g., C:\Program Files\XpertTimer\xt.sqlite

Username

User name for logging into the access database (default=admin)

Pass

Password for logging into the SQLite database (encrypted, default=[blank])

 

[Messaging] (Messaging is used to display notifications for new projects and when working with tasks.)

Parameter name

Description

enabled

0 = disabled; 1 = enabled

interval

By default, the interval is set to 5 seconds. You can set the interval to whatever you want. To do this, write interval = 100 if you want the interval to be 100 seconds.

 

Individual adjustments to the report header

To customize the reports generated by the Xpert-Timer system, you must adjust the XpertTimer.ini file accordingly.

If you want to make a change to the report, write the desired designation after "Istgleich".

For example:

[ReportOptions]

ReportHeader_User=Name

ReportHeader_Client=

ReportHeader_Project=

ReportHeader_DateRange=

ReportHeader_Filter=
 

The default

For users, the report shows: Employees. However, in the example above, the Xpert-Timer user wants to display "Name" instead of "Employees" in their printout.
For clients, the report shows: Customers
. For projects, the report shows: Projects
. For date ranges, the report shows: Time period
. For filters, the report shows: Selection.

If you want to customize the titles of the reports, you can also manage this centrally in the .ini file. These are the titles of the following lists:

- Working hours
-
Task list - Employee list
- Project list
- Customer list
- History entries

For example:

[ReportOptions]

ReportTitle_Times=Overview of times

ReportTitle_Todo=List of tasks

ReportTitle_Users=

ReportTitle_Projects=

ReportTitle_Clients=

ReportTitle_History=

Individual adjustments in the program

You can use the following commands to rename the columns in the program yourself. These will then also be printed accordingly:

Settings for the "Task list" area

[Columnheaders_TasXTTreeTodoExt]

Col_0=Category

Col_1=ID

Col_2=Completed on

Col_3=Due on

Col_4=Complete from

Col_5=Created on

Col_6=Processed by

Col_7=Creator

Col_8=Status

Col_9=Note

Col_10=Progress

Col_11=Priority

Col_12=Subject

Col_13=Estimated

Col_14=Required

Col_15=Remaining

Col_16=Text

Col_17=Project name

Col_18=Task package

Col_19=Last change

Col_20=Notes

Col_21=Attachments

 

Settings for the "Project list" area

[Columnheaders_TasXTTreeProjectsExt]

Col_0=Project name

Col_1=UP No.

Col_2=Description

Col_3=Project No.

Col_4=Project type

Col_5=Status

Col_6=Quick access

Col_7=Priority

Col_8=Responsible

Col_9=Start

Col_10=End

Col_11=Flat rate

Col_12=Price/unit

Col_13=Unit of measurement

Col_14=Progress

Col_15=Time spent %

Col_16=Disp. mode

Col_17=Security

Col_18=Escalation

Col_19=Time required

Col_20=Time required (team)

Col_21=Time estimated

Col_22=Telephony

Col_23=Deleted on

Col_24=Deleted by

 

Settings for the "Timestamp list" area

[Columnheaders_TasXTTreeTimestampsExt]

Col_0=From / To

Col_1=Break

Col_2=Hours

Col_3=Internal

Col_4=Price

Col_5=Status

Col_6=Employee

Col_7=Project name

Col_8=Task

Col_9=Price/unit

Col_10=Currency unit

Col_11=Comment

Col_12=Location

 

Settings for the "Activity history" area

[Columnheaders_TasXTTreeHistoryExt]

Col_0=Activity

 

Settings for the "Services" area

[Columnheaders_TasXTTreeProjectItems]

Col_0=Service

Col_1=No.

Col_2=Type

Col_3=Project name

Col_4=Category

Col_5=Date of service

Col_6=Billing date

Col_7=Employee

Col_8=Location

Col_9=Purchase price

Col_10=Selling price

Col_11=Quantity

Col_12=Total (purchase price)

Col_13=Total(Selling price)

Col_14=Profit

Col_15=VAT%

 

Settings for the "Reminders" section

[Columnheaders_TasXTTreeReminders]

Col_0=Reminder

Col_1=Priority

Col_2=Object

Col_3=Type

Col_4=Comment

Col_5=Employee

Col_6=Creator

Col_7=Signal

Col_8=Lead time

Col_9=Next reminder