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.