Enhancement request: 'Native' importing of '.CSV' files

[Dave]

Derek,
The reason we are working on a free-standing tool is that 1) I wasn't aware
of the CSV importer in gnucash code, 2) the developer I'm working with
didn't mention it, and 3) and we have already started and made good progress
going in this direction. That said, I would be interested in learning more
about the CSV importer code. I assume this basic existing CSV import
functionality is not compiled into the release version of gnucash...
Regards,
Dave

On Tue, Jan 20, 2009 at 2:07 PM, Derek Atkins <warlord at mit.edu> wrote:

> Dave,
>
> Why work outside gnucash?
> GnuCash already has a basic CSV importer -- why not spend your
> time enhancing it?
>
> -derek
>
>
> Quoting Dave <dave at davestechshop.net>:
>
>  Hi John,
>> A developer from this list and I are working on something similar to what
>> you have requested. Work has started. A working prototype is close at
>> hand.
>>
>> I plan to make the completed tool available free (open source).  It will
>> run
>> outside gnucash and it targets Linux. It will allow complex CSV files to
>> be
>> easily and quickly imported into gnucash.
>>
>> My personal need is to import complex CSV files from Yodlee into gnucash.
>> I
>> use Yodlee to aggregate all my tranasactions because it is far superior to
>> the online banking features of gnucash or any other personal finance app
>> that I would consider using.
>>
>> However, if your needs are less complex than mine, you might want to take
>> a
>> look at one of these two tools:
>>
>> See link: http://www.mt2ofx.tk/ (freeware)
>>
>> Calc2Qif (http://xl2qif.chez-alice.fr/calc2qif_en.php).
>>
>> At some point I expect the tool we are working on will offer all the
>> important features of both the above tools.
>>
>> Regards,
>> Dave
>>
>> On Tue, Jan 20, 2009 at 1:26 PM, John Smith <lbalbalba at gmail.com> wrote:
>>
>>  Hi,
>>>
>>>
>>> I am aware of the fact that it currently is not possible to import
>>> arbitrary csv formatted files directly into GnuCash, and that instead
>>> you have to use or write python/perl/shell scripts to convert between
>>> the .csv and something that GnuCash understands like Intuit Quicken
>>> files. But since I am not a programmer, unfortunately I am unable to
>>> write a script or program to bulk transfer my bank supplied cvs files
>>> to GnuCash supported formats like Intuit Quicken.
>>>
>>> So I was wondering if there is any interest (both from user and
>>> developer sides) to create a 'native' import-csv-into-gnucash feature,
>>> preferably something where you can map fields of your csv file to
>>> gnucash fields, and perhaps even save the mapping into some sort of
>>> 'template' so that you can easily re-use the mapping when importing
>>> the next batch from your bank ?
>>>
>>> Anyway, just something I was wondering about... I can imagine that
>>> this topic has come up quite frequently already, so Im sorry if Im the
>>> one that brings this up for the Nth time, but it would just seem like
>>> such a basic and still very useful feature for banks that only supply
>>> CVV formatted files.
>>>
>>>
>>>
>>>
>>> Regards,
>>>
>>>
>>> John Smith
>>> _______________________________________________
>>> gnucash-devel mailing list
>>> gnucash-devel at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>>
>>>  _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>>
>>
>
>
> --
>      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>      Member, MIT Student Information Processing Board  (SIPB)
>      URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>      warlord at MIT.EDU                        PGP key available
>
>