Submitting Data and saving to file+email
Posted on 2009-03-30
I am after something which is properly pretty standard but new to me and my environment. I have zero programming knowledge.
I use a Sonic Wall 2000 VPN Device which in a nut shell allows you to authenticate to your Active Directory Domain and connect using SSL over port 80.
Once authenticated the sonic wall allows you to use book marks (links) to internal servers and services so it is secure and free to do what is needed.
I want to create a HTML page that reflects our time sheet format (excel file) and allow staff to submit their time sheets online and emailed and/or saved (prefer both) in excel in our company format.
The naming of the files is not important as long as the email can contain the name of the saved excel file and the users username that created it.
I hope I am not asking much but to make things clearer I have itemised the list
1. HTML (or any programming/web language) page to enter time sheet details into.
2. Submit button that allows automatic saving of the file to a pre defined location with a defined file name of date and username perhaps taken from a field with their name in it when filling in time sheet? Location would need to be \\UNC based
3. Automatic email notification that a submission has occurred with username and date time etc
I have no real way forward due to lack of knowledge and would appreciate any person with experience or the knowledge to push me the right way.
I have access to Expression Web to build pages, unsure if that is enough.
P.S if this needs to be rezoned please do.