Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Submitting Data and saving to file+email

Posted on 2009-03-30
9
Medium Priority
?
277 Views
Last Modified: 2013-11-19
Hi All,

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.

My Need:

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.

Thanks

Aalborg

P.S if this needs to be rezoned please do.
0
Comment
Question by:AI-SYD
  • 4
  • 4
9 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24025358
Hi Aalborg,

Do you have any scripting language knowledge to call upon?
0
 

Author Comment

by:AI-SYD
ID: 24025382
No Real Knowledge, will to learn. I have some scripting books.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24025509
Okay, so you will need to learn how to do the following:

1) Set up IIS on the server so you can serve pages

2) Learn either PHP, ASP, or ASP.NET to handle the form submission.  ExpressionWeb should work for this

3) Set it all up to work with the VPN/AD.

I suggest you concentrate on ASP.NET as it provides the most benefit in terms of automatic operations.
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 

Author Comment

by:AI-SYD
ID: 24025522
Sounds like a sinch....

Do you have some good scripting forums that i can visit? I will obviously post here as well.

1) already done.
2) ASP.NET sounds like the way to go, anyone else have any input before i get started?
3) Ok..
4) How many hours will it take a professional programmer to do what i asked? estimated cost?

Thanks

Aalborg
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 24025545
>> ASP.NET sounds like the way to go, anyone else have any input before i get started?

Can you click the "Request Attention" link in your original post and ask the Moderators to changes the Zones?  They'll put it in the right spot to get you more attention.

>> How many hours will it take a professional programmer to do what i asked? estimated cost?

The form submission and email is pretty simple, no more than 5 to 10 hours by my estimate.  The passthrough the VPN may be a sticking point but overall I don't think you are looking at a ton of time to do this.

Costs vary greatly.  You can hire very expensive programmers, bid it out on odesk or find a local university student who wants to make some extra cash...
0
 

Author Comment

by:AI-SYD
ID: 24025550
Is Visual Studio 2008 ASP.NET?

I have access to the following Developer tools

Visual Studio 2008 Professional Edition
Visual Studio Team System 2008 Architecture Edition
Visual Studio Team System 2008 Database Edition
Visual Studio Team System 2008 Development Edition

Any Ideas, thanks

Aalborg.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 24025562
VS can be used to handle ASP.NET controls, yes.
0
 

Author Closing Comment

by:AI-SYD
ID: 31564663
O Desk was very good, thank you.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question