thewrath1 Posted September 26, 2005 Share Posted September 26, 2005 EXPORT CSV To EXPORT your list of products (or whatever) from phpmyadmin Before you start - backup your database in your Admin,Tools,Database Backup or from phpmyadmin. Before you save your file from Excel - just save it with only ONE product line and test it works with ONE product first. if successfull, go for the entire product list. Backup takes seconds, so DO IT!!!! In phpmyadmin choose your products table click BROWSE scroll to the bottom of the page and hit EXPORT choose CSV for MS Excel choose from Excel edition: Windows (if on a PC) click zipped click GO and save you file to your PC, then unzip and alter in Excel. When finished altering - Save as csv (comma delimited) IMPORT CSV To IMPORT your list of products (or whatever) in phpmyadmin Go to phpmyadmin and choose your products table click BROWSE click SQL tab Under the 'Run SQL query window' you will see a box marked Or Location of the textfile: Location of the textfile: (Max: 8,192KB) (this is 8mb by the way, enough to upload over 20000 products) Underneath you will see some text that says... "Insert data from a textfile into table" Click it, you will see this.... Location of the textfile CHOOSE YOUR CSV FILE YOU SAVED FROM EXCEL AS COMMA DELIMITED Replace table data with file TICK THIS - (Warning! This will replace the entire databes product lines to read the same as the data you saved from Excel) The contents of the file replaces the contents of the selected table for rows with identical primary or unique key. Fields terminated by CHANGE THIS FIELD TERMINATOR TO A COMMA , HENCE THE CSV (Comma Delimited File) ...DATA LOCAL Keep this to DATA LOCAL SUBMIT (You will have to wait around 15 seconds for 3000 to 4000 products to complete and then you will see... Inserted rows: 14192 as an example) Voila! - that's it. You're done. :D - This can be used for any header field in your database - not just the product field, I used it for image names. It worked for me fine - but if things went ugly - then reload your backup). You did backup didn't you? If you didn't, please don't complain to me. :-) :blink: Q/ How many therapist's does it take to change a lightbulb? A/ Two. But the lightbulb has to really 'want' to change. Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.