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? 

ENTRYTITLE

 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

Info

How to add multiple translations, categories, etc.

Batch upload spreadsheets support adding multiple translations, categories, and other information, just like the website. For these “multiple” fields, you can add up to 5 columns. The additional columns should be followed by _2 , then _3, _4, _5 .

Example: To add 5 categories to the same word, you can create five different columns:

Code Block
CATEGORY  CATEGORY_2  CATEGORY_3  CATEGORY_4  CATEGORY_5
Nature    Environment Games       Animals     Cultural Practices

Note: You must have a column CATEGORY before you can add a column CATEGORY_2 !

Privacy columns

In addition to this basic information, further details can be added to both words and phrases:

...

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

Info

How to add multiple media files

To add more than one a second media file of the same kind, you can add a new an additional set of columns with an underscore and a numberwhere _2 is written after the media type. For example, the column headings for a second audio file would be a first set of columns labeled AUDIO can be followed by a second set of columns labeled AUDIO_2.

  • File #1 headers: AUDIO_TITLE, AUDIO_FILENAME, AUDIO_SPEAKER, AUDIO_SPEAKER_2, etc.

  • File #2 headers: AUDIO_2_TITLE, AUDIO_2_FILENAME, AUDIO_2_

DESCRIPTION
  • SPEAKER, AUDIO_2_SPEAKER_2, etc.

Related entry link columns

...

Header

Required?

Example

RELATED_ENTRY

Optional

Copy the ENTRY TITLE information (i.e. the word/phrase title) for another row in the spreadsheet. When the batch uploads, the entry in this row will link to the entry in that row.

The text should exactly match the ENTRY TITLE information of the other row.

duus

RELATED_ENTRY_ID

Optional

List the unique ID for any word or phrase on your FirstVoices language site. When this new entry uploads, it will contain a link to that word or phrase.

9deb9c27-6941-4620-b7d8-d7b8fe0987ec

...

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_wmediaminimal_sample_minimalmedia.csv

View file
namebatch_recommended_wmediasample_recommendedmedia.csv

View file
namebatch_maximum_wmediasample_maximummedia.csv