Page Comparison

1. Before you start

As a team, decide on what information you want to include as part of your batch upload. In general, the more information you can provide, the more useful the language site will be in the future, but the longer the batch may take to prepare.

For example:

• Just the basics:

  • word/phrase in your language, and its translation (for words/phrases)

  • alphabet characters and their order (for alphabet characters)

• Sample pronunciation audio for each word, phrase, or alphabet character

• A part of speech (words only)

• A reference or citation

• Additional explanatory notes

2. Review file-naming requirements

If you are submitting media files such as audio recordings, you will need to prepare your files in a specific way so that they can be accepted by our uploader. Our batch uploader is not as flexible as the FirstVoices website, and has more restricted file name requirements.

Please keep this in mind and make sure that ALL files and folders you submit follow these rules.

3. Create your spreadsheet

The batch spreadsheet captures the metadata and documentation about your files and is required for the batch upload. You'll need a spreadsheet application to proceed with this step.

1. Review the specific preparation instructions for the kind of batch you are working on:

   • Set up your alphabet via a batch spreadsheet

   • Upload words and phrases via a batch spreadsheet (coming soon!)

2. From the “Resources” section of the instructions page, download a template spreadsheet and save it on your computer.

3. Open the template spreadsheet on your computer. If you are using Open Office, ensure that ONLY the box next to "Comma" is checked before clicking OK.

   

4. (Optional) Add or remove columns in the spreadsheet to match the field information you plan to upload.

   1. If there are optional columns in the template that you do not plan to use, you can delete or “hide” them. For example, you can delete columns relating to image files if you are not using them.

   2. You can add additional columns to the template if you wish. Please note that your additional columns WILL NOT BE UPLOADED unless the column header matches a column listed in the instructions.

   3. DO NOT change the names of the column headers in the template.

5. Enter your data into the appropriate columns below the headers. Take great care to avoid typos. Any errors you make in the content of this spreadsheet will be uploaded to your FirstVoices language site or may affect the success of the upload.

6. When you are finished and ready to save, save your spreadsheet in CSV UTF-8 (Comma delimited) (.csv) file format.

   1. Give the file a practical name with no spaces or special characters, following the rules in step 2.
      Example: denekeh_september_2019_words.csv

   2. Do NOT save as an Excel file (.xlsx) or a regular Comma Separated Values (.csv) – these cannot be processed and may break special characters in your data.

4. Prepare your media files

1. To include media files in the upload, copy your audio and other media files into one folder on your computer.

2. Give the folder a practical name related to your batch. The name should follow the rules in step 2 (e.g. NO SPACES.)
   Example folder: denekeh_september_2019_words_media

3. Name your media files using the same format. The names should follow the rules in step 2. (e.g. the only special character should be the period before the file type, such as .mp3 or .wav). 
   Example filename: 2018_joe_smith_word1.mp3

4. Enter the exact filename of the media into your spreadsheet where it belongs, along with other information such as the title.

5. Double-check all your files and the spreadsheet

It's important to make sure your files, metadata and documentation are correct before you submit them. Take particular care to match the filenames in your spreadsheet exactly as they have been named in your folder. Any typos in filenames may affect that row being successfully uploaded.

Work with your language team to double-check and proofread all entries before sending them in. You may wish to send it to another team member, who can open it up and make sure it saved correctly.

6. Send to the FirstVoices team for processing

Format your spreadsheet and media folder as such:

If your upload is large and cannot be attached by email, you can upload these files to FPCC’s custom Sharepoint in a folder designated for your team. To set this up or get access to the link, email hello@firstvoices.com.

It is ok to zip your folder of media files for easier upload.

Once the upload is complete, email batch@fpcc.ca with your files attached, or by letting us know that you uploaded them to Sharepoint. The subject of the email should match the name of your spreadsheet – so for example, if the spreadsheet you uploaded was ktunaxa_august_2_2021_phrases.csv, that should be your email subject.

7. Review uploaded content

Once FirstVoices staff has uploaded your content, we will notify you by email.

Then, you should review the new content to make sure it uploaded correctly. For words/phrases, the entries will be visible only to your language team until you approve them.

Congrats, you have uploaded a batch!