Sandoval's SharePoint Spot

A personal collection of links, notes and shortcuts.

  •     
  • Biography
  • Bloggers I Follow
  • Links and More Links
  • Welcome
  • 16
    Sep 11

    Can not add the user because a user with that name already exists …

      Posted by Sandoval
      0 comments

    See solution here:

    http://rehmangul.sauftveyr.com/2008/04/23/can-not-add-the-user-because-a-user-with-that-name-already-exists/

    Worked for me.

      Security, Tips & Tricks
      Errors, Permissions, Security
     
  • 19
    Oct 10

    Illegal Characters

      Posted by Sandoval
      0 comments

    Here is a list of common illegal characters that must not be included in web urls – - – and not used when creating file names that will be used on the web:

    # % & * { } \ : < > ? / +

    In addition to this list it is prohibited to have consecutive periods in the URL (or file name). It’s also prohibited to start or end with a space or underline, or to end with a period.

    Even though it isn’t illegal to use commas or spaces in a url – it is best to not use them for consistency across different server platforms.

    These rules are Web Standards.

      Tips & Tricks
      Characters, Illegal, URL
     
  • 2
    Sep 10

    Using TODAY As a calculated column

      Posted by Sandoval
      0 comments

    Important things too know about using TODAY in a calculated column!

    http://www.linkedin.com/news?viewArticle=&articleID=185992482&gid=93094&type=member&item=28659782&articleURL=http%3A%2F%2Fblog%2Epentalogic%2Enet%2F2010%2F09%2Ftoday-sharepoint-calculated-default-values%2F&urlhash=q1qF&goback=%2Egde_93094_member_28659782

      Calculated Columns, Functions and Formulas, Tips & Tricks
      Calculated Columns, Date Field, Formulas & Functions, Today
     
  • 14
    Aug 10

    Add Site Quick Launch Menu to a Web Part Page

      Posted by Sandoval
      0 comments

    You need to edit a line of code in SharePoint Designer

    • Go to Code View
    • FIND:  “Placeholderleftnavbar”
    • Delete Row (approx. line 47) that has that above code
    • OK to Change site definition
      HTML, Master Pages, Page Layout, SharePoint Designer, Tips & Tricks
      Code View, LeftNavBar, Quick Launch
     
  • 14
    Aug 10

    Creating Single Server Sign On from Central Admin

      Posted by Sandoval
      0 comments

    SSO Single Server Sign On

    Add Application Services in Central Admin

    1. Operations Tab
    2. Manage Settings for SSO

    Ensure SSO Service is Running (If you get a “Failed to Connect…”)

    1. Start/ Admin Tools/ Services
    2. Open Microsoft Single Sign On Services
    3. Log On Tab
    4. Best Practice to use to Server Admin Account (from A.D.) not the Local System Account
      1. Provide Name Password
    5. General Tab
      1. Start Service/ OK
    1. Manage Settings for SSO
      1. Manage Server Settings
      2. Provide an SP SSO Admin Account
      3. Provide Enterprise Application Definition Admin Account (usually the same as SSO Admin Account)
      4. Creates a SSO DB (Server Name, DB name)
      5. Click OK
    2. Manage Settings for Enterprise Application Definitions (link)
      1. Create a New Item for Each Back end system that will be used to with each application requiring connection.
      2. Display Name for SSO Admin
      3. Application Name that Site Admins will use to connect (No Spaces)
      4. Contact e-mail for back end db
      5. Account Type (best practice GROUP)
      6. Authentication Type (Leave blank so that no authentication is required).  This will allow for the passing of credentials
      7. Create a SP Name and Password for this Application Definition.  Ok to leave defaults (“Username” [mask NO], “Password” [mask YES]).  Not a best practice!
    3. Manage Settings for SSO
    4. Manage Account Info for Enterprise Application Definitions
      1. Provide account information that is going to be passed.
      2. Pick Enterprise App Definition created in Step 3.
      3. Provide Group name (See step 6 below)
      4. Click SET to provide User Name and Password for Enterprise Application.  (Best Practice to not provide Enterpise App Sys Admin.  Use a Enterpise App Read Only Account),
      5. Click OK/ Done

    Active Directory (use to find AD Groups)

      1. Start/ Admin Tools/ AD Users and Computers
      2. Get name and verify membership
    1. Manage Encryption Key
      1. Click Create Encryption Key
      2. Click OK/ OK
      • NOW TO USE SSO!
    1. You will be using the Application Name (not Display Name) to make a connection to the db)

    In SP Designer

      1. Go to Data View Menu
      2. Click Insert Data View
      3. From Task Pane Connect to a Data Base
      4. Click Configure Database Connection
      5. Server Info is where (SQL Server is running)
      6. Authentication (USE SSO)
      7. Click Settings
      8. Provide Application Name (Step 3c, no spaces) and
        Application Username and Password (Step 3g)
      9. Click Next/ Select Database/ Select Table
      10. Click Finish/ Ok to make the connection
      Best Practices, Central Administration, SharePoint Designer, SharePoint Server, SQL, SSO - Single Server Sign On
      Application Services, Enterprise Application Definitions, Single Server Sign On, SSO
     
  • 13
    Aug 10

    Nested If Then Statement with 15 Conditions

      Posted by Sandoval
      0 comments

    Another GREAT tip from Christophe at Path to SharePoint

    =IF([Status]=””,”Black”,IF([Status]=”Choice1?,”Red”,IF([Status]=”Choice2?,”Gold”,IF([Status]=”Choice3?,”Green”,IF([Status]=”Choice4?,”DarkBlue”,IF([Status]=”Choice5?,”DarkCyan”,IF([Status]=”Choice6?,”DarkRed”,IF([Status]=”Choice7?,”Gray”,””))))))))&IF([Status]=”Choice8?,”MediumSlateBlue”,IF([Status]=”Choice9?,”SpringGreen”,IF([Status]=”Choice10?,”MidnightBlue”,IF([Status]=”Choice11?,”Sienna”,IF([Status]=”Choice12?,”SlateGray”,IF([Status]=”Choice13?,”OliveDrab”,IF([Status]=”Choice14?,”Gray”,””)))))))

      Calculated Columns, Functions and Formulas, Tips & Tricks
      Calculated Columns, If Then Statement
     
  • 20
    May 10

    Collapsing Multiple-line of Text in a Webpart

      Posted by Sandoval
      0 comments

    I’ve used this before. Great solution for collapsing a multiple-line of text field. Solution created by Paul Grenier and enhanced by Pater Allen.

      jQuery, Tips & Tricks
      Collapse, jQuery
     
  • 5
    May 10

    Display Form and Edit Form Customizations

      Posted by Sandoval
      0 comments

    Great idea from Jim Howard for creating section breaks in a Display Form or Edit Form.

      jQuery, Other Bloggers, Tips & Tricks
      DispForm, Display Form, Edit Form, EditForm
     
  • 25
    Apr 10

    SharePoint Page Modes

      Posted by Sandoval
      0 comments

    Sometimes there are instances where page functionality is not operating as it should. The GUI is not letting you edit a page or remove a corrupt web part. Here I will start listing those URL appendices that will get you to the mode you need:

    Put a page in EDIT mode.

      Tips & Tricks
      Edit Page, URL
     
  • 30
    Mar 10

    Creating a Multiple selection List Box in browser enabled InfoPath form.

      Posted by Sandoval
      0 comments

    Solution provided by Mehul Bhuva at SharePoint Fix.

      InfoPath, Other Bloggers, Tips & Tricks
      Checkbox, InfoPath, Multiple Items
     
  • 10
    Feb 10

    Access the task pane of an ASPX page

      Posted by Sandoval
      0 comments

    How to Quickly get to the task pane of an ASPX page.

    Add the following text to the end of the ASPX page.

    ?&toolpaneview=2

      Tips & Tricks
      Task Pane
     
  • 10
    Feb 10

    URL Limitations

      Posted by Sandoval
      0 comments
    • Limit the number of nested folders.
    • Abbreviate where possible.

    Instead of Folders create Libraries with Acronym then rename library to full name.  The original created name never changes.

      Best Practices
      URL
     
  • 10
    Feb 10

    Invalid/Illegal Characters

      Posted by Sandoval
      0 comments

    Special Character that are reserved and not to be used in creating Folders.

    Invalid characters include the following: ~ ” # % & * : < > ? / \ { | }.

    Also, the name cannot begin or end with dot and cannot contains consecutive dots.


    Solution: STG Print Folder Plus can globally replace characters.  ECHO can also migrate content and replace illegal characters

      Best Practices, SharePoint
      Folders, Illegal Characters
     
  • 10
    Feb 10

    When to use a Publishing Site or a Collaboration Site

      Posted by Sandoval
      0 comments

    From SharePoint Best Practices Conference Mark Eischenberger

    • Publishing sites can not be saved as a template
    • Collab sites site settings is limited vs. Publishing sites
    • Hybrid site

    o   Start a collab site

    o   Turn on site features

    o   Turn on SP server publishing

    • Collaboration Portals are ideal for:

    *  Blog Sites

    *  Multilingual sites almost always require Publishing ON.

    • Intranets are ideal for Collaboration Portal
      Best Practices
     
  • 10
    Feb 10

    Maximum Number of Users Met. How do I boot someone off the box?

      Posted by Sandoval
      0 comments

    Start > All Programs > Administration Tools > Terminal Service Manager >

      I.T. Know How
     
  • 10
    Feb 10

    Firefox and MOSS

      Posted by Sandoval
      0 comments

    Some features that require ActiveX control in MOSS is not available in Firefox.  I attached the complete list.

    So any basic stuff will work on Firefox and Safari (apple Mac).

    MOSS Browser Level Support

      Browsers
     
