tsv and csv import
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.
Keyboard shortcuts
Generic
| ? | 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
Support Staff 1 Posted by drewmccormack on 02 Sep, 2011 09:07 PM
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.
Drew
2 Posted by danzac on 05 Sep, 2011 01:37 PM
Wow, how did I not know that?! This makes me very happy!
drewmccormack closed this discussion on 05 Sep, 2011 01:48 PM.
danzac re-opened this discussion on 05 Sep, 2011 02:04 PM
3 Posted by danzac on 05 Sep, 2011 02:04 PM
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
Support Staff 4 Posted by drewmccormack on 05 Sep, 2011 02:25 PM
We'll look at supporting this. It might already be in the new version.
Drew
5 Posted by carlyjb on 16 Sep, 2011 03:57 PM
So there is no way to import cards that have audio yet? Major bummer. I need to make over 2000 Russian flashcards right away.
6 Posted by danzac on 16 Sep, 2011 04:13 PM
yes there is a way still, just not as simple http://www.mentalcaseapp.com/studyarch/
7 Posted by carlyjb on 16 Sep, 2011 04:20 PM
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.
8 Posted by danzac on 16 Sep, 2011 04:33 PM
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.
Support Staff 9 Posted by drewmccormack on 16 Sep, 2011 04:35 PM
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
Done
If it doesn't work, you can send it to me to test.
Drew
Support Staff 10 Posted by drewmccormack on 16 Sep, 2011 04:39 PM
You can import audio via a study archive, which is like a zipped tsv/csv. See
http://www.mentalcaseapp.com/studyarch
Kind regards,
Drew