[SOLVED] QuickBooks Database Online?

Darnel_380 · 06-01-2009, 01:40 PM

I would like to set up a new site and have all the items organized into categories and then have a generic page pulled up for every item and have it automatically filled in with information from a database.

What I want to know is if I can use my QuickBooks database which is already complete and either automatically update online (which I know would be more complicated) or more preferably have it so I can upload a new database when I chose.

I also need this to pull a corresponding photo of the item for the page if possible. Would I need an intermediate database where I combine the item and such with the picture?

I use QuickBooks Premier 2006 and Dreamweaver CS3 and am relatively new to both. Any help would be appreciated.

ParsaAkbari · 06-07-2009, 03:17 AM

Okay Darnel 380, i was faced with this dilema around 3months ago when i was planning my website.

Im not sure what your trying to say but i think your saying:
"I want to have a page with prices that are from a automatically updating database"

I dont know much about quickbooks, but i THINK its possible to intergrate it to a SQL database (like mySQL).

Im not sure if you can operate quick books automatically updating feature while it is a SQL database, IF it is possible it will be very easy to use PHP to get the variables from the SQL database and echo them onto the screen.

Darnel_380 · 06-08-2009, 01:02 PM

Quote:

Im not sure what your trying to say but i think your saying:
"I want to have a page with prices that are from a automatically updating database"

Yes I would like it to automatically read from the QuickBooks database if possible. What I would really like to know is what format of a database would QuickBooks put out so that DreamWeaver could load it and use that for my site.

Thanks

ParsaAkbari · 06-13-2009, 11:10 AM

In that case, since i do not know much about 'quick books' i would convert fully to mySQL, once you do having pages that update from a database is blindingly simple.

Darnel_380 · 06-23-2009, 02:15 PM

I am not familiar in MySQL, but I could learn. I just need a way to move data from Quickbooks into any database management tool (I think Access works better with MySQL) so I don't have to retype all of that data.

Darnel_380 · 07-03-2009, 03:24 PM

I have changed my mind on what I plan to do so here is my new question on this issue:

Graphic Version of MySQL

06-01-2009, 01:40 PM	#1 (permalink)
Darnel_380 Registered User Join Date: Apr 2009 Location: Illinois Posts: 82 OS: Windows XP SP3, Vista	[SOLVED] QuickBooks Database Online? I would like to set up a new site and have all the items organized into categories and then have a generic page pulled up for every item and have it automatically filled in with information from a database. What I want to know is if I can use my QuickBooks database which is already complete and either automatically update online (which I know would be more complicated) or more preferably have it so I can upload a new database when I chose. I also need this to pull a corresponding photo of the item for the page if possible. Would I need an intermediate database where I combine the item and such with the picture? I use QuickBooks Premier 2006 and Dreamweaver CS3 and am relatively new to both. Any help would be appreciated.

06-07-2009, 03:17 AM	#2 (permalink)
ParsaAkbari Registered User Join Date: May 2009 Posts: 16 OS: Windows Vista Home Premium	Re: QuickBooks Database Online? Okay Darnel 380, i was faced with this dilema around 3months ago when i was planning my website. Im not sure what your trying to say but i think your saying: "I want to have a page with prices that are from a automatically updating database" I dont know much about quickbooks, but i THINK its possible to intergrate it to a SQL database (like mySQL). Im not sure if you can operate quick books automatically updating feature while it is a SQL database, IF it is possible it will be very easy to use PHP to get the variables from the SQL database and echo them onto the screen. __________________ Sticks and stones may break my bones, but whips and chains excite me.

06-13-2009, 11:10 AM	#4 (permalink)
ParsaAkbari Registered User Join Date: May 2009 Posts: 16 OS: Windows Vista Home Premium	Re: QuickBooks Database Online? In that case, since i do not know much about 'quick books' i would convert fully to mySQL, once you do having pages that update from a database is blindingly simple. __________________ Sticks and stones may break my bones, but whips and chains excite me.

06-23-2009, 02:15 PM	#5 (permalink)
Darnel_380 Registered User Join Date: Apr 2009 Location: Illinois Posts: 82 OS: Windows XP SP3, Vista	Re: QuickBooks Database Online? I am not familiar in MySQL, but I could learn. I just need a way to move data from Quickbooks into any database management tool (I think Access works better with MySQL) so I don't have to retype all of that data.

07-03-2009, 03:24 PM	#6 (permalink)
Darnel_380 Registered User Join Date: Apr 2009 Location: Illinois Posts: 82 OS: Windows XP SP3, Vista	Re: QuickBooks Database Online? I have changed my mind on what I plan to do so here is my new question on this issue: Graphic Version of MySQL