image location

[itsdanny]

I have taken over a project (bad enough at the best of times) and all of the product images (about 300+) are pointing to c:\my documents\ product images\blah\blah\.... This as far as i am aware is rubbish as i would like them all to be stored wihtin the Actinic site strucure (sites\site1\productimages\blah\blah\....) is there a quick way of changing all product image loactions to the one i want or does it not matter where they are stored localy.
hope someone can help
dan

[chrisbrown]

I can't think of anyway within Actinic but a little bit of programming would do it.

The path to the product image file is stored in the Product table of the Actinic database in the column Image FileName. You could write a query to strip out the "c:\my documents\" bit and replace it with "productimages\" in all the non-null entries.

Taking backups first of course.

[itsdanny]

Sounds like the way forward.
Thanks
Dan