Back

Creating personalized i+1-lists?

#1
I make this thread to discuss a project that has been on my mind for quiet some time. I want to create a program which does the following:

INPUT:
-(large) database of sample sentences + audio-links
-list of known vocab-items
-list of new vocab-items

OUTPUT:
Spreadsheet/table with the following information for each new vocab item
-new vocab item Hanzi
-new vocab item Translation
-new vocab item PinYin
For said vocab item:
-Sample Sentence Hanzi
-Sample Sentence Translation
-Sample Sentence Pinyin
-Sample Sentence Audio-link
-possibly some formating for comfortable anki-import (for cloze deletion etc)?

So basicly the programm has to do:
for(new vocab items)
for(database sentences)
if(only new vocab item unknow) then (write sentence and data into spreadsheet)

The merits of this kind of program are pretty much obvious: Creating flexible i+1 anki-decks eventually of a certain theme. (For instance one could take a large subs2srs database of one's favourite show etc). This would also be usable for beginner decks.

I only have little programming experience, however I DO have a lot of freetime right now, so I guess I should succeed. I was thinking of creating an excel-spreadsheet via visual basic. I still have to learn it though ;-) Any suggestions or comments concerning the programming part/the functionality of the skript?
Edited: 2010-04-30, 1:31 pm
Reply
#2
Please don't use Visual Basic. It is a terrible language. I would strongly recommend Python for your needs. Not only does it have all of the advantages of a modern language, many many libraries, but it is also cross platform compatible. You would also be able to find documentation and get help much more readily. Oh, and it's also so very easy to learn.
Reply