Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sales Report - use as general Data Export Tool


DogTags

Recommended Posts

Hi All

 

Trying the Sales Report tool - very nice

 

Would like to make it a more general data export tool

 

For instance, would be great if it could export customer shipping address data to be used for an address label mailmerge.

 

Has anyone tried this? Is it possible?

 

Any other export tools around? So far, haven't found any.

 

Many thanks :)

Edited by DogTags
Link to comment
Share on other sites

you can use mysql odbc to pull the info out of mysql and into whatever app you want to use, as long as it supports odbc

Thanks, John :)

 

I'm not sure how to apply mysql odbc directly, but might you know of any mysql tools, either win based or lin, that can do this?

 

Maybe there is a tool out there that can be aimed at the db to do the extractions.

 

Many thanks :)

Link to comment
Share on other sites

it doesnt matter who's tool, they all will have to use mysql odbc if they want to talk with a mysql database from a windows application.

thus go to mysql.com and download the odbc connector, set it up and then you can open the database via excel. you may need to go to the help files for learning the proper way, as that is not a part of this forum, but there are plenty out there to teach you how to use odbc, if you dont want to use the help files.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...