Solved

Need Suggestions for a Real-Time Tracking System

Posted on 2014-02-17
7
423 Views
Last Modified: 2014-02-19
I'm tasked with duplicating a proof of concept that my team has developed in Google Docs Spreadsheet.  I need a commercial solution that meets the following criteria.  Partial matches and suggestions will receive credit!

1.      Utilize a spreadsheet-style interface allowing dynamic filtering and update.

2.      Provide a multi-user interface where all users see any changes in real-time with functionality for this identical to Google Docs Spreadsheet.

3.      Provide user-rights level settings. This includes update, filter, browse and others.

4.      Provide segregation of some real-time view functions ie real-time content update but not real-time global distribution of view/filter settings.

5.      Use an LDAP Authentication and Security model based on Active Directory userids and groups.

6.      Provides color-based highlighting for severity/importance levels.

7.      Provides visual feedback of real-time editing by other users.

8.      Include full change-history including userids, specific modifications, and all previous versions history.

9.      Ability to save copies, export, lock versions by date or other criteria.

10.      Provide encrypted access from public networks.

Thanks Experts!
0
Comment
Question by:gurutc
  • 4
  • 3
7 Comments
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39865736
Why are you re-creating this if it works in Google Docs now?

Serious question so that suggestions take that fact into consideration.
0
 
LVL 16

Author Comment

by:gurutc
ID: 39865747
We would like to bring the app more 'in-house' and some of the functionality isn't there in Google docs like the AD-integrated authentication for one.

- gurutc
0
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39865776
Have you looked at the Microsoft O365, Sharepoint Server and Excel 2013. You can do AD integration there and Excel works similar to Google Docs with the near real time, multi-user access to sheets. This could give you a very rapid deployment.

I do not know if you can do the web apps if you self-host the SharePoint server but it might be worth the look.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 16

Author Comment

by:gurutc
ID: 39865801
Checking the O365 per your suggestion.  Sharepoint Server won't do it.  That was our first try.

- gurutc
0
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39865826
Not SharePoint by itself but with the office web-apps integration. If you want a trial account on O365, let me know and I can set you up with an E3 account for 30 days at no cost.
0
 
LVL 16

Author Comment

by:gurutc
ID: 39870369
If the O365 were to work, what's the cost for ~$4000 seats?

- gurutc
0
 
LVL 11

Accepted Solution

by:
Gregory Miller earned 500 total points
ID: 39870586
I did not mean for this to turn into a sales pitch and if we continue, I would request that we take it off of EE so we don't irritate anyone.

There would be a lot of dependency on which features you would need or want. SharePoint by itself is $4-8 per seat. Other components are similar in price as individual pieces. The whole suite including Office Pro Plus that has both desktop apps as well as the web based equivalent for Word, Power Point, Excel and others, SharePoint, Exchange, Lync, and other pieces goes for $20-24 per seat. The Full subscription allows a single user to install their subscription on up to five computer or devices. This is a nice perk for users who would like the benefit of using the software from home but do not want to shell out personally for the individual Office license. If the employee ever leaves the company, the subscription is controlled by the company and can be suspended and reassigned. You can also mix and match and have users only have access to a sub set of parts and others who have access to everything. If you use MS Office, and Exchange and SharePoint in the organization now, the TCO are much less and you can control the licenses with more flexibility.
Everything is administered via web portal and some advanced functions from Powershell. Administrative users get 24x7 telephone support included in price from Microsoft.

The number of seats you are asking about would undoubtedly bring a discounted price. I would encourage you to let me set you up with a trial account which will give you Full usage for 30 days. Let me know if you want to explore any further and I can get you more details. my email address is gmiller @ geekpatrol.com

Thanks,
-greg
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Scenario: Your operations manager has discovered an anomaly in your security system. The business will start to suffer within 15 minutes if it is a major IT incident. What should she do? We have 6 recommendations for managing major incidents (https:…
Why pager replacement is still an issue OnPage has what some might call a “hate/hate” relationship with pagers. Not much room for love. As we see it, pagers are an antiquated bit of technology. Pagers are dinosaurs which, like most dinosaurs, sho…
Both in life and business – not all partnerships are created equal. Spend 30 short minutes with us to learn:   • Key questions to ask when considering a partnership to accelerate your business into the cloud • Pitfalls and mistakes other partners…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

809 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