Jump to content

Picture import - MySQL


Recommended Posts

Hi all,

i already imported everything directly using MySQL - categories, products, ...
But now, i dont know how to solve my last problem - pictures.

Picture import by .csv file is easy, but does not work for me. (Czech letters in name, etc...<-problem with import)
So i need to import links to picture directy into DB. I think, that correct table are:

ps_image
ps_image_lang
ps_image_type

but when i insert all data, copy picture into ../img/p/ and regenerate miniaturies. it does not work...

Do you have any idea how to simply insert direct link to picture into DB? Or how to disable a compulsory field
"name" and use only ID and picture link?

Thank you for your time and sorry for my english..

Daniel

Link to comment
Share on other sites

Hello,

I'm having problems importing pictures using CSV. I'm not exactly sure about,

(1) what folder to upload the pictures?
(2) how to specify the path in CSV for these pictures.

Do you have an example?

Thanks!
canand

Link to comment
Share on other sites

(1) folder is up to you. i recommend /img/temp
(2) you must specify the full path -> e.g.: /var/www/web2/howto.cz/webmaster.howto.cz/new/img/temp
if you don´t know your full path, u can find it in BO - Tools - Import - under browse button.

on this forum is many many tips how to import pictures, just search...

Link to comment
Share on other sites

×
×
  • Create New...