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:
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.
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:
This will be provided to the winning bidder as a starting point for creating this functionality.
25 freelancers are bidding on average $276 for this job
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
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
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.
Hello Sir, I can write the code very efficiently, and with proffesional structure in C/C++. I will consacrate my intire time for two days on it. Please let me know, so that I can start with it! Regards Armand