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: "[email protected]" <[email protected]> An: "mnemosyne-proj-users@googlegroups com" <[email protected]> Datum: 16.02.2017 06:25 Betreff: RE: [mnemosyne-proj-users] Keeping tags when exporting to txt files > 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 <[email protected]>: > > > > Hi, > > > > I'm afraid the only way is to write a custom exporter / importer yourself > for this... > > > > Cheers, > > > > Peter > > > > ---- > > -Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > 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 > [email protected]. > To post to this group, > send email to [email protected]. > To view this > discussion on the web visit > https://groups.google.com/d/msgid/mnemosyne-proj-users/6035d58e-a3fd-407a-a6 > ce-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 [email protected]. > To > post to this group, send email to [email protected]. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/mnemosyne-proj-users/484d69db5a1a447f97e9c > 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 [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/mnemosyne-proj-users/t9oiir451m9jsrt21uxjf > ccj.1487222617676%40email.android.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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mnemosyne-proj-users/1326849080.504291.1487239354616.JavaMail.ngmail%40webmail08.arcor-online.net. For more options, visit https://groups.google.com/d/optout.
