Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Orders to excel?


willard

Recommended Posts

Posted

Is the a way to copy or get a report to put into excel so I can use excel to work with my orders?

 

I am getting so many orders , its hard to go 1 by 1 online to copy the info and place into excel.

 

I sure hope I explained this right,

I am going crazy try to figure out a way to do this,

 

 

Thanks

Posted

First of all, congratulations!!! You have what we call a "Class A" headache....so many orders that they are hard to keep up with. That's a good one to have.

 

Second, it can be done but it's not as easy as just downloading a file. If you have any Access experience, you can create a database that can handle what you need. You would export the seven(7) "Orders" tables in the "CSV for Ms Excel data" format(easiest to so if you use phpMyAdmin 2.5.2-pl1 as your mysql client).

 

Once you have exported the tables you can import them into Access. Once your tables exist in Access you would then join the tables by "orders_id". Once you have done that you can create all types of forms, reports and crosstabs that can give you all types of information.

 

Now that I have said all that, I realize that we could use the same thing as our business grows. I will knock the rust of mu Access skills and will give it a try. If I come up with anything worthwhile, I will let you know. It will be a welcome distraction for a couple of hours.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

OK...now this has gotten deep. A search has turned up this solution MySql to Access and I am digging into it. Check it out.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

Well I didn't get far. Installing the application went fine but when I try and import or link tables I get an error saying my db server doesn't exist....when if course it does. If anyone get's this to work, please let me know. Meanwhile, I will keep looking.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

Worked fine for me on my local PC, are you trying to connect to an online server.

Sounds like you have put the wrong server name, hostname or database name in the fields during the install and connect procedure.

Posted

I have the client installed on my local pc and am connecting to the MySql server that drives my website via the Internet. All of the variables are correct it just doesn't like what I am trying to do. I will continue to research.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

If your settings are right do you have a firewall running it might block the connection.

 

Mine worked okay but my server is on my local PC as well as the client. Works great and is really worth the effort to get it going.

Posted

I didn't think of that. I just tried it though with the firewall disabled and it doesn't work. I am beginning to belive that my host only allows connections to the database from within the domain (i.e. phpMyAdmin). Some are like that. So I am going to look at automating the exports from MySql....it will be a pain to do it manually each time.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

You could export the tables using phpMyadmin, download the files and import them onto a mysql database on your PC. Then setup Access to it there.

Only thing is you would have to regularly keep the database up to date with the one online.

Posted

Also found this link on installing and connecting to online database using Access or Excel Click Here to view.

Posted

thanks...I'll check it out.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

OK.....that would be better than trying to keep up with certain reports online. I just dowloaded MySql 4.0 and will install it. Wish me luck. I have never used anything other than my host's MySql.

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

Well that's not going to work. I opened the 3.5 meg install doc that came with the MySql download and it has enough instructions to launch the space shuttle. I am a functional user of OSC but certainly not a programmer or server expert. The install was easy but I was hoping for some type of gui to configure it. It is really this complicated or am I missing something? Do I need a server running on my laptop?

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

I found a great tutorial the other day which gives step by step detail on installing Mysql, PHP, Apache and configure in Windows.

Link is Here For All to Find B)

Posted

What the heck...you only live once...here goes

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

thanks so much...the last link gave a very clear set of instructions. Installed Apache and found MySql gui....

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

smooth as a babies behind...udaman

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

Unbelievable...in 1.5 hours I have installed and have running on my local machine:

php4

mysql

apache

phpmyadmin

 

All of this because I just wanted to run a mysql-to-access application.

 

 

I can now work on my websites offline as a testbed. I am sure everyone else already knew this. That tutorial is the coolest thing out there.

 

Thanks again

"Aliiiiive, it's alive, it's ALIIIIIIIIIIIIIVE!!!"

Posted

Now you can play till your hearts content but don't forget to,

 

backup, backup backup B) :rolleyes:

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...