This project is to take keyword information from an excel file, make titles and descriptions using random keywords from the cells and writing it to the individual images. Also add the Author name.
I have attached a sample excel file, sample images (I have made these thumbnail size rather than full size to save bandwidth) and a sample of the output images.
The keywords provided will be a mixture of individual words, 2 word phrases and 3 word phrases. There will be one column of between 2 and around 5 words or phrases which are more important and another column with 12 plus words or phrases.
The output to each file should be as follows:
Keywords: The limit of words should be 45 and random words should be removed if there are more than 45 words. The words removed should not include the important words in the first column called Keywords.
Title: This should be between 7 and 9 actual words (7 is better) and all words should be capitalized.
A keyword should not appear twice.
It should follow a similar pattern to this -
keyword-a keyword-b (keyword-c) Shows keyword-d keyword-e And keyword-f
For example - Spa Stones Shows Health Harmony And Relaxation
For keyword-a and keyword-b (and maybe keyword-c) the priority is to use a 3 word phrases if there is one, if not then a 2 word phrase and if not then 2 random words. These should be from the column called 'Keywords' in the excel file.
keyword-d, keyword-e, and keyword-f should be random words from the Keyword-export column.
The word Shows should be randomly 'Shows', 'Means', 'Represents' or 'Indicates'
Description (or sometimes called Caption):
This should be in the same format as the title but instead of 'Shows' randomly use 'Showing', 'Meaning', 'Representing' or 'Indicating'
For example - Spa Stones Showing Wellbeing Water And Meditation
The description should be 7 to 11 words
Author: This should be filled with the phrase Stuart Miles
The program should input the data from the excel file, manipulate it and save it to the individual images.
Any data in the keyword, title or description(caption) fields should be deleted before entering the new data.
There might be over 2000 images so it is best to have something that shows the progress.
It should show any errors where the image cannot be found or where the data cannot be written.
It should have a box to select the images folder and to select the excel file.