This can be done in Office.  First load the program in word.  Then save it again as a text document.  here it will give you the option to save as UTF-8.  Then just rename the .txt to .rtf and you can load it up in excel and sort by whichever column you like.

I'm having a problem with commas as delimiter because many of the stories contain commas and even " quotation marks which are then wrongly interpreted as new fields when I try to import them -- for example into Anki.

I've tried to come up with a sed or awk script to substitute the commas, but that doesn't work either. Would it be possible to add a function to export them as tab-delimited, or using semicolon as delimiter, neither of which will be (commonly) used when people write up their stories?

I see your point, and your probably right. Here's what I wanted to do. Take the following exported line where the comma in the story messes up the import.

509,染,"dye",0,2009-12-23 13:10:40,"To make this dye, I used *water* and the barks of *nine* different *tree*s."

Of course, I can go via OpenOffice, but I'm learning new kanji by finding  a story I like and copying it or adding one of my own, then use the "My Stories List" to export the csv file, and then import only the newly added kanji to Anki---which I'm using to review because it has an excellent spaced repetition algorithm. That's already a few steps to take, so I'm hoping to cut it short by not going via OpenOffice.

In any case, for future reference if anyone wants to do the same, here's an ugly bash line that works by creating a semicolon-separated file that Anki automatically recognizes:

sed -e 's/\*//g' -e 's/\#//g' -e 's/"//g' -e 's/, / /g' -e 's/,/;/g' my_stories.csv | \awk -F';' '{print $1, $2, $3, $6; OFS=";"}'  > myfiletoimport.csv

It works simply by deleting the commas in the stories because they're usually followed by a space, then substituting all others with a semicolon because somehow Anki reads that better than a comma.

Cheers,

Mark

Here's a little Ruby script that will update your Anki deck with the stories in your .csv export. Requires sqlite3-ruby. Just update the DECK and STORIES constants to point to their respective files and you should be set.

Note: Close Anki before doing this so the script can modify the database. And be sure to back up the database before running this.

require 'csv'
require 'sqlite3'

DECK = "/home/alex/.anki/decks/Heisigs Remember the Kanji (RTK) 13.anki"
STORIES = "/home/alex/Downloads/my_stories.csv"

db = SQLite3::Database.new(DECK)

heisig_id = db.get_first_value("select id from fieldModels where name = 'Heisig number'")
story_id = db.get_first_value("select id from fieldModels where name = 'Story'")

csv = CSV.parse(File.read(STORIES))
csv.each do |row|
  puts "Inserting story for ##{row[0]}: #{row[5]}."
  fact_id = db.get_first_value("select factId from fields where fieldModelId = ? and value = ?",
                               heisig_id,
                               row[0])
  db.execute("update fields set value = ? where fieldModelId = ? and factId = ?",
             row[5],
             story_id,
             fact_id)
end

Last edited by alexsuraci (2010 February 13, 10:17 pm)

I think you're looking at the Flashcards Export, not the stories export. I'll have to merge them at some point as it's a bit confusing (this is on the project roadmap wiki page...).

alexsuraci wrote:

Here's a little Ruby script that will update your Anki deck with the stories in your .csv export. Requires sqlite3-ruby.

Alex,
Would you mind going into a little detail on how to get this sqlite-ruby application up and running, pretty please?  I'm quite the n00b with this database stuff, but I'd love a quick conversion of my Reviewing the Kanji stories into my Anki application.  The Ruby Forge site says I have to have the SQlite engine installed to build this module, and that's where my tech abilities fall short. I'm on a Mac BTW, but I gather that shouldn't matter?  Yoroshiku onegaishimasu!

IMPORT UTF-8 .CSV INTO EXCEL 2003
(These steps may require installation of the Analysis Toolpak in Tools>Add-Ins)

To open the .csv directly in Excel 2003:
1. Open a 'Blank Workbook'
2. Go to Data>Import External Data>Import Data
3. Set 'Files of type:' to 'All Files (*.*)'
4. Navigate to Folder and highlight File and Open
5. In the 'Text Import Wizard', Set 'File origin:' to '65001 : Unicode (UTF-8)'
6. Be sure that 'Delimited' is selected as the file type and click the 'Next >' button
7. Set 'Delimiters' to 'Comma' - remove any other selections
8. Be sure that the double quotation mark (") is selected as the 'Text qualifier:' and click the 'Next >' button
9. Set Date format if desired and click the 'Finish' button

That's it. Though I'm learning to like Google Docs, there's no need to use it, or another intermediary between the .csv file and Excel. And, though I haven't checked, a similar set of steps should work for other versions of Excel.

I just wish I didn't create so many links to other kanji using brackets {}.

Fabrice - Could you add an option to replace bracketed numbers with the text

*Key_Word_HERE* (# Story_Number_HERE)

to the 'Export Stories' dialog in a future Update?

Thanks for your work.

[Note - in my original post, I asked for #Key_Word_HERE# (bolded text markers '#', when I meant italicized text markers '*'. Edited above.]

Last edited by dalmim (2010 September 11, 12:46 am)

Just fyi it's done and will be in the next update. It also uses custom keywords if any are created. Next update may be before end of September, if the UI for editing keywords doesn't turn out too complicated.

Ok, can somebody please, please, please make a step-by-step guide as to how we import  our RevTK data into anki on a mac? I am totally and utterly lost, I've tried almost everything and nothing seems to work.

You should probably edit the file before importing in a spreadsheet. Use text editor like UltraEdit or Vim with support for regular expressions you can then replace these with surrounding tags like <em>primitive</em> or <strong>keyword</strong> or whatever else formatting tags your target application uses.

Hi Fabrice,

I'm trying to take a backup of my stories using this feature, but it is resulting in a 0KB download. Any ideas?

Edit: Doh, Apparently 'Export Flashcards' here: http://kanji.koohii.com/manage means export the SRS data, of which I have none because I'm using Anki.

But there is another link, 'Export to CSV' on the 'All my stories' page: http://kanji.koohii.com/study/mystories which did what I wanted.

:-)

Last edited by amillerchip (2012 November 26, 7:45 am)

Ah you replied while I was editing my post. Turns out I was using the wrong link... Looks like I'm not the first one either.

Thanks :-)