Valency Database
Help page

(Last updated: 18 November 2010)

Click here for the main page of the...

Leipzig Valency Classes Project

Page contents

Download & Setup............   Download > Extract > Open > Enter user name > Set default language > Start work
The Basics.........................   Navigation | Creating new records | Selecting / creating new related records | Colour-coding of fields
Inserting Special Characters    
Backing up / Submitting data    
The Project Manual    

Download & Setup

Steps: Download > Extract > Open > Enter user name > Set default language > Start work

1.Download the Windows version (~20MB) or the Mac version (~30MB).  [Version: v0.28]

Tip: If prompted by your browser to Open or Save the file, select Save, and save to your desktop.

Note: Although FileMaker is not required to work with the Valency database, if you have FileMaker Pro 10 or above installed you can download the much smaller database file (<1MB) on its own instead.  Also note: Earlier versions of FileMaker Pro - between 7 and 9 - will also open the database file but with reduced functionality.

1b.If it's not already installed, download and install the Charis SIL font. Charis SIL is free and is used in some fields of the database for displaying IPA characters (in particular, the Example text fields and the Verb form field).
2.Extract / unzip the downloaded file to anywhere on your hard drive (perhaps to your desktop).

Tip: Under Windows, extraction usually involves (a) double-clicking the zip file to open it, (b) dragging the Valency folder out to your desktop, and (c), importantly, closing the zip file window to avoid inadvertently working with files within it.  Under Mac OS, extraction usually happens automatically when you double-click the zip file.

3.Open the extracted Valency folder and then double-click !open_Valency to Open the database.  Note that when opening the database for the first time, there may be some delay before any window appears.  [FileMaker Pro users can directly double-click on Valency.fp7.]

4.You may (or may not) be prompted to Enter your user name.  Enter any name you wish (your real name is the most practical choice) and then click OK.
5.You will then be prompted to Set your default language. At the prompt click OK.

a) If your language appears in the pre-defined list, select it.
b) If your language isn't listed, click the new button, click OK, and enter your language name.

6.Click the Meanings button at the top of the layout. This will navigate you to the Meanings layout where you can Start work by creating new verbs for each meaning. To create a new verb record, click the new button adjacent to the Verbs portal. Once verb information is entered, click Back (or the Meanings button) to return to the Meanings layout and proceed to the next meaning.

The Basics

Navigation | Creating new records | Selecting / creating new related records | Colour-coding of fields


Creating new records

To create a new Record in the current table (e.g. a new Verb record in the Verbs layout), select Records > New Record (or press Ctrl/Option + N).

Selecting / creating new related records

To link a record in one table (for example, a Meaning) with a record in another table (for example, a Verb), click the select button adjacent to the relevant field.

If the item doesn't yet exist (i.e. isn't listed), click the new button instead. This will navigate you to the home layout of the new item, where you can complete its required fields before returning to the original layout; either by clicking Back or the relevant button in the navigation bar.

In cases where the relationship is many-to-many (as in the Meanings-Verbs example) you can link as many related records as you wish, by clicking select on subsequent rows in the portal (or by clicking new again).

In other cases, where the relationship is one-to-one or many-to-one, only one selection is allowed. An example is the selection a Coding frame schema for a particular Verb.

Colour-coding of fields

White field
  • Required
  • Should be complete for each record
Light yellow field
  • Optional
Home-layout coloured field
  • Field from a related table
  • Not modifiable on current layout
  • Modifiable on its home layout (where it will appear white). To access the home layout click the adjacent go button.
  • If no value exists, click the adjacent select button. If item isn't listed, click new.

Inserting Special Characters

To insert a special character (such as an IPA character) the database includes an Insert character function.

1.Select menu item Scripts > Insert character (or press Ctrl/Option + 1). The Insert character window should appear.
2.To search for your character, click the Find button, enter your search criteria, then click Find again. Tip: You can search the Unicode name field, the Unicode block name field, or within the character field itself. Searching on e in the character field, for instance, will result in a list of all characters based on the letter 'e'.

3.Once you've found your desired character place your cursor in the target field and click Insert.

Tip: To have the Insert character function start by displaying a short list of preferred characters, check each desired character's Favourite checkbox.

Backing up / Submitting data

1.Select menu item Scripts > Backup... and click OK at the prompt.
2.After a brief delay while the data is prepared, a dialogue box should appear. Type any file name, select any location, and click Save.
 To submit your data you only need to send this newly-created (and more compact) snapshot file.

Tip: At the dialogue box you can additionally select Create email with file as attachment. Depending on your email system and configuration, this function may or may not work. If it doesn't, manually attach the file to your email.

The Project Manual

The Project Manual provides detailed information on how to complete the questionnaire.

Page location: