Aboriginal Languages of Australia
©Jeremy Steele
Contact Jeremy
Aboriginal Languages of Australia - Bayala Database
Aboriginal Languages of Australia - Bayala Database
Aboriginal Languages of Australia - Bayala Database
Aboriginal Languages of Australia - Bayala Database
Aboriginal Languages of Australia - Bayala Database

13. SETTING UP A BAYALA DATABASE

On deciding to create a database, the first thing to do it to create the fields.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Fig. 13.1 A few of the fields in the ALLSYD database

 

 

 

 

In the illustration above some of the field in use in the ALLSYD database can be seen.

After the fields have been created, changes by addition, amendment and deletion can occur at any time. 

Layouts can then be made, to display the fields in any desired arrangement. In the case of the Bayala databases, colours were added to help distinguish between the many columns used.

Many databases are simple, but not so the Bayala databases, which were able to become increasingly useful through relationships. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Fig.13.2 Relationships structure of the ALLSYD database

 

The above illustration reveals the relationships that enable the ALLSYD database to work. The green rectangles to the upper left control the eight Elaboration bars, the yellow rectangles below control theJSM links in the LINKS layout, and the brown rectangle below the control the NoH links in the same layout.  Each of these is connected to the ALLSYD database, which is the tall grey rectangle in the centre on the illustration.

On the right are the various other relationships — for searching, geographical purposes, for the transcription keys. Others control the pictures, the source details, and the special characters.

 

 

MAKING A SEARCHER PANEL WORK

 

 

 

 

 

 

 

 

 

Fig. 13.3 Layout for the ALLSYD SEARCHER NoH

 

 

 

Once a layout has been created, it is necessary link all the constituent blank fields to the appropriate field name in the relational link concerned (here, ALLSYD SEARCHER NoH).

If it is done correctly, something like the following will result:

 

 

 

 

 

 

 

 

 

Fig. 13.3 ALLSYD SEARCHER NoH in use: in the bottom right, the word ‘wara’ was entered

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Fig. 13.5 ALLSYD SEARCHER NoH in use: next, the word ‘bada’ was entered

 

 

SUMMARY LINES

Summary lines have been described earlier, created by the key combination ‘option-shift-Z’. This was used to create:

"Pattadiou" bada-dya-wu = "I eat or have eat [eaten]" eat did I: Anon (c) [c:19:10] [BB]

for the first record in the illustration immediately above. But how does this happen?

It is the result of coding in a program ‘QuicKeys’. The programming is the following:

 

tell application "FileMaker Pro"

set Australian_field to cellValue of cell named "Australian" of current record

set suffixDFX1_field to cellValue of cell named "suffix DFX 1" of current record

set suffixDFX2_field to cellValue of cell named "suffix DFX 2" of current record

set suffixDFX3_field to cellValue of cell named "suffix DFX 3" of current record

set suffixDFX4_field to cellValue of cell named "suffix DFX 4" of current record

set suffixDFX5_field to cellValue of cell named "suffix DFX 5" of current record

set suffixDFX6_field to cellValue of cell named "suffix DFX 6" of current record

set suffixTENSE_field to cellValue of cell named "suffix TENSE" of current record

set qualifier_field to cellValue of cell named "qualifier" of current record

set suffixPRONOUNNOM_field to cellValue of cell named "suffix PRONOUN NOM" of current record

set suffixPRONOUNACC_field to cellValue of cell named "suffix PRONOUN ACC" of current record

set suffixPRONOUNNOMpost_field to cellValue of cell named "suffix PRONOUN NOM post" of current record

set suffix1_field to cellValue of cell named "suffix 1" of current record

set suffix2_field to cellValue of cell named "suffix 2" of current record

set suffix3_field to cellValue of cell named "suffix 3" of current record

set nohyphens_field to cellValue of cell named "no hyphens" of current record

set English_field to cellValue of cell named "English" of current record

set EnglishJSmain_field to cellValue of cell named "English JS main" of current record

set EnglishJSDFXtense_field to cellValue of cell named "English JS DFX tense" of current record

set EnglishJSadj_field to cellValue of cell named "English JS adj" of current record

set source_field to cellValue of cell named "source" of current record

set notebook_field to cellValue of cell named "notebook" of current record

set page_field to cellValue of cell named "page" of current record

set line_field to cellValue of cell named "line" of current record

set langshort_field to cellValue of cell named "langshort" of current record

if suffixDFX1_field is not equal to "" then

set suffixDFX1_field to "-" & suffixDFX1_field

end if

if suffixDFX2_field is not equal to "" then

set suffixDFX2_field to "-" & suffixDFX2_field

end if

if suffixDFX3_field is not equal to "" then

set suffixDFX3_field to "-" & suffixDFX3_field

end if

if suffixDFX4_field is not equal to "" then

set suffixDFX4_field to "-" & suffixDFX4_field

end if

if suffixDFX5_field is not equal to "" then

set suffixDFX5_field to "-" & suffixDFX5_field

end if

if suffixDFX6_field is not equal to "" then

set suffixDFX6_field to "-" & suffixDFX6_field

end if

if suffixTENSE_field is not equal to "" then

set suffixTENSE_field to "-" & suffixTENSE_field

end if

if qualifier_field is not equal to "" then

set qualifier_field to "-" & qualifier_field

end if

if suffixPRONOUNNOM_field is not equal to "" then

set suffixPRONOUNNOM_field to "-" & suffixPRONOUNNOM_field

end if

if suffixPRONOUNACC_field is not equal to "" then

set suffixPRONOUNACC_field to "-" & suffixPRONOUNACC_field

end if

if suffixPRONOUNNOMpost_field is not equal to "" then

set suffixPRONOUNNOMpost_field to "-" & suffixPRONOUNNOMpost_field

end if

if suffix1_field is not equal to "" then

set suffix1_field to "-" & suffix1_field

end if

if suffix2_field is not equal to "" then

set suffix2_field to "-" & suffix2_field

end if

if suffix3_field is not equal to "" then

set suffix3_field to "-" & suffix3_field

end if

set cell named "word for word JS" of current record to quote & Australian_field & quote & tab & nohyphens_field & suffixDFX1_field & suffixDFX2_field & suffixDFX3_field & suffixDFX4_field & suffixDFX5_field & suffixDFX6_field & suffixTENSE_field & qualifier_field & suffixPRONOUNNOM_field & suffixPRONOUNACC_field & suffixPRONOUNNOMpost_field & suffix1_field & suffix2_field & suffix3_field & " =" & tab & quote & English_field & quote & tab & EnglishJSmain_field & space & EnglishJSDFXtense_field & space & EnglishJSadj_field & ":" & tab & source_field & " [" & notebook_field & ":" & page_field & ":" & line_field & "] [" & langshort_field & "]"

end tell