Me again, Still having trouble.

So, I have trimmed all the model fields and started again. Once again products are all in the system just fine. I have then tried a basic attributes import. Again it has reported success but nothing has changed. This time I used open office (I updated Java as suggested - seems OK now. Thanks Chad) Text csv as export with comma delimiter and double quotes around text fileds (is this correct?)

issue 1) v_products_options_type is different in my advanced attribute export to my basic export. In the basic they are all set to 5, In advanced they are set to 5,3 or 2 - i have tried both ways and neither works.

issue2) Not sure if I'm supposed to have entered the attribute/name values prior to the basic import.

issue3) I had one v_products_options_values_name_1 of "Form, Colour, Patterns" and thought this may be an issue due to the comma separation of values so I changed this to "Form Colour Patterns" but still no joy.

I haven't tried the advanced attributes import yet since I cannot see any changes after the basic import, further more, when I look at mysql logs after the basic import, all I can see are select queries - no updates or inserts.

Can anyone tell me what I am doing wrong here. I'm starting to think SQL may be the way to go. Here is my basic attribute import csv http://pastebin.com/rjZF1VtM. I know this is a big dataset so I tried with the first 4 rows only and once again it reports success but nothing is changing. Any suggestions would be greatly appreciated.