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_termvalue. 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_termtext. 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_termheading - 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_termvalue is grouped under theenglish_termheading
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_termheading (rather than each maori_term). If you see the example demo search page this will be clearer.