X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   image extension is case sensitive- what to do? (https://forum.x-cart.com/showthread.php?t=23062)

dgreen 07-06-2006 08:57 AM

image extension is case sensitive- what to do?
 
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 07-06-2006 09:40 AM

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

dgreen 07-06-2006 04:33 PM

image extension - case sensitive
 
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 07-06-2006 04:35 PM

Uggg...that is a headache :(

amy2203 07-07-2006 03:27 AM

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 07-16-2006 07:27 PM

solution
 
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


All times are GMT -8. The time now is 04:36 AM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.