Looks like you are using excel to join cells via ="("&A2&","&B2&")" ect ect. You could run the next available sql on the recipe table, and set the limit to say 100, and export the results to excel, then use that as your id column (A)for the tradeskill_recipe sql import. Column B is the name field and you can use your premade names if you have them from row1 to row100, next columns are; 63, 200, 250 (trivial), 0, 0, Made by ME, 0, 0
Then highlight cells c1:j1 to auto fill rows 2 -100 with the same info as row 1. Next create the sql compatible cell in cell L1 with
="("&A1&",'"&B1&"',"&C1&","&D1&","&E1&","&F1&","&G 1&",'"&H1&"',"&I1&","J1&"),"
drag bottom right hand corner (crosshair icon) down to row 100. This converts to:
Code:
(82,'Ykesha recipe name',63,200,250,0,0,'Made by ME',0,0),
I have templates made for importing sql that I edit with notepad++, for tradeskill_recipe it looks like this:
Code:
INSERT INTO `tradeskill_recipe` (`id`,`name`,`tradeskill`,`skillneeded`,`trivial`,`nofail`,`replace_container`,`notes`,`must_learn`,`quest`) VALUES
I open this template up in notepad++ and on line 3 or 4 I paste the info in excel column L1:L100. after pasting I scroll to the bottom line and replace the last comma with a semi colon, then I save this file as tradeskill_recipe_1.sql and import to the db...
Of coarse if you added the extra column from c0ncrete's sql then you would add that in to the template and excel as well.
Then run the next available sql to get the next 100 ect ect...This way you have control over where the sql is being inserted, and have reference recipe ids in hand when you build the tradeskill_recipe_entries sql..
Threaded Mode