Recent Posts
  • Can not add the user because a user with that name already exists …
  • With WSS3 (or MOSS 2007) and Outlook 2007, we have the ability to not only view activity from multiple calendar sources in one virtual calendar view, but we can also edit these SharePoint calendars directly from Outlook.
  • Illegal Characters
  • Using TODAY As a calculated column
  • How to Repair/Replace a broken SharePoint List Form
Recent Comments
    Tags

    Alerts Attachments Calculated Columns Calendar Calendars Checkbox Compare Values Concatenate Contains Crawl Customize Date Field Edit Page Error Folders Form Letter Formulas & Functions History hyperlinks If Then Statement Illegal Characters index indexing InfoPath LDAP Query Master Page Migrate Minutes Move Content Multiple Items Notes Office Outlook Integration Repeat Characters Server Limits SharePoint Designer Solid Line SSP stsadm Task Pane Today Truncate URL Visio Word Count

    Feed
    •    Posts Feed
    •    Comments Feed
    • Archives

      • September 2011
      • April 2011
      • October 2010
      • September 2010
      • August 2010
      • May 2010
      • April 2010
      • March 2010
      • February 2010
    • Categories

      • Best Practices
        • Browsers
        • I.T. Know How
        • Tips & Tricks
      • Blog Spots
        • Other Bloggers
      • Code Library
        • HTML
        • jQuery
      • Microsoft
        • Excel Services
        • Functions and Formulas
        • InfoPath
        • Office
        • SharePoint Designer
      • SharePoint
        • Calculated Columns
        • Calendars
        • Central Administration
        • Content Editor Web Parts
        • Dataview Web Parts
        • Document Libraries
        • Error Messages
        • List/Document Library
        • Master Pages
        • Page Layout
        • Search
        • Security
        • Server Limits
        • SharePoint Forms
        • SharePoint Server
        • SSO – Single Server Sign On
        • Web Parts
        • Workflow
      • SQL

    Copyright © Sandoval's SharePoint Spot