Manipulate keyword and titles metadata and insert into IPTC fields on images

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.

Kemahiran: Pembangunan Perisian

Lihat lagi: software development project description example, priority health, name writing images, a. d. miles, Wellbeing , manipulate , harmony, excel add development, keyword development, excel manipulate data, example development writing, 2000 words writing sample, name spa, 2000 words health, excel format project development, image metadata, insert image word, writing iptc metadata, titles health project, export excel image

Tentang Majikan:
( 140 ulasan ) Orpington, United Kingdom

ID Projek: #6102596

Dianugerahkan kepada:


Hello Stuart, I have read the project requirements. I understand that you need to modify image file attributes (title, description, author), from the Excel file. You also need to select image folder, excel file and Lagi

$255 USD dalam 5 hari
(1 Ulasan)