Introduction


FirstVoices hosts custom, interactive alphabets with many useful and interesting features. Custom alphabets on FirstVoices provide features such as:

Creating your custom alphabet is an important step in setting up a new FirstVoices site, which will ensure that your site dictionary functions properly and is easy for visitors to use.

In order to set up your alphabet, you will need to create a batch spreadsheet (.csv file) which contains the basic necessary information about your alphabet. This article will help walk you through creating it. The Language Administrator will submit the alphabet information to the FirstVoices team, who are responsible for uploading it to the site.

It is important to set up your custom alphabet at the beginning of your project, before publicly launching your site, so that visitors do not encounter any errors or issues with functionality.


Prepare your language alphabet


Gather information

  1. Identify and finalize the list of characters/letters in your writing system.

  2. Decide on the correct order for your alphabet.

  3. Identify different ways to type the characters/letters in your writing system. For example, lowercase and uppercase versions, or accented versions.

  4. (Optional) Identify how people may commonly type your language’s characters if they are unfamiliar with your writing system.

If you would like assistance in planning for or engaging in community consultation, please email the LTP team (ltp@fpcc.ca) or James (james@fpcc.ca).

Organize your findings

At the end of this process, you should have a list of the characters in your alphabet and some information about each one. For example:

Character

Versions

Unfamiliar version

ʔ

'

a

A à À

Ą ą̀ Ą̀

a

b

B

You can also choose to add extra information at this step. For example, you might wish to list an example word for each letter, or write in some additional notes. You will not submit these as part of the batch spreadsheet, but they may be helpful to your team for following steps.


Record sample pronunciations for your alphabet


FirstVoices language sites allow you to include an audio or video file along with each letter, which can help learners become familiar with the pronunciation. It can be a good learning opportunity to create these recordings while you are setting up the alphabet for the first time.

  1. Decide what information should be included in the recording.

  2. Make a recording of a speaker producing the character sound and any other information that you decided to include, for each character.

  3. Follow these instructions for managing data for your project and naming/storing your audio files.

When saving file names, follow these rules: ONLY use lowercase letters, numbers, hyphens, or underscores, NO SPACES. The only special character should be the period before the file type.

Read more about our file name requirements for batch uploads.


Create the batch spreadsheet


The language team must collect their alphabet information into a spreadsheet (.csv) in the correct format for it to be uploaded to FirstVoices.

Before starting, it may be helpful to review our general instructions for batch uploads here.

Download submission template

DO NOT alter the column headers in the template.

View and download our template spreadsheet for alphabet submission here:

Add basic information to your alphabet spreadsheet

  1. Open the alphabet submission template.

  2. Choose the columns you wish to include. CHAR and ORDER are required – the others are optional. If a column is not applicable to your alphabet, you can leave it blank, 'hide' it, or delete it.

  3. Enter the information you gathered about your alphabet into the spreadsheet columns. Definitions of each column are in the table below.

Column

What goes here?

Sample

CHAR

The character in your writing system.

If there are multiple versions of this character (e.g. upper and lower case), use the more “basic” one that is used most often.

kw'

Required

CHAR_VERSIONS

Any alternate variations of the character in your writing system, separated by spaces.

If there are no alternate versions of the character (e.g. you only use lower case, no accents, etc), leave this blank.

Kw'

Optional

APPROXIMATE

The equivalent character in English, approximate characters that are commonly used by learners, or alternate spellings.

qu

Optional

ORDER

The numerical order in which this character appears (for alphabetical sorting).

15

Required

Take great care to avoid typos when creating this spreadsheet. Any errors you make in the content of this spreadsheet will be reflected when the FirstVoices team uploads your alphabet and may affect how words are listed on in your site dictionary.

Add information about pronunciation files (optional)

It is optional to submit your pronunciation files as part of the initial upload. Language administrators can add and change the media files linked to alphabet characters at any time after the alphabet has been uploaded.

  1. If you are including media files with pronunciations, collect them into one folder labeled “media”. Ensure the file names do not include any spaces or special characters.

  2. Fill out the following columns in the alphabet submission template with information about your files.

  3. Double check: Make sure the file name exactly matches what is written in your spreadsheet!

Column

What goes here?

Sample

AUDIO_FILENAME

The exact filename of the corresponding audio file, including the file extension.

alphabet_hard-kw.mp3

Recommended

AUDIO_SPEAKER

The name of the speaker on the recording.

Linda Line

Recommended

AUDIO_ACKNOWLEDGEMENT

The name of the person who made the recording, if known, or any other acknowledgements.

Recorded by: Sam Square

Optional

Save and submit the spreadsheet to FirstVoices staff

  1. Save your spreadsheet in CSV UTF-8 (Comma delimited) (.csv) file format. The file name for the spreadsheet should follow our batch upload rules.

  2. Send your spreadsheet and folder of media files to FirstVoices as an email attachment to <batch@fpcc.ca>. It is ok to zip your media files for easier attachment.

  3. FirstVoices staff will review your batch, perform the upload, and set up alphabet functionality on your site. Please allow 1-2 weeks for this to be completed.

Once your alphabet has been uploaded, Language Administrators can continue to customize it with example words, or adding/editing pronunciation files.

Read about how to manage and customize your language alphabet


Example alphabet spreadsheets


Check out these helpful sample spreadsheets, demonstrating how to enter a writing system that uses uppercase characters, lowercase characters, or both.

Both upper and lower case

Upper case only

Lower case only