elijahweb Posted May 31, 2003 Posted May 31, 2003 I'm attempting to upload the database for my bookstore that has 65,000 line items and roughly 10 fields. I'm using phpmyadmin to upload to the tables. My first attempt is to the products table. I'm simply locating the text file by clicking the browse button. After it's located(from my desktop) I clicked the submit button and then watch it seemingly stall. On the bottom of my explorer window I see it saying sending request for /3rd party/phpmyadmin/ldi_check.php. It justs kind of sits there. Any suggestiosn to what might be wrong? It showed and error window once but I didn't catch what it said before I closed it out by mistake. is it because I'm loading it from the local host and it needs some sort of permission. I opted to go this way instead of EZ populate by number of osCommerce users, because of teh size of the database. Thanks in advance! Keith Ronan Thanks in advance, Keith Ronan
Guest Posted May 31, 2003 Posted May 31, 2003 With such a huge database it may take some time to upoad to your server. Try been more patient, maybe start it and have some coffee or something.
elijahweb Posted May 31, 2003 Author Posted May 31, 2003 I also am unsure of thsi area in my upload process... I am using the ISBN # for my products as the product ID ,I think! Is it a good idea to then remove the default setting of Auto Increment from product ID or is that a bad idea?? I thought using ISBN as the product ID would help different tables ie. product description, product categories, and etc, by all having that ID (ISBN) # to see . Is this going to cause confusion. I'm about to take a MYsql course, but I'm up against the wall with a client so I'm relying on thsi forum and my Books... Thanks Keith Thanks in advance, Keith Ronan
dvdvideo Posted June 1, 2003 Posted June 1, 2003 I also would like to hear comments regarding the isbn number being used as prod id in the database. At present I have added another table to the database for the isbn number with prod id... seems like there must be a better way. Also when an order comes and send me the extra email I want and need to know the isbn number on that email to save time when ordering from my distributors. Has any one got a suggestion on how to do this effectively? If the isbn becomes the product Id can that be added to the extra email? or both customer and admin email? Cheers Paul
meuk Posted October 19, 2003 Posted October 19, 2003 Hi there appears to be an add SKU, ISBN issn, module in contriutions, but i'm not clear how to install it yet as i'm not up on sql programming isis
Mark1 Posted October 21, 2003 Posted October 21, 2003 sql programming is not needed to install this module. Wordpad and a MYSQL admin is all you really need. (Of course there are a hundred ways to do it). Just load the file you want to edit into wordpad. Use the Find / replace function in wordpad to locate and replace all the instances of code. That will take care of 80% of the installation. It should take you about 30 minutes to install this contrib. (maybe longer for newbies). :D Mark
Recommended Posts
Archived
This topic is now archived and is closed to further replies.