Solved

Submitting Data and saving to file+email

Posted on 2009-03-30
9
259 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
 

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Trying to figure out group policy inheritance and which settings apply where can be a chore.  Here's a very simple summary I've written which might help.  Keep in mind, this is just a high-level conceptual overview where I try to avoid getting bogge…
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

746 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now