[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: importing ledger transactions

On Mon, Jan 21, 2013 at 11:11 AM, Grant <..hidden..> wrote:
>> Can anyone recommend a method for importing several years worth of
>> ledger transactions from gnucash into ledgersmb?
> You my talk to Federico Gasparrini and get some more info, and ask him
> for about the code.
> Migrating from gnucash
> http://ledger-smb.1045705.n5.nabble.com/Migrating-from-gnucash-td5166790.html

Thanks Havard.  As for CSV importation of bank transactions, I get the
impression this functionality is not quite complete.  Do folks using
ledgersmb really enter each bank transaction into the ledger

Ok, CSV import of bank transactions has sample code which works (based closely on what is working for one of my customers) but the problem you will run into is that it isn't really suitable for initial import.  This is for cash reconciliation only and so it is for on-going usage, not initial import.

We also have an addon that is capable of importing *very simple* AP batches and relatively complex GL transactions.  This is again working for a customer of mine in production, but again the use case isn't really for initial import.

For an initial import scenario, the first thing we'd need to establish is what information you have extracted in CSV format and what the columns represent.  From there I can start to make suggestions as to how to get this into LedgerSMB.  The existing CSV import code however is probably a bad place to start because it is aimed at relatively specific use cases of a different nature.

Best Wishes,
Chris Travers

- Grant

Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, _javascript_ and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. SALE $99.99 this month only -- learn more at:
Ledger-smb-devel mailing list