Solved

Submitting Data and saving to file+email

Posted on 2009-03-30
9
270 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
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

 

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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Australian government abolished Visa 457 earlier this April and this article describes how this decision might affect Australian IT scene and IT experts.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to count occurrences of each item in an array.

738 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