Newbie: Data import question

Derek Atkins warlord at MIT.EDU
Mon Jun 8 11:11:26 EDT 2009


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

> David

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

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available


More information about the gnucash-user mailing list