Browse by Tags

Tagged Content List
  • Wiki Page: SharePoint 2010: Importing Data from a SQL Database into a SharePoint list

    When developing solutions for the SharePoint platform, there's often a requirement to import data from a SQL database into one or more SharePoint lists. This can easily be accomplished using PowerShell. By using PowerShell you have a lot of control over what data gets imported, and how it is formatted...
  • Wiki Page: SharePoint 2013: Custom Expiration Action for SharePoint Retention Policy

    Table of Contents Step 1 Step 2 Step 3 Step 4 Step 5 Step 1 Create feature receiver Step 2 Create xmlManifest string xmlManifestAction = "<PolicyResource xmlns='urn:schemas-microsoft-com:office:server:policy' " + "id='CustomExpiration...
  • Wiki Page: SharePoint 2010: Importing Data from an Excel File into a SharePoint List Using PowerShell

    There are several different ways to import data from a spreadsheet into a SharePoint list. Depending on your requirements, you can copy data into SharePoint lists using the DataSheet view, for example. However, there are some circumstances where this won't work (i.e. lack of support for certain...
  • Wiki Page: SharePoint: Using PowerShell to Perform a Bulk Delete Operation

    Introduction Have you ever written a really great PowerShell script for migrating data into SharePoint, only to have made the mistake of adding tens of thousands of new list items into the wrong SharePoint list? Oops. Have you ever tried deleting a few hundred list items using SPListItemCollection...
  • Wiki Page: Hosting the SharePoint Server 2013 Three-Tier Test Lab with Windows Server 2012 Hyper-V

    The SharePoint Server 2013 three-tier test lab consists of five separate computers on the Corpnet subnet: DC1: The domain controller, DNS server, certification authority, and DHCP server WFE1: The front-end web server of the SharePoint Server 2013 three-tier farm APP1: The application server...
  • Wiki Page: How To: Convert VHD-bootable Image into Hyper-V VM

    Table of Contents Scenario Solution Conclusion Scenario You have a VHD used to boot your PC or server (see Boot from VHD ). You need to make this VHD bootable as Hyper-V VM. Solution This would not work by default. You will need to execute the following sequence of tasks. Note...
  • Wiki Page: Trick : SharePoint Group by View with Order by on DateTime Field

    Hello Folks, This article is regarding creating “ SharePoint Group by View with Order by on DateTime Field ” for list or library in SharePoint 2010. First, lets us have a look on what is the need to create this kind of view? To create Group by view, SharePoint provides out of box settings in...
  • Wiki Page: Create SharePoint List/Library Using PowerShell

    Use CreateSharePointLibrary function to create a new SharePoint List or Library. Parameters : $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/ $LibraryName - Mandatory - SharePoint Library Name $Discription - Mandatory - SharePoint Library Description $LibraryTemplate...
  • Wiki Page: Making Backup and Restore Script

    @echo off @echo -------------------------------------------------------- @echo Backing Up site http://localhost/ @echo -------------------------------------------------------- cd \Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN @echo Generating File Name using current...
  • Wiki Page: SharePoint: Upload File in Document Library Using PowerShell

    Use UploadFileInLibrary function to upload a file in SharePoint document Library. Parameters : $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/ $ DocLibName - Mandatory - SharePoint Library Name $ FilePath - Mandatory - File Path on hard drive , e.g. .\abc.xlsx ...
  • Wiki Page: SharePoint: Listing and Deleting SPListItemVersions Using PowerShell

    Table of Contents Introduction Download The Script Example 1: Listing the versions of all list items in the http://corporate/pages library Example 2: Delete all versions in excess of 5 (ignoring minor versions) Example 3: A more advanced example, listing the versions of all list items in the http:...
  • Wiki Page: Create Blank WebPart Page Using PowerShell

    Use CreateBlankWebpartPage function to create blank webpart page in a Non-Publishing SharePoint web . Parameters : $webUrl - Mandatory - SharePoint Web Url - e.g. http://server:port/ $WebPartPageName - Mandatory - New page name $WebPartPageLibraryName - Mandatory - Parent Library name...
  • Wiki Page: Tips : SharePoint Group by View with Order by on DateTime Field

    Hello Folks, This article is regarding creating “ SharePoint Group by View with Order by on DateTime Field ” for list or library in SharePoint 2010. First, lets us have a look on what is the need to create this kind of view? To create Group by view, SharePoint provides out of box settings...
  • Wiki Page: MOSS2007: How to Remove Orphaned Features Using PowerShell

    I recently had to use content deployment on some old MOSS 2007 systems. These systems are alive for a long time and a lot of solutions/features have been deployed to them. If features are not deactived before removal they stay as an orphan in the system (contentdb) and can cause issues lateron....
  • Wiki Page: MVC4 – Entity Framework (8 Steps to create your site)

    MVC4 – Entity Framework 8 Steps to create your site Download your code here http://code.msdn.microsoft.com/vstudio/MVC4-ENTITY-FRAMEWORK-10-e15ef983 STEP1 Create a new project of type ASP.NET MVC 4 Web Application Choose the option Internet Application After project...
  • Wiki Page: FIM 2010 R2: How to Manage Group Membership from the User UI

    Table of Contents Introduction Prerequisites Create Attributes and Bindings Modify the Resource Control Display Configuration XML file Create the sets Create the workflows Create the MPR’s Modify default Sets Testing Notes and modifications Introduction As everybody knows FIM has great capabilities...
  • Wiki Page: Read XML file from document library (All Sharepoint version)

    Last week someone asked one question in forum about reading XML file from document library. As we know the implementation of XDocument.Load(string) doesn't supports an authenticated request to retrieve the XML file so we can use the Stream or FileStream to read the file directly, otherwise you...
  • Wiki Page: Small Basic Sample: GameGraphics

    Code '*************************************************************************************** 'Import XZG681 'Sample program to demonstate virtually all of the SmallBasic GraphicsWindow commands 'Includes use of Shapes, Images, Arrays, Mouse and Keyboard control 'Does...
  • Wiki Page: Small Basic Sample: Turtle Plus Flickr

    Code GraphicsWindow.Show() pic = Flickr.GetRandomPicture("lightning") gw = GraphicsWindow.Width gh = GraphicsWindow.Height GraphicsWindow.DrawResizedImage(pic, 0, 0, gw, gh) distance = 50 Turtle.Speed = 9 For sides = 3 To 20 DrawPolygon() EndFor Sub DrawPolygon...
  • Wiki Page: T-SQL: Display Horizontal Rows Vertically

    This article is an outcome of my answer to this question on MSDN forum. Consider this scenario : Table 1: DEPARTMENT EMPID ENAME SALARY A/C 1 TEST1 2000 SALES 2 TEST2 3000 Table...
  • Wiki Page: Tools for Troubleshooting Slow Boots and Slow Logons (sbsl)

    Table of Contents Tools Overview Installing XPERF to capture a slow boot or logon trace Using XBOOTMGR to capture slow boots, or slow logons caused by slow boots Using XPERF to capture slow logons Installing and using the SBSL SDP Manifest to capture data Configuring XPERF to view slow boot and logon...
  • Wiki Page: Visual Studio FAQ: Why a Coded UI Test Is Able to Find the Window/Controls Even if the Search Properties Are Different

    Table of Contents Introduction Scenario Reason Solution Note See Also Introduction This is a common question that rises in the mind of every test developer. Scenario You add a control to UIMap using Coded UI Test Builder (You are able to locate the control using Coded UI Test...
  • Wiki Page: How to convert Unicode Data to ASCII and back in SQL server

    Product Targeted MS SQL Server 2012 Summary In SQL server, few specific data handling scenarios require Unicode source data to be moved to non-Unicode destination format like ASCII format. During data conversion, it can be observed that the Unicode characters getting converted to ‘?...
  • Wiki Page: Deploying of the new version of SharePoint Workflow

    Assume you have an activity which is executing for very long time. This is so called Long-Running workflow. In fact long-running scenario is one of scenarios in Commuter Sciences which practically can very easy be solved by Using Microsoft Workflow Foundation. Following workflow show never ending...
  • Wiki Page: SQL : Split Delimited Column into Multiple Columns Without External Function

    Without making any external code or CLR, when we try to split a column into multiple column based on the delimeter present in that column, it can be achieved with XML methods present(SQL server 2005 or above). When number of dseired columns are less(say 2 or 3), it is quite easy with the help of character...
Page 4 of 45 (1,105 items) «23456»
Can't find it? Write it!