Google Docs, audio files and import (and randomizing cards)

[Benjamin Barrett]

Today, I played with Mnemosyne a bit and looked around the website more. I'm really impressed with all the thought that has gone into the software and community.

Separate from my question--in case this is of use to someone--I downloaded the Korean3000 card set, and found that the words are in alphabetical order (by English word). Since I don't want to be stuffing my head with words alphabetically (just too strange to learn abandon, abuse, abusive all at once), I exported to txt, copied and pasted to Excel, put in random numbers with the rand function, and then sorted on the random number. Then I copied the data back to the txt file and imported. (I also deleted the Korean-to-English data since it was repeat of the English-to-Korean.)

My question:

I'm preparing some data and want to add audio files. I'm doing this in a Google Docs spreadsheet and plan to export just a part of the data for Mnemosyne. 

In my next step, I'm going to add audio files to the spreadsheet. What is the best method for getting those files to Mnemosyne, attached to the correct words?

Best regards

Ben Barrett

Seattle, WA

Learn Ainu! https://sites.google.com/site/aynuitak1/videos

[Gnome]

kl. 10:03:09 UTC+2 fredag 26. juli 2013 skrev Benjamin Barrett følgende:

Today, I played with Mnemosyne a bit and looked around the website more. I'm really impressed with all the thought that has gone into the software and community.

Separate from my question--in case this is of use to someone--I downloaded the Korean3000 card set, and found that the words are in alphabetical order (by English word). Since I don't want to be stuffing my head with words alphabetically (just too strange to learn abandon, abuse, abusive all at once), I exported to txt, copied and pasted to Excel, put in random numbers with the rand function, and then sorted on the random number. Then I copied the data back to the txt file and imported. (I also deleted the Korean-to-English data since it was repeat of the English-to-Korean.)

You can also enable random order in the options menu.

 

My question:

I'm preparing some data and want to add audio files. I'm doing this in a Google Docs spreadsheet and plan to export just a part of the data for Mnemosyne. 

In my next step, I'm going to add audio files to the spreadsheet. What is the best method for getting those files to Mnemosyne, attached to the correct words?

There may be a better way, but this is probably how I would do it:

Add columns for the sound tags, and sound name, then remove the tabs for the new columns in the exported txt.

Lastly I copy the files to the correct location reffered in the default.db_media directory.

For example the spreadsheet may look like this:

COLUMN 1: Question1

COLUMN 2: Answer1

COLUMN 3: <audio src="languages\Korean\

COLUMN 4: sound1

COLUMN 5: .wav">

Getting the file names to the sounds may be a time consuming task. You may get the sound file names into the spreadsheet, by saving the names of the sound files in the directory where they are located to a textfile. In windows this may be done using the command line.

Then after export to txt remove all the tabs except between the question and answer by using search and replace in an editor.

Make sure that the exported txt is saved in UTF8 encoding before importing.

Good luck!

[Benjamin Barrett]

Thank you for the responses!

So, I want my text to look like this:

Word1 Word2 <audio src="languages\Korean\AudioFile1.wav">

And then do I put my audio files under default.db_media\languages\Korean?

For the files, my thought is to load the audio files into the Google Docs spreadsheet (in addition to my local directory) because gFlash+ allows words and audio files to be imported to the iPhone/iPad.

Best regards

Ben Barrett

Seattle, WA

Learn Ainu! https://sites.google.com/site/aynuitak1/videos

[Peter Bienstman]

Indeed!

Good luck,

Peter

Benjamin Barrett <benjamin...@gmail.com> wrote:

Thank you for the responses!

So, I want my text to look like this:

Word1 Word2 <audio src="languages\Korean\AudioFile1.wav">

And then do I put my audio files under default.db_media\languages\Korean?

For the files, my thought is to load the audio files into the Google Docs spreadsheet (in addition to my local directory) because gFlash+ allows words and audio files to be imported to the iPhone/iPad.

Best regards

Ben Barrett

Seattle, WA

Learn Ainu! https://sites.google.com/site/aynuitak1/videos

On Jul 26, 2013, at 2:10 AM, Gnome <jippi...@hotmail.com> wrote:

kl. 10:03:09 UTC+2 fredag 26. juli 2013 skrev Benjamin Barrett følgende:

Today, I played with Mnemosyne a bit and looked around the website more. I'm really impressed with all the thought that has gone into the software and community.

Separate from my question--in case this is of use to someone--I downloaded the Korean3000 card set, and found that the words are in alphabetical order (by English word). Since I don't want to be stuffing my head with words alphabetically (just too strange to learn abandon, abuse, abusive all at once), I exported to txt, copied and pasted to Excel, put in random numbers with the rand function, and then sorted on the random number. Then I copied the data back to th e txt file and imported. (I also deleted the Korean-to-English data since it was repeat of the English-to-Korean.)

[Benjamin Barrett]

Thank you for that confirmation. 

I'm going to see how efficiently I can concatenate the file name in the spreadsheet.

I'll post the results once I get everything working. 

Best regards
Ben Barrett
Seattle, WA

Learn Ainu! https://sites.google.com/site/aynuitak1/videos

[Henrik in Oslo]

I have done something similar. I most often use a digital dictaphone for audio-production. It produces filenames like 130505_019.mp3, 130505_020.mp3 etc. 

Being attentive to routines when recording, and with help of xcel-tools I produce txt input to Mnemosyne like this:

Sound_RF_GER_2013_05_06_001 <audio src="130505_018.mp3"> Sound_RF_NO_2013_05_06_001 <audio src="130505_019.mp3">

Sound_RF_GER_2013_05_06_002 <audio src="130505_020.mp3"> Sound_RF_NO_2013_05_06_002 <audio src="130505_021.mp3">

Sound_RF_GER_2013_05_06_003 <audio src="130505_022.mp3"> Sound_RF_NO_2013_05_06_003 <audio src="130505_023.mp3">

(I found it useful to have a text "Sound_RF_GER_2013_05_06_00x"  together with the audio giving indication for instance that sound is in GER (German)

/ Henrik

[Benjamin Barrett]

Thank you for this additional reference.

I'm thinking of naming the files after the target word, and then doing a concatenation to create the string.

As it turns out, you cannot put audio files into a Google Docs spreadsheet. So what you do for gFlash+ is to upload the files onto the Internet and then include the URL, and gFlash+ retrieves the audio files during the import process. So I'm planning on including the URL as a separate concatenation.

I'm still in the data verification stage, so it's going to take a few more weeks, but I'm planning on doing a test of the audio part soon.

Ben Barrett

Seattle, WA

Learn Ainu! https://sites.google.com/site/aynuitak1/videos