totallyb Posted October 24, 2008 Share Posted October 24, 2008 hi all - does anyone know if there is anyway to download the customer database in a format where you can print off all the names and addresses etc - thanks in advance Link to comment Share on other sites More sharing options...
danjt Posted October 24, 2008 Share Posted October 24, 2008 Have you got access to the database? If so you can export an XLS from it. Phpmyadmin will get you in. Link to comment Share on other sites More sharing options...
totallyb Posted October 24, 2008 Author Share Posted October 24, 2008 Have you got access to the database? If so you can export an XLS from it. Phpmyadmin will get you in. hi - thanks for this but i am not very technical - where do i find the phpmyadmin and whats an xls - i have access to the database no problem but i dont really know my way around the file system - thx Link to comment Share on other sites More sharing options...
danjt Posted October 24, 2008 Share Posted October 24, 2008 xls is an Excel Spreadsheet and phpmyadmin is a way of reading an sql database. If you have access to the database then you can export from it somehow? How do you access it? You need to export the customers and address book tables. Link to comment Share on other sites More sharing options...
totallyb Posted October 24, 2008 Author Share Posted October 24, 2008 xls is an Excel Spreadsheet and phpmyadmin is a way of reading an sql database. If you have access to the database then you can export from it somehow? How do you access it? You need to export the customers and address book tables. hi there again - have found both the customers file and the address book file via the file manager and have saved them into a file on the desktop then i open them up with excel but all it shows is the php script - any ideas appreciated Link to comment Share on other sites More sharing options...
danjt Posted October 24, 2008 Share Posted October 24, 2008 I think you are looking at the files rather than the database Link to comment Share on other sites More sharing options...
failsafe Posted October 24, 2008 Share Posted October 24, 2008 hi there again - have found both the customers file and the address book file via the file manager and have saved them into a file on the desktop then i open them up with excel but all it shows is the php script - any ideas appreciated Assuming your hosting service is an Internet Service Provider (ISP) and you have an account with them, do you have access to the control panel for your ISP account. This normally allows you to do all things concerning your ISP account via a secure web interface, like order new domain names, alter your email configuration, suchlike. Normally, one of the options in this control panel is to manipulate one or more mySQL databases using a tool called phpMyAdmin. If you have access to such a control panel for your ISP account, see if you can see an option to click called phpMyAdmin or "mySQL Administration", something like that. If so, you should be able to select the osCommerce database you're using and then select some of the tables there to save as an Excel Spreadsheet (.xls) format file. Alternatively, you could save them in a .csv format file (Comma separated values) and import that into your spreadsheet program on your PC. Either way, what you're looking to do is download part of your database to your local PC where it will get stored in a spreadsheet readable format. From what you said above, you'll be interested in downloading the "address_book" and "customers" tables only. What you've done so far is use the osCommerce admin interface to download osCommerce PHP source files... nothing to do with your database itself. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.