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

Derek Atkins warlord at MIT.EDU
Tue Jan 20 14:07:07 EST 2009


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



More information about the gnucash-devel mailing list