PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Switching from a HFSQL Classic database to a HFSQL Client/Server database
  • The different steps are as follows
  • Implementation
  • Step 1: Installing a HFSQL Client/Server server if necessary
  • Step 2: Transfering (if necessary) the HFSQL Classic database (optional)
  • Step 3: Configuring the different products for using the Control Centers in Client/Server mode
  • Step 3: 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
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Using the Control Centers in Client/Server mode
Overview
All the Control Centers supplied 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 found in the Control Centers will also be available via ADSL. Therefore, it is easier for the developers to work remotely.
This documentation page explains how to switch from a HFSQL Classic database to a HFSQL Client/Server database.
Important:
  • The data found in the Control Centers in HFSQL Client/Server will be accessible from WINDEV 11, WEBDEV 11 and WINDEV Mobile 11 version 110040 or later. This data cannot be handled by the earlier versions (WINDEV, WEBDEV and WINDEV Mobile version 9 or 10).
  • With a database of Control Centers 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 is using the "Feedback" component: to manage the user feedback, the applications must be modified. This modification is required if you are using the connected mode or ADSL (modification not required if the user feedback is performed by emails). See Using Feedback in ADSL for more details.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Switching from a HFSQL Classic database to a HFSQL Client/Server database

The different steps are as follows

  1. Install a HFSQL Client/Server server if necessary.
  2. Transfer the HFSQL Classic database of Control Centers into a new HFSQL Client/Server database. This step is optional. The import is required only if you are already using a database for the Control Centers.
    If no data is transferred, the HFSQL Client/Server database for the Control Centers will be created empty.
  3. Configure the Control Centers to use the HFSQL Client/Server database.
  4. Use the Control Centers.
Implementation

Step 1: Installing a HFSQL Client/Server server if necessary

To use the Control Centers with a HFSQL Client/Server database, a HFSQL Client/Server server must be installed on a computer. The data files of Control Centers will be installed on this server.
To install a HFSQL Client/Server server, start the setup DVD of your product and click "Install the HyperFileSQL Client/Server server".
Note: In WINDEV, the setup program of a HFSQL Client/Server server is supplied in the "\Install\HyperFile server" sub-directory of the setup directory of your product.
To install a HFSQL Client/Server server, start the setup DVD of your product and click "Install the HFSQL Client/Server server".
Note: In WINDEV, the setup program of a HFSQL Client/Server server is supplied in the "\Install\HFSQL server" sub-directory of the setup directory of your product.

Step 2: Transfering (if necessary) the HFSQL Classic database (optional)

To transfer the data from the existing HFSQL Classic database to a new HFSQL Client/Server database:
  1. Select "Tools .. Options .. General options of WINDEV/WEBDEV/WINDEV Mobile".On the "Home" pane, in the "Environment" group, expand "Options" and select "General options of WINDEV/WEBDEV/WINDEV Mobile".
  2. In the "User" tab, click the "Parameters of Control Centers" button.
  3. In the window that is displayed, click the "Import wizard" button.
  4. The wizard for importing data starts.
    Wizard for importing data
  5. In this wizard, specify:
    • the directory containing the HFSQL Classic data files. The current path is proposed by default. This path can be modified if necessary.
    • the characteristics of the HFSQL Client/Serveur server to use:
      • the name or IP address of the server.
      • the name of the HFSQL Client/Server database to use. This database must be empty (without files) or not found (in this case, it will be automatically created).
      • the port that will be used for the connection.
    • the login and password of an administrator of the HFSQL Client/Server database. Indeed, the data can only be imported by an administrator (who has the rights to create files, ...).
      Note: By default, the administrator of a HFSQL server has "admin" for login and no password.
    • the option "Add the contributors of Control Centers to the list of users of the HyperFileSQL server" allows you to automatically identify all the contributors via their login and password in the HFSQL Client/Server database.the option "Add the contributors of Control Centers to the list of users of the HyperFileSQL server" allows you to automatically identify all the contributors via their login and password in the HFSQL Client/Server database.
      If this option is not checked, a new account will have to be created for each contributor when using the Control Centers with the HFSQL Client/Server database.
      If this option is checked, two groups of users are created on the HFSQL server: "Contributors of Control Centers" and "Administrators of Control Centers". These two groups automatically have the necessary rights to use the database of Control Centers in HFSQL Client/Server mode.
  6. Validate.
The import is started. During the import, the files of the Control Centers are automatically locked. This operation can take quite a long time.

Step 3: Configuring the different products for using the 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 ("Tools .. Options .. General options of WINDEV/WEBDEV/WINDEV Mobile", "User" tab, "Parameters of Control Centers" button).in the options of WINDEV, WEBDEV or WINDEV Mobile:
    • On the "Home" pane, in the "Environment" group, expand "Options" and select "General options of WINDEV/WEBDEV/WINDEV Mobile".
    • In the "User" tab, click the "Parameters of Control Centers" button.
  • in the parameters of the Project Monitoring Center ("Parameters .. Options of Project Monitoring Center").in the parameters of the Project Monitoring Center: expand Menu of Project Monitoring Center and select "Options".
All you have to do is specify:
  • the database in HFSQL Client/Server mode.
  • the name or IP address of the server.
  • the port used.
  • the database used.
  • the shared directory used by the Document Management Center and by the Reusability Center. Indeed, these two Control Centers use a directory to share the created documents. These two Control Centers cannot be used if this directory is not specified. Caution: These two Controls Centers cannot be used via ADSL.
Once the access mode to the data of Control Centers is configured, the Control Centers are used according to the same method.

Step 3: 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\23.0]
<ModeHF_CS>=dword:00000001


[HKEY_CURRENT_USER\Software\PC SOFT\CControl\23.0\HFConnection]
<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.
  • The Document Management Center and the Reusability Center cannot be used via ADSL.
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 a HFSQL Classic database was imported and if "Add the contributors of Control Centers to the list of users of the HFSQL server" was checked:If a 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: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:
Unknown user
This screen is also displayed when a new contributor is trying to establish a connection.
This screen is used to:
  • Re-enter the name/password: if an error occurred during the identification.
  • Create the account: for a new user or if the existing contributors were 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 (network problem, problem with the HFSQL server, ...). Caution: the information entered in this mode will not be applied to the database of Control Centers.
Using the Feedback component with the Control Centers in Client/Server mode
WINDEV

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 online mode: If WINDEV, WEBDEV or WINDEV Mobile is installed on the user computer and if the data of Control Centers is accessible, the suggestions and the incidents will be immediately saved in the "User Feedback" spool of your application (if this one is saved in the Project Monitoring Center).
  • in offline mode (by emails): In the other cases, the suggestions and the incidents will be emailed to the address of your choice. The Project Monitoring Center 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".
WINDEV

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

If your application is using the UMC, disable the use of the Hxxx functions in the UMC (uncheck "Allow the use of HFSQL read commands", in the wizard for executable creation for example).
If your application is using an automatic menu, the setting must be modified in order to access the Client/Server database of Control Centers. To do so:
  1. Display the window that is using the automatic menu and select "Windows .. Main menu .. Open the '?' menu".Display the window that is using the automatic menu: on the "Window" pane, in the "Bars and menus" group, expand "Main menu" and select "Add the '?' menu".
  2. Edit the code of "Send a suggestion, an incident, a business rule" option.
  3. Modify the code line used to specify the path of the data files. To use the Control Centers in Client/Server mode, the new code line to use is as follows:
    pFeedback.Configure(fbPathCCData, ...
    "hfcs://<user>:<password>@<server>:<port>/<database>")
In this code:
  • <user>: Name of a user of the HFSQL server.
  • <password>: Password associated with the user.
  • <server>: IP address or name of the server where the HFSQL server and the database of Control Centers are installed.
  • <port>: Server port.
  • <database>: Name of the HFSQL Client/Server database corresponding to the files of Control Centers.
Note: if you update the automatic menu of your application, this code line will be automatically updated with the name of the current developer.
If your application directly is using the Feedback component, the configuration of the path of data files must be modified (Configure method of the component, with the fbPathCCData parameter). See above.
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment