Keeping tags when exporting to txt files

[max.sch...@gmail.com]

Hey,

I have a bunch of cards that I would like to work with in Excel. Roughly 5000 cards, roughly 25 tags (every card has at most one tag). I'd like to export them to a tab-separated text file, but when I do this I only get the questions/answers, not the accompanying tags.

I know one way to do this is to just manually select which cards I want to export, so I only export those with a certain tag. Is there another, easier way so I don't have do this procedure 25 times? The dream would be if I could just copy/paste the entire table I can highlight in the "Browse Cards" menu, but that doesn't seem to work either.

Thanks!

[Peter Bienstman]

Hi,

I'm afraid the only way is to write a custom exporter / importer yourself for this...

Cheers,

Peter

--
You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mnemosyne-proj-u...@googlegroups.com.
To post to this group, send email to mnemosyne-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/6035d58e-a3fd-407a-a6ce-f885699379ee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[abaku...@arcor.de]

Hi!

You could try something like this:
http://smallbusiness.chron.com/convert-sqlite-excel-40798.html

Back up your database first!

Let me know, if it worked! :)

Cheers,

Abakus

Am 15.02.2017 11:38 schrieb Peter Bienstman <Peter.B...@UGent.be>:
>
> Hi,
>
> I'm afraid the only way is to write a custom exporter / importer yourself for this...
>
> Cheers,
>
> Peter
>
> ----

-Original Message----- > From: mnemosyne-...@googlegroups.com [mailto:mnemosyne-...@googlegroups.com] On Behalf Of max.sch...@gmail.com > Sent: 15 February 2017 01:24 > To: mnemosyne-proj-users > Subject: [mnemosyne-proj-users] Keeping tags when exporting to txt files > > Hey, > > I have a bunch of cards that I would like to work with in Excel. Roughly 5000 cards, roughly 25 tags (every card has at most one tag). I'd like to export them to a tab-separated text file, but when I do this I only get the questions/answers, not the accompanying tags. > > I know one way to do this is to just manually select which cards I want to export, so I only export those with a certain tag. Is there another, easier way so I don't have do this procedure 25 times? The dream would be if I could just copy/paste the entire table I can highlight in the "Browse Cards" menu, but that doesn't seem to work either. > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group. > To unsubscribe from this group and stop receiving emails from it, send an email to mnemosyne-proj-u...@googlegroups.com. > To post to this group, send email to mnemosyne-...@googlegroups.com. > To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/6035d58e-a3fd-407a-a6ce-f885699379ee%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups "mnemosyne-proj-users" group. > To unsubscribe from this group and stop receiving emails from it, send an email to mnemosyne-proj-u...@googlegroups.com. > To post to this group, send email to mnemosyne-...@googlegroups.com. > To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/484d69db5a1a447f97e9cbe4e8e416e9%40xmail102.UGent.be. > For more options, visit https://groups.google.com/d/optout.

[abaku...@arcor.de]

Hi again,

it might be easier to use this Software:

https://sqlitestudio.pl

Download and unzip the software on the destop (or any other location)
Start the Software: C:\Users\abakus\Desktop\sqlitestudio-3.1.1\SQLiteStudio\SQLiteStudio.exe

1. Add database "default.db" (C:\Users\abakus\AppData\Roaming\Mnemosyne\default.db)
2. Click on cards
3. Click on data tab (if not already selected)
4. Click somewhere in data table and select all cards (CTRL+a)
5. Copy the content (CTRL+c)
6. Paste in Excel (CTRL+v)
7. Delete all columns, you don't need

or

1. Add database "default.db" (C:\Users\abakus\AppData\Roaming\Mnemosyne\default.db)
2. Right-Click on cards and choose "generate query for table"->SELECT
3. Just choose the database entries you are interested in and delete all the others, you should end up with something like this:
SELECT
question,
answer,
tags
FROM cards;
4. Click on the play-button
5. Click on data tab (if not already selected)
6. Click somewhere in data table and select all cards (CTRL+a)
7. Copy the content (CTRL+c)
8. Paste in Excel (CTRL+v)

Enjoy! :)

Cheers,

Abakus

----- Original Nachricht ----
Von: "abaku...@arcor.de" <abaku...@arcor.de>
An: "mnemosyne-proj-users@googlegroups com" <mnemosyne-...@googlegroups.com>
Datum: 16.02.2017 06:25
Betreff: RE: [mnemosyne-proj-users] Keeping tags when exporting to txt files

> be4e8e416e9%40xmail102.UGent.be. > For more options, visit

> https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to the Google Groups
> "mnemosyne-proj-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to mnemosyne-proj-u...@googlegroups.com.
> To post to this group, send email to mnemosyne-...@googlegroups.com.
> To view this discussion on the web visit

> https://groups.google.com/d/msgid/mnemosyne-proj-users/t9oiir451m9jsrt21uxjf
> ccj.1487222617676%40email.android.com.