GnuCash
Contact   Instructions
Bug 797336 - CSV Accounts import fails on UTF-8 e-acute in account name
Summary: CSV Accounts import fails on UTF-8 e-acute in account name
Status: RESOLVED DUPLICATE of bug 797088
Alias: None
Product: GnuCash
Classification: Unclassified
Component: Import - CSV (show other bugs)
Version: 3.5
Hardware: PC Mac OS
: Normal normal
Target Milestone: ---
Assignee: import
QA Contact: import
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-04 17:22 EDT by Michael Hendry
Modified: 2021-09-23 18:50 EDT (History)
4 users (show)

See Also:


Attachments

Description Michael Hendry 2019-08-04 17:22:01 EDT
I have been experimenting with the export and import of accounts of the form:

Assets:Current Assets:Members:Surname_Forename

I was successful when I edited the export file down to a single account, but failed when I tried to import all of the members' accounts.

One of our members has an e-acute ("é") in his forename, and I suspected this might be the issue. Changing the e-acute to an ASCII lowercase "e" solved the problem.
Comment 1 Chris Good 2020-05-25 05:47:20 EDT
I tested this problem with current master (~3.10+).
I had to use a different format from above as now CSV importer says you must use same format as exported. Not sure when this started.

Here is the format that worked: (Using UTF-8)
type, full_name,name,code,description,color,notes,commoditym,commodityn,hidden,tax,placeholder
ASSET,Assets:Current Assets:Members:Surname_Forename1,Surname_Forename1,,Surname_Forename1,,,AUD,CURRENCY,F,F,F
ASSET,Assets:Current Assets:Members:Surname_Forenamé2,Surname_Forenamé2,,Surname_Forenamé2,,,AUD,CURRENCY,F,F,F
ASSET,Assets:Current Assets:Members:Surname_Forename3,Surname_Forename3,,Surname_Forename3,,,AUD,CURRENCY,F,F,F

Note 2nd data record (Surname_Forenamé2) has "é" in full_name, name and description.

If I didn't use "é" in full_name, but did in name, the record did not import, presumably because of mismatch between fullname + name.

Please try with the format as above?
Comment 2 Chris Good 2020-05-28 05:33:52 EDT
This seems similar to Bug 797088 where it works in Linux but not in Mac OS.
Comment 3 Chris Good 2020-05-28 05:40:32 EDT
My testing re comment 1 was in Linux.
Comment 4 John Ralls 2021-09-23 18:50:07 EDT

*** This bug has been marked as a duplicate of bug 797088 ***

Note You need to log in before you can comment on or make changes to this bug.