Re: Migrating from gnucash

Thank you very much. As soon as I have something working I'll post it in case anyone needs to use it. I need to transfer 5 companies so it'll be fun!
Thanks again.

Federico

Federico Gasparrini

Nixe Limited
85 Tottenham Court Road, London W1T 4TQ, United Kingdom
Phone: +44 (0) 20 8370 7900
Fax: +44 (0) 20 8370 7901
Mobile: +44 (0) 780 879 2525
Web: http://www.nixe.co.uk

Nixe s.r.l.
Pte. Luis Saenz Pena 366 4 "A", Buenos Aires, (1110), Argentina
Phone/Fax: +54 (0) 11 4383 7831 Ext.: 3002

Nixe Limited
Registered Office: 7 Bideford Gardens, Enfield EN1 2RP, United kingdom
Registered in England No. 3913108

From: "Chris Travers" <..hidden..>
To: "Development discussion for LedgerSMB" <..hidden..>
Sent: Wednesday, 25 January, 2012 8:39:03 AM
Subject: Re: [Ledger-smb-devel] Migrating from gnucash

On Mon, Jan 23, 2012 at 9:03 AM, Federico Gasparrini <..hidden..> wrote:

Hi,
I started writing a script in PHP (don't know perl) to migrate from gnucash to SQL_Ledger, then I discovered ledgersmb and I'd prefer to use it over sql-ledger.
I managed to get all the data from gnucash, and now I need to write into the ledgersmb database.
I'll be offering the script to the community once I've finished it.
My question is:
Is there any documentation on which tables are written when adding:
A client/vendor

entity, company, entity_credit_account, location eca_to_contact, eca_to_location, entity_bank_account, entity_note and/or eca_note

See stored procs in sql/modules/Entity.sql, sql/modules/Company.sql

A transaction (sale/purchase)

For sale:

ar, acc_trans, transactions (via triggers)

For purchase, same except ap instead of ar.

For a GL transaction,

gl, acc_trans, transactions (via triggers)

An invoice (sale/purchase)

Same as sale/purchase above except also invoice table.

Best Wishes,
Chris Travers

Thanks,
Federico

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel