yoshistabber / anymemo

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

XML spreadsheet does not convert to db file #278

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. create an xml spreadsheet with japanese characters in column a and english 
in column b
2. run the converter (prodices 7 KB file that seems to indicate that it is 
empty.)
3. move to phone
4. database is empty

What is the expected output? What do you see instead?
I expect to see my flash cards

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

What is your Android phone model?
EVO 3d

What is your Android version?
not sure

Original issue reported on code.google.com by rays0...@gmail.com on 13 Nov 2013 at 8:11

Attachments:

GoogleCodeExporter commented 8 years ago
The XML header shows:
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

AnyMemo does not support excel XML format. The only XML format supported are 
SuperMemo 2008 and SuperMemo 2004 PPC. 

If you want to export from excel, please use CSV format.

Here are some hints about the format:
http://anymemo.org/wiki/index.php?title=Formats

Original comment by mrlhwlib...@gmail.com on 13 Nov 2013 at 8:14

GoogleCodeExporter commented 8 years ago
I cant seem to use csv file without losing the Japanese characters.

Original comment by rays0...@gmail.com on 13 Nov 2013 at 8:27

GoogleCodeExporter commented 8 years ago
Windows default save as win1252/ ASCII encoding, that is not supported in 
Android.
You can use Notepad to open your .csv file and "Save as". Choose the encoding 
as "UTF-8" and then the Japanese should be displayed correctly.

Original comment by mrlhwlib...@gmail.com on 13 Nov 2013 at 8:37

GoogleCodeExporter commented 8 years ago
Thanks.I will give it a shot.

Original comment by rays0...@gmail.com on 13 Nov 2013 at 8:43