[Bug 571161] CSV import crash

Alan Jenkins sourcejedi.lkml at googlemail.com
Sun Feb 15 05:46:27 EST 2009


GnuCash (bugzilla.gnome.org) wrote:
> ------- Comment #4 from Andreas Köhler  2009-02-14 19:20 UTC -------
> Should be fixed by r17900 on trunk.
> Thanks a lot for the report and patience.
>   

Yes, that fixes it.

There are some remaining issues.  The CSV file comes from a niche UK
ethical building society, so it may not be a priority to fix :).  But I
think they're generally applicable and worth addressing.

Here's a screenshot showing errors during the import.

1) The first error is a blank line.  Blank lines should always be
ignored, and not cause errors.
2) Only one of the error messages is in the "errors" column.  (The other
lines have fewer columns).
3) It looks like it can't import amounts with commas such as "3,000.00".



And I have some rather more wishful ideas :)

4) It didn't auto-detect the date format.  The QIF import claims to be
able to do this.  But here I had to manually select "d-m-y".  My import
included unambiguous dates such as 25/04/2007.  2007 has got to be a
year, and 25 has got to be a day.  I think it'd be really impressive if
it could auto-detect this.

5) When it can't auto-detect date formats, it should provide a
locale-specific default.  (I'm not sure if QIF does this).  That should
cover 99% of cases, so that most users don't need to know what "d-m-y"
means.

6) It would be really great to detect the header row.  I.e.
automatically ignore the first non-blank row, if it can't be imported. 
(But only if _some_ rows have been imported successfully.  And maybe
require that _non_ of the values can be successfully interpreted as
dates or numbers).



Many thanks!
Alan

-------------- next part --------------
A non-text attachment was scrubbed...
Name: snapshot3.png
Type: image/png
Size: 51935 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20090215/52dc0112/attachment-0001.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: trans.csv
Type: text/csv
Size: 311 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20090215/52dc0112/attachment-0001.bin 


More information about the gnucash-devel mailing list