|
Posted by Hobby Central on August 24, 2008, 2:44 am
Please log in for more thread options
Thankyou, that worked out great.
Bill
Hobby Central
"Koit Lahesoo" wrote:
> SKU is Item Lookup Code?
> If it is, then:
> update Item set PictureName=ItemLookupCode+'.jpg'
>
> Koit Lahesoo
>
>
> >I am using Newestech's Web Integrator pro wi 2.4 along with Kosmos and I
> >have
> > ran into an image problem. Based upon previous input from this forum, we
> > save all of our images in HQ using the sku.jpg and then save product
> > images
> > using the skew as jpegs. We have two problems:
> >
> > 1. We have thousands of items in our dbase and it is tedious calling up
> > each item and adding the image path.
> >
> > 2. Some of my employees have saved the image files with a jpg suffix in
> > uppercase. The Unix server does not recognize these images on our web
> > server
> > and so does not assign them to the products. This leaves us with a lot of
> > our online products without images. The did not notice a problem due to
> > the
> > fact that the Windows O.S. doesn't care if the suffix is upper or lower
> > case.
> >
> > Would it be possible to use SQL command or a script to set the image path
> > of
> > each item to the sku.jpg ?
> >
> > Thanks
> >
> > Bill
> >
> > Hobby Central
> >
> >
>
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap