Newbie: Data import question

David Goodenough david.goodenough at linkchoose.co.uk
Mon Jun 8 10:54:39 EDT 2009


On Monday 08 June 2009, David Goodenough wrote:
> I have an existing Customer Management System (which as it happens is
> Postgresql based), and I need to be able to import customer details into
> GnuCash once they move from being prospects to being customers.  I would
> want to keep the CMS as the master in general for this.
>
> For some customers I also have billing generated from an external
> application which I then need to import into GnuCash.
>
> This is all in the planning stage at the moment, and I am trying out the
> new 2.3.1 version with its SQL support.  But I would expect that loading
> the data directly into the DB is going to be the wrong way to do this.
>
> What is the approved mechanism for doing this?  I can generate an XML form
> of the data quite easily if that would do, I just need the schema.
>
> David
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Reading further I see that I can export is QSF-XML format, which looks to be
about what I want for exporting data.  I then found a set if discussions about
using QSF to import Palm data (Neil Williams seems to be involved), and
that talked about importing invoices using QSF format, but I can not find
how to do the import.  The File->Import menu has QIF, OFX (which is good
as my bank uses OFX to export statement data), CSV or GnuCash log files, 
but nothing about QSF files.

David


More information about the gnucash-user mailing list