RE: FN-FORUM: Sage integration with php/MySQL

date posted 14th June 2007 13:25

Mike A wrote:
>
> From: "Duncan Glendinning" [EMAIL REMOVED]
> >
> > I am building an ads campaign management tool for a publishing
> > company, who would like to manage their advertisers, the
> adverts, the
> > issues, etc.. and ultimately the orders (=money) taken.
> > They only wish to have certain financial on the system so I
> can write
> > custom reporting scripts for them, but still wish to use
> Sage Line 50
> > Accounts to send out the invoices and track their payments.
> > I therefore need a way of synchronising the customer
> entries in sage
> > with those in the web app. What i plan to do is make a "synchronise
> > customers" button which will create a CSV tailored to be
> imported for
> > the customers entries in Sage, so they can update Sage that way.
> > Problem is, what about synchronising back the other way? In
> case a new
> > customer is added to Sage and not the web app?
> > Also, how hard will it be to pass over the order info from
> the web app
> > to sage so it generates the invoices?
> >
> > Any advice from anyone who has been there greatly
> appreciated. This is
> > all being developed using PHP/MySQL. Maybe there are some
> > bridging/synchronising programs out there worth getting to save
> > re-inventing the wheel?
>
> Saage have an excellent tech support team - have you spoken
> with them? They may already have your answers. There's also a
> developers program which, if joined, will provide access to
> the full Sage API and objects.
>
> Mike A.
>
>

In my experiences in the Sage Developer program (and in general) Sage tech
support won't tell you anything unless you are paying for a support contract
(i.e. extra to the cost of the Sage product)... Even if you are a Sage
Developer, you still have to buy an extra support package to get them to
give you technical API support, and it becomes more complicated if you are a
developer doing this on behalf of your customer.

Duncan, to get data out of Sage, there will be a specific Sage database ODBC
driver installed on the machine running L50 that allows you to read the
tables of the Sage database (it's Access based)... Email me off-list if you
need password info (assuming they've not changed) etc. As for passing orders
into Sage to produce invoices, this definitely requires the Sage Developer
API... I've been there and done that and take my advice from my bitter
experience... Find an existing registered Sage Developer and pay them to
write this invoicing interface for you instead.

Dave.
_____________________________________________________________________
Dave Boulden, Director. DA Media Limited
web: http://www.da-media.co.uk/ Tel: 01795 559456 Fax: 07092 011488
DA Media Limited is registered in England and Wales, No: 04283345