still trying my best this is what i am getting now and i cant find out how to change this bit (ISO-8859-1 instead of UTF-8)and i cant collect the debug file? the file is the same layout as all my other sites so that is why i don't understand it


Debug message
Importing filetype: csv
CSVI Version:1.9.1
PHP Version: 5.3.6
Using template: CSVI Product Import
Using delimiter: /
Using enclosure:
Not skipping the first line
Not skipping default value
Overwriting data
Do not use column headers for configuration
Using preview
File path:
Doing a productimport import
Field: category_path
Field: product_availability
Field: product_desc
Field: product_full_image
Field: product_name
Field: product_price
Field: product_publish
Field: product_sku
Field: manufacturer_id
Field: manufacturer_name
Field: product_weight
Field: product_available_date
Field: product_in_stock
Use database for configuration
Memory usage: 5 MB
Process line 1
Check to see if the product ID exists Show/hide query
Check to see if the vendor ID exists Show/hide query
Process line 2
Check to see if the product ID exists Show/hide query
SELECT product_id FROM jos_vm_product WHERE product_sku = '3D-orgat-Peg-Large.jpg,3D Coat Peg,�13.50,Y,WP0110,http'

Process line 3
Check to see if the product ID exists Show/hide query
SELECT product_id FROM jos_vm_product WHERE product_sku = 'lrg'

Process line 4
Check to see if the product ID exists Show/hide query
SELECT product_id FROM jos_vm_product WHERE product_sku = '3D-Monkey-Clock-Large.jpg,3D Monkey Clock,�24.88,Y,WP0264,http'

I think you are still trying to fix syntax of your file in MS excel or something, sorry but Excel is not successfull for that work.
I checked your last file, there are lines like that:
http//kidstoysrus.org.uk/thumbs/3D-Monkey-Clock-Thumb.jpg
it should be:
http://kidstoysrus.org.uk/thumbs/3D-Monkey-Clock-Thumb.jpg

and in your previous file, product_available_date field values were like:
"01/01/2012"
but in your last csv file, it is:
"13/10/2011 180600"

I think excel added 180600 part to the field, PLEASE DO NOT USE MS EXCEL, DOWNLOAD NOTEPAD++ or your problems in your file syntax will continue

For converting to UTF-8 format, do this:
Download notepad++ and open your csv file with notepad++, select "Edit" in upper menu and click "select all", then click "Encoding" in upper menu and click "Convert to UTF-8", then click on "File" in upper menu and click "Save as..." and enter a new name to your file, click "Save".

After that, open your new file with notepad++, check syntax, it should be as I told you in my previous message. Also, In "joomla admin panel => Components => CSVI Virtuemart => import => then on Options tab, you will see:
Auto detect delimiters: NO
Field Delimiter is ,
Text Enclosure is "
Category separator is \ as default
Dont use / as category separator because it is used in date values in your file, so it can cause a problem, use \ for it.
Then try to import your products again.

Thanks for all your help all fine this time i was only using the std notepad you get with windows downloaded the ++ one like you said i that was my problem

just did not understand

again THANKS
colin

colin136 wrote:
I will be happy if you press "thank you" button under my messages to that my karma on this web site can raise a little bit because I am new here