April 7, 2013

Export Selected Items to Excel release 1.2.0


I have worked on the updates for my component "Selected Items Export to Excel", most of the issues are mentioned by the users (Thanks for mentioning issues in comments).

What's new in SharePoint 2010 Export Selected Items to Excel Release 1.2.0
  1. Fixed Taxonomy field Single/Multiple values issues.
  2. Now supports the below templates 
    • Form Library 
    • Announcements 
    • Discussions 
    • Contacts 
    • Links 
    • Site Pages 
    • Tasks

January 10, 2013

Configuring Search suggestions in SharePoint 2013


This post is about configuring the search suggestions in the SharePoint 2013 environment, I would be using SharePoint 2013 preview for this post. It would be the similar configuration for the on-premise environment as well.

Steps

  • Go to SharePoint Admin Center in Office 365, in case of on-premise go to the Central Admin >> Manage Service Applications >> Search Service Application >> Manage
  • Go to Search administration
  • Click on the link, "Query Suggestion Settings", you'll be presented with the below settings page

  • Make sure the "Show search suggestions" option is checked
  • Next the select the language of suggestion, by default its English
  • Click on the "Export to text file" under the Always suggest phrases section
  • The above step will download a flat file, you can also create one instead of downloading a blank text file.
  • Add the phrases you would like to show in the search suggestions to the flat file.
  • Import the text file, that's it.
  • As I already mentioned, I used Office 365 SharePoint 2013 preview. I had to wait to overnight to get these changes reflected in the search suggestions.

October 30, 2012

Export Selected Items to Excel Release 1.1.0


What's new in SharePoint 2010 Export Selected Items to Excel Release 1.1.0 

  • Now this release supports Document library as well. 
    • Don't expect the document contents, its only the meta data 
  • Export to excel button in ribbon grouped inside the Action & Share group 
  • Eliminated the look-up column issue, previously showed the look-up values as ID;#Value to just as value 
  • Supports Multi-value look up columns 
  • Supports Multi-value people picker 
  • Supports Single/Multi-value Taxonomy field 
  • UTF8 characters are now supported. 
  • Uses minified JS for less space consumption 
  • Better exception logging
You can download the latest version from here - http://bit.ly/V69LMt

October 23, 2012

Another day in SharePoint Migration

Restricting video files in SharePoint Migration

Requirement - We are migrating enterprise wide SharePoint 2003/2007 sites to SharePoint 2010. Migrated content has to go to new site structure, governance and in some cases the list/libraries level migration also needed, so we are relying on the 3rd party solutions for the migration. Leaving much on the background coming to the actual problem statement, one of the department decided to migrate large document library which has lot of videos. All these videos are quite large in size.
The department wants these videos to be excluded from the migration, and only the non video files are to be migrated.

Solution - We tried with the multiple options,

  • Filtering based on the file type - the tool which we are using is not filtering the contents based on the file type and adding them to their exclusion list. 
  • Dumping the total contents to the file system and then removing the videos files in them - but in this approach you'll be losing the versions and other meta data in the list. For example all the modified by column will hold the user info of who is trying to upload the documents, and same modified time stamp also. 
  • Deleting the video files from the source and then restore back from the recycle bin once the contents are migrated to the 2010 site - but this option is risky we can't rely on this approach. 
  • All these options doesn't seem to be a feasible and apt ones. Then we opted for a better solution to add these video file extensions to the web application file extension blocked list and removing the file extension block after the migration of the non-video files. 

The last option worked great, nothing to do in the tool. Find the file extensions which are to be excluded from the migration and then add them to the block list and unblock it once it's done. I used this approach since we dint had any kind of meta data associated in the source SharePoint site, it's always advised to use metadata for better classification. I'm open for any other optimized approaches.

October 21, 2012

Raspberry Pi - Day 2 Boot up

Day 2 update on the Raspberry pi, I imaged the SD card with the Raspbian Wheezy Linux version. It was very straight forward approach, goto SD Card Setup and follow the instructions. 
So here goes my edition,
  1. Raspberry Pi (RPi)
  2. Micro USB charger to Power
  3. SD card - 8 Gb (Imaged with OS)
  4. Logitech K400 wireless keyboard with trackpad
  5. Internet via Ethernet Cable 
  6. HDMI cable to connect to TV or Monitor
I hooked up the micro USB cable to the board, and inserted the SD card in the slot. After that inserted the K400 keyboard's USB dongle and then connected the Ethernet cable and HDMI. There was no power on switch on the board. When the charger is connected to the power socket, the LEDs started glowing in the board and got the display in my HDMI connected TV in few seconds. The Keyboard was not detected on the first time, I had to reboot the pi again, to do that just pull the micro USB power cable and re-connect again to the pi board. This time the keyboard got detected successfully without any fuss. So I don't need a mouse, since K400 comes with the trackpad too. I have saved one USB slot on this. As its first time boot I had to configure few regional settings. After these initial steps booted successfully and showed the Raspbian OS prompt. Here is the pi got successfully booted with the OS. When prompted for login name and password, I used the default user name and password supplied with the Raspbian Wheezy version. Now its the time to start the desktop, so types "startx" command in the prompt. And Wow here came the desktop screen, a decent one for this cheap computer.



The Raspbian comes with the pre installed python games and with few apps like browser, so opened rjesh.com in the browser. The site opened without any issues and the performance is also not so bad. So here it goes $35 computer booted in few seconds and connects to the internet and can open my blog site.
I'm really impressed with this RPi, great work folks. So for any one if Akash is your cheap tablet, then RPi is your cheapest desktop. Its doesn't have boundaries and sky is your limit extending it with your ideas.

Next on page, is to install the OLXPlayer or any other player to play videos and music. My RPi days will continue.

October 19, 2012

Raspberry Pi - Day 1

At last the Raspberry Pi reached, after a really long wait. In fact I even forgot about the ordered date and to my surprise it reached yesterday. When I un-boxed the RPi realized that I haven't order the power supply. But to my wonder it doesn't need a wait, for that you can use any of your mobile chargers which has the micro USB connector with 5v power supply. Luckily, I have few which came with multiple gadgets. I can dedicate of them to these tiny one.



Now some info on the Raspberry pi, RPi is a single board computer which is small in size (Normally its widely written its credit card size computer, I wont say that its litter bigger than the credit card :-) when connected with SD Card and other accessories, just kidding) Which has HDMI slot, RGA, USB, Ethernet Port. You can use this computer for wide range of ideas. And main thing its cheap just $25 for Model A and $35 for Model B. Now coming back to my day 1 experience, you read about the RPi in their site or in wiki.

At the time of ordering, I know there was 256 MB Ram version alone but later came to know there exists the 512 version also. So quickly want to check on my piece whether its 256 or 512 Ram. I have not prepared my SD card with the OS image to boot. Need to find the Ram size with out booting, it was simple after reading through other RPi owners blog. If you look into the picture above(click on the image to zoom), in the center there is a chip with Samsung written on top of it and there is lengthy string below that. If you can find 2G in that, then its 256 MB Ram if you see 4G in it then its going to be the 512 MB Ram in your board.

Whats next, I already own a full sized SD card going to load the Raspbian linux distribution in it and then try to boot the RPi for the first time. Just curios to see the boot up in the large LED screen.
And will be trying with the other features like adding the WiFi dongle to board and the need to find a way to connect by K400 wireless Logitech keyboard. I'll be writing about my further experience with the RPi.