GnuCash fails to import some CP932 CSV files because of libgoffice problem

Bug #630214 reported by Yasuaki Taniguchi
10
This bug affects 1 person
Affects Status Importance Assigned to Milestone
GOffice
Fix Released
Medium
GnuCash
Fix Released
Medium
Ubuntu Japanese Kaizen Project
Fix Released
Low
Unassigned
goffice (Ubuntu)
Fix Released
Low
Unassigned
Nominated for Lucid by Yasuaki Taniguchi
Nominated for Maverick by Yasuaki Taniguchi

Bug Description

GnuCash fails to import some CP932 CSV files, which contains NEC/IBM extensions characters (ex. roman numbers, numbers with circle, square cm sign).
This seems to be libgoffice problem.

A sample file "cp932.csv" is attached.

[Expected behavior]
GnuCash can import successfully like gnucash-cp932-good.png.

[Actual behavior]
GnuCash fails to detect the CP932 encoding like gnucash-cp932-invalid-dialog.png and gnucash-cp932-invalid-dialog2.png

[Workaround for this problem]
Apply an attached patch goffice-0.8.1-sjischarmap.patch

Tags: patch
Revision history for this message
Yasuaki Taniguchi (yasuakit) wrote :
Revision history for this message
Yasuaki Taniguchi (yasuakit) wrote :
Revision history for this message
Yasuaki Taniguchi (yasuakit) wrote :
Revision history for this message
Yasuaki Taniguchi (yasuakit) wrote :
Revision history for this message
Yasuaki Taniguchi (yasuakit) wrote :
Revision history for this message
Yasuaki Taniguchi (yasuakit) wrote :

Additional workaround
Use iconv program before importing CSV file like this:
$ iconv -f CP932 -t UTF-8 -o utf-8.csv cp932.csv

tags: added: patch
Changed in gnucash:
status: Unknown → New
Changed in goffice:
status: Unknown → New
Changed in gnucash:
importance: Unknown → Medium
Changed in goffice:
importance: Unknown → Medium
Changed in gnucash:
status: New → Fix Released
Changed in goffice:
status: New → Fix Released
Revision history for this message
Charlie Kravetz (cjkgeek) wrote :

Thanks for reporting this bug and any supporting documentation. Since this bug has enough information provided for a developer to begin work, I'm going to mark it as confirmed and let them handle it from here. Thanks for taking the time to make Ubuntu better!

Changed in goffice (Ubuntu):
status: New → Triaged
importance: Undecided → Low
Revision history for this message
Nobuto Murata (nobuto) wrote :

Your patch has been accepted in upstream as 0.8.11. Our latest development release Natty already has 0.8.12-1.
It would help us greatly if you could test with it. You can find out more about the development release at http://www.ubuntu.com/testing/ . Thanks again and we appreciate your help.

Changed in goffice (Ubuntu):
status: Triaged → Incomplete
Nobuto Murata (nobuto)
Changed in ubuntu-jp-improvement:
importance: Undecided → Low
status: New → Triaged
Revision history for this message
Nobuto Murata (nobuto) wrote :

Fixed version is already in Ubuntu natty. So "Fix Released" status is more appropriate than "Incomplete". Feel free to reopen this bug if you think it's not fixed.

Changed in goffice (Ubuntu):
status: Incomplete → Fix Released
Changed in ubuntu-jp-improvement:
status: Triaged → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.