Fashion Golden Key

Posts Tagged ‘Business Data’

Microsoft Office SharePoint Server 2010 is an integrated suite of server capabilities that can help improve organizational effectiveness by providing comprehensive enterprise search and content management, accelerating shared business processes, and facilitating information-sharing across boundaries for better business insight.

You can quickly create and manage SharePoint sites that support specific content publishing, enterprise content management, records management, or BI needs. You can also conduct effective searches for people and documents; participate in forms-driven business processes; and access and analyze large business data.

Capabilities of SharePoint Server

Collaboration, Portal, Enterprise Search, Enterprise Content Management, Business Process and Forms, Business Intelligence and Licensed for Internet/Extranet

SharePoint 2010 Sites delivers a single infrastructure to provide portal and collaboration capabilities across internet, intranet and extranet. Bring all users together to share information, and knowledgebase across organizations.

SharePoint 2010 Search gives users the ability to find the people, content, and information they need by combining an integrated, with enterprise search technology.

SharePoint 2010 Communities empowers organization to work with people in ways that are most effective for them. Allow employees to collaborate in groups, share knowledge and ideas, connect with colleagues, and find information and experts without difficulty.

SharePoint 2010 Insights enables users to access and act together with information across unstructured and structured data sources. Empower users to discover the right people and expertise to make better and more accurate business decisions.

SharePoint 2010 Content enables users to participate in a governed, compliant content management lifecycle. SharePoint Content makes it possible to skillfully balance user experience with organization policy and business process.

SharePoint Foundation 2010 is made for small business organizations or departments looking for a low-cost entry-level or pilot solution for secure, Web-based portal. Organization can use SharePoint Foundation to coordinate schedules, share, organize documents, and participate in discussions through team workspaces, blogs, wikis, and knowledgebase on the platform that is the underlying infrastructure for SharePoint Server.

SharePoint Designer 2010 is the tool of choice for the rapid development of SharePoint applications. With the help of SharePoint Designer, advanced users and developers can quickly create SharePoint solutions. Expert users can compose no-code solutions that encompass a variety of common scenarios, from collaborative sites and web publishing to line-of-business data integration, business intelligence solutions, and HR workflows. These great solutions leverage the building blocks available in SharePoint in an easy-to-use environment. Additionally, developers can use SharePoint Designer 2010 to get a rapid start on SharePoint development projects.

Copyright © Ryan Mutt, All Rights Reserved. If you want to use this article on your website or in your ezine, make all the urls (links) active.

SharePoint servers store this information in what are called ‘Lists’ that typically resembles an Excel spreadsheet.

As you may be aware already, you can import Microsoft Excel Spreadsheet to SharePoint [In your SharePoint site, select Site Actions -> Create -> Custom Lists -> "Import Spreadsheet" hyperlink under the Custom Lists header]

Microsoft Excel Spreadsheets may do what organizations generally require, but have limitations when the data volume is large or when there are several participants, as may be the case in many organizations.

The following are some of the areas where the users would sometimes feel the pain when importing Microsoft Excel Spreadsheet data to SharePoint 2007:

1) Limited support of data types or data classification

2) Import data to all SharePoint list types, including project tasks, issue tracking, custom lists etc.

3) Missing link between SharePoint and source data

4) Tracking changes to the data

5) Handling complex queries and conditions to filter data

SPList Manager for SharePoint 2007 (SPListM), our list management solution helps users overcome these pain points and in this article post we will explain on how it does it.

1) Limited Support of data types:

Importing an Excel spreadsheet in SharePoint supports only custom lists and is not compatible with built-in data types such as People, Lookup and Business Data etc. Consider the situation where the user has to retrieve a huge chunk of business data relating to a unique id say Customer ID. All the data associated with Customer ID spread across various spreadsheets has to be referred and interpreted manually. SPListM on the other hand can help users retrieve information across multiple lists by referring to the Customer ID. It retrieves all information associated with the Customer ID and presents it for the user. SPListM supports all SharePoint standard data types. It would be appropriate to term SPListM as a generic SharePoint ‘list processing tool’ as it supports all widely used data types. This feature has managed to attract several SPListM customers and is rightly its value proposition.

2) Import data to all SharePoint list types:

As said earlier, importing list types such as project tasks, issue tracking, custom lists etc. to SharePoint would be a tough task, especially the ones with file attachments. SPListM offers a simple solution to import metadata (or list items) and associated file attachments to SharePoint lists such as Tasks, Calendar, Contacts, Survey, Discussion Boards, Announcements, Links, Issue Tracking and Custom Lists. For example, SPListM can easily let the user regularly update the project tasks or a custom list through an external batch file and could prove quite efficient by saving several man hours.

3) Missing link between SharePoint and the source data:

There is only a one-way communication between a Microsoft Spreadsheet and SharePoint services. Changes made to SharePoint list items is restored back to a spreadsheet (content source) while the vice versa is not possible. If the changes made to the spreadsheet source are to be updated in SharePoint list, it has to be exported to SharePoint as a new list. The link between the content source and the destination (SharePoint list) is terminated and this could prove costly when data undergoes constant changes. Consider a situation where loads of information is constantly dumped into an Excel spreadsheet and needs to be updated in the SharePoint site. It would be increasingly difficult for the user to export it every time or update the voluminous information manually in a datasheet view. SPListM could prove extremely handy in this situation as the updates could be defined in the import task wizard or through an external metadata file. SPListM does not necessarily establish a two-way communication with the SharePoint. But it still makes a one-way communication complete and more effective.

4) Tracking changes to data (versioning):

It is increasingly difficult for the user to keep track of the changes made to the content sources as the changes made would only be exported to SharePoint as a new list. As a result of which, ‘versioning’ is made impossible. In situations where a list has to be approved by other SharePoint users, it would be impossible to keep track of changes made by each user. Updating a list item with SPListM can help you maintain versions and track changes made by users in a collaborative environment.

5) Handling complex queries and conditions:

It would prove a daunting task for the user while attempting to conditionally import data using complex queries from a spreadsheet to a SharePoint site in an automated manner and more so if it involves a lot of data. In a situation where data is often exported to a spreadsheet and the user has to migrate the same to a SharePoint site, Excel’s filter options could be very useful. But what if the user wants to impose conditions at various levels and do a major cleansing of data? SPListM has the ability to impose conditions at various levels and could do this cleansing as easy as a cake walk. It allows the user to apply multiple logical conditions and can update the list items with ease. The updating could be done either through the basic import task wizard option or through an external batch descriptor file.

SPListM has been engineered in such a way as to fill the potential pitfalls a user faces while importing Microsoft Excel spreadsheet data to a SharePoint list. SPListM supplements Microsoft Excel’s capabilities in enhancing business productivity.