I currently have a manual process which goes like this...
1 Receive a zip file via email
2 Save it to a working folder
3 Extract contents (usually 12..18 large jpg files and some other stuff)
4 prepare a working folder to hold files
? repeat 12 times...
? 5? View and select 1 jpg
? 6? resize to a max width/height and save as [login to view URL]
? 7 resize to thumbnail and save as [login to view URL]
? end repeat
8 generate a HTML page from a template with these image names etc.
9 add rows to a MySql db with file names, etc
10 FTP the images to a web server
Currently this manual process takes far too long. I need a desktop app, batch file, windows script, HTApp or something to speed it up.
I'm hoping for something which lets me point at the saved zip,? creates the working folder (based on date and user input), unpacks the zip and shows me all the images to let me select 12 and order them, then it will resize and generate thumbnails in the target folder, then it will insert data into the MySql db? (on a remote server) then it will FTP the folder and images to the web? server.
the last bit may be left off, but everything else is needed to streamline this process.
Please quote.?
## Deliverables
Best for me would be a HTA app I could just open in IE7 and fill in a couple of textboxes and browse to identify the zip file. Then I click button A.
The app unpacks the zip and shows all images (small) with a textbox for me to give a number. I enter numbers in my selected 12 as 001, 002, etc... 012. and click button B.
The app creates the resized jpg and thumbnail jpg in the target folder for eaach numbered image in turn. Any without numbers are ignored.
The app adds a row to my MySql db for each image processed.
The app? generates the html file in the target folder.
The app FTPs the folder and contents to my server.
The app deletes the unpacked files (leaving the? original .zip behind)?
I want the HTA app code to be clearly commented so I can make changes later.? I don't mind VBScript or JScript, VB.Net or C#.
**The sooner the better**