B i t s O f S h a r e P o i n t C o n s u l t i n g L L C > B l o g P o i n t > Categories

4/15/2009

SharePoint /_layout/images/ Full List - Update
I have updated the area where you can see all the different images that SharePoint provides OOB.  The original setup called up each image, well with a grouping of over 900 images that could be a over a meg of data, not acceptable. 
 
So the new setup is one image showing all the individual images with the name of the file below.  This will make it much faster to view the images.
 
 
Click to View SharePoint Images
 
Posted at 1:16 AM by Peter Allen | Category: SP-Blogs; SP-Calculated Columns - Formula; SP-Calculated Columns - HTML; SP-CSS/Theme; SP-Document Library; SP-Javascript/JQuery; SP-Lists; SP-Meeting Minutes; SP-Navigation; SP-Project Management; SP-Tracking System; SP-SharePoint Add-ons; SharePoint | Permalink | Email this Post | Comments (0)

3/16/2009

SharePoint /_layout/images/ Full List
Not everyone has admin access to see under the hood of SharePoint.  One of those areas is the "/_layout/images/" directory where SharePoint stores its images. 
 
As user who customizes SharePoint and uses JQuery and Javascript to improve the experience I found that I wanted to use the same images that came with SharePoint, but I did not have access.  So with the help of Paul Greneir I was able to get my hands on the 2000+ images found in "/_layout/images/".
 
My first reaction was wonderful, now I can organize and have access to all these images.  Then when I realized it was 2000+ images, I took great pause.  That is a lot of images to review and organize.
 
Here is what I am attempting, not to loose my sanity.  So far I have grouped these in two ways.  First, I have grouped them alphabetically.  Second, I have grouped them by size of the image (Small, Medium, Large).
 
I have also identified which images can be found in WSS and MOSS (both) and only on MOSS (MOSS Only).
 
Here is a sample view: 
 
 
 
Click to View SharePoint Images
 
Posted at 12:05 AM by Peter Allen | Category: SP-Blogs; SP-Calculated Columns - Formula; SP-Calculated Columns - HTML; SP-CSS/Theme; SP-Document Library; SP-Javascript/JQuery; SP-Lists; SP-Meeting Minutes; SP-Navigation; SP-Project Management; SP-SharePoint Add-ons; SP-Tracking System; SharePoint | Permalink | Email this Post | Comments (4)

12/12/2008

Calculated Column - Formula - Yes/No Field
OK, so I was trying get a formula in calculated column to recognize the Yes/No field (check box), this is not the choice field.  You would think that you could check to see if the filed is yes or no, but that turns out not to be the case.
 
I read a few posts and the data is stored in Boolean, so I tried 1 or 0 as some post said, but that did not work.  I then stumbled upon a post that said to use True or False, that worked.
 
Here is an example: 
 
WORKED:
=IF(Attending=TRUE,"Attending","Not Attending")
 
Did NOT work:
=IF(Attending="Yes","Attending","Not Attending")
=IF(Attending=1,"Attending","Not Attending")
 
 
Posted at 1:36 PM by Peter Allen | Category: SP-Calculated Columns - Formula; SharePoint | Permalink | Email this Post | Comments (4)

12/8/2008

Calculated Column - Formula - Fix Sort by Date
I had an issue where I wanted to sort by date, but since by default SharePoint formats a date as 5/25/2008 and 12/2/2008, sorting caused the Dec. date to sort first then the May Date.
 
My solution was to create a calculated column that formatted a date in way that is could be easily sorted.  mm-dd-yy.
 
  1. Create a new Calculated column
  2. In the Formula box, enter something like this: =TEXT([existing date column],"mm-dd-yy") You can use any date format string you like instead of "mm-dd-yy"
  3. Make the data type "Date and Time"
  4. Make the date and time format "Date Only"

This worked great for me.  Sorting worked as it should and grouping worked very well too.

Posted at 1:44 PM by Peter Allen | Category: SP-Calculated Columns - Formula; SharePoint | Permalink | Email this Post | Comments (0)
 
 
This blog is about HealthCare, SharePoint, Technology and things that catch my interest.
 
 
Below is BitsOfSharePoint related links:
 

 ‭(Hidden)‬ Content Editor Web Part ‭[2]‬

 T o p i c P o i n t

 E x a m p l e P o i n t

 All Posts
 > SharePoint Book - Global Navigation Solution 2010
 > SharePoint 2007 - Wiki View Solution
 > SharePoint - Global Navigation 2010 Solution In Progress
 > SharePoint – A Global Navigation Solution Across Site Collections – Permissions
 > SharePoint - A Global Navigation Solution across Site Collections – Version 2.0 Solution
 > SharePoint – A Global Navigation Solution Across Site Collections – Version 2.0 Primer and Deployment
 > Tab Page for SharePoint Version 2.0
 > SharePoint - A Global Navigation Solution across Site Collections
 > Search Lists and Document Libraries by Metadata
 > SharePoint Information Architecture with MindManager by MindJet
 > SharePoint Themes – More than Pretty Colors – Information Architecture
 > Site Owners – Display and Manage
 > SharePoint: ToolTip 2.0 (Posted on EndUserSharePoint.com)
 > jQuery – List and Document Library Filter Version 2.2
 > SharePoint CEWP Solution Interface – Part II
 > SharePoint CEWP Solution Interface – Introduction
 > jQuery – List and Document Library Filter Version 2.1 - Released
 > jQuery – List and Document Library Filter Version 2.0 – Part 2
 > What's next? List Filter, Search and CEWP Options Interface
 > jQuery - List and Document Library Filtering Solution
 > Wiki Customization Update: Add List Views to Wiki Content
 > Presenting at Sacramento SharePoint User Group
 > Where have I been?
 > Launch of Peter Allen's Blog
 > Multiple Lists from Different Sites – Viewing Tool
 > Wiki Customization - Update
 > Tab Page for SharePoint
 > JQuery - View a list from any site with Auto Refresh
 > Wiki - Customization
 > Challenge: Twitter and Managing/Following Multiple Interests - One Account or More?
 > SharePoint /_layout/images/ Full List - Update
 > SharePoint /_layout/images/ Full List
 > JQuery - Improved Pop-up for Lists, Document Libraries, Calendar and Username with Examples
 > JQuery - List Collapse/Expand Multi-line Text Fields
 > JQuery - Pop-up for Lists
 > Document Library - Another great article on using metadata
 > JQuery - View a list on any site from any other site
 > CSS - View all aspects of your SharePoint Site CSS Theme
 > JQuery - Manage Multiple implementations of a JQuery Solution
 > JQuery - Quick Launch with Tool tips with Simple Tip plug-in
 > JQuery - Solutions - Highlight list Item -Updated
 > Navigation - QuickLaunch add with CEWP and JavaScript
 > EndUserSharePoint.com - Become Your Company’s SharePoint Superstar
 > Print - Clean Pages and Lists on any Page
 > Document Library - Setup a Content Type (Link to a Document)
 > Meeting Minutes - Use of a Blog to manage
 > Blogs - How to change Blog Posts to allow multiple selections for Categories
 > Lists - Cascading Columns
 > Topic Point - Update - Added Ranking
 > Document Library - URL Length Problem/Solution
 > JQuery - Calendar with Mouseover preview pain
 > Navigation - Custom Quick Launch Look
 > JQuery - Solutions - Highlight list Item
 > Site Navigation - Quick launch in Webpart Pages (Continued)
 > Site Navigation - Quick launch in Webpart Pages
 > Issue Tracking - Custom Setup
 > BitsOfSharePoint Launched Today
 > Blog Setup - Comments and Spam - Today's date column
 > Calculated Column - Formula - Yes/No Field
 > SharePoint Add-ons - Embed Video in a Blog
 > Meeting Minutes - Use a Blog
 > Calculated Column - Formula - Fix Sort by Date
 > Calculated Column - HTML - The Progress Bar
 > SharePoint Blog lack of Features - Statistics - Part 1
 > Calculated Column - HTML - Java Script to Use
 > BitsOfSharePoint - What is this site and blog about?