Solved

Submitting Data and saving to file+email

Posted on 2009-03-30
9
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

 

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 500 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Color can increase conversions, create feelings of warmth or even incite people to get behind a cause. If you want your website to really impact site visitors, then it is vital to consider the impact color has on them.
Although a lot of people devote their energy toward marketing for specific industries, there are some basic principles that can be applied to any sector imaginable. We’ll look at four steps to take and examine how those steps were put into action fo…
The viewer will learn how to dynamically set the form action using jQuery.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

617 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