Transcript Discussion Board used in the site.

“Information Sharing Portal
for Indus Sub-System”
Under the guidance of :
By :
Shri Rohit Mishra RRCAT, Indore
Dr. Shaligram Prajapat , DAVV Indore
Rupesh Kumar Verma
M.Tech (IT), DAVV, Indore
Project Objective :
- Trace the event of cycling and ramping.
- Display Magnet Power Supply data in tabular and graphical format.
- Design and Deploy a daily report on web portal.
Present System Scenario:
Drawbacks of Present System:
- No graphical representation of the data
- No events tracing is done
- Slow Response from the database
Proposed System:
Benefits of this project:
-
Graphical view of the complex data
Less load on the main database
Better User Interface
Live Discussion board
Document Management
Security
Tools Used:
Microsoft SQL Server 2012
Microsoft SQL Server Reporting Services 2012
Microsoft SharePoint 2013
Hardware Specification :
Server Machine : HP
ProLiant DL380 Gen9 Server
Operating System : Windows
Processor : Intel(R)
RAM : 32
GB
Server 2012
Xenon(R) CPU E5-2620
Microsoft SQL Server 2012
Relational Database Management System
Uses Transact SQL as query language to interact with DB
Microsoft SQL Server Reporting Services (MS-SSRS)
• Report generating tool
• Reports are developed using Business Intelligence
template of Microsoft Visual Studio Data tools and
Report Builder
• Easy to export reports in various formats : Pdf, Excel,
Docx etc.
Microsoft SharePoint 2013
• Creating an organised website
• Document management and storage system
Editions of SharePoint :
1. SharePoint Online
2. SharePoint Server : Foundation, Standard and Enterprise
SharePoint Server 2013
SharePoint Server 2013 with respect to our project :
•
•
•
•
•
•
Security
Web Content Management
Integration with Reporting Services
Integration with MS SQL Server
Integration with MS Office
Additional Web Apps and Web Parts
Permissions in SharePoint:
View Only : Used for the Excel Services Viewers group.
Read : Enables users to view pages and list items, and to
download documents.
Contribute : View, add, update, and delete list items and
documents.
Edit : Add, edit, and delete lists; view, add, update, and delete
list items and documents.
Design : Create lists and document libraries, edit pages and
apply themes, borders, and style sheets on the site.
Full Control : Contains all available SharePoint permissions.
Commonly Used In-built Web Apps in SharePoint
•
•
•
•
•
•
•
Discussion Board
Contact List
Task List
Announcement
Event List
Surveys
Alerts and many more
Discussion Board used in the site.
Central
Database
MS SQL Server
Management
Studio
Visual Studio
Interface
Sends data
User #1
SharePoint Site
Views reports
deploying
Views reports
User #2
Views reports
Tracing of events
are done and
Dataset are created
Graphical Reports
are generated and
are deployed to
SharePoint server
Reports (.rdl file) is deployed
to SharePoint Server and reports
are scheduled in excel format
Work Description
User #3
Form Based Users
Domain Users
verify
fail
User wants to view report
and also discussions
wants to contribute
in discussions
Report
Home
Page
User
Views Report and
Views Discussions
verify
pass
Requests for
Report scheduling
Central Indus
Database
Sign In
Page
Permission
granted
Report published at
Scheduled time
Portal
Data Flow Diagram
DEMO
Thank You