PHP/mySQL -> Peachtree

[RussellC]

I have seen this done but have never seen any documentation on it before. Does anyone know how to connect php/mysql sites to accounting programs like Peachtree? For example, pulling info from the mysql DB and creating invoices etc.

Thanks,
Russell

[Allen]

First you need to find out what types of files it accepts. Many software packages support easy-to-create file formats such as CSV or tab-delimeted.

If not, then you're probably going to have to get a hex editor and deconstruct the file manually (unless the software is open source, or someone has already posted file structure info on the web somewhere - Google is your friend :)

Allen

[RussellC]

I've been searching Google forever to try to figure this one out. I can't find it.

[nosanity]

I had a similar problem, but with another accounting program. After extensive research, ALOT of trial and error, several pots of coffee, and 2 large pizzas, I got it all working.

My project was based on QuickBooks, and all I needed to do was generate invoices that matched the same accounting data as was in MySQL. After a couple of phone calls to Intuit, they gave me a url (which I had seen but ignored) which explained how to create a Tab delimited file which could be imported into QuickBooks.

Moral: Call Peachtree Software technical support to ask them if they have a solution for importing data into their database. If it has an import feature, then they should be able to tell you how to use it, right?

noSanity

PS: Keep a copy of an origional invoice handy so you can compare the data you enter with the data that is normally entered by hand.