XML spreadsheet does not convert to db file

[helloworld1]

Original issue 278 created by helloworld1 on 2013-11-13T20:11:10.000Z:

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

[helloworld1]

Comment #1 originally posted by helloworld1 on 2013-11-13T20:14:32.000Z:

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

[helloworld1]

Comment #2 originally posted by helloworld1 on 2013-11-13T20:27:53.000Z:

I cant seem to use csv file without losing the Japanese characters.

[helloworld1]

Comment #3 originally posted by helloworld1 on 2013-11-13T20:37:03.000Z:

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.

[helloworld1]

Comment #4 originally posted by helloworld1 on 2013-11-13T20:43:54.000Z:

Thanks.I will give it a shot.