GNOME Bugzilla – Bug 121443
problem recognizing QIF quantity formats
Last modified: 2018-06-29 20:36:54 UTC
This may be a Quicken bug... I am using 1.8.5 When importing shares exported from Quicken french version : Formats for Q and I use ',' as decimal separator and ' '(space) as thousands separator. Importation fails when trying to import a line such as Q2 327,44 When a quantity appears as Q2,3456 it is correctly recognized as "2.3456" However, if you have 3 decimals Q2,345 is recognized as "2345.00" in effect multiplying by 1000 the quantity.
You are correct, a space is not considered a valid numeric separator. So the Quantity: "Q2 345,67" is not a valid numeric. This was actually OUTPUT from quicken? Or did this come from some bank? As for Q2,345 -- this is an ambiguous number. It can mean either: 2345 or 2 and 345/1000 The only way to determine what you mean is by looking at other numbers and comparing. If you find 1,234,567 then you know it's the first. If you see 2.30 you also know its the first. However if you had a 0.002,345 then you know it's the second. If you only have X,ABC then you have no way of knowing which to choose, so it chooses one (albeit incorrectly in your case). All I can suggest is fix your numbers to be unambigious... However I'll leave this bug open so I remember to at least examine the issue. QUESTION: Do other numerics also use a space as the thousands separator? What are some examples of other numeric values in your qif file?
In France, officially, the thousands separator is space and the decimal separator is comma. I suspect Quicken got the values from Windows. I'll have to test but in this case a solution might be to change the system separators on Windows before exporting. Editing the QIF by In addition, the format number I find in my QIF files are this way for Q and I, but regular US format (x,xxx.xx) for cash value. I'd say this is worth at least a entry in the FAQ. The problem is with Quicken in my opinion.
Huh.. I should've asked for a sample QIF file so I could add it to the tests.. Do you have a sample QIF transaction that I could use? I think i know how to fix this but I really want to have a test-case I could use. Thanks.
Question to amon@cs.stanford.edu: Can you please add a sample QIF file as an attachment to this bugreport? Thanks.
Closing this bug report as no further information has been provided. Please feel free to reopen this bug if you can provide the information asked for. Thanks!
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=121443. Please update any external references or bookmarks.