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

date posted 14th June 2007 12:25

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.