Solved

Need Suggestions for a Real-Time Tracking System

Posted on 2014-02-17
7
409 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:Technodweeb
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:Technodweeb
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:Technodweeb
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:
Technodweeb 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

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

Steve Terp was featured in a video created by CRN about how "Channel Is Crucial To Market Disruption". Click on View source to see the video and article
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This Micro Tutorial will explain how to export DynamoDB tables in Amazon Web Services.

759 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

18 Experts available now in Live!

Get 1:1 Help Now