[Kmymoney-devel] [Bug 282763] Kmymoney crashes while importing .csv

[allan]

https://bugs.kde.org/show_bug.cgi?id=282763





--- Comment #3 from allan <agander93 gmail com>  2011-09-26 10:59:47 ---
(In reply to comment #2)
> I managed to get it to work right before I left home. The csv had 3 lines at 
> the top that only appeared in colum 1 in csv format, and then the header row. 
> I deleted the 3 lines and the header from the file and the import went 
> perfect. I did not back up the file first so I do not have a copy of the 
> original formatting to send. If I remember correctly the formatting was like 
> this:
> 
> name of institution
> account number
> some description
> 
> transaction number,date,payee,description,debit,deposit
> data,data,data,data,data,data
> data,data,data,data,data,data
> data,data,data,data,data,data
> data,data,data,data,data,data
> data,data,data,data,data,data
> data,data,data,data,data,data
> etc...
> 
> 
> Not backing up the original was carless of me. This is the first time I have 
> submitted a bug and I diddnt think it through first. Ill be more thorough next 
> time and have some better feedback to help with the troubleshooting.
> 

I constructed a test file by adding your header lines to the top of a valid csv
file.  The only way I could reproduce your problem was by failing to set the
first line to the correct value on the Settings tab.  Leaving it set to '1'
will result in that error message appearing.  Prior to that, another warning
appears, an empty cell having been detected in the amount column on row 1. 
Ignoring that and proceeding to import, your message appears.  Clicking
'accept'
or accept all brings up an error message that an invalid date has been detected
on row 1.

As far as I can see, the logic is correct, and can only assume you failed to
set the first line correctly on the Settings tab.

If you will be able to retry with another file, I'll leave this bug open,
unless you con confirm that an incorrect setting was used.

In the event of a further problem, it might help if you can enable debug
symbols.
> On Sunday, September 25, 2011 09:33:26 PM allan wrote:
> > https://bugs.kde.org/show_bug.cgi?id=282763
> > 
> > 
> > allan <agander93 at gmail.com> changed:
> > 
> >            What    |Removed                     |Added
> > ----------------------------------------------------------------------------
> > CC|                            |agander93 at gmail.com
> > 
> > 
> > 
> > 
> > --- Comment #1 from allan <agander93 gmail com>  2011-09-25 21:33:25 ---
> > (In reply to comment #0)
> > 
> > > Application: kmymoney (4.6.0)
> > > KDE Platform Version: 4.7.1 (4.7.1) "release 8"
> > > Qt Version: 4.7.4
> > > Operating System: Linux 2.6.37.6-0.7-desktop x86_64
> > > Distribution: "openSUSE 11.4 (x86_64)"
> > 
> > Would it be possible for you to send direct to me a copy of your csv
> > file, if necessary with private data changed, as long as the format
> > remains intact.
> > 
> > Allan

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.