Hello there!
I am in need of an application (script) for Windows 7 platform. I have a large number of image files in a folder with each file using a naming convention utilizing the date and time the image was created:
"20140227-134726.jpg" -Taken Feb 27 2014 at 01:47:26 PM
I also have numerous .csv files which contain data I wish to overlay onto all the images I have taken.
For example,
"Humidity.csv" contains:
STAMP,VALUE
2014-02-27 13:36:41.312,45.3
2014-02-27 13:39:11.908,44.5
2014-02-27 13:41:42.07,43.7
2014-02-27 13:44:12.379,43.2
2014-02-27 13:46:42.489,43.1
2014-02-27 13:49:12.653,43.6
2014-02-27 13:51:43.197,44.2
"Temperature.csv" contains:
STAMP,VALUE
2014-02-27 14:44:27.952,22.4
2014-02-27 14:46:58.964,22.7
2014-02-27 14:49:29.863,23.1
2014-02-27 14:52:00.952,23.5
2014-02-27 14:54:31.916,23.8
2014-02-27 14:57:02.14,24.0
2014-02-27 14:59:32.304,24.1
The script or program would:
1. Prompt user for folder where ALL the .jpg image files inside will be modified with data overlay.
2. Prompt user for the location of the CSV file.
3. Prompt user for the text positioning variables of where CSV data will be displayed
3. Use the date and time values of that .jpg image file to approximate and match to the closest timestamp value in the specified CSV
For image name "20140227-134726.jpg" -Taken Feb 27 2014 at 01:47:26 PM
The script would find:
(Humidity.csv -file)
STAMP,VALUE
2014-02-27 13:36:41.312,45.3
2014-02-27 13:39:11.908,44.5
2014-02-27 13:41:42.07,43.7
2014-02-27 13:44:12.379,43.2
2014-02-27 13:46:42.489,43.1
2014-02-27 13:49:12.653,43.6
2014-02-27 13:51:43.197,44.2
4. Overlay the corresponding value for the selected timestamp value onto the .jpg image for example, "Humidity 43.1%"
5. Overwrite original image file with overlayed image file to the same folder
6. Repeat for ALL .jpg files selected in step 1.
I would assume this couldn't be terribly difficult for an experienced programmer. If anyone is willing to create this, I am willing and able to pay. I can also pay with BTC or LTC currencies.
-DZ