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! > Best regards > Ben Barrett > Seattle, WA > > Learn Ainu! https://sites.google.com/site/aynuitak1/videos > -- 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/a4c8e6d5-18f2-439c-87d9-a796400dba58%40googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
