Batch Renaming of Product Images

Completed Posted Nov 8, 2011 Paid on delivery
Completed Paid on delivery

We require a solution to automate batch renaming of images based on data currently contained in two spreadsheets.

The files being renamed are product image files of differing dimensions for a website. Currently the images of different dimensions are divided into separate directories based on size. There are 5 directories of varying size:

800x800

436x436

166x166

108x108

29x29

The original product image file name is stored in one spreadsheet ( Image [url removed, login to view] ) which corresponds to the current image file names.

The desired product image file names (5 images) are stored in the other spreadsheet ( [url removed, login to view] ). The images must be renamed according to size with the correct file name and placed in the correct dimension directory.

Spreadsheets attached.

The solution must produce a log detailing any errors in the process of batch renaming. More images will be added through these spreadsheets so it must be relatively simple and quick process to repeat.

Currently the solution is part completed in a dos batch file. Allows batch renaming based on 1 column for the old image and 1 column for the new image in a CSV file. Attached is the batch file currently used.

Ideally the solution would be completed in a DOS Batch file but any windows based program would sufice. Source code must be provided.

Correspondence done via Skype, Email and Telephone if required.

To clarify some questions asked:

The Image 1 column in Image Spreadsheet.xlsx is the source image which requires to be renamed. There is also Image 2 column in Image Spreadsheet.xlsx which requires to be renamed as well.

The full path for where images are will be in a sub directory of the program created e.g. C:\BatchGini\images\. The images are currently seperate by size in seperate directories e.g. C:\BatchGini\images\800x800

The error log output can be in an xls file or a text file.

The full windows batch file program of progress so far will be provided to the winning bidder as a starting point.

Currently some images are not added to Image Spreadsheet.xlsx . These will be added later as they become available. Its for that reason some Image 1 fields are blank and a lot of Image 2 fields are blank. The program should be able to be run easily again to do renaming.

Current windows batch file looks like this:

http://i40.tinypic.com/ncdu0y.jpg

This will be provided to the winning bidder as a starting point for creating this functionality.

C# Programming C++ Programming eCommerce Software Architecture Windows Desktop

Project ID: #1283612

About the project

25 proposals Remote project Active Nov 12, 2011

Awarded to:

deadhunt

Please check PMB.

$250 USD in 3 days
(38 Reviews)
5.5

25 freelancers are bidding on average $276 for this job

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$250 USD in 7 days
(36 Reviews)
6.6
simonchen

I thought i can write python script to finish this project, I would like to ask you fewer questions. please check p.m.b, thanks. Simon

$250 USD in 3 days
(40 Reviews)
6.4
barundebnath

Hi, My last work was similar as your one. I can deliver it within 3 days. Let me know if you are interested. Thanks

$400 USD in 5 days
(62 Reviews)
6.2
gangabass

I can do this for you. See PM for details.

$250 USD in 2 days
(77 Reviews)
5.5
anhouse

Good day. Please see pm

$400 USD in 4 days
(5 Reviews)
5.5
crypted

Please check your pm.

$250 USD in 2 days
(29 Reviews)
5.2
pratham2003

I have experience is writing such applications in C#. I have written quite a few applications for the people hiring my services on freelancer related to batch file processing (processing includes renaming/altering actu More

$250 USD in 7 days
(19 Reviews)
4.9
junworried

Hi, I am interested in this project. I have developed applications that use the excel engine. Delivery will be on time. Please send me more details. Thank you

$250 USD in 2 days
(8 Reviews)
3.7
danibu

Hello Ramsaybell, I can help you with my experience in writing batch files. I've done similar jobs for clients with many branch-offices. I can also write an application on Python. Regards, Dani

$250 USD in 4 days
(3 Reviews)
3.1
MrSawy

Hi sir, I can complete this project for you. please check PMB for details.

$250 USD in 2 days
(4 Reviews)
2.6
marcodf

Hi, i'm an italian Dev. Please check PM

$250 USD in 3 days
(2 Reviews)
2.6
anatol1988

I can do this for you. Please check PMB.

$250 USD in 5 days
(2 Reviews)
2.2
yehia111111

Hi Kindly check your PMB

$250 USD in 3 days
(2 Reviews)
1.9
PriyankaKale

Hello, I have 6 years of experience in IT. I can deliver high quality product on time. We can negotiate on costing

$250 USD in 5 days
(1 Review)
3.4
axbinn

Hi Sir, I can write a C# windows program to implement the batch image renaming. The program with a user interface can display the renaming progress and error message in a list view. Best regards.

$250 USD in 3 days
(1 Review)
1.0
UrmanSoft

plz check the pmb ..!!

$450 USD in 10 days
(0 Reviews)
0.0
Drisney

I have written several applications that make use of Excel. As to proove this , i already made a demoproject for you. Look at the PM.

$250 USD in 1 day
(0 Reviews)
0.0
mpaunovic

Hi, check PMB.

$250 USD in 3 days
(0 Reviews)
0.0
thomaswinkeler

Please see private message for details.

$400 USD in 5 days
(0 Reviews)
0.0
mn5

I may do that for you.

$250 USD in 5 days
(0 Reviews)
0.0