case study: building the roadrunner public website site + bonus: deep dive building site admin tools...
DESCRIPTION
In this presentation, I provide an overview of how we built the public website for Roadrunner Transportation Systems using SharePoint 2013. As a bonus, I also provide a deep dive into building site admin tools with Telerik RadGrid.TRANSCRIPT
2014
Case Study: SP2013 Internet Site
ROADRUNNER TRANSPORTATION SYSTEMS
2014
Who is Michael Blumenthal?
• Sr. Solution Architect• CSPUG Co-Leader• 19 years in IT Consulting• 11 years of SharePoint • Team member on this
project
2014
Today
RRTS.com
Building Custom Data Admin Tools
2014
This is about you!
SharePoint Internet site experience?• Version?
Used 3rd party controls?
2014
THE BIG PICTURE – RRTS.COM
PART 1
2014
Roadmap
The business challenge
The solution
Technical Architecture & key components
Team
Measures of success
2014
The Challenge: The Client
2014
The Challenge:
Aging ASP.Net site
30+ Subsidiary Sites
500+ Line of business tools
Small Internal developer staff
AS400 integration
User Management
Older VB.NET code base
201404/08/2023 9
The Challenge: Analysis
• 30+ Subsidiary Sites• 250+ Pages• 100+ Forms• 16 Login Methods• 32 Reports• 63 Tools
2014
Roadmap
The business challenge
The solution
Technical Architecture & key components
Team
Measures of success
201404/08/2023 11
Solution: Design
Goals
Modern
Friendly
Branding
Home
Admin
Search
Companies
12 Layouts
Design Tools
Axure
PS
Bootstrap
201404/08/2023 12
Solution: Development
What We Saw
• 30+ Subsidiary Sites• 250+ Pages• 100+ Forms• 16 Login Methods• 32 Reports• 63 Tools
What We Built
• 30 Line of Business Apps• 15 Admin Apps• 8 SSRS Reports• 7 Web Services• 6 Service Segments Pages• 16+ Company Sites
2014
WALKTHROUGH OF RRTS IMPROVEMENTS
2014
Roadmap
The business challenge
The solution
Technical Architecture & key components
Team
Measures of success
2014
Technology Overview
201404/08/2023 16
Development Decisions
Farm Solutions vs. App Model
Authentication
Data Storage
2014
Farm Solutions!
Farm Solutions
• On Premise• Mature• Resources
SP App Model
• Cloud Oriented• Immature• Challenging
Authentication
Sharepoint2013FBA.codeplex.com
www.rrts.com
Data Storage
Production Farm
2014
Roadmap
The business challenge
The solution
Technical Architecture & key components
Team
Measures of success
2014
The A-Team
• Client: 2 .Net developers, 1 Team Lead, 1 manager, 1 CIO , 1 Dir of Marketing
Account Exec Practice Lead Project Manager
Sr. UX
Designer
UX Designer
SP Arch
Data
Arch
SP Devs
Tester
2014
Solution: Project Management
2x Weekly status meetings
PSC Client Extranet
Shared Team Notes• Every Meeting• Every App
Working Out Loud
2014
Measures of success
• 700 Bills Of Lading/day• Increased hits, decreased exits
Google Analytics 3 mo Before 3 mo AfterPage Views 3,393,986 5,270,783Unique Page Views 2,609,161 3,606,197Average Time on Page 1m:51s 1m:21s% Exit 27.92% 20.79%
2014
Summary
The business challenge
The solution
Technical Architecture & key components
Team
Measures of success
2014
BUILDING DATA ADMIN TOOLS WITH TELERIK RADGRID
PART 2
2014
Roadmap
Why Telerik?
Installing Telerik
Building an Admin Page with RadGrid
2014
Why custom Web Parts?
Usability
2014
Why Telerik?
2014
Why RadGrid?
Productivity
2014
Brandability
No Free Lunch
2014
Roadmap
Why Telerik?
Installing Telerik
Building an Admin Page with RadGrid
2014
Installing Telerik ASP.NET AJAX library
So how do you wire it up?
2014
After Install
2014
2014
2014
Roadmap
Why Telerik?
Installing Telerik
Building an Admin Page with RadGrid
2014
Zero to Done in 4 Steps
Done!Custom
Row Editor
Custom Columns
Display DB Data
Add RadGrid
1. 2. 3. 4.
2014
#1: Add RadGrid to your Web Part
2014
#2: Display Your Data
2014
#2a: Set the Data Source to a Data Table
2014
2014
#3:Customize the Columns
2014
Before and After
2014
3a: Tweak the Column Renderings
2014
Tooltips!
2014
#4: Custom Row Editor
Yuck! Yeah!
2014
2014
4a: Wiring up row changes
2014
4b: Insert
2014
4c:Update
2014
4e: Delete
2014
Zero to Done in 4 Steps
Done!Custom Row Editor
Custom Columns
Display DB DataAdd RadGrid
2014
Bonus: Sorting & Paging
2014
Roadmap
Why Telerik?
Installing Telerik
Building an Admin Page with RadGrid
2014
Resources
Telerik: www.Telerik.com
Sample Code: https://sp2013radgridexample.codeplex.com/
2014
Review
RRTS.com
Building Custom Data Admin Tools
2014
Questions
• Michael BlumenthalSharePoint ArchitectPSC Group, LLC
• [email protected]• psclistens.com• www.cspug.org• Blog.blumenthalit.com• Twitter: @MichaelBL• SPYam & MWC Yam
Thank you for your time today.
PSC is Hiring!