Solved

Infopath 2010 vs Custom Application

Posted on 2010-09-10
3
454 Views
Last Modified: 2012-05-10
My company is considering using Infopath and Sharepoint to create an application to gather data from users in the field.  This would be a pretty basic application involving the user adding and editing what amounts to timesheets.  Then from that, creating some summary reports for their inputs only.  The management would want to be able to create/view reports across all the users.  Sounds like something that can be done within Infopath and Sharepoint.  But i'm a novice when it comes to the development using those tools.

The advantage seems to be the modification of this application would not have to involve a developer per se like a custom application would.  If the employee within the company is very good at learning both Infopath and Sharepoint - then they could in effect modify the Infopath/Sharepoint application.

So, can you tell me if this makes sense or not?
Thanks!
0
Comment
Question by:JLEmlet
[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
3 Comments
 
LVL 10

Accepted Solution

by:
duffman76 earned 500 total points
ID: 33646045
Infopath and Sharepoint certainly give you a lot of flexibility when creating custom applications with reports.  You can create  a form in InfoPath that ties back to a Sharepoint site and then uses the workflow of Sharepoint.  In your example this could allow a manager to get notified that time has been entered and is awaiting his approval.  

Keep in mind while a good solution and it would work, that everyone would need to have InfoPath in order use and fill out the forms you make.  You can make a web based infopath form so people do not have to have Infopath but it is pretty limited and eventually you will want to put a feature in that requires the full piece.
0
 

Author Comment

by:JLEmlet
ID: 33646074
Thanks for the info!  And is it correct to assume that the form can use a SQL Server database as the source for adding/editing the data?
0
 
LVL 28

Expert Comment

by:clayfox
ID: 33646079
Yah this is a valid solution and I would recommend just because InfoPath, once your up to speed, gives you the ability to rapidly deploy forms for this project and many other data collection projects.  SharePoint is a great partner in that it provides the ability to integrate data and host the forms. The only issue is that as a data repository SharePoint libraries filled with individual XML files is not ideal.  It limits your ability to report on the data as well as to migrate the data compared to what a true database can provide.
If you are using SP2010 you can use BCS to bridge this gap but you probably should look at the solution from www.qdabra.com on how to easily add webservices to your SQL server.  This gives you all of the beneifts I mentioned while also databasing the data for aggregated reports and possibly even interfacing it directly with payroll or finance.  The tools they provide gives you an enterprise class platform to make this just the first of many successful solutions.

I know I sound like a sales guy, but I am not. I have just spent years creating InfoPath solutions and if I was going to start today, I would want the correct tools and design architecture to make it as easy on me as possible and give me the most power and flexibility to build the solutions my company needs.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

689 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