hbsites solutions GmbH

Colligo Contributor widens and simplifies the confluence of Microsoft SharePoint, Microsoft Outlook and Windows Explorer. At the same time it supplies an extensive help when using the SharePoint library offline.

Objective

Apart from the offline-use of SharePoint, all mails - meta data included (subject, sender etc.) - are to be moved into a SharePoint library.

Work

Colligo Contributor was installed and configurated. The feasibility of the software and the optimization of the actual internal working processes were presented. As the Standard Versions of SharePoint and Office already offer possibilities for exchanges, particularly the extensions granted by Colligo were worked up.
 

A dashboard (or code number cockpit) is a way to visualize data in a compressed way. In the SharePoint 2010 Enterprise Edition, the by Business Intelligence-templates integrated PerformancePoint Service are the perfect tool to realize a dashboard.

Objective

• Development of a dashboard with integrated report platform on a SharePoint 2010 basis, with integration of PerformancePoint Services, SQL Server Analysis Services and SQL Server Reporting Services

Work

• Architecture and development of a PerformancePoint-Dashboard with various integrated cubes on a SQL Server Analysis Services basis
• Development of different reports on a Reporting Services basis
   

SharePoint optimally suits as a platform for the intranet, as it offers a web-based management of documents with integration of different Microsoft Office products, such as Outlook, Word and Excel.

Objective

Development of an intranet with integration of external data via WebServices; suggestions for possible designs and realizations of homepages

Work

• Suggestions for possible designs and realizations in SharePoint
• Connection of external data via webservices
• Exclusive use of the SharePoint UI and the SharePoint designer, as a realization with Visual Studio would be too complex for the customer
   

Objective

Moving files between two directorys in a document library

Work

• Default setting of item features, that have to be uploaded in the Event ItemAdded
• When a certain entry in the item properties has been selected, the file will be moved into the other directory (Event ItemUpdating)
   

The main focus of a SharePoint installation may vary: "classical" intranet with the functionality to manage different types of documents or portals for Business Intelligence evaluations, Kerberos authentification or multilinguism. Essential skills for a successful SharePoint installation are a solid IT know-how, experience with the development of PowerShell functionalities and an excellent general SharePoint know-how.

The basis of any installation has to be the Microsoft guidelines. Any deviation will create errors, that will be difficult to rectify, as well as high costs.

Objective

Development of a Business Intelligence portal on a SharePoint 2010 Enterprise Edition basis.

Work

• Multilingual installation in accordance with Microsoft TechNet
• Installation of Reporting Services with integrated SharePoint mode
• Installation of PerformancePoint Services with connection to SQL Server Analysis Services
• installation of web parts and reports on a SQL Server Reporting Services basis
• Implementation of a Kerberos authentification
• Extensive documentation in English for Roll-Out into other environments (development, integration, pre-production, production), with consideration of different server names and accounts
   

Objective

Development of an intranet on a SharePoint Server 2010 Enterprise Edition basis

Work

• Consultation and help when constructing a new design; integration of the design in SharePoint 2010
• Installation in accordance with the Microsoft TechNet
• Takeover of old data after updating
• Installation of InfoPath
• Installation of Office Web Apps
   

When taking over a design for Microsoft SharePoint, various aspects have to been taken into consideration: good SharePoint knowledge, excellent css knowledge as well as good experience in Visual Studio for bigger projects are essential.

Objective

Design adjustments for an intranet

Work

• Various css adaptations (rounded edges for WebParts, changes in colours and types)
• Design for homepage
• Adjustments master page

Objective

Development of a WebPart with consideration of the style guide

Work

• Analysis of the style adjustments
• Development of a css-file with all elements to be changed

SharePoint includes language packages, which offer translations for the internal SharePoint menues as well as a whole concept for the variations, with which the contents can be shown in different languages.

Objective

Multi-language installation of SharePoint 2010 with consideration of multinguistic WebParts and reports.

Work

• Installation of Language Packs
• Setting of the variations
• Configuration of the variations in order to avoid an unintended transfer of one page into another language
• Documentation in English with regard to the use of variations

With PowerShell, Microsoft completes a gap towards Unix-based systems, that has existed a long time. With PowerShell nearly all administrative work for SharePoint can be realized.

Objective

Data import by Windows PowerShell and Microsoft SQL Server 2008 R2

Work

• Development of parametrized PowerShell scripts for a data import
• Writing up of errors
• Import of over 100.000 items with Windows PowerShell into a SharePoint-list under consideration of the White Papers „Working with large lists in Office SharePoint Server 2007”
• Extensive update of the data to be imported by the SQL Server 2008 R2

The SQL Server Reporting Services enables the presentation of evaluations on internal lists or on external files. SharePoint offers extensive graphical portrayals, too.

Objective

Construction of a SSRS 2008 R2 dashboard with klick-through function on basis of a already existing, aggregated Excel sheet

Work

• Construction of a required table on the SQL-Server
• Development of reports with Business Intelligence Development Studio
• Consideration of various graphical elements (data bar, sparkline, diagrams, pie charts)

Objective

Update of a MOSS 2007 intranet to SharePoint Server 2010

Tätigkeiten

• Analysis of the requirements and the altered elements in comparison to the SharePoint Standard
• Workarounds for functionality that is difficult to update
• Realization of a Database Attach Upgrade
   

WebParts belong to the ASP.Net-technology and are used especially for SharePoint installations. WebParts help to evaluate and edit SharePoint data as well as data that are located on external database. WebParts can be parametrized and personalized.

Objective

Merging of meeting dates and appointments from subsites into SharePoint.

Work

When creating a single meeting or a meeting series in Outlook, a meeting workspace is automatically generated in SharePoint. In case that the user is actually working with SharePoint, all past and future meetings will be shown.

• Merging of all dates (meetings etc.) on which the user has access
• Chronological sorting of all meeting dates
• Development of a css-file to grant a CI concurring portrayal
• Parametrisation of WebParts in order to use the WebPart the most flexible way

Objective

Editing and automatic actualization of SharePoint data located on an external SQL server

Work

• Encoded storage of authentification information in web.config
• Exclusive use of JQuery in the frontend in order to optimize the system interface for users
• Takeover of old data when updating
• Consideration of jqGrid and JQuery UI
• Time-controlled, asynchronized update of the SharePoint frame together with the data located on the SQL server

The multitude of possibilities to integrate efficient workflows is a big strength of SharePoint.

Objective

Sending individual emails after having saved the data in SharePoint lists

Work

• Design of workflows
• Integration of additionally developed Custom Actions into the workflow
• Realization of the workflows with the SharePoint designer