Re: Migration from Sage Line 50

[George James <..hidden..>]

Chris
Thanks but that's the wrong kind of answer - I guess I asked the question
wrongly. 

I'm not trying to do any data migration, I just want to start afresh with
Ledger-SMB from the start of a new financial year.  The data volumes are
small enough to do everything manually.

What I need to find out is, for example, if my bank account shows a balance
on sage of x at year end, where and how do I put that figure into
Ledger-SMB.

I don't even know what all the questions are, but these are the kind of
things I think we might have to do:
1) Enter opening balances for some GL accounts - which accounts and how to
do it
2) Customer account balances - Should all outstanding invoices at year end
be entered?  How?
3) Suppliers - ditto?
4) Stock - we don't do stock :)

Like I said, I need an idiots guide...

Regards
George

George James Software
www.georgejames.com


-----Original Message-----
From: ..hidden..
[mailto:..hidden.. On Behalf Of Chris
Travers
Sent: 05 February 2007 19:22
To: ..hidden..
Subject: Re: [Ledger-smb-users] Migration from Sage Line 50

I don't have any experience with Sage Line 50.

With unknown programs my pointer are to find out:
1)  How much data can you get out?
2)  What database system does it use on the back-end?
3)  If you cant export data, are there other means (i.e. custom ODBC
drivers) that can access the info?

If you can get that information, you are about 50% of the way there.

A few pointers about such migrations I have found helpful:
1)  Import into holding tables that match the existing schema of your old
application first.  This gives you a backup in case you need to re-import
the data in order to get it right.
2)  If you need a quick guide to the current (1.1/1.2) db schema, I can
write one up really fast for you and post it to thi list.

3)  If you get stuck in specific areas, we may be able to be of more help

Best Wishes,
CHris Travers
On 2/5/07, George James <..hidden..> wrote:
>
>
> Hi
> We got Ledger-SMB installed and ready to go.
>
> We've been using Sage Line 50 up to now and I'm wondering if there is 
> an idiots guide to migrating to Ledger-SMB from Sage.
>
> If not, can anyone provide any pointers on what to do?
>
> George
> ----------------------------------------------------------------------
> --- Using Tomcat but need to do more? Need to support web services, 
> security?
> Get stuff done quickly with pre-integrated technology to make your job 
> easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache 
> Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=1216
> 42 _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users