This documentation refers to PhraseExpress v17 beta. The documentation for the production version 16 is available here.
Configuration
The PhraseExpress SQL Client Manager is your central hub to manage users, clients and licenses.
While running, the SQL Client Manager allows clients to find the SQL database on the network (via UDP broadcast polling). The SQL Client Manager also optionally sends email status notifications.
Monitor tab
The tab shows status information and all clients with a license key association:
Use the SHIFT- and CTRL-keys to highlight multiple users in the list.
Right-click the title bar of the user list to add/remove columns.
Click a column title to sort the users in the list. Click again to invert the sorting order.
Right-click on one of the column headers in the monitor to show or hide additional columns.
Monitor columns
Right-click the title bar of the user list to add/remove columns.
Click a column title to sort the users in the list. Click again to invert the sorting order.
| Column | Description |
|---|---|
Check boxes in column "W" (for "write access") define whether a client is generally allowed to edit phrases. If unchecked, options to add/remove/edit phrases are disabled in that client to prevent operating errors. This global write permission setting overrides any folder-based access permissions configured in the clients. To change settings for all clients in one go, (un)check the check box in the title row and transfer this setting with the Set button. The check boxes in the title bar also define the default settings for new clients connecting for the first time. If you uncheck the "W" check box in the title bar, any client connecting for the first time will have no write access to the phrase file by default. Do not revoke write access while a user is editing a phrase as the change would be lost. Clients are updating this setting in intervals, which can be configured in the client's configuration file (tag <Network><SQLPingInterval>). If zero, or if the client has a locally registered license, this setting is retrieved on client launch only. | |
The check boxes in the column "C" (for "configuration") define whether a client can access program settings. If unchecked, access to program settings is disabled to prevent configuration errors. To change settings for all clients in one go, (un)check the check box in the title row and transfer this setting with the Set button. The check boxes in the title bar also define the default settings for new clients connecting for the first time. If you uncheck the "C" check box in the title bar, any client connecting for the first time will have no write access to the phrase file by default. Clients are updating this setting in intervals, which can be configured in the client's configuration file (tag <Network><SQLPingInterval>). If zero, or if the client has a locally registered license, this setting is retrieved on client launch only. | |
If the check mark in column "P" is set, a personal phrase folder will be created with the next restart of the respective PhraseExpress Clients, if such folder does not exist yet. In this phrase folder users can store individual phrases to which only he has access: If the check mark is removed, personal phrase folders are no longer created on the corresponding clients. Any existing personal phrase folder will be deleted on the client if it empty. If the personal folder is not empty, it will remain to protect against data loss. If desired, it must be deleted manually. | |
Licensed: The client has successfully received a license from the SQL license database. | |
| Demo: The client has no license and is running in demo or freeware mode. | |
Local License: The client is registered locally and does not require a license from the central license pool (if any). | |
The SQL Client Manager can enable collecting the time and money saved by PhraseExpress for each PhraseExpress client. The money savings doesn't reflect different currencies. |
Release unused licenses
- Exit PhraseExpress for the users, you wish to remove from the list of users.
- Select the users you wish to remove from the list.
- Click the button "".
The license returns to the pool of available licenses and can be occupied by the next client connecting to the server.
A removed user will take a license if his client is launched again. To prevent that, remove PhraseExpress on his computer or disable autostart.
Master user
Master users have following extra rights:
- The Master can access all phrases regardless of any access restrictions.
- The Master can redefine the owner of any phrase (via the client access restrictions dialog).
To elevate one or more users to a master user:
- In the SQL Client Manager, switch to the "Monitor" tab.
- Right-click the user you wish to become the master and select the corresponding context menu option:
The selected user becomes the master users and appears in bold text. If the master controls the configuration for all users, the user is emphasized in the list as bold green text.
Central Master Configuration
The PhraseExpress client program settings of one of the master users can be applied to other clients:
- Right-click one of the master user and select the corresponding context menu option. If the Master user provides the central configuration appear, he appears in bold green text:
- Withdraw configuration rights to all users, who shall use the program settings of the master user by unchecking the the "C" column for those users.
The selected users will use the master client program settings with the next start of their PhraseExpress clients. As they do not have configuration permission, they cannot alter the master user program settings.
Database Tab
Tab "" provides overview about the SQL database. You can create a configuration file that contains connection information for the clients:
To create a new database or to load an existing one:
- Switch to the tab "" in the SQL Client Manager
- Press button "Configure".
- Define an administrator account that is used to authorize access to the SQL Client Manager.
- Optionally change the field path to the SQL database. The database must be located on the server computer running the SQL server.
- Press to create the phrase and license database.
If you never changed the phrase file location on the clients (e.g. after initial installation) and if the clients can access the SQL Client Manager via UDP, the SQL Client Manager will transmit the SQL database location and PhraseExpress for Windows clients will load the SQL database automatically.