Skip to main content

Posts

Showing posts from August, 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 DescriptionjQuery 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 DetailsPublisher:Packt PublishingBy:Dan WellmanISBN:978-1-84951-910-6Year:Pages:296Language:EnglishFile size:4 MBFile format:PDF

Download ebook - jQuery Hotshot


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:
LEFT RIGHT SEARCH LEN IF ISERROR TRIM
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 &q…

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 : ohttp://[YourSiteURL]/_layouts/people.aspx?MembershipGroupId=[ANumber] ·Just make a change in this url ohttp://[YourSiteURL]/_layouts/people.aspx?MembershipGroupId=0
·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!!!

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














Download My Sites Webpart Download Document

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.