Posts

Showing posts from 2009

SharePoint 2010 Installation Matters

Image
SharePoint is an integrated suite of server capabilities can help your organization by providing comprehensive content management and enterprise search, accelerating shared business processes, and facilitating information-sharing across boundaries for better business insight. I am trying to highlight key difference between WSS 3.0, MOSS 2007 and later SharePoint 2010. WSS 3.0 Vs MOSS2007: WSS 3.0 offers all the standard site templates to build team sites, document workspaces, blank sites, blogs, wikis, and meeting workspaces. You can also use WSS 3.0 to create people and group lists. You can integrate WSS 3.0 sites with Access 2007, Excel 2007, Outlook 2007, Word 2007 and PowerPoint 2007. You can create RSS feeds and set up alerts to notify you when content changes on a site. Version control, task notification and alerts all come with WSS 3.0 MOSS 2007 offers all of the features included in WSS 3.0. In addition, MOSS 2007 offers business intelligence features that allow you to track k

SharePoint BDC - Step By Step

Image
Business Data Catalog, a new feature introduced in MOSS2007, provides an easy way to integrate business data from external database/web services , such as SAP, Oracle, SQL Server, Web Services or Siebel without writing any code. Business Data Catalog comprises a metadata database and an object model that provide a simple, consistent object-oriented programming interface for business logic that lives in the various business applications. To use BDC in MOSS we need to configure SharePoint Shared Service Provider. We can go to SharePoint Central Administration and select Shared Services Administration link. To create a new SSP use the following steps: 1. Click on New SSP 2. Fill in SSP Name [Lets name it "MyDefaultSSP"] and Associated Web Application 3. Select/Fill In Other necessary information based on your Farm settings 4. Click OK If you have multiple SSPs configured, you may change the web application association by selecting Change Association link at the top. After you ha

Heuristic Optimization of SQL Queries

Image
In general, relational algebra expressions and query trees could be equivalent; that is, they may correspond to the same query. But, the performance or cost of query may vary depending on the query technique that we apply. An optimization technique helps reduce the query execution time as well as the cost by re-formatting the query. We applied heuristic optimization in our queries and could reduce the execution time to a greater extent and thus reduced the cost quite a bit. Figure 1: Initial Query If we write this query in SQL we get: Select Name from E, J, P where E.EID=J.EID and PCode=Code and P.Name='GreenLife' and E.BDate>'31-12-1967' Which is basically the cross product of E, J and P Outline of a Heuristic Algebraic Optimization Algorithm: Break up any select operations with conjunctive conditions into a cascade of select operations. Move each select operation as far down the query tree as is permitted by the attributes involved in the select condition. Rearrang

FW: About VSSImporter

Hi Selcuk: Yes, I have successfully implement this tool in our Enterprize and could transform 30GB VSS Document Store to SharePoint list by keeping all the previous VSS versions. This application runs on SharePoint API rather that SharePoint Web Services. So, you may have to have the following environment to run this tool. 1. Windows Server 2003 or Recent 2. WSS 3.0 or MOSS 2007 3. Visual Source Safe 2005 4. .NET Framework 2.0 Thanks. Fazlul From: Selcuk OZDOGAN <selcuk.ozdogan@gmail.com> Sent: September 30, 2009 6:59 AM To: Fazlul.Chowdhury@gmail.com Subject: About VSSImporter Hello Md. Fazlul Alam Chowdhury, I was looking for any helpful tool that imports vss documents to sharepoint, then i came across with your project. I immediately, download and gave a try. But unfortunately, i could not execute the tool succesfully. Firstly i want to ask you, if you have ever tried your tool on windows server 2003 operating system? My main problem is that, if i run the program on my local p

OutLookImporter - Import OutLook Public Folder Contacts

Image
I have created a nice little tool to export OutLook Public folder contacts to CSV file. It basically exports the Master/Detail contact list from OutLook to CSV File Format. Then, we may import the list to SharePoint or Other Third Party Applications. In Outlook, the Details Tab Information [Key Contacts] are basically stored as individual user defined fields for each contact. So, to get the value of User Defined fields we may have to use the following syntax: ctc.UserProperties["MyCompanyAlbertaRelationshipHolder"] instead of: ctc.FullName.ToString(); The following Public Folder Path I used in this example: \\Public Folders\All Public Folders\MyCompany\MyCompanyAB\Customer Information Folders\All Public Folders\MyCompany\MyCompanyAB\Customer Information and List Name is: Customer Information. So, to get the items of Customer Information we may have to create the instance of the MAPI Folders using following methods: Microsoft.Office.Interop.Outlook._Application olApp = new Mic

DocMaster - SharePoint Document Library Sync Tool

DocMaster is a handy tool to sync SharePoint Document Libraries Between Sites/Servers. I have used SharePoint Copy Web Service to perform this task. So, it will work on any PC with .NET Framework 2.0 installed. But, you may have to configure the config file according to your SharePoint resources.   Config File Settings:   <? xml version = " 1.0 " encoding = " utf-8 " ?> < configuration > < configSections > < sectionGroup name = " applicationSettings " type = " System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " > < section name = " DocMaster.Properties.Settings " type = " System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " requirePermission = " false " /> </ sectionGroup > </ configSections > < appSettin