Text/bitmap/Excel/CSV files

Video tutorial

To import external files into PhraseExpress:
  1. Open the main program window.
  2. Highlight the desired target folder in the phrase tree view.
  3. Click Import .
  4. Selected the file to import.

Alternatively, just drag the file(s) into the desired phrase folder of the phrase tree view.

Depending on the import data type, PhraseExpress shows a selection of following options:

Import OptionDescription

A copy of the file contents will be stored within the phrase file.

Benefits:
  • The original file is not required anymore.
  • Pasting is very quick as the file content is embedded with the phrase file and loaded during initial PhraseExpress startup.
Disadvantage:
  • The phrase file size is increased which may slow down the PhraseExpress startup time. To keep the phrase file small, you should avoid embedding too many external files.

PhraseExpress creates a new phrase and links the external file with the macro function. If you call the phrase, the macro will dynamically load the external file and inserts its contents into the target application.

Benefits:
  • The macro function does not require much space in the phrase file.
  • As the external file is loaded at the time of the insertion, you always get the latest contents.
Disadvantages:
  • As the external file is loaded at the time of the insertion, the phrase is inserted with a small delay.
  • You must not move or delete the linked file to keep the link. Links to external files are ignored by PhraseExpress if missing.
  • If you are using the phrase file on another PC, you must make sure that the external file is also accessible via the same link. If using a PhraseExpress Server, this is not critical as the phrase file is centrally stored.

PhraseExpress creates a new phrase and opens the external file/program with the macro function.

Example: If you import a Microsoft Excel .XLS file this way, PhraseExpress will launch Excel and load the Excel spreadsheet.

PhraseExpress can split text or CSV/Excel files and generate a separate for each line. Each line may contain a phrase content and, optionally, an Autotext for that phrase.

Video tutorial

Example: A text file contains a list of words and their abbreviations, each separated by three by three underscore characters as a "separator".

After defining the order of the phrase <-> Autotext, PhraseExpress will create a phrase folder named with the imported text file name and generate a separate phrase per line.

Text file formatting requirements

You may need to tweak the raw data of your text file to allow PhraseExpress scanning the file line-per-line properly:

  • The file must be text without formatting.
  • Each line must consist of a phrase plus optionally an Autotext that is separated by one or more separating characters.
  • The order phrase <-> autotext does not matter but must be consistent for all lines.
  • All separators must be identical.
  • The separator must not be contained in any phrase text or autotext in that file.

PhraseExpress tries to auto-detect the separator. You can manually correct the separator.

Table of Contents


    Table of Contents