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 I

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

2009-01-20 Thread Derek Atkins
Hi, Quoting 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

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 CS

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

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

2009-01-20 Thread John Smith
On Tue, Jan 20, 2009 at 7:44 PM, Dave 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). It will run > outsi

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 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 checking out s

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 I

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

2009-01-20 Thread Andy Den Tandt
elijk 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

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

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

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 learnin

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

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 bit

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

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

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

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 and the records consist of "fields" delineated by commas. But t

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

2009-01-21 Thread Derek Atkins
John Smith 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 install') > > (I

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

2009-01-21 Thread Derek Atkins
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 into some sort of >> 'temp

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 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 working. A L

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 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 out the bugs.

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

2009-01-22 Thread Derek Atkins
John Smith writes: > On Wed, Jan 21, 2009 at 4:06 PM, Derek Atkins 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 littl

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 a

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

2009-01-22 Thread Derek Atkins
Hi, Quoting 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,

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 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:* *MONEYMRKT* This will

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 acco

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 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 current and al

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

2009-01-23 Thread Dave
On Fri, Jan 23, 2009 at 7:50 AM, John Smith wrote: > On Fri, Jan 23, 2009 at 12:23 PM, Martin Preuss 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 t

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

2009-01-23 Thread John Smith
On Fri, Jan 23, 2009 at 6:18 PM, Dave 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 out to me, but I t

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

2009-01-24 Thread Christian Stimming
Please file this observation as a bug report in bugzilla, preferably with a test OFX file so that this error can readily be reproduced by the developers. Thanks! Christian Am Donnerstag, 22. Januar 2009 22:26 schrieb Dave: > I want to report some observations (bugs?) regarding gnucash's OFX imp