![]() You did backup didn't you? If you didn't, please don't complain to me. It worked for me fine - but if things went ugly - then reload your backup). This can be used for any header field in your database - not just the product field, I used it for image names. (You will have to wait around 15 seconds for 3000 to 4000 products to complete and then you will see. 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.ĬHANGE THIS FIELD TERMINATOR TO A COMMA, HENCE THE CSV (Comma Delimited File) ![]() " Insert data from a textfile into table "ĬHOOSE YOUR CSV FILE YOU SAVED FROM EXCEL AS COMMA DELIMITED ![]() Underneath you will see some text that says. (Max: 8,192KB) (this is 8mb by the way, enough to upload over 20000 products) Under the 'Run SQL query window' you will see a box marked Go to phpmyadmin and choose your products table To IMPORT your list of products (or whatever) in phpmyadmin When finished altering - Save as csv (comma delimited) Scroll to the bottom of the page and hit EXPORTĬhoose from Excel edition: Windows (if on a PC)Ĭlick GO and save you file to your PC, then unzip and alter in Excel. if successfull, go for the entire product list. To EXPORT your list of products (or whatever) from phpmyadminīefore you start - backup your database in your Admin,Tools,Database Backup or from phpmyadmin.īefore you save your file from Excel - just save it with only ONE product line and test it works with ONE product first.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |