Solved

Is Sharepoint the right platform for this client?

Posted on 2011-02-15
4
346 Views
Last Modified: 2012-06-21
I have a client who has an in house program created in excel and visual basic that they are thinking about trying to move to a hosted solution.  Is that the right path for them?  Any alternate suggestions?

See original email I received below giving better detail:

As you are aware, we have several 'home grown' database apps that we use in conjunction with Peachtree Accounting to manage our business.
 
One of them is our Estimator.  This is an application that Jxx developed several years ago and has continued to tweak and enhance.  It is primarily an Excel spreadsheet with a lot of Visual Basic that has been incorporated to automate various elements of our estimating and job creation process.
 
We want to know how best to transition this to something that is not dependant on being physically in the office and attached to the LAN.  We would like some thoughts on use of
1.) rented server space from someone such as Sago Networks;  
2.)  use of Microsoft SharePoint; other options that we aren't aware of.  We have used GoToMyPC with reasonable success, but the primary users of this app no longer have desktop machines at the office for a connection.
 
How would you suggest we start the process of evaluation?


Most of their users are transitioning to laptop computers and taking them home with them in the evening.
0
Comment
Question by:resinate
  • 2
4 Comments
 
LVL 14

Expert Comment

by:KoenVosters
ID: 34904964
Honestly, no expert will be able to give you a good answer with the specifications you are giving right now :)

A lot depends on the functionalities that you have in there and what the end users expect. All you have given right now are some technical specifications why you want this to be moved to SharePoint. And that Sharepoint has an advantage here, sure, but to be blunt I can't say it is the best solution with the information I got :)

Secondly, I've seen quite of those excel applications in my life and most of the time the only person who understands them is the person who built them. So I would take a lot of time (when you plan this project) to understand what is going on in it :p
0
 
LVL 8

Accepted Solution

by:
rseabird earned 125 total points
ID: 34905034
Depends what else they want to do. It seems that the Excel workbook works as a kind of an application. I am not sure what they exactly want with that. Storing the Excel file somewhere central or do they want to get it as a web application?
SharePoint is a tool for collaboration on document and information as well as a social computing platform.
Seems to me that you need to create a web based version of that Excel workbook. To deploy it inside SharePoint or not depends on what they want to do more with SharePoint. Or, that's a possibility too, you can use SharePoint 2010 as a kind of database (able to create/use relations between lists) and build your application around those lists.
0
 
LVL 14

Assisted Solution

by:KoenVosters
KoenVosters earned 125 total points
ID: 34905049
Or you create the excel by code using OpenXML and push it to a document library. You might even not need an excel and just a webpage displaying the results. You might not need SharePoint but you could build a custom web app..

That's why I'm saying that we need more info :)
0
 

Author Comment

by:resinate
ID: 34920248
After further inquiry, my client is looking to just move what they currently have to a online server platform of some sort that will run the program online and allow multiple users access to the program.

It appears to be an excel spreadsheet with externally linked visual basic databases that up to 4-5 people are able to access at one time.

Not looking to rewrite program right now.

See Q&A string below:

1.       How many people currently access the estimator program?  Are they concurrent users (accessing at same time or one at a time?)
Generally not more than 4 simultaneous users and it varies greatly over the course of the day.
 
2.        Is the visual basic databases embedded in the excel spreadsheet or is the database externally linked?  
I believe they are externally linked.  I know that the output of the application the user's machine writes back to database(s) on the server
 
3.       Are you looking to develop the excel application as a web based application? Or just move what you have to a server that can be accesses offsite?
I think the preference now would be to move what we have to a server that can be accessed from offsite.
 
4.       Any additional functionality to be added to the application?
I don't think that would be part of this project.  It would probably be determined based on what would make sense at the time.  The important elements here are data security, data integrity, minimizing lag for the remote exchanges to take place.  We have experimented with VPN and FTP connections on the existing SNAP Server but there were substantial lags in the processing times.
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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Some of you may have heard that SonicWALL has finally released an app for iOS devices giving us long awaited connectivity for our iPhone's, iPod's, and iPad's. This guide is just a quick rundown on how to get up and running quickly using the app. …
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

708 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

13 Experts available now in Live!

Get 1:1 Help Now