Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

Header

Required?

Intended use

Example

Multiple columns allowed? 

ENTRY

 Required 

The word or phrase in the language, using the language site’s alphabet.

duus

TYPE

 Required 

Choose one of two options: word or phrase . Determines whether this row is uploaded as a word or phrase.

word

phrase

TRANSLATION

Recommended

An explanation or definition, in English, of what the word/phrase means or how it is used. The translation can be literal or non-literal.

cat

I have a cat.

CATEGORY

Recommended

A descriptive grouping related to the word or its meaning. The text you enter should match the name of a category on your language site. Learn more about adding and editing categories to your language site.

Note

The text you enter must exactly match an existing category on your language site (e.g. it is case sensitive). If the category does not exist on the language site, the row will not upload.

Mammals

Essential Phrases

PART_OF_SPEECH

Recommended

The grammatical category that best describes the way the word is used in a sentence. The text you enter should match the name of a part of speech used on FirstVoices. Find the list here.

This information is only relevant for words. It will not display for phrases.

Noun

Transitive Verb

NOTE

Optional

Any notes about the word/phrase or its meaning beyond its definition. Can include notes about what the word/phrase does or does not convey, cultural information about usage, literal translations, or information about the history of the word/phrase.

This word is only used when talking to small children.

Literal translation: “Something that makes noise”

ACKNOWLEDGEMENT

Optional

If the word/phrase is sourced from a dictionary, wordlist, or other reference, you can make a note of it here. It could be a citation, a link, or other information. You may also choose to include information about who was involved in contributing or compiling the word, instructions on reuse, or copyright.

Boas’s 1905 Dictionary, page 42

Compiled by Jane Doe, 1975 notes

PRONUNCIATION

Optional

The pronunciation of a word in a linguistic or sound-it-out format that may not be a real spelling.

hi-tin-qis

/speʔəθ/

ALTERNATE_SPELLING

Optional

Indicate more possible spellings of the word that people will be able to search.

xsi
ksi
ksii

...

Header

Required?

Intended use

Example

AUDIO_FILENAME

IMG_FILENAME

VIDEO_FILENAME

 Required 

The name of the media file that will be uploaded. Must exactly match the name of one of the media files included in your batch submission.

20190521_PB_cat_01.mp3

cat_blink_TM2023.jpg

AUDIO_TITLE

IMG_TITLE

VIDEO_TITLE

Recommended

Web-friendly title for the media. This title will be displayed when a visitor plays the audio/video or clicks on the image.

If blank, then the FILENAME information will be used.

Elder saying “neko” (cat)

Picture of Guarani traditional lands

AUDIO_DESCRIPTION

IMG_DESCRIPTION

VIDEO_DESCRIPTION

Optional

A longer, user-friendly description of how the recording or image came to be. Can include recording location, conditions, date etc.

A recording of the word “neko”, spoken by Jane Doe. Recorded at the FPCC office, May 2019.

AUDIO_SPEAKER

Recommended

The person speaking in an audio file. Visitors will be able to see the Speaker name before they play the file. Must exactly match the name of a Speaker on your language site.

Note

The text you enter must exactly match an existing speaker (e.g. it is case sensitive). If the speaker does not exist on the language site, the file will not upload.

Tip

Add multiple: You can additional speakers in extra columns AUDIO_SPEAKER_2, AUDIO_SPEAKER_3, etc.

Jane Doe

AUDIO_ACKNOWLEDGEMENT

IMG_ACKNOWLEDGEMENT

VIDEO_ACKNOWLEDGEMENT

Recommended

Information about where the media file has been sourced from. For images and videos, this field can be used to acknowledge the artist, photographer, or videographer who created it. For audio, you may wish to acknowledge people involved in recording or processing the file.

Warning

Warning: The FirstVoices team does not monitor whether or not media content is sourced appropriately. If FirstVoices receives a copyright strike against content on your language site that isn’t properly sourced, we may be legally required to remove all content that does not have source information.

Video by Peter Brown

Photo sourced from Wikimedia Commons

AUDIO_INCLUDE_IN_KIDS_SITE

IMG_INCLUDE_IN_KIDS_SITE

VIDEO_INCLUDE_IN_KIDS_SITE

Optional

Is the media suitable for young children? If so, this media file will be displayed in the Kids’ Area.

For “no”, write N, False, or 0. For "yes", write Y, True, or 1. Defaults to "yes".

Y

N

AUDIO_INCLUDE_IN_GAMES

Optional

Is the media suitable to be used in FirstVoices Games? If so, this media file may be used in games.

For “no”, write N, False, or 0. For "yes", write Y, True, or 1. Defaults to "yes".

Y

N

VIDEO_EMBED_LINK

Optional

If you wish to link a video from Youtube or Vimeo to your dictionary entry, add the video URL in this column.

This column is not related to any other video columns.

https://youtu.be/4RxNvoO7CMw

...

  • Are all the column headings spelled correctly? (i.e. AUDIO_TITLE, not AUDIOTITLE or AUDIO TITLE)

  • Does every row have word or phrase listed in the TYPE field?

  • Are all of the categories and speakers you reference in your spreadsheet spelled the same on your FirstVoices site, including their capitalization? (e.g. The category "Food" is not accidentally spelt "food" in your spreadsheet.)

  • Have you already created any new custom categories or speakers that you reference in your spreadsheet?

  • Are all of the parts of speech that you reference spelled the same as in the Parts of Speech list above?

  • Did you write the .wav or .mp3 extension after your filenames in the AUDIO_FILENAME column? (i.e. my-great-sound.mp3, not just my-great-sound)

  • Have you added information in the AUDIO_SPEAKER , IMG_ACKNOWLEDGEMENT , and VIDEO_ACKNOWLEDGEMENT columns, as needed?

...

Resources

...

Templates

...

Minimal columns

Recommended columns

All columns

Text headers only

View file
namebatch_minimal_template.csv

View file
namebatch_recommended_template.csv

View file
namebatch_maximum_template.csv

Text and media headers

View file
namebatch_minimal_template_media.csv

View file
namebatch_recommended_template_media.csv

View file
namebatch_maximum_template_media.csv

...

Example batches

Minimal columns

Recommended columns

All columns

Text data only

View file
namebatch_minimal_sample.csv

View file
namebatch_recommended_sample.csv

View file
namebatch_maximum_sample.csv

Text and media data

View file
namebatch_wmedia_minimal.csv

View file
namebatch_wmedia_recommended.csv

View file
namebatch_wmedia_maximum.csv

...