This documentation refers to PhraseExpress v17 beta. The documentation for the production version 16 is available here.

Generate phrases from database

PhraseExpress can generate a folder with phrases based on the query output of an external Microsoft Access/SQL/MySQL database.

This feature is targeted to advanced users with sufficient database management skills. If you do not know how to create a database query, please pass this feature and consider to import phrases from a CSV file.

To generate phrases from a database:
  1. Click the small triangle underneath the "Import" button in the main menu and select "Database" from the drop-down menu:

  2. Select the database type and fill in the fields:

  3. To dynamically link the data source with PhraseExpress, enable option "Dynamic link". PhraseExpress will query the database and update the phrases each time you restart the program.

  4. Press OK to start the import.

PhraseExpress connects to the database, executes the query, creates a phrase folder and creates a phrase for each record of the specified query.

If you select "Dynamic link", the database is required each time you restart the PhraseExpress client. If the database is not available, PhraseExpress uses a cached version of the last known content.

To embed specific data from a database into a phrase, check out the macro to embed database data.

System requirements

Reading from 3rd party databases require specific drivers:

  • Microsoft Access: Microsoft Access Driver (*.mdb)" x86 ODBC driver. To install the 32-bit version instead of 64-bit, use the command line parameter /passive.
  • Microsoft SQL: Microsoft SQL NativeClient (Download)
  • MySQL: LibMySQL.dll (Copy this file into the PhraseExpress program directory)

Table of Contents

Table of Contents