SQL Query

8 Aug 2006, 10:51 PM

#1

New Zenner

Join Date:: Aug 2006
Posts:: 36
Plugin Contributions:: 0

SQL Query

Hello,

I've been searching all over the forum to find a sql query that will pull customer information and order information and order product attribute information into one export to a csv file.

I have picked up some syntax but am having no luck with it. I am working with a trial version of EMS SQL data exporter and it will download the tables, but I don't know how to add the query to make it produce one download file with all the info.

Has anyone done this? And if so are you willing to share?

Rhonda

9 Aug 2006, 12:30 AM

#2

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: SQL Query

I use a program to do this work. I am sure that there are many but the one I use is "Navicat MySQL" and as I recall there is a trial for evaluation. You can see if it gets you what you want.

Zen-Venom Get Bitten

9 Aug 2006, 1:02 AM

#3

rgoetz

New Zenner

Join Date:: Aug 2006
Posts:: 36
Plugin Contributions:: 0

Re: SQL Query

Oh thank you! I love this. It's interface is similar to access query windows, but better! Worth the $100 to me.

Rhonda

9 Aug 2006, 1:19 AM

#4

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: SQL Query

Glad that you might find it useful...it also does other things like access, orcale to ?? and will create the queries that you want to excecute on a regular basis and, and...

Good Luck with this as I have found it invaluable as long as I know what settings are required.

Zen-Venom Get Bitten

9 Aug 2006, 6:08 AM

#5

designbydemeter

Zen Follower

Join Date:: Jun 2006
Location:: Taos,NM
Posts:: 225
Plugin Contributions:: 0

Re: SQL Query

Would this program do things for example - let me export my pricing for all my products to a file?

Thanks,
Laura

Laura M Collins Invitation Designs

"The best way to navigate in a new area is to first get totally lost in it."...Mike L. Stein

9 Aug 2006, 8:15 AM

#6

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

Re: SQL Query

Yes. SQLyog will do similarly. So does Easy Populate. Each has their own approach and pro/con's.
The new Sales Report due out soon also has some export capabilities.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.