Need help with *.csv images upload

[Lone_Ranger]

I have all of my products logged and tracked in *.xls spreadsheets and convert to *.csv for import into PrestaShop v1.5.6.2 but here is what I want to be able to do:

 

I will have several hundred into the thousands of products when I'm done getting up and running and I want to be able to copy *.jpg or *.png images of those products to a folder location on my FTP and copy that URL to my spreadsheet to be used as the thumbnail for the product once imported.

 

1.) Is this possible...if so please advise on how to do this...so far I have been able to copy to FTP no problem but getting the URL to actually display the image without giving me the following error has been the problem

 

 

 

2.) Which import option do I need to use for the import...Rewritten URL or Image URL...I'm assuming I will need the Image URL for something as this.

 

3.) What directory would you recommend to ensure the least security risks for doing this?

 

Thanks!

Edited March 1, 2014 by Lone_Ranger (see edit history)

[Lone_Ranger]

Apparently when I attempt to quote the error here it goes completely blank when you save it.

 

 

Edited March 1, 2014 by Lone_Ranger (see edit history)

[musicmaster]

I don't understand what you are doing.

 

First you copy the images to some directory of your website. You can call it Temp or whatever, Don't worry about safety, it is only for a short moment.

 

Then you add the image url's in one of the database fields in your CSV file. That will look something like "http://www.mysite.com/temp/123.jpg".

 

Next you import the csv files and it will automatically import the images into the Prestashop structure (under the img directory). When it is finished you can delete your Temp directory.