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

2009-01-23 Thread John Smith
On Fri, Jan 23, 2009 at 12:23 PM, Martin Preuss aquaman...@gmx.de wrote: As I said, GnuCash currently doesn't use AqBanking's CSV importer. Sorry, my mistake for misunderstanding. What is missing in GnuCash is a more generic approach to use the AqBanking importers so that GC can use all

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

2009-01-23 Thread Dave
On Fri, Jan 23, 2009 at 7:50 AM, John Smith lbalba...@gmail.com wrote: On Fri, Jan 23, 2009 at 12:23 PM, Martin Preuss aquaman...@gmx.de wrote: As I said, GnuCash currently doesn't use AqBanking's CSV importer. Sorry, my mistake for misunderstanding. What is missing in GnuCash is a

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

2009-01-23 Thread John Smith
On Fri, Jan 23, 2009 at 6:18 PM, Dave d...@davestechshop.net wrote: Well, there are simple solutions that are currently available: 1. csv2ofx http://github.com/mulicheng/csv2ofx/tree/master 2. http://www.mt2ofx.tk/ 3. http://xl2qif.chez-alice.fr/calc2qif_en.php Thanks for pointing those

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

2009-01-22 Thread Derek Atkins
John Smith lbalba...@gmail.com writes: On Wed, Jan 21, 2009 at 4:06 PM, Derek Atkins warl...@mit.edu wrote: GnuCash is absolutely the right place for this. We already have the infrastructure for it, we already have a basic parser and a basic GUI for it. All the tools are there. It's just

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

2009-01-22 Thread John Smith
Great. That only leaves me with the question of which distribution to use to start the building and testing on ? I initially tried Red Hat Enterprise Linux 4, but almost all of the packages used there were severely out of date. Then I switched to Fedora 10, which gave me a cryptic error message

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

2009-01-22 Thread Derek Atkins
Hi, Quoting John Smith lbalba...@gmail.com: Great. That only leaves me with the question of which distribution to use to start the building and testing on ? I initially tried Red Hat Enterprise Linux 4, but almost all of the packages used there were severely out of date. Then I switched

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

2009-01-22 Thread John Smith
On Thu, Jan 22, 2009 at 8:53 PM, Derek Atkins warl...@mit.edu wrote: Fedora 10 is fine.. You're just missing the -devel package. But yes, the error is somewhat cryptic. try: yum install gtkhtml3-devel Thanks (again), that worked like a charm. Regards, John Smith

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

2009-01-22 Thread Dave
I want to report some observations (bugs?) regarding gnucash's OFX import function. With the import of any OFX file I have tested, there is a reproducible bug. The bug shows up in two different ways depending on the content of the ACCTTYPE element in the OFX file. *Case 1:*

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

2009-01-22 Thread John Smith
Ok, So Im playing around with the CSV data importer, but the layout of my data is a little bit different than the importer expects. The basic layout is as follows : Date,Description,Bank Account number,Counter Bank Account number,Code,Withdrawal/Deposit,Amount,Mutation Kind,Notes Where bank

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

2009-01-21 Thread marcus.wolschon
On Tue, 20 Jan 2009 19:26:46 +0100, John Smith lbalba...@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

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

2009-01-21 Thread Mike or Penny Novack
I just want to point out what .cvs support entails for the benefit of those for whom this isn't immediately obvious. .cvs refers to the low level format of the data -- just that the file of data consists of records? delineated by newline and the records consist of fields delineated by commas.

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

2009-01-21 Thread Derek Atkins
John Smith lbalba...@gmail.com writes: Great! I'd love to play with that. However, Im a complete newbie to checking out source code from a repository and compiling, so could you give me a quick newbie friendly way to check out and compile that ? (my knowledge stops at './configure;make;make

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

2009-01-21 Thread Derek Atkins
marcus.wolsc...@googlemail.com writes: 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

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

2009-01-21 Thread John Smith
On Wed, Jan 21, 2009 at 4:02 PM, Derek Atkins warl...@mit.edu wrote: Read the Wiki page on Win32? In short, install the basic MinGW development system, check out the 'packaging/win32' directory, and then run 'install.sh' Nah, ive tried fooling around with MSYS before, and never got it quite

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

2009-01-21 Thread John Smith
On Wed, Jan 21, 2009 at 4:06 PM, Derek Atkins warl...@mit.edu wrote: GnuCash is absolutely the right place for this. We already have the infrastructure for it, we already have a basic parser and a basic GUI for it. All the tools are there. It's just buggy and needs a little TLC to flush

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

2009-01-20 Thread John Smith
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

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

2009-01-20 Thread Derek Atkins
Hi, Quoting John Smith lbalba...@gmail.com: 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

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

2009-01-20 Thread Dave
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

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

2009-01-20 Thread Derek Atkins
Dave, Why work outside gnucash? GnuCash already has a basic CSV importer -- why not spend your time enhancing it? -derek Quoting Dave d...@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

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

2009-01-20 Thread John Smith
On Tue, Jan 20, 2009 at 7:44 PM, Dave d...@davestechshop.net wrote: 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).

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

2009-01-20 Thread John Smith
On Tue, Jan 20, 2009 at 7:41 PM, Derek Atkins warl...@mit.edu wrote: There is already a CSV importer in Trunk. It's buggy, but if you wanted to continue working on it you at least have something to start with! -derek Great! I'd love to play with that. However, Im a complete newbie to

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

2009-01-20 Thread Dave Reiser
John Smith 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

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

2009-01-20 Thread Andy Den Tandt
bericht- Van: gnucash-devel-boun...@gnucash.org [mailto:gnucash-devel-boun...@gnucash.org] Namens John Smith Verzonden: dinsdag 20 januari 2009 19:27 Aan: gnucash-devel@gnucash.org Onderwerp: Enhancement request: 'Native' importing of '.CSV' files Hi, I am aware of the fact that it currently

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

2009-01-20 Thread Derek Atkins
It's in GnuCash Trunk in SVN. -derek Quoting Dave d...@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

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

2009-01-20 Thread 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

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

2009-01-20 Thread Dennis Muhlestein
Derek Atkins wrote: It's in GnuCash Trunk in SVN. -derek Quoting Dave d...@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

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

2009-01-20 Thread Martin Preuss
Hi, On Dienstag, 20. Januar 2009, Dave Reiser wrote: [...] aqbanking (but maybe only the almost release version4?) also has some capability for csv handling. I'm pretty sure that would mean someone would have to write a module for gnucash talking to the csv piece instead of ofx or hbci bits

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

2009-01-20 Thread Dave
On Tue, Jan 20, 2009 at 3:59 PM, Dennis Muhlestein djmuhlest...@gmail.comwrote: Derek Atkins wrote: It's in GnuCash Trunk in SVN. -derek Quoting Dave d...@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