Using the Control Centers in Client/Server mode

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / Control Centers / Project Management Hub

Overview
Switching from an HFSQL Classic database to an HFSQL Client/Server database
The different steps are as follows
Implementation
Step 1: Install an HFSQL Client/Server server if necessary
Step 2: Configure the various products to use Control Centers in Client/Server mode
Step 2: Tip
Using the Control Centers in Client/Server mode
Specific features of Client/Server
Managing contributors
Using the Feedback component with the Control Centers in Client/Server mode
Overview
Operations that must be performed in the applications that use the Feedback component

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Using the Control Centers in Client/Server mode

Overview

All the Control Centers provided with WINDEV, WEBDEV and WINDEV Mobile use the same database. This database can be a database in HFSQL Classic format or in HFSQL Client/Server format.

If you are already using the Control Centers, you have the ability to import the HFSQL Classic data into a Client/Server database. In this case, the data form the Control Centers will also be available via the Internet. Therefore, it is easier for the developers to work remotely.

This documentation page explains how to switch from an HFSQL Classic database to an HFSQL Client/Server database.

Important: With a Control Center database in HFSQL Client/Server format:

the "Guest" connection mode of the Control Centers is not available anymore.
the mobile mode is not available for the Control Centers.
all the contributors of Control Centers are defined as users of the HFSQL Client/Server database.
if your WINDEV applications use the "Feedback" component : to forward customer feedback, you need to modify the applications.. This modification is required if you are using the connected mode or ADSL (modification not required if the user feedback is performed by emails). For more details, see Using Feedback in ADSL.

Switching from an HFSQL Classic database to an HFSQL Client/Server database

The different steps are as follows

Install an HFSQL Client/Server server if necessary.
Configure the Control Centers to use the HFSQL Client/Server database.
Note: the HFSQL Client/Server database for Control Centers will be created empty.
Use the Control Centers.

Implementation

Step 1: Install an HFSQL Client/Server server if necessary

To use the Control Centers with an HFSQL Client/Server database, an HFSQL Client/Server server must be installed on a computer. The data files of Control Centers will be installed on this server.

To install HFSQL Client/Server, start your product installation package and click "Setup of HFSQL Client/Server".

Note: The HFSQL Client/Server setup program is also available in the "\Install\HFSQL Server" subdirectory of the WINDEV installation directory.

Step 2: Configure the various products to use Control Centers in Client/Server mode

When the data found in the Control Centers is in HFSQL Client/Server format, all the users of WINDEV, WEBDEV, WINDEV Mobile and/or Control Centers must specify the new format of the database to use.

This indication can be given:

when installing WINDEV, WEBDEV or WINDEV Mobile.
in the options of WINDEV, WEBDEV or WINDEV Mobile:
- On the "Home" tab, in the "Environment" group, expand "Options" and select "WINDEV/WEBDEV/WINDEV Mobile general options".
- On the "User" tab, click the "Parameters of Control Centers" button.
or in the Project Management Hub parameters: pull down then select "Options".

All you have to do is specify:

the database in HFSQL Client/Server mode.
the server name or IP address.
the port used.
the database used.

Once the access to the data of the Control Centers is configured, you can use the Controls Centers just as you would in HFSQL Classic mode.

Step 2: Tip

To simplify the configuration of the different computers that use the Control Centers, you have the ability to create a .reg file that can be run by each user on his computer.

This .reg file must contain the following information:

[HKEY_CURRENT_USER\Software\PC SOFT\CControle\30.0]
<ModeHF_CS>=dword:00000001

[HKEY_CURRENT_USER\Software\PC SOFT\CControle\30.0\ConnexionHF]
<ServeurConnexionHF_CS>=<Server name>
"BaseConnexionHF_CS"=<Database name>
"PortConnexionHF_CS"=dword:0000<Hexadecimal port value>

To find out the hexadecimal value of the port, open the Windows calculator (calc.exe) in scientific mode, enter the decimal value of the port (4988 for example) and click "Hex". The hexadecimal value is displayed (137C in our example).

Using the Control Centers in Client/Server mode

Specific features of Client/Server

In Client/Server mode:

The "Guest" mode is not available.
The mobile mode is not available for the Control Centers.

For security reasons (especially when using an ADSL connection), we recommend that you change the password of the administrator accounts. All the accounts must have a password.

Managing contributors

Two groups are automatically created on the HFSQL Client/Server server:

"Contributors of Control Centers".
"Administrators of Control Centers".

The rights granted to these groups are configured for using the Control Centers in Client/Server mode. These two groups have the rights to create files.

If an HFSQL Classic database was imported and if "Add the contributors of Control Centers to the list of users of the HFSQL server" was checked:

the contributors with administrator rights are automatically associated with the "Administrators of Control Centers" group,
the other contributors are automatically associated with the "Contributors of Control Centers" group.

If a new HFSQL Client/Server database was created or if "Add the contributors of Control Centers to the list of users of the HFSQL server" was not checked, the following screen will be displayed when the contributors establish the connection:

This screen also appears if a new user tries to log in.

This screen is used to:

Retype name/password: in the event of a login error.
Create account Exist: in the case of a new user, or if existing contributors are not imported. In this case, the new contributors with administrator rights are automatically associated with the "Administrators of Control Centers" group and the other new contributors are automatically associated with the "Contributors of Control Centers" group.
Work in restricted mode: allows you to work with a local database (in the event of a network problem, a problem with the HFSQL server, etc.).. Please note: not all information entered in this mode will be transferred to the Control Center database.

Using the Feedback component with the Control Centers in Client/Server mode

Overview

The Feedback component included in your applications allows the users to easily send notes and suggestions about your application. These messages can be sent:

in connected mode If WINDEV, WEBDEV or WINDEV Mobile is installed on the user's workstation and Control Center data is accessible, suggestions and malfunctions will be immediately recorded in the "Customer Feedback" spool of your application (if registered in the Project Management Hub).
in offline mode (by e-mail): In all other cases, suggestions and malfunctions will be sent by e-mail to the address of your choice.. The Project Management Hub allows you to retrieve the emails sent in order to save them in the "User feedback" spool of your application.

If you are using the online mode, a modification must be made to your applications in for the Control Centers to be managed in Client/Server mode.

This modification must be performed just after switching the database of Control Centers to Client/Server mode. All the applications must be updated at the same time to prevent from using the HFSQL Classic and HFSQL Client/Server databases simultaneously.

For the network applications, we recommend that you "Force the update".

Operations that must be performed in the applications that use the Feedback component

If your application uses the UMC, disable the use of Hxxx functions in the UMC (uncheck "Allow the use of HFSQL read commands", e.g., in the executable creation wizard).

If your application uses an automatic menu, the setting must be modified in order to access the Client/Server database of Control Centers. To do so:

Display the window that uses the automation menu: under the "Window" pane, in the "Bars and menus" group, scroll down to "Main menu" and select "Open '?' menu".
Edit the code of "Send a suggestion, an incident, a business rule" option.
Modify the line of code used to specify the path of the data files. To use the Control Centers in Client/Server mode, the new line of code to use is as follows:
pFeedback.Configure(fbPathCCData, ...
"hfcs://<user>:<password>@<server>:<port>/<database>")

In this code:
- <utilisateur>: Name of a user on the HFSQL server.
- <mot de passe> Password associated with the user.
- <serveur>: IP address or server name where the HFSQL server and Control Center database are installed.
- <port>: Server port.
- <base de données> HFSQL Client/Server database name corresponding to Control Center data files.

Note: if you update your application's automation menu, this line of code will be automatically updated with the current developer's name.

If your application uses the Feedback component directly, the configuration of the path of data files must be modified (Configure method of the component, with the fbPathCCData parameter). See above.