Need .jpg Removed. Serious Inquiry

[teedizz]

Hello, I have a site where the picture names i.e. 123737.jpg, 127293.jpg is actually the product number. I know I can go through and just rename everything but that would take forever. Is there someone here that can make it to where instead of it saying "828128.jpg" they can make it say " Item # 828128" ....of course "Item #" will be static while the product number will be change with each product. Heres a link to what Im talking about http://capsncases.com/thumbnails.php?album=13

You can see what I mean by image number.

[Αndré]

So you want to add a prefix to all existing files? Please also read this, e.g.

post the budget you're ready to spend, the time schedule you have in mind and as many details as possible on the customization you need

[teedizz]

Well yes and no. I would like the prefix for all file names to be "Item #" but then I would also like the extension of ".jpg" to be take off of the end of all file names. So its kind of a yes and a no answer. LOL.

[Αndré]

Do you want to change the file name or the title? Please read the docs to understand how Coppermine works. If you want to change just what you see, you only have to change the title. Should be done with a simple SQL query.

[teedizz]

See the thing is, I wouldnt even understand how to do it if it was a SQL query. Here's what Im trying to do:

http://capsncases.com/thumbnails.php?album=13

On that page there you see the file name which is actually the name of the picture I uploaded. So lets take the very first picture which is:

121908.jpg

Well when a customer tell me which hat he wants to order, he will say I want to order 121908 in a size 7 1/2.

What I want to do it add the words "Item #" in front and to remove the .jpg to ALL files on the site.

I KNOW i can do it via admin page BUT I have over 1000 items and that would take toooo long. Im looking for someone who can do that for me.

Trust me Andre, if I knew even the simplest of code then I'd try doing it myself. LOL.

I would also like the item number on this page:

http://capsncases.com/displayimage.php?album=13&pid=805#top_display_media

without using that dropdown BUT thats in the future. I just want to go step by step. LOL. Thanks for your time though Andre.

[artistsinhawaii]

teedizz,

Maybe what you are looking for is already a feature of Coppermine?

Click on ADMIN Tools
Click on Filename ⇒ File title
Look at the first option...

[teedizz]

I understand that Hawaii and I appreciate your feedback but again, I know about that option but with over 1000 products and over 2000 yet to be added, editing each file individually will take wayyyyyy too long.

[Αndré]

Again:

Details needed
post the budget you're ready to spend

If you started your thread in the paid support board to get faster support, I have to tell you it doesn't work that way. I have a fast & easy solution in mind, but it seems that this board gets abused lately to get something like "priority support". So please post the budget you're ready to spend according to the sub-board rules.