Newbie: Data import question

David Goodenough david.goodenough at linkchoose.co.uk
Mon Jun 8 11:26:41 EDT 2009


On Monday 08 June 2009, Derek Atkins wrote:
> Hi,
>
> David Goodenough <david.goodenough at linkchoose.co.uk> writes:
> > 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.
>
> As of this moment there is no way to import customer information into
> GnuCash.  GnuCash also wont be able to share the data with your CMS.
> There isn't a well-defined XML schema, and even if there were you
> wouldn't be able to just import it; you'd have to hand-edit your XML
> Data File (which isn't supported).
>
> Now, you COULD work on fixing the QSF importer before it gets ripped out
> for lack of love.....
That is something I could look at.  Where do I start looking for it (in the 
2.3.1 source) and how do I enable it?

My C is a bit rusty (I am normally a Java coder), but I am happy to give it
a go.  What kind of love does it require?  Are there known bugs, or are the
problems more basic than that?

David
>
> > David
> >
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek




More information about the gnucash-user mailing list