Friday, August 30, 2013

Download ebook - jQuery Hotshot

Download ebook - jQuery Hotshot

Ten practical projects that exercise your skill, build your confidence, and help you master jQuery


Book Description

jQuery is used by millions of people to write JavaScript more easily and more quickly. It has become the standard tool for web developers and designers to add dynamic, interactive elements to their sites, smoothing out browser inconsistencies and reducing costly development time.

jQuery Hotshot walks you step by step through 10 projects designed to familiarise you with the jQuery library and related technologies. Eachproject focuses on a particular subject or section of the API, but also looks at something related, like jQuery's official templates, or an HTML5 feature like localStorage. Build your knowledge of jQuery and related technologies.

Book Details

Publisher:Packt Publishing
By:Dan Wellman
ISBN:978-1-84951-910-6
Year:
Pages:296
Language:English
File size:4 MB
File format:PDF


Download ebook - jQuery Hotshot


Thursday, August 29, 2013

10 jQuery snippets for SharePoint 2010


A good post which let you know through jQuery:


  1. Text manipulation
  2. Check the URL
  3. Timestamp
  4. Change the attribute
  5. Change CSS
  6. Add expand / collapse web parts
  7. Modify form field
  8. Check site template
  9. Welcome message
  10. Append today’s date


Thursday, August 22, 2013

Split string in 2 column

I have a field called "Location" in this field we are storing "City, State". Now we want to show city in other column and state in other column. Basically I want to split the "Location" column based on "," (comma).

To achieve this goal I am using the functions:


Let’s see how can we do this with use of above given functions.

If Errors, I am using ISERROR formula
=IF (ISERROR (currentFormula), "", currentFormula)

I am going to create a calculated column called "City" and copy & paste the "=IF(ISERROR(LEFT(Location,(SEARCH(",",Location,1)-1))), "", TRIM(LEFT(Location,(SEARCH(",",Location,1)-1))))" in the formula text box. This formula will check whether any error is coming or not if error is coming then it will return blank value otherwise show us "City Name"


I am going to create a calculated column called "State" and copy & paste the "=IF(ISERROR(RIGHT(Location,(LEN(Location)-SEARCH(",",Location,1)))), "", TRIM(RIGHT(Location,(LEN(Location)-SEARCH(",",Location,1)))))" in the formula text box. This formula will check whether any error is coming or not if error is coming then it will return blank value other wise show us "State Name"

Monday, August 19, 2013

Remove user from site collection

Hi,

If you want to remove or delete a user from site collection not from a site only what will you do in SharePoint 2010. We have option to delete a user from site collection In SharePoint 2007. But unfortunately in SharePoint 2010 we do not have this option.

     ·        Now follow below given steps to remove or delete a user from whole site collection:
·         Log in as Site Collection Admin in site collection
·         Go to Site Actions & then Site Permissions
·         Hit on any security group to open.
·         Go to the URL now. You will find the url look like :
·         Just make a change in this url

·         Just remove number [ANumber] from the URL & place “0” (Zero) instead of that number.
·         After deleting any user from here will be deleted from the whole site collection.


Enjoy SharePoint!!!

Wednesday, August 7, 2013

Exam Ref 70-332: Advanced Solutions of Microsoft SharePoint Server 2013

Hi,
Prepare for Exam 70-332 - and help demonstrate your real-world mastery of Microsoft SharePoint Server 2013. Designed for experienced IT Professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level.

Download ebook for 70-332

Exam Ref 70-331: Core Solutions of Microsoft SharePoint Server 2013

Hi,
Prepare for Exam 70-331 - and help demonstrate your real-world mastery of Microsoft SharePoint Server 2013 core solutions. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level.

Download free ebook for 70-331

Tuesday, August 6, 2013

My Sites Web Part

Here people wanted to see a web part which can show my sites on which current user have access permission. I searched in SharePoint but I didn't find any out of the box web par for the same purpose. So created My Sites Web Part for our internal use.

I have created 2 view of the web part with some different kind of settings:

1.  Show My Sites in Tree View





2.  Show My Sites in View















Friday, August 2, 2013

WSS_Logging database

Truncate WSS_Logging database with this script :

1. Open SQL Server with "Run as Administrator"
2. Right click on WSS_Logging database & click on New Query.
3. Copy & paste below given script.

     DECLARE @TableName AS VARCHAR(MAX)
DECLARE table_cursor CURSOR
FOR
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_NAME LIKE '%_Partition%'
OPEN table_cursor
FETCH NEXT FROM table_cursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE @SQLText AS NVARCHAR(4000)

SET @SQLText = 'TRUNCATE TABLE ' + @TableName

EXEC sp_executeSQL @SQLText

FETCH NEXT FROM table_cursor INTO @TableName
END
CLOSE table_cursor
DEALLOCATE table_cursor


4. Run this query.
5. Than shrink this database.