Documentation
Back to website >

Parameters when starting EULANDA

There are several ways to start the program EULANDA®. In addition to command line parameters, a local configuration file for the main program, eulanda.ini, is supported.

Configuration file eulanda.ini

Cross-client settings can be entered in the eulanda.ini file. The file is not necessary for the operation of EULANDA®, as the parameters with the default values are usually completely sufficient. The file eulanda.ini is expected in the same folder as the main program eulanda.exe.

Time-out

The time-out section can be used to set values for different time-outs. This is the time the main program waits for a response from the SQL server before terminating the requested action with an error message.

Argument

[Timeouts]
SqlAction= 60
ReportBuilder= 1200
DefCommandTimeout=30

Description of the parameters for time-outs

SqlAction
Default value =

60
This value determines the time after which one of the server functions in the Extras menu is to be aborted if no response is received from the SQL server. In addition to the conversion functions for orders, these are also the copy functions.
60 is the default value for seconds. Increase this value only cautiously, because if an error occurs, it will only be reported after this time.
ReportBuilder

Default value = 1200

This value determines the time after which a print job is to be terminated if no response is received from the SQL server. This applies in particular to the retrieval of data. For extensive data and complex statistics, it may be necessary to increase the value. However, at 20 minutes (=1200 seconds) it is usually sufficiently high.

DefCommandTimeout

Timeout for some standard commands. (From EULANDA® Version 3.0)

General

argument

[General]
UseSinglePrintIDs=1


Description of the parameters for General

UseSinglePrintIDs
Default value = 1

This value improves SQL processing for"SingleObject" type reports.
According to the current state of knowledge, there is no reason to switch off this optimization.

checks

The Checks section allows you to set checks for SQL logs or firewall settings.

argument

[Checks]
ForceSqlClientProtocol= 1
ForceSqlServerProtocol= 1
ForceOpenFirewallPortForSql= 1
CheckLastBackup=7
VerifyCertificates=1
VerifyCertificatesExpired=1
AdminWarning=1

Description of parameters for checks

ForceSqlClientProtocol
Default value = 1

This value determines whether the"TCP" SQL client protocol is active when the program is started. If the TCP protocol is not active, an attempt is made to activate it.
If the logged on user does not have sufficient rights to the registry and to HKEY_LOCAL_MACHINE, the log cannot be set automatically. In this case the administrator has to set the TCP protocol for the SQL client via the right mouse menu of the EULANDA® start menu; this is described in section Network Installation.
Setting the value"0" does not perform any checks. The complete omission of the value corresponds to the default value.
ForceSqlServerProtocol
Default value = 1

This value determines whether the"TCP" SQL server protocol is active when the program is started. If an MSSQL server is installed on the executing PC and the TCP protocol is not active, the system tries to activate it.
If the logged on user does not have sufficient rights to the registry and to HKEY_LOCAL_MACHINE, the log cannot be set automatically. In this case the administrator must set the TCP protocol for the SQL server via the right mouse menu of the EULANDA® start menu; this is described in section Network Installation.
Setting the value"0" does not perform any checks. The complete omission of the value corresponds to the default value.
ForceOpenFirewallPortForSql

Default value = 1

This value determines whether the firewall is checked at program start if port 1433, which is required for communication with the SQL server, is opened. If an MSSQL server is installed on the executing PC and the TCP protocol is not active, it is tried to activate it for the internal LAN, i.e. to open it. This setting is required for Windows® XP SP2 or higher with integrated Windows Firewall.
If the logged on user does not have enough rights to the registry and to HKEY_LOCAL_MACHINE, the port cannot be opened automatically. In this case, the administrator must manually release the port for the SQL server. This is done in the Control Panel under "Windows Firewall" and is described in the section Network Installation.
Setting the value"0" does not perform any checks. The complete omission of the value corresponds to the default value.
CheckLastBackup
(from 4.3.x)
Default value = 7

When a client is started, EULANDA issues a warning if the last backup was made more than the specified number of days ago.
This information is read from the SQL database"msdb". If there is no read authorization for this database, no error message is issued. To check whether the detection works correctly, you can enter TEST as a value. In this case, a message is always issued.

To switch off the test, NOCHECK can be specified.
VerifyCertificates
(from 4.3.x)

Default value = 1

At program start, the system checks whether the EULANDA program is digitally signed. If the certificate is missing in the EULANDA.EXE, it is very likely that the program is infected by a virus and an error message is displayed:

"The program you started (*.exe) is not digitally signed! A missing certificate indicates a virus infection. Please check your PC immediately with an up-to-date virus scanner, which should always boot from a CD drive".

The remote maintenance supported by EULANDA is also digitally signed. If the remote maintenance is freshly downloaded from the Internet or used from the registry cache, a certificate is also checked for its contents. If the certificate is missing, remote maintenance is not started.

VerifyCertificatesExpired
(from 4.3.x)

Default value = 1

By default, the system checks whether the certificate found has not yet expired. If you enter"0", this check does not apply to a valid date.
AdminWarning
(from 4.3.x)
Default value = 1 As

soon as the user has SQL administration rights, a message is normally issued that he is the database owner and can ultimately bypass all checks (for example, change final invoice prices). With the value 0 this warning can be suppressed.

EulandaProtocolCache

Parameter

[EulandaProtocolCache]

NoCache=0

Description of the parameters for EulandaProtocolCache

NoCache
Default = 0

Using a sophisticated buffer system (cache) significantly speeds up the execution of brief information and other HTML-based Eulanda functions.
The cache is enabled by default (value = 0)Turning off the cache (value=1) is useful during the development phase of customized home pages (Eulanda homepage) etc.


BlobCache

In this section you can change the basic settings of the EULANDA object cache.


argument

[BlobCache]
CacheSize=20000
MaxSmallBlobs=2000

Description of BlobCache parameters

CacheSize
Default value = 10240

The maximum size of the object cache. When the limit is exceeded, the rarely used elements are removed from the cache.
MaxSmallBlobs
Default value = 10000

The maximum number of smallest elements that require less than 100 bytes.

Skin

Starting with EULANDA® Version 2.0 the skin (=skin), i.e. the design of the start menu can be adapted. A skin is a layout designed by designers and provided in a format readable by EULANDA®.

An alternative skin file with the file extension".cnskn" can be specified via the eulanda.ini file.

In addition to the built-in layout of the start menu, EULANDA® also has a simple layout that enables a fast screen structure and is specially designed for use with the terminal server or the remote console. The detection of a terminal session is automatic, so that the switch to the simpler but faster layout is automatic. However, the eulanda.ini file can also be used to specify that the graphical layout should also be used in terminal server sessions.

Advice

Note that when renaming the main program, the eulanda.ini is identical for all EULANDA® programs in the same folder. To get different skins for different EXE files, the main program would either have to be copied to different folders, or skins have to be stored with the name of the main program in the EXE folder with the extension".cnskn".
Skins can be used to display different versions of EULANDA® in different folders.
Argument

[Skin]
Filename= Kromo
IgnoreTerminalserver= 1
LargeItems=1

Description of the parameters for Skin
file name
Default =Default

The specification of"Default" is equivalent to omitting the name. In this case the internal graphical skin is used.
If a skin other than the integrated one is desired, the file name of the skin can be done without path and file extension. In this case the skin file is expected in the folder of the eulanda.exe main program with the file extension".cnskn".

Example 1
Filename= Kromo
Alternatively, the file extension can also be specified.

Example 2
Filename= Krono.cnskn
If the skin file is not saved in the main program folder, the file name can be specified with a fully qualified pathname. For networks, the UNC \\Server\Share etc. should be used and not drive information, as a drive mapping depends on the workstations and can therefore be different.

Example 3
Filename= \\NTSERVER\Prog\Eulanda\Kromo.cnskn

Example 4
Filename= Terminal Server
In example 4 a pseudoskin is given. The simple text skin is always used here. The file is not required in this case, since it is a pseudoskin.
Ignore Terminal Server

Default value = 0

This value specifies that the fully graphical skin should also be used for a recognized session via the terminal server or the remote console.

Example
IgnoreTerminalserver= 1
In this example, the terminal server session is ignored and the same skin is used as for a normal console session.
LargeItems

Default value = 0

This value indicates that the client menu entries in the start menu are displayed with a significantly larger font.
Example
LargeItems= 1
In this example, the font for client names is displayed larger in the Start menu.

If there is no skin entry in the eulanda.ini file, an alternative skin can be specified by specifying the main program. If the main program is called "eulanda.exe", the file "eulanda.cnskn" in the same folder is used if there is no ini entry.

This allows you to use different skins for different EXE names in the same folder.

Common

Further system-related settings

Parameter

[Common]
StartupClient=Mustermann
Blobexe=1
StartupShowLibErrors=0
RegisterGraphicFiles=1
SplashScreenOnTop=1
SplashScreenPosition=CC
StartupClient
available as of 3.0

Default value = (empty)

The specified client is automatically called when the program is started without the Start menu being displayed. This corresponds to the command line parameter"-m", whereby the command line parameter is given priority.
BlobExe

Default value =

1
Determines whether the Eulanda.exe should be imported into the database at startup. It is strongly recommended not to disable this option.
StartupShowLibErrors

Default value =

0
shows possible script errors in the script libraries when starting EULANDA. This option is primarily intended for developers.
RegisterGraphicFiles
available as of 3.5

Default value =

1
Specifies whether Eulanda.exe registers itself as an additional application for the graphics file formats it supports in Windows. If this is not desired, the value "0" must be entered here.
SplashScreenOnTop
available as of 4.0

Default value =

1
Specifies that the graphic (splash screen) that is displayed when the client is initialized is always placed in the foreground. If this is not desired, a value of"0" must be entered.
SplashScreenPosition
available as of 4.0

Default value = CC

Determines where the splash screen should be positioned on the monitor. The first letter determines the vertical position (T=Top, C=Center, B=Bottom); the second letter determines the horizontal position (L=Left, C=Center, R=Right).
ignorecollation
available from 4.3

Default value =

0
Determines whether the SQL server collation check should be performed when the client is started. The correct setting of the sorting is critical for the correct program flow. The test should therefore only be switched off carefully.

PDF

This controls whether and which fonts are to be embedded in the PDF document. This setting is available in Eulanda Version 3.0 and only applicable for internal PDF generation.

Argument

[PDF]
AutoEmbedFonts=0
FontsToEmbed=none

Description of parameters for PDF

FontsToEmbed
Default = Arial

list of fonts separated by semicolons
AutoEmbedFonts

Default value = 1

Proxy

This controls whether a special proxy server should be used for Internet calls. By default nothing has to be entered here, because EULANDA automatically uses the settings of the Explorer.

Argument

[Proxy]
ProxyHttpHost= ProxyHttpsHost=
ProxyFtpHost=
ProxyHttpPort=
ProxyHttpsPort= ProxyFtpPort=
ProxyForceAccount=
ProxyUsername=
ProxyPassword=

Description of the parameters for Proxy

ProxyHttpHost
available as of 4.3

Default value = (without value)The IP number of a proxy server responsible for the HTTP protocol can be entered

here. If the value is missing, the Internet Explorer setting is used.
ProxyHttpsHost
available as of 4.3

Default value = (without value)The IP number of a proxy server responsible for the HTTPS protocol can be entered

here. If the value is missing, the Internet Explorer setting is used.
ProxyFtpHost
available as of 4.3

Default value = (without value)

Here you can enter the IP number of a proxy server that is responsible for the FTP protocol. If the value is missing, the Internet Explorer setting is used.

ProxyHttpPort
available as of 4.3

Default value = (without value)The port number of a proxy server responsible for the HTTP protocol can be entered

here. If the value is missing, the Internet Explorer setting is used.
ProxyHttpsPort
available as of 4.3

Default value = (without value)The port number of a proxy server responsible for the HTTPS protocol can be entered

here. If the value is missing, the Internet Explorer setting is used.
ProxyFtpPort
available as of 4.3

Default value = (without value)The port number of a proxy server responsible for the FTP protocol can be entered

here. If the value is missing, the Internet Explorer setting is used.
ProxyUsername
available from 4.3

Default value = (without value)If the proxy server requires authentication, the user name can be stored here. Since the user name is stored here in plain text, we advise against making this entry.
ProxyPassword
available as of 4.3

Default value = (without value)If the proxy server requires authentication, the password can be stored here. Since the user name is stored here in plain text, we advise against making this entry.
ProxyForceAccount
In planning

Default value = (without value)If the proxy server requires authentication, the user name and password can be requested once at program start, so that the user can enter his data without saving them.

SQL server

argument

[sqlserver]
ValidInstanceNames=eulanda*;SQLEXPRESS;MSSQL*

Description of SQL parameters

ValidInstanceNames
Default value = eulanda*;SQLEXPRESS;MSSQL*

Specifies the server instance names valid for Eulanda. For operations such as restore backup or create a new client, only the appropriate instances are displayed.
Placeholder "*" is allowed. Different search patterns are separated by semicolons

MAPI

Here you can find global settings for email transfer (Windows Mail API).

Argument

[MAPI]
AsyncSend=1

Description of the parameters for MAPI

AsyncSend

Default value = 1

Eulanda is not blocked when an email is sent.

asyncSend=0

Eulanda is blocked until the email is sent. This setting can be useful when sending with david®.

Command line parameters

EULANDA® can be called with command line parameters. The following parameters are currently supported.

-m
EULANDA -m "mustermann"

Call EULANDA with the parameter -m followed by the client name to call the client immediately without the start menu. The client name corresponds to the menu entry of the Start menu.
Piccolink

This parameter can be combined with the parameter -m, so that a link can be defined that calls a specific client incl. radio server.

Example:
EULANDA -m "mustermann" - Piccolink
-xml


This option supplements the autostart command in the settings and takes precedence over its PC name. The autostart via the command line parameter requires that the other values such as COM port etc. are correctly set in the settings

"C:\Programme\EULANDA Software GmbH\Eulanda\EULANDA.exe" -m "mustermann" -xml "C:\eulanda.xml"
Call EULANDA with the parameter -xml followed by the file name. This starts the automatic XML import. This command line parameter works only in conjunction with the parameter"-m", which specifies the client name. This starts EULANDA the client and then the XML import module which imports the XML file.

After the import is executed, EULANDA is automatically terminated. The original file is renamed by saving the file name in parentheses with a sequential number. e.g. EULANDA.XML(2).XML etc.

ADVANCEDADOERRORS

Available as of 3.0


EULANDA

-ADVANCESADOERRORS
This displays additional information for some database errors. This mainly concerns errors that consist of several steps and only the first - possibly irrelevant - message is displayed in Eulanda.

This function should only be activated after consultation with Support, as this may cause other errors to be displayed incorrectly.

File names and extensions

The EULANDA® merchandise management system supports additional files. They can extend, configure or improve the program. In addition there are proprietary (=Eulanda-specific) export and import formats with five-letter file extensions, each starting with".cn".

EULANDA® only requires an installed Microsoft SQL Server on the local PC, the Intranet or the Internet and a single program file, the eulanda.exe, as well as the UDL file created at the first start.

Although some help files are installed during installation, they only contain information for advanced features such as the online documentation help file, the spell checker dictionary file, and so on.

Table for file names

.adl
Default = eulanda.adl

This is the user dictionary. The file is created automatically, either under the default common name eulanda.adl, or under the user name of the logged in user, as soon as own words are added to the dictionary in a spell checker .
.adm

Default value = eulanda.adm

The dictionary file has the file name eulanda.adm. There are approx. 250,000 word entries. The dictionary file is only required if the spell checker is activated in the text module, e.g. in the letter module.

.chm


Default value = eulanda.chm

The file eulanda.chm is the help file for EULANDA®. This is a file in Windows HTML Help format. The file can be loaded and updated via the Internet at any time.

.cnarp
All printouts can be exported in EULANDA® in an own non-changeable archive format. These files can be printed at any time with EULANDA®, but can also be exported into different formats.
.cnlnk

Link files with the file extension".cnlnk" contain a link to a specific record of a specific client. By double-clicking on such a link file the corresponding module (address management, article management, order management etc.) is opened in EULANDA® and the data record matching the link is loaded and displayed.

EULANDA® is to a large extent defined in itself. The behavior of individual fields, the control of the report templates, the information systems, the HTML short info, the scripts like JScript, VBScript, the menus etc. are all defined in the SQL registry.
.cnreg
This registry is a separate system that works similar to the registry of the PC, but is stored in the SQL server.

Areas of the SQL registry can be exported and imported. These files have the file extension".cnreg".
.cnrep

Report templates that are exported have the file extension".cnrep". The format is always upward compatible. Thus a report template exported from an EULANDA® version 6.0 can be imported in version 6.5. Unless otherwise stated, only half a version is guaranteed to be compatible. This means that no form from version 7.0 can be imported into version 6.0. Older versions of forms must then first be imported into the next higher intermediate version, opened there, saved again and exported.

.cnskn
The type of layouts can be changed via skin files. For this EULANDA® supports the file format".cnskn". Skin files can use the name of the program as file name, or can be specified in the configuration file eulanda.ini.
.exe
Default = eulanda.exe

The main program is called eulanda.exe. In a program folder different program versions can exist in parallel, in this case you can simply rename the different versions to other EXE names such as "eulanda60.exe".
.htm
Default value = eulanda.htm

The EULANDA®-Homepage, which is displayed at program start via the module "Home", can be replaced by saving an own htm-file in the EULANDA® program folder.
.html
see

htm
.iniDefault value = eulanda.ini

The program can be configured across clients via the file eulanda.ini. The file is only necessary in exceptional cases and is not required for normal operation.
.mht
Unlike htm or html files, a mht file also contains image information. A mht file can be created via the Internet Explorer using the "Save as" function.
.udl

Default value = eulanda_1 .udl

The udl file is managed by the operating system. This contains information about accessing the database. This includes information such as driver name to access the SQL server; the IP number or the PC name that executes the SQL server; the user name and password to open the database; the database name and various optional settings.

The udl file is approx. 1 KB in size and is created automatically on initial startup after the information for client creation has been requested by EULANDA®.