Welcome to WebmasterWorld Guest from 35.173.234.237

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

PHP/mySQL -> Peachtree

     
9:58 pm on Mar 4, 2003 (gmt 0)

Preferred Member

10+ Year Member

joined:Jan 8, 2002
posts:465
votes: 0


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

11:24 pm on Mar 4, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Jan 14, 2002
posts:118
votes: 0


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

3:47 am on Mar 5, 2003 (gmt 0)

Preferred Member

10+ Year Member

joined:Jan 8, 2002
posts:465
votes: 0


I've been searching Google forever to try to figure this one out. I can't find it.
9:04 pm on Mar 5, 2003 (gmt 0)

Junior Member

10+ Year Member

joined:Dec 6, 2001
posts:99
votes: 0


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.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members