[Kmymoney-devel] [kmymoney4] [Bug 325437] New: CSV Importer Problems

[aga]

On Sun, 29 Sep 2013 18:47:30 +0000
Doug <dougt901-2012 at yahoo.com> wrote:

> https://bugs.kde.org/show_bug.cgi?id=325437
> 
>             Bug ID: 325437
>            Summary: CSV Importer Problems
>     Classification: Unclassified
>            Product: kmymoney4
>            Version: 4.6.3
>           Platform: unspecified
>                 OS: Linux
>             Status: UNCONFIRMED
>           Severity: normal
>           Priority: NOR
>          Component: general
>           Assignee: kmymoney-devel at kde.org
>           Reporter: dougt901-2012 at yahoo.com
> 
> CSV importer is buggy.
> 
> 1.  Cuts off payors randomly after "WDRL-POS "  Sometimes it includes
> the text that follow, sometimes, not, can't see a pattern to it.
 I don't understand that at all.
> 2.  The option to import "debit/credit columns" does not work -- in
> my case the debits are all negative numbers, so maybe that is the
> reason. 
So your file actually has columns for both debits and credits, but just
to make sure you understand, the debits have a minus sign as well?  So
that really makes the positive.  There should be no minus signs.  I've
not come across that before, but could certainly check for that.
> 3.HUGE problem: when importing investments, only can
> import one investment at a time.  So if the account has 30
> investments, they all come through as the same investment (or an
> error) and need to redo manually 30 times.
How are the individual investments identified in the file?  For a
multi-investment file, it is necessary to ensure each has a unique
ticker symbol, which can be added during the import process.  It
doesn't need to be a real symbol, unless you wish to do on-line price
updates
> 4.  Generally, the
> functionality does not seem reliable. 
> 5.  I can change data/fields in
> the importer dialog, but then the changes seem like they are ignored
> by the importer at least sometimes.
> 

Again, I don't have such a problem. 

Investment files tend to be formatted according to the whim of the
producer.  I have been able to import from three quite different
sources, and am happy to try to add more. Are you able to send me,
off-line, a small sample file, at least with a few different
investments, and which will demonstrate your issues?  The data does not
need to be your real private date, as long as the format is retained.

Allan

> Reproducible: Always
> 
> Steps to Reproduce:
> 1.  Use the CSV importer.
> Actual Results:  
> 1.  Takes a really long time to import data, lots of manual
> interventions.
> 
> Expected Results:  
> 1.  Should import the data without large manual interventions.
>