So i built my categories database in excel and I have no idea how to import it into mysql. What kind of file do i need to store it as? Lost Help an0n, help!
Why you don't save it as txt and add sql script inside and then execute the script in phpmyadmin to load your categories?
Sounds good in theory but I can't seem to find the right format to save it in that matches and SQL file I export. All kinds of quotes and brackets in places and they dont exist in the excel version. I don't want to manually edit the text file to add these quotation marks. Too much tedious work. I'll never find my errors if I miss a single one of these --> '
Well. I got it done. Was brutal. Had to save the excel as a CSV then open in text editor to use "find-replace to switch all the comma separators to quote-comma-quote ( "," ) while at the same time keeping the comma's intact within the category description fields and keyword fields. Brutal. A few hours of work that should have been able to be done by a few clicks of the mouse. But happy now. Now to figure out how to edit those damn .tpl template files.
I have done many data imports for phpld from other directory scripts. If you need help again I will help you.
Another good way will be to use vbScript inside MSExcel to export the data directly int SQL...though this will be a bit tough