Quickbooks to MySQL for a PHP/MySQL based site

This is a discussion on Quickbooks to MySQL for a PHP/MySQL based site within the PHP Language forums, part of the PHP Programming Forums category; is this possible, or does my client need to enter information in the DB manually (which I will end up ...


Go Back   Usenet Forums > PHP Programming Forums > PHP Language

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-10-2005
behindspace
 
Posts: n/a
Default Quickbooks to MySQL for a PHP/MySQL based site

is this possible, or does my client need to enter information in the DB
manually (which I will end up doing for them)

any ideas or links would be great,

thanks in advance!

Reply With Quote
  #2 (permalink)  
Old 03-10-2005
NC
 
Posts: n/a
Default Re: Quickbooks to MySQL for a PHP/MySQL based site

behindspace wrote:
>
> is this possible,


Yes. You need to export QuickBooks data into an IIF file
(this is QuickBooks' standard export-import format; essentially,
this is flat text with some twists, such as multiple lines
per transaction). Then you can twist the IIS around to
transform it into something importable into MySQL.

Last time I dealt with IIS was a couple of years ago, so I
don't remember all the details, but I do remember that somewhere
between QuickBooks help files and QuickBooks Web site I found
a pretty intelligible description of the IIF format...

Cheers,
NC

Reply With Quote
  #3 (permalink)  
Old 03-11-2005
behindspace
 
Posts: n/a
Default Re: Quickbooks to MySQL for a PHP/MySQL based site

I wouldn't be using IIS, I have a Linux server running Fedora Core 2, so
I'll be using Apache and MySQL on it's native platform. I can't deal with
IIS, it's to insecure, and prefer not to use M$FT at all (except for
gaming)

Reply With Quote
  #4 (permalink)  
Old 03-14-2005
NC
 
Posts: n/a
Default Re: Quickbooks to MySQL for a PHP/MySQL based site

behindspace wrote:
>

NC> Last time I dealt with IIS was a couple of years ago, so I
NC> don't remember all the details, but I do remember that somewhere
NC> between QuickBooks help files and QuickBooks Web site I found
NC> a pretty intelligible description of the IIF format...
>
> I wouldn't be using IIS,


My apologies. The quote above should read: "Last time I dealt
with IIF". The choice of HTTP server has no bearing on data
imports. In fact, you can do data imports without any HTTP
server, by using command-line scripting...

Cheers,
NC

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:07 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0