Utility for processing, then ftp uploading photos and entering photo data in a SQL database.
a.? ? ? ? ? Software should have a preferences page that sets sql database location, sql login info, defaults for photo location drop down, defaults for camera numbers, ftp login info, etc.
b.? ? ? ? ? Software is to lookup info from SQL database and populate drop down boxes for sponsor, event#, photographers, etc.
c.? ? ? ? ? Show a form to select event# from drop down, enter camera# from drop down, photographer from drop down, photo date form field with calendar pop-up, photo location from drop down, photo description form field, average people per photo form field.
d.? ? ? ? ? Button to select files and/or folders from the hard drive of photos to be uploaded via FTP to the web server. Option to adjust filename as uploaded. Some digital cameras have a prefix in the filename such as DSC001205.jpg. I want the software to rename this file to 1205.jpg. This feature should be very flexible to adjust file name and should show and example of how it will look when renamed. It can assume all photos are named in same format.
e.? ? ? ? ? Option to add a border overlay to each image in a batch mode. Checkbox to select whether a border should be added and a browse button to select the graphic file to be used as a border.
f.? ? ? ? ? ? Option to set JPEG compression in a batch mode. Checkbox to select whether JPEG compression should be applied. Drop down box to select JPEG compression level.
g.? ? ? ? ? The two previous options should not alter the originals, it should apply the settings to a new file that is saved in a temp folder for uploading.
h.? ? ? ? ? Runs routine to optionally apply border, optionally apply JPEG compression, upload image to FTP directory based on sponsor\event\images\camera#\, confirm upload, add record to SQL database with photo code(generated from image filename & event #), event#, photographer, description, location, date, camera#, people per photo, etc., move to next image, loop. It should do this until it all files have been uploaded.
See JPEG sample screen shots for what the interface should look like.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. I do not want a Java app.
Windows XP & 2000 Please specify what language you would write this in.