X-Cart forums

[dgreen]

Is there something I can do to get the image extension not to be case sensitive?
Most of my products have images with .jpg extension but I have a few with .JPG and those are not showing up. I can't go through each one because I have over 30,000 products.

By the way, I am using the Telafirma mod for the images.
Thanks

[balinor]

Unix is case sensitive. You can run an sql query on the database to replace the extension on everything in one swoop.

[dgreen]

Thanks for responding.
Is there a way to go through the images and replace the .JPG ones with .jpg?
Changing it in the database only helps if I know which ones have the uppercase and which ones have the lowercase.
In the database, they are all lowercase. In my image folder, most are lowercase and a few are uppercase - I just do not know which ones are which (unless I go through one by one).
Thanks again

[balinor]

Uggg...that is a headache

[amy2203]

I have a program that will batch rename files called renamer4mac, it's for mac computers you know anyway I could download all of the files, rename them all and then reupload them,

??hth

[dgreen]

I ended up running a php script that went through the directory and wrote to a file each image ending in uppercase letters.
I then took the list and imported it into a database and through a few queries, generated product codes from the image names (image 123.JPG has a product code of CR00123).
I used the import products from the admin site (using the fields productcode and thumbnail) to stick the new image names into the database.
I am not sure if I am too clear, but it worked and was not that complicated.
Thank you for your help