Bug 230788 - QIF Import misses decimal point
Summary: QIF Import misses decimal point
Status: RESOLVED NOT A BUG
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: unspecified
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-15 03:48 UTC by k6lw
Modified: 2010-04-17 12:58 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
Sample import file (1.70 KB, application/qif)
2010-03-20 15:50 UTC, k6lw
Details

Note You need to log in before you can comment on or make changes to this bug.
Description k6lw 2010-03-15 03:48:27 UTC
Version:           3.96.1 (using KDE 4.4.1)
OS:                Linux
Installed from:    Debian testing/unstable Packages

Importing a QIF representing pay statements with pay and with holdings. 
It appears that the decimal points were ignored so instead of importing $2916.14, kMyMoney
shows $291,614.00 in the ledger.  Looking at the splits in the details also shows all entries as whole numbers instead of the hundred decimals as listed in the QIF.  Version 1 of kMyMoney had no problems importing the same QIF file. Hence the bug report.
Comment 1 Thomas Baumgart 2010-03-15 08:07:07 UTC
Can you provide a sample (file) that shows the problem please? TIA.
Comment 2 k6lw 2010-03-15 17:19:19 UTC
I'll send it to you when I get home tonight.
Lee

--- On Mon, 3/15/10, Thomas Baumgart <ipwizard@users.sourceforge.net> wrote:

> From: Thomas Baumgart <ipwizard@users.sourceforge.net>
> Subject: [Bug 230788] QIF Import misses decimal point
> To: k6lw@arrl.net
> Date: Monday, March 15, 2010, 12:07 AM
> https://bugs.kde.org/show_bug.cgi?id=230788
> 
> 
> 
> 
> 
> --- Comment #1 from Thomas Baumgart <ipwizard users
> sourceforge net>  2010-03-15 08:07:07 ---
> Can you provide a sample (file) that shows the problem
> please? TIA.
> 
> -- 
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 3 k6lw 2010-03-16 06:01:54 UTC
Thomas,
I shortened the file to two entries and then imported it into my account and had the same thing happen. I got two new deposits with a ton of money. In addition the two entries are marked as reconciled. Which I don't believe should be correct either.

Lee
--- On Mon, 3/15/10, Thomas Baumgart <ipwizard@users.sourceforge.net> wrote:

> From: Thomas Baumgart <ipwizard@users.sourceforge.net>
> Subject: [Bug 230788] QIF Import misses decimal point
> To: k6lw@arrl.net
> Date: Monday, March 15, 2010, 12:07 AM
> https://bugs.kde.org/show_bug.cgi?id=230788
> 
> 
> 
> 
> 
> --- Comment #1 from Thomas Baumgart <ipwizard users
> sourceforge net>  2010-03-15 08:07:07 ---
> Can you provide a sample (file) that shows the problem
> please? TIA.
> 
> -- 
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 4 Thomas Baumgart 2010-03-16 19:55:45 UTC
Maybe. You must have forgotten to attach that small file to the bug report.
Comment 5 k6lw 2010-03-19 04:33:25 UTC
Let's see if Yahoo can send the file this time.
Lee
--- On Tue, 3/16/10, Thomas Baumgart <ipwizard@users.sourceforge.net> wrote:

> From: Thomas Baumgart <ipwizard@users.sourceforge.net>
> Subject: [Bug 230788] QIF Import misses decimal point
> To: k6lw@arrl.net
> Date: Tuesday, March 16, 2010, 11:55 AM
> https://bugs.kde.org/show_bug.cgi?id=230788
> 
> 
> 
> 
> 
> --- Comment #4 from Thomas Baumgart <ipwizard users
> sourceforge net>  2010-03-16 19:55:45 ---
> Maybe. You must have forgotten to attach that small file to
> the bug report.
> 
> -- 
> Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 6 k6lw 2010-03-20 15:50:56 UTC
Created attachment 41781 [details]
Sample import file

Here's a sample of a QIF which when imported ignores the decimal point.
Comment 7 Thomas Baumgart 2010-03-20 17:39:03 UTC
Your file is missing an export header. Check (for example) http://xl2qif.chez-alice.fr/download/QIF99.pdf which contains some information about the record format used. As soon as the export header is present, detecting of the decimal symbol will be working.

The export header is necessary because the identifiers are ambiguous between different groups of items. The identifier T alone has 4 different meanings.