Posts

What is TDD?

Image
TDD has been around since NASA’s Project, Mercury in 1960s. But, when Kent Beck and Ward Cunningham introduced TDD as an eXtreme Programming (XP) practice, it started gaining popularity.   Test Driven Development is a Technique through which Test Cases are being written to fail and then produces test cases to pass followed by refactoring the code to achieve the acceptable standard. Which eventually means: the mind set for TFD together with a Test First Design Technique and Refactoring the tested functions yields to Test Driven Development.                                   TDD = TFD + Refactoring   While implementing TDD, Developers write software codes through small iterations to implement following tasks:   ü   Create Automated Unite Tests ü   Execute the tests to make sure they fails ü   Update the tests to make sure they passes ü   Re-run the new unit test cases to ensure they pass ü   Refractor the codes a...

How to Create a Deployable Solution Package for SharePoint Feature/WorkFlow

Creating a Manifest.xml File You must create a Manifest.xml file for your solution package. Open the Visual Studio 2008 project you created in the previous Visual How To: Building an Expense Report Approval Workflow for SharePoint Server 2007 Using Visual Studio 2008. To create a Manifest.xml file Add a solution folder to the project. Select the solution in Solution Explorer. Right-click the solution, point to Add, and then click New Solution Folder. Rename the folder Solution. Select the new solution folder. Right-click the new solution folder, point to Add, click New Item, and then select XML File in the dialog box. Rename the XML file to Manifest.xml. Click Add. Add the following to the blank XML file. Xml Copy Code <?xml version="1.0" encoding="utf-8"?> <Solution xmlns="http://schemas.microsoft.com/sharepoint/" SolutionId="B90C9FD7-29F3-477f-A038-B4BA51FE219F"> <FeatureManifests> <FeatureManifest Loc...

How to Copy/Upload Files into SharePoint Document Library

We may have to add a service reference to SharePoint Copy Web Service [ http://SharePointSite/_vti_bin/copy.asmx ] before coding this. Here are two functions to copy/upload files into SharePoint Document Library. To call the functions, we may have to use following syntaxes: CopyFromFileToSP("ASLog.txt", "C:\\ASLog.txt", " http://dcftsd1/Policy/ASLog.txt "); CopyFromSPtoSP(" http://dcftsd1/Policy/Book1.xls ", " http://dcftsd1/Policy/Book3.xls "); //Function to Copy a File from One Document Library to Another Document Library private void copyFromSPtoSP(string _SourceFile,string _DestFile) { try { SPCopyService.FieldInformation myFieldInfo = new SPCopyService.FieldInformation(); SPCopyService.FieldInformation[] myFieldInfoArray = { myFieldInfo }; SPCopyService.CopyResult myCopyResult1 = new SPCopyService.CopyResult(); SPCopyService.CopyResult myCopyResult2 = new SPCopyService.CopyResult(); SPCopyService.CopyResult[] myCopyResultArray = { ...

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...