search

yoshistabber / anymemo

Automatically exported from code.google.com/p/anymemo
GNU General Public License v2.0
0 stars 0 forks source link

Import Mnemosyne2 cards action throws java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: Transaction callable threw non-SQL exception #294

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Select in AnyMemo Pro / Misc / Import / Import Mnemosyne2 cards
2. Try to import the attached Mnemosyne2 cards file
3. The exception java.lang.RuntimeException: java.lang.RuntimeException: 
   java.sql.SQLException: Transaction callable threw non-SQL exception
   will be thrown and the cards will not be importet

What is the expected output? What do you see instead?
I expect the cards to be successfully imported, instead I get the exception 
from above.

What is the AnyMemo version (E.g 8.999.1, 9.0, 9.1.1)?
AnyMemoPro 10.3.2

What is your Android phone model?
Samsung Galaxy S2 / GT-I9100

What is your Android version?
4.1.2

The cards-file was sent to device via email, saved to external sd card and I 
tried to import it from there.

Thank you very much in advance and let me know if I could provide additional 
information!

Original issue reported on code.google.com by Wolfram....@gmail.com on 9 Jan 2014 at 9:46

Attachments:

GoogleCodeExporter commented 8 years ago 
I see the problem. Each card has multiple category mapping and is currently not 
supported by AnyMemo. I will make it conversion ignoring the multiple category.

Original comment by mrlhwlib...@gmail.com on 9 Jan 2014 at 11:11

GoogleCodeExporter commented 8 years ago 
The format is like this:
<log card_t="2" fact_v="2.1" e="2.5" gr="-1" 
tags="R6LlB4Ml6mDbawMGve3eGY,klpxYyeJiuEbYb7Hxtp33e,qZie8WvnxKQYS5TnAUZBzZ,NTkMO
X3oT7EfTIlGhcxFmG,tRJjujSCG7J4apZzkUEwif,2jIxI1wWjFabzqZxPxcs6S" rt_rp_l="0" 
lps="0" l_rp="-1" n_rp="-1" ac_rp_l="0" rt_rp="0" ac_rp="0" type="6" 
o_id="tawmkcHUZUE7PBzgg1D5Go" fact="GVzSfLTdbls1O473rGawvn"></log>

Original comment by mrlhwlib...@gmail.com on 9 Jan 2014 at 11:11

GoogleCodeExporter commented 8 years ago 
Fixed the issue. You can try tomorrow's nightly build. I have attached the 
converted db file if you do not want to use the nightly build.

http://code.google.com/p/anymemo/source/detail?r=f5f8070b1cb5c042daf68c92e532363
d4f42f0f4

Original comment by mrlhwlib...@gmail.com on 9 Jan 2014 at 11:23

Attachments:

GoogleCodeExporter commented 8 years ago 
Thank you very much for the fast resolution of the problem and the converted 
database! Great work!

There is one issue left: The cards where added to be displayed both ways: 
Question -> Answer and Answer -> Question.

Importet to Anymemo it is only Question -> Answer.

The information has to be in the *.cards file, because it works correctly if 
imported into another installation of Mnemosyne on a different computer.

Should I open a new issue for this?

Again, thanks a lot in advance!

Original comment by Wolfram....@gmail.com on 10 Jan 2014 at 10:18

GoogleCodeExporter commented 8 years ago 
Each record is down twice in the XML file, the only difference is fact_v, I 
suppose they are mnemosyne versions but it also seems to indicate it is Q->A or 
A->Q. I don't get it at all. Luckily, you can use AnyMemo to swap the QA. 
1. Go to "Preview/edit"
2. elect "Advanced..." in the menu
3. select "Swap the Q/A of all cards"
4. Click the button "Swap&Dup", it will swap the Q/A of all cards and append 
them to the db.
5. (Optional), you can shuffle all cards in "Advanced..." -> "Shuffle all 
cards".

Related XML pasted here for reference.
<log type="16" o_id="55P8u30jl6sg4McDiIZ3GM">Go to declaration<f>Ctrl + B or 
Ctrl + Click</f></log>
<log card_t="2" fact_v="2.1" e="2.5" gr="-1" 
tags="R6LlB4Ml6mDbawMGve3eGY,klpxYyeJiuEbYb7Hxtp33e,qZie8WvnxKQYS5TnAUZBzZ,NTkMO
X3oT7EfTIlGhcxFmG,tRJjujSCG7J4apZzkUEwif,2jIxI1wWjFabzqZxPxcs6S" rt_rp_l="0" 
lps="0" l_rp="-1" n_rp="-1" ac_rp_l="0" rt_rp="0" ac_rp="0" type="6" 
o_id="FTncliixkjgiAVE3FzbWXf" fact="55P8u30jl6sg4McDiIZ3GM"></log>
<log card_t="2" fact_v="2.2" e="2.5" gr="-1" 
tags="R6LlB4Ml6mDbawMGve3eGY,klpxYyeJiuEbYb7Hxtp33e,qZie8WvnxKQYS5TnAUZBzZ,NTkMO
X3oT7EfTIlGhcxFmG,tRJjujSCG7J4apZzkUEwif,2jIxI1wWjFabzqZxPxcs6S" rt_rp_l="0" 
lps="0" l_rp="-1" n_rp="-1" ac_rp_l="0" rt_rp="0" ac_rp="0" type="6" 
o_id="MZw1HKt8ou4DgFR7fAwsd7" fact="55P8u30jl6sg4McDiIZ3GM"></log>

Original comment by mrlhwlib...@gmail.com on 10 Jan 2014 at 7:16

GoogleCodeExporter commented 8 years ago 
Mark as fixed due to no response from the original reporter. If you still have 
any issues, please feel free to leave comments here or create a new issue.

Original comment by mrlhwlib...@gmail.com on 14 Jan 2014 at 6:58