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

[Derek Atkins]

It's in GnuCash Trunk in SVN.

-derek

Quoting Dave <dave at davestechshop.net>:

> 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
>>
>>
>



-- 
       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