Spreadsheet Information

Describes the source CSV spreadsheet structure/columns in more detail

Example spreadsheet: https://docs.google.com/spreadsheets/d/1ZIgksxaZMqpyEy_PbiB3ACWfXCFlOyTsD0Es3wCRHLc/edit?gid=0#gid=0

Spreadsheet columns description:

english_search_term

• The values in this column matches the users search query and is the word that appears in the search dropdown.
• All rows that share the same column text are shown together in the results page for that search.
• Example: I have three rows with the english_search_term "Doctor". When the user searches for "Doctor" the info in all those rows will be shown on the results page.

english_term

• This is the English term that is shown as a heading in the results page.
• Normally this will be the same word as the english_search_term value. In fact, if you are feeling lazy you can leave this column blank and it will use the english_search_term as a default.
• However it doesn't have to be the same text. This gives more flexibility:
• Firstly it allows the heading in the result page to be different from the Search term.
• More usefully, different rows can have different english_term text. If they do, then the results are grouped under seperate headings, one for each english_term.
• Example: I have multiple rows for the search term "Doctor". But I would like the results to be grouped under two different headings, so I use different english_term values to do this: "Doctor (Medical)" and "Doctor (Phd)"

english_term_description

• This optional text appears under the english_term heading
• Note in the case where there are multiple rows with the same english_term, only the first english_term_description in the spreadsheet will be shown.

maori_term

• Each maori_term value is grouped under the english_term heading

maori_term_description

• Optional description text for the maori_term

maori_audio_url

• This is the filename of the audio file (audio files can be uploaded on the admin page). The audio filename can be any text (or number if preferred). Audio files should always have the ".mp3" extension. In the spreadsheet the extension can be optionally omitted. For example if the uploaded audio filenames are "1.mp3", "2.mp3", "3.mp3 the column values can be "1", "2", "3" etc.

english_term_tags

• Tags are currently attached to each english_term heading (rather than each maori_term). If you see the example demo search page this will be clearer.