• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

Submitting Data and saving to file+email

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
AI-SYD
Asked:
AI-SYD
  • 4
  • 4
1 Solution
 
Jason C. LevineNo oneCommented:
Hi Aalborg,

Do you have any scripting language knowledge to call upon?
0
 
AI-SYDAuthor Commented:
No Real Knowledge, will to learn. I have some scripting books.
0
 
Jason C. LevineNo oneCommented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
AI-SYDAuthor Commented:
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
 
Jason C. LevineNo oneCommented:
>> 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
 
AI-SYDAuthor Commented:
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
 
Jason C. LevineNo oneCommented:
VS can be used to handle ASP.NET controls, yes.
0
 
AI-SYDAuthor Commented:
O Desk was very good, thank you.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now