RECENT TOPICS » View all
This is for the very few Trinity users:
I am ready to move the test site to the "live" site, but before I do that I need to take care of the Trinity data.
Unfortunately it will be difficult to maintain Trinity, and the new site login system is different. Since I have no future plans for Trinity (and plenty of work ahead with RevTH + Wiki) and very few people are using it nowadays (about 5? the rest haven't logged in a month)... I will write some export scripts.
The plan is to write a simple export page like the one existing for RevTK. Probably I will have two links, one to export all the sentence flashcards, and one to export all the word flashcards. They'll work separately because you will get two separate downloads.
These scripts will be available for a while after the site is updated, but you won't be able to login into Trinity anymore. Rest assured that I have many backups so however the export turns out, I will assist you in getting your data in pristine condition
Just email me if there's any trouble.
I see about 5 heavy users who have thousands of vocab and hundreds of sentences who have been reviewing very recently, but everyone else will also be able to export the data.
So in conclusion if you are one of those Trinity users who have been reviewing regularly and recently please look asap for the flashcard software you will use, try to do a little bit of research as to how you will be able to import CSV files for vocab and sentences into your software of choice.
PS: I'll try to write the export scripts for Trinity this week, Friday at the latest, and hopefully update the site coming weekend. This gives you about a week to look for flashcard software, but keep in mind that when the site is updated you will have immediately access to export your Trinity data, bookmark this topic I will post links to the export page here.
This sucks... I was just taking a break from Trinity because I get overwhelmed by SRSs sometimes. I'm using Anki right now but...
Damn, I don't know anything about scripts or importing.
I'm going to miss Trinity. I've been usingit everyday since itcameout (OK, mykeyboardis acting outrightnow)
I wrote the export scripts and should update the site this weekend.
The vocab file format will be comma-separated CSV, with following column data:
* compound : as in JMDICT
* reading : as in JMDICT
* glossary : as in JMDICT, a concatenation of all definitions for given vocab item
* itemid : the dictionary id from JMDICT (ent_seq)
* dateadded
* lastreview
* leitnerbox : as on this site's review system, 1 is the first box so it means failed/red card if lastreview is not null, if lastreview is zero, it's a blue card
* failcount
* passcount
The sentences file format will be comma-separated CSV, with following column data:
* question : the sentence itself (normally this is japanese sentence)
* answer : any text you entered in the desription box, may be empty, or may be a translation if you inputted english text there
* spakid : sentence pack id, a number unique per sentence-pack
* spaktitle : title of the sentence collection this sentence belongs to
* lastedited
* dateadded
* lastreview
* leitnerbox : as on this site's review system, 1 is the first box so it means failed/red card if lastreview is not null, if lastreview is zero, it's a blue card
* failcount
* passcount
Here's a couple links to ease the transition:
Importing in Anki
Importing in Mnemosyne
The files will be comma-separated, I think Anki will recognise it. But in any case from OpenOffice Calc or other spreadsheet application you should be able to export/save as CSV and choose TAB separated fields.
Most likely you'll want to delete the extra columns which you won't need, but may want to use for other ends.
I selected the first two columns to match logical "question" and "answer" sides, so in the simplest case you'll probably delete all columns BUT the first two, save again or export to tab-separated + utf8 format, then import in the flashcard software.
PS: unfortunately that will reset your review status. I think in Anki you can import items as if they were learned a while ago? I can't help much with that, but there are lots of people here who will be able to help.
I guess I'll wait until I've downloaded them and tried to import them into Anki before I let you know how confused I am. Because--who knows?--Maybe it won't be as confusing as it sounds. I'm just hoping it'll automatically know when my next reviews are scheduled, so I don't have to start all over again with my thousands of cards.
MethodGT wrote:
I'm just hoping it'll automatically know when my next reviews are scheduled, so I don't have to start all over again with my thousands of cards.
You won't be able to, at least not easily I'm afraid. I don't think Anki imports review schedule or has a format for importing review schedule.
However members before have shared a script to import the RevTK review status into Anki.
The script assumes the RevTK export format for the kanji flashcards:
framenum lastreview expiredate leitnerbox failurecount successcount
Perhaps someone here can help you with adapting the python script to use the format of the trinity exports above (the review schedule data works exactly the same way, but the displayed flashcard data is different).
PS: I will do some minor adaptations to more closely match the format which is expected by the python script Asriel shared. Maybe he'll be able to help. The blocker seems to be the assumption about a "Heisig model" and the fact that it reads a framenumber, where as with the exports above you will get a question and answer data for each card. I can't help with Python nor Anki I'm afraid, as I have no experience with them.
I am absolutely clueless as to what I'm supposed to do with this.
No worries, we'll sort you out. Once the export is live, we can try to contact the script author (Asriel), he actually had posted his gmail address in the topic.
Otherwise I'm pretty sure we have Python script Ninjas onboard who can adapt the script for you. It doesn't seem like it would require a lot of change to work.
I don't really if I have to start reviewing from scratch since it's been so long since I last reviewed.
Now that there are links up on the front page I figured out how to get my stuff into Anki. I thought I had to do something with those scripts posted above myself o_o;
That's cool. Have you tried chaning the intervals in Anki? I think you may be able to change the last interval so, say, those cards you know well if you reply the top answer, they'll get pushed for 3 months or more.. once you went through all the cards you can reset the intervals to the base values. Don't take my words for it though, I just vaguely remember a topic where this was discussed.
Oops just noticed I left a "www.x.com" in the trinity message. It's a placeholder url that I forgot to replace with the proper link to this topic. Thankfully it points to a "regular" site.. o_O
OK, just downloaded them. I opened them in Excel and they were filled with all sorts of funky characters--ãÿãã and stuff like that. I'll try importing them and see if it works. I'll get back on if it doesn't.
Hmm, I see, I tried with Excel 2007 here, and it does not let you pick the character type. Furthermore, it doesn't support the BOM mark, so even when I manually added the BOM mark with UtlraEdit conversion features, it did not work. It seems Excel supports only certain encoding types. Wow.
Edit: We have two solutions!
Importing in OpenOffice
Make sure to select "CSV" file type in the drop down. Then you should get extra options after you pick the file : choose UTF-8, and separated by comma (not tabs). Now all Japanese characters should appear correctly. You will see that every time you change one of those options the preview will show you in real time, what the import will look like.
Importing in Google Spreadsheets
Tada! Google to the rescue. Select File > New > Spreadsheet, then Import, select the trinity_vocab.csv file (or sentences). Edit in there, or File > Download As > Excel, and voila monsieur! Google is smart enough to detect both the CSV format and the encoding.
A little extra information about the fourth column in trinity_vocab.csv
The fourth column is the ent_seq field from JMDICT. JMDICT is a xml version of the famous EDICT from Jim Breen. If you are crafty with Excel / spreadsheet apps (I am not), you may be able to cross that with JMDICT or EDICT to add all sorts of extra info to the vocab.
Also, if you can wait out a little bit, I could add some extra JMDICT fields such as part-of-speech or the word priority, I have those already in the database. If you are interested then please specify clearly what extra JMDICT fields you would like for the vocab export. I can't add all of them, but the most important ones I had already in the database for use with Trinity.
Trinity gone?
EXtremely disappointed.
I didn't use it very much because I was too busy learning RTK.
But I'm through with that now and ready for Trinity.
It has some very nice features I do not see in other web pages.
Tried Anki, just confusion.
We want Trinity! We want Trinity!
I guess you can't just create a Trinity webpage separate from this one and let it run itself with no forums and no corrections for hangups.
Darn! I'll get over it.
richcoop wrote:
Trinity gone?
EXtremely disappointed.
I didn't use it very much because I was too busy learning RTK.
But I'm through with that now and ready for Trinity.
It has some very nice features I do not see in other web pages.
Tried Anki, just confusion.
We want Trinity! We want Trinity!
I guess you can't just create a Trinity webpage separate from this one and let it run itself with no forums and no corrections for hangups.
Darn! I'll get over it.
I really liked trinity too, same reason for not using it though, finishing RTK. I don't like anki either, sorry guys ![]()
Is there any chance of it coming back?
I didn't want to discontinue Trinity but it was difficult to maintain it due to structural changes in the database to do with the refactored RevTK.
I want to refactor Trinity as well someday, and redesign its workflow.. but right now I need to focus on remaining issues with RevTK and missing functionality like custom keywords to support non-english users; and RevTH.
I haven't given up on Trinity but it will be on hold for a long while.. ![]()

