| Table of Contents |
|---|
...
✅ "1_go-danrecording_martha_bill.wav"
"1.gṑdanrecording~martha&bill.wav"
| Note |
|---|
Note: MP3 files are smaller and are the preferred choice for uploading to FirstVoices and for downloading. WAV files can be used for master copies. |
Create your spreadsheet
The spreadsheet captures the metadata and documentation about your files and is required for the batch uploading. You'll need a spreadsheet application. Open Office is recommended because it handles the Indigenous special characters best. You can download Open Office for free at https://openoffice.apache.org/.
Download a template spreadsheet from the Resources section of this page.
If you are using Open Office, click the box next to "Comma" before clicking OK
Enter your data into the appropriate columns below the headers. DO NOT alter the column headers in the template. Please note that you can add additional columns, but they must be taken from the list of field options available in the list below. Take great care to avoid typos. Any errors you make in the content of this spreadsheet will be added to your FirstVoices language site or may affect the uploading of entries altogether. See the list of fields below for explanations on each field.
When you are finished and ready to save, you must make sure to save your spreadsheet in CSV UTF-8 (Comma delimited) (.csv) file format. Do NOT save as an Excel file (.xlsx) or a regular Comma Separated Values (.csv) these cannot be processed. More information on how to do this can be found here: Save spreadsheets in UTF-8 CSV format
...
Words and phrases require different fields, so they must be collected in different spreadsheets. Example: ktunaxa_august_2_2021_words.csv for words, ktunaxa_august_2_2021_phrases.csv for phrases.
Fields for Words
Required | Type | Intended use | Example | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
USERNAME | ♦ Required ♦ | Text (email) | Users with accounts in the system who worked on the record. Up to 5 usernames are supported, but only one is "required". Extra definitions can be added in extra columns with a modified title: e.g USERNAME_2, USERNAME_3... | ||||||||||
WORD | ♦ Required ♦ | Text | The word or phrase, written in the language, using the community writing system consistent with the language site. | déjà vu | |||||||||
DEFINITION | ♦ Required ♦ | Multiple Text | An explanation, in English, of what the word means and/or how it is used (may or may not match the literal translation). Up to 5 definitions are supported, but only one is "required". Extra definitions can be added in extra columns with a modified title: e.g DEFINITION_2, DEFINITION_3... | "The strange feeling that in some way you have already experienced what is happening now" | |||||||||
CATEGORIES | Recommended | Comma Separated Text | A descriptive grouping related to the word or its meaning. If you want to add a word to multiple categories, separate each category by a comma and space. e.g "Shellfish, Food". NOTE: The category must be added online to your FirstVoices language site before you can add words to it in a batch upload. See this article for instructions on Adding and editing categories. | Shellfish, Food | |||||||||
PART_OF_SPEECH | Recommended | Text | The grammatical category that best describes the way the word is used in a sentence.
| noun | |||||||||
PRONUNCIATION | Optional | Text | An IPA transcription of the word or phrase. | /ˌdāZHä ˈvo͞o/ | |||||||||
LITERAL_TRANSLATION | Optional | Multiple Text | A direct English translation of the word, without interpreting meaning or usage. Up to 5 literal translations are supported. Extra literal translations can be added in extra columns with a modified title: e.g. LITERAL_TRANSLATION_2... | "already seen" | |||||||||
INCLUDE_IN_GAMES | Optional | True/False | Content suitable to appear in games. Typing 0 means false and 1 means true. Defaults to 1 (i.e. True; include in games). | 1 |
...
Required | Type | Intended use | Example | |
CULTURAL_NOTE | Optional | Multiple Text | Any notes about the word/phrase or its meaning beyond its definition. Includes both general notes and cultural notes (currently there is no separate field for general notes). Cultural notes often include information about who the word is used by (man or woman, young or old), or where it is used (in the Big House, on the land). General notes often include additional details about what the word does or does not convey, information about the history of the word, or any other information about the word that is not captured by the definition or literal translation. Up to 5 notes are supported e.g. CULTURAL_NOTE_2 ... | Often used in literary writing. |
REFERENCE | Optional | Text | If the word/phrase is sourced from a dictionary or other reference make a note of it here. It could be a citation, a link, or other information. | Cambridge English Dictionary, or another online archive/word list |
ACKNOWLEDGEMENT | Recommended | Text | This an extra field that can be used to credit anyone involved in collecting or recording the entry. | Collected by Jane Doe |
CONTRIBUTOR | Optional | Text | The name of the person who prepared the word/phrase entry. | John Smith |
CHILD_FRIENDLY | Recommended | True/False | Content suitable for young children. Typing 0 means false and 1 means true. Defaults to 1 (i.e. True). If true, this entry and related audio recordings will be automatically included in the Kids’ Portal. | 1 |
...
Required | Type | Intended use | Example | |
|---|---|---|---|---|
AUDIO_TITLE | ♦ Required ♦ | Text | Web-friendly title for the media. | "Child saying déjà vu" |
AUDIO_DESCRIPTION | Recommended | Text | Description of the media and any other notes. Potentially a longer, user-friendly description of how the recording or image came to be, recording location, conditions, date etc. | "A recording of 'déjà vu' being spoken. Recorded at the FPCC office, May 2019." |
AUDIO_FILENAME | ♦ Required ♦ | Text | The exact name of the media file itself. | 20190521_pb_01_w7.wav |
AUDIO_SHARED_WITH_OTHER_DIALECTS | Recommended | True/False | Typing 0 means false and 1 means true. Defaults to 1 (i.e. True). | 1 |
AUDIO_CHILD_FOCUSED | Recommended | True/False | Media suitable for a younger audience. Typing 0 means false and 1 means true. Defaults to 1 (i.e. True). | 1 |
AUDIO_SOURCE | Recommended | Text | The person speaking in audio files (the speaker). For images and videos, this field could be used to acknowledge the artist who created it. Up to 3 audio sources are supported for each file. For example, add columns AUDIO_SOURCE_2, AUDIO_SOURCE_3. | Peter Brown |
AUDIO_RECORDER | Recommended | Text | Person who captured the recording or image. | Kyra Borland |
...