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 On Jul 26, 2013, at 9:25 PM, Peter Bienstman <[email protected]> wrote: > Indeed! > > Good luck, > > Peter > > Benjamin Barrett <[email protected]> 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 <[email protected]> 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.) > > > 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! > -- You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/891F4E2B-A4E8-4977-85FB-EC44A0FFA3A4%40gmail.com. For more options, visit https://groups.google.com/groups/opt_out.
