tsv and csv import

danzac's Avatar


02 Sep, 2011 08:04 PM

I've asked this before, but I'll ask again. I create flashcard databases for my students quite often and having to create study archives is VERY time consuming. I would like to suggest one very minor upgrade that would make things so much easier.

I would like to ask that we not have to zip everything to make a study archive, but that we could just choose a csv or tsv file and it could recognize and import audio and video if the text file is created properly.

  1. Support Staff 1 Posted by drewmccormack on 02 Sep, 2011 09:07 PM

    drewmccormack's Avatar

    This actually already works. If you use four columns, and have the name of a media file in two columns, it will look for that and import it. See the help pages in the Mac app and search for csv.

    Of course, this is not a good way to distribute data, because folders work badly on servers and in emails. That's why zipping is much more convenient for sharing, and you can create hierarchy as well.


  2. 2 Posted by danzac on 05 Sep, 2011 01:37 PM

    danzac's Avatar

    Wow, how did I not know that?! This makes me very happy!

  3. drewmccormack closed this discussion on 05 Sep, 2011 01:48 PM.

  4. danzac re-opened this discussion on 05 Sep, 2011 02:04 PM

  5. 3 Posted by danzac on 05 Sep, 2011 02:04 PM

    danzac's Avatar

    Ahh, this is still limited. It only does photos. I would like to import just like in the study archive format

    1 Text 1 audio 1 image 2 Text 2 audio 2 image

  6. Support Staff 4 Posted by drewmccormack on 05 Sep, 2011 02:25 PM

    drewmccormack's Avatar

    We'll look at supporting this. It might already be in the new version.


  7. 5 Posted by carlyjb on 16 Sep, 2011 03:57 PM

    carlyjb's Avatar

    So there is no way to import cards that have audio yet? Major bummer. I need to make over 2000 Russian flashcards right away.

  8. 6 Posted by danzac on 16 Sep, 2011 04:13 PM

    danzac's Avatar

    yes there is a way still, just not as simple http://www.mentalcaseapp.com/studyarch/

  9. 7 Posted by carlyjb on 16 Sep, 2011 04:20 PM

    carlyjb's Avatar

    I've never been able to make a studyarchive that works. I have followed these instructions meticulously, but somehow it never works. So I've always resorted to the CSV.

    I can make the simplest studyarchive and will get a message about it somehow being incorrect.

    What I want is this:
    1 Text, 1 Image, 1 Audio, 2 Text, 2 Image, 2 Audio

    Most of the time 1 Image will be empty, and the 2 Image will be there. Russian is in 1 Text and English is in 2 Text.

    I've attached the CSV I"m working with.

  10. 8 Posted by danzac on 16 Sep, 2011 04:33 PM

    danzac's Avatar

    The first row in your csv/tsv needs to indicate how your text is.

    Second, your data needs to be perfect. If a file is misnamed, or if your csv names a file that is not in the folder, an error will occur and the import will stop.

    I've actually requested a while back that Mental Case provide some sort of "report" after an import, to inform the user of any errors, instead of stopping the import, the import can continue and just make note of the error for the user.

    fyi, I've also requested that mass imports be made even more simple and robust—like the PC app Memorylifter. For that app, all of the media files can be in one folder and a csv/tsv can indicate the case, the media, and any other "side" info (like tags, etc). The csv/tsv would then create the cases upon import.

  11. Support Staff 9 Posted by drewmccormack on 16 Sep, 2011 04:35 PM

    drewmccormack's Avatar

    We will probably make this possible in future. For now, study arch is the way to go.

    It is not that complex.

    Make a folder called Archive
    In that, make folders Ungrouped and Groups
    In Groups make a folder for your case (Russian)
    In Russian, out your media files and Data.csv
    Now zip the Archive folder by right clicking in finder and choosing Compress


    If it doesn't work, you can send it to me to test.


  12. Support Staff 10 Posted by drewmccormack on 16 Sep, 2011 04:39 PM

    drewmccormack's Avatar

    You can import audio via a study archive, which is like a zipped tsv/csv. See


    Kind regards,

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac