Insert Customer using QIF file

Neil Williams linux at codehelp.co.uk
Fri Oct 29 04:46:37 EDT 2004


On Thursday 28 October 2004 11:19 pm, Derek Atkins wrote:
> On Thursday 28 October 2004 10:12 pm, Antonio Laterza wrote:
> Is There a way to import customers in Gnucash using QIF or xml or OFX file?
> I want i.e. edit a list of customer and then insert in Gnucash importing a
> file.

XML will be the method but it's not ready. I'm hoping to have the basics in 
place with pilot-link 0.13 (imminent release is 0.12) and that will work with 
GnuCash CVS HEAD. I'd look for useful interaction with the following release 
of GnuCash.

> > In the same way I wish to insert invoices in the same way.

I sympathise completely, but as I said off-list, there is a LOT more to this 
than a 'simple' CSV import (which itself is an oxymoron). I've wanted this 
functionality for over a year and it's taking all my time to implement it.

> Can't do that, either.  You can work on encouraging Neil to
> finish his CSV importer..

?? Things have changed a bit, I'm not considering CSV for the invoice data 
anymore - IMHO, I just don't feel CSV can cope. XML is the only realistic 
method, with QOF the intermediary. Even then, a reasonable amount of 
processing will be required within QOF.

It will be possible to write or create the XML directly - as long as a 'map' 
is defined of how to relate those objects to GnuCash objects. It's perfectly 
possible to write a separate program to create these QOF XML files and I'll 
need one for testing, but I doubt that even that will be able to accept 
arbitrary CSV content. With certain defaults and processing, it could accept 
pre-defined formats like QIF by utilising the QIF import code that already 
exists but I'm not sure what that would add to the QIF import we already 
have.

Instead, I'm adding QOF functionality to pilot-link with an XML file backend 
(see other message) and then mapping the QOF objects between the two 
applications.

Each application using their own objects makes it easy to exchange data in 
different ways with a variety of programs. With Linas' DWI, the data itself 
can be queried, independently of the application. It's about making the data 
accessible (free if you like) independently of the application that created 
it, using a framework that is capable of retaining meaning in complex data. 
It allows the data to be queried even if the source application is not 
installed, e.g. on a remote system, or cannot access the source data, e.g. 
pilot-link between HotSync's.

Possible methods:
1. GnuCash can query the pilot-link data directly using an offline XML QofBook 
storage and a map.
2. Pilot-link can query the GnuCash data file directly using QOF and a similar 
map.
3. Once other maps are defined, data can flow in any direction between 
applications. 

Whichever application is open at the time will do the work of mapping the QOF 
objects to the destination and writing a suitable QofBook XML file for import 
later if necessary. After all, any program will be able to import (and merge) 
any QofBook that uses it's own object definitions, it won't matter that it 
was written using a different QOF application. QOF becomes the intermediary, 
XML the method.

e.g. Sync the Palm to offline XML storage and then import the data directly 
using GnuCash. Or, it may be possible to create the GnuCash invoices directly 
from the HotSync. In effect, QOF would enable other applications to plug into 
GnuCash whilst allowing GnuCash to ALSO plug in to other applications.

Anyapp -> QOF wrapper -> QofBook in XML with map.
Anotherapp -> QOF wrapper -> converts the QofBook into it's own type using the 
map and imports (and merges) the data as if it was a native XML file.

Any other application that needs to exchange complex data is welcome to wrap 
QOF around suitable objects and define their maps, e.g. on the Psion.

-- 

Neil Williams
=============
http://www.codehelp.co.uk/
http://www.dclug.org.uk/
http://www.isbn.org.uk/
http://sourceforge.net/projects/isbnsearch/

http://www.biglumber.com/x/web?qs=0x8801094A28BCB3E3
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20041029/2dc80580/attachment.bin


More information about the gnucash-user mailing list