Calculated field date format

According to the regional settings of your system , the format of the date will follow these settings in any list , however if you have a date field in any list and you want to format it you can follow this solution

Problem : Formatting date field in list.

Solution : you can play with that by creating calculated field that contains the following formula
 =TEXT([Date Field Name],"dd mm, yyyy")

But if the date field is optional so the NULL values will return default date value so you need to check if the value is NULL to return nothing , the formula will be
=IF([Date Field Name]=""," ",TEXT([Date Field Name],"dd/mm/yyyy"))

The first part checks if the value is NULL so it returns “ “ however you can add any text in between if you want like “ No date “ , the second part is placing the date text and format it and you can play with the format types.



Calculated field date format

 

Unable to add selected web part(s). The file is currently checked out or locked for editing by another user.

If you play with list default pages like DispForm.aspx or EditForm.aspx or NewForm.aspx and after modification you find that anyone can’t see your modifications or if anyone trying to edit the page get this error

Unable to add selected web part(s). The file is currently checked out or locked for editing by another user.

You have to do the following , Simply check the file in , but the question is , from where can I check the file in ?

If you opened the file from SharePoint Designer under your list you will not find check-in option , you have to open it from “ All Files “ folder in SharePoint Designer , locate your file , check it in.

Back to blogging :) - The filename you specified is not valid or too long

Since last Feb i didn't post any article in my blog , but let's back again :)

One of our clients faced this problem while trying to upload any document to a document library in SharePoint 2010


Error Message : The filename you specified is not valid or too long

OR

Error Message : The URL serverpath/filename.ext is invalid , it may refer to a nonexistent file or folder , or refer to a valid file or folder that is not in the current web

Reason : SQL log was full

Solution  :DB admin shrinked log files and removed some.

SharePoint 2010 101 Code Samples

SharePoint 2010: Leveraging HTML5 Objects in SharePoint
SharePoint 2010: Creating Document Sets Programmatically
SharePoint 2010: Programmatically Finding Tagged Items
SharePoint 2010: Developing AJAX-Enabled Web Parts
SharePoint 2010: Using JavaScript to Enable Notifications
SharePoint 2010: Creating Taxonomies Programmatically
SharePoint 2010: Developing List Definitions
SharePoint 2010: Managing Document Sets Programmatically
SharePoint 2010: Using JavaScript and CAML to Query Lists
SharePoint 2010: Developing JQuery-Enabled Web Parts
SharePoint 2010: Creating Content Types Programmatically
SharePoint 2010: Using JavaScript to Create Lists
SharePoint 2010: Developing Styled Master Pages
SharePoint 2010: Developing Delegate Controls
SharePoint 2010: Performing Cross-List Queries
SharePoint 2010: Using JavaScript to Edit and Save Values in Items
SharePoint 2010: Using JavaScript to Get Details About Site Collections
SharePoint 2010: Using JavaScript to Show Dialog Boxes
SharePoint 2010: Developing Connected Web Parts
SharePoint 2010: Developing Connected Silverlight Web Parts
SharePoint 2010: Developing Application Pages
SharePoint 2010: Programmatically Reading User Profile Properties
SharePoint 2010: Displaying User Profile Pictures Programmatically
SharePoint 2010: Developing Event Receivers
SharePoint 2010: Using REST to Obtain Excel Charts
SharePoint 2010: Creating Custom Timer Jobs
SharePoint 2010: Creating List Items from Silverlight
SharePoint 2010: Retrieving Single List Items in REST Requests
SharePoint 2010: Developing Starter Master Pages
SharePoint 2010: Working with Disposable Objects
SharePoint 2010: Displaying Video Files Stored in Azure
SharePoint 2010: Logging Site Events Programmatically
SharePoint 2010: Calling RESTful SharePoint Services From Desktop Applications
SharePoint 2010: Using JavaScript to Delete Items from Lists
SharePoint 2010: Uploading SharePoint Library Content to Azure Storage
SharePoint 2010: Using JavaScript to Get Details About Sites
SharePoint 2010: Using JavaScript to Retrieve and Interrogate Items in Lists
SharePoint 2010: Querying SQL Azure Data from Web Parts
SharePoint 2010: Developing Feature Receivers
SharePoint 2010: Developing Custom Navigation Providers
SharePoint 2010: Developing Workflow Activities
SharePoint 2010: Calling Azure Services from Custom Workflow Activities
SharePoint 2010: Using REST to Discover the Contents of Excel Worksheets
SharePoint Online: Authenticating Using the Client-Side Object Model
SharePoint 2010: Creating Custom Field Types
SharePoint 2010: Calling Azure Services from Web Parts
SharePoint 2010: Developing State Machine Workflows
SharePoint 2010: Canceling Synchronous Events
SharePoint 2010: Using JavaScript to Update Site Properties
SharePoint 2010: Developing Sequential Workflows
SharePoint 2010: Calling Azure Services from Timer Jobs
SharePoint 2010: Using REST to Query Data Ranges in Excel Worksheets
SharePoint 2010: Retrieving List Contents and Parsing Atom Responses
SharePoint 2010: Developing Web Templates
SharePoint 2010: Declaring Records Programmatically
SharePoint 2010: Performing Cached Cross-Site Queries
SharePoint 2010: Creating Content Organizer Rules Programmatically
SharePoint 2010: Developing Custom Expiration Actions
SharePoint 2010: Developing Custom Expiration Formulae
SharePoint Online: Creating Excel Worksheets by Using Excel Web App
SharePoint 2010: Using JQuery to Retrieve List Contents in JSON
SharePoint 2010: Logging Data to the Developer Dashboard
SharePoint 2010: Creating SQL Azure Records from Web Parts
SharePoint 2010: Developing Page Layouts
SharePoint 2010: Calling WCF Services from Timer Jobs
SharePoint 2010: Accessing SharePoint Lists from External WCF Services
SharePoint Online: Accessing Web Services
SharePoint 2010: Performing Searches from Silverlight
SharePoint Online: Creating and Deploying Sandboxed Web Parts
SharePoint 2010: Calling Azure Services from Event Receivers
SharePoint 2010: Using LINQ in REST Requests
SharePoint 2010: Creating Custom SharePoint Service Applications
SharePoint 2010: Calling WCF Services from Web Parts
SharePoint 2010: Accessing List Items from Silverlight
SharePoint Online: Deploying Sandboxed Content Types and List Definitions
SharePoint 2010: Developing Editor Web Parts
SharePoint 2010: Importing Content by Using the Content Deployment API
SharePoint 2010: Developing Custom Field Controls
SharePoint 2010: Using REST to Create a SharePoint and Bing Maps Mashup
SharePoint 2010: Developing Ribbon Drop Down Controls
SharePoint Online: Creating and Deploying Sandboxed Event Receivers
SharePoint 2010: Developing Branded Media Controls
SharePoint 2010: Calling WCF Services Hosted in SharePoint
SharePoint 2010: Developing Site Definitions
SharePoint 2010: Developing Solution Validators
SharePoint Online: Accessing Current User Information in Sandboxed Solutions
SharePoint 2010: Creating Items in Lists from External WCF Services
SharePoint Online: Creating and Deploying Sandboxed Feature Receivers
SharePoint 2010: Deleting SQL Azure Records from Web Parts
SharePoint 2010: Updating SQL Azure Records from Web Parts
SharePoint 2010: Developing Sandboxed Web Parts
SharePoint 2010: Deleting Items in Lists from External WCF Services
SharePoint 2010: Performing Searches from Web Parts
SharePoint 2010: Retrieving List Contents in JSON Format and Parsing Responses
SharePoint 2010: Calling WCF Services from Event Receivers
SharePoint 2010: Exporting Content by Using the Content Deployment API
SharePoint 2010: Developing Ribbon Actions
SharePoint Online: Creating and Deploying Sandboxed Workflow Activities
SharePoint 2010: Calling WCF Services from Custom Workflow Activities
SharePoint Online: Creating Documents Using Word, PowerPoint, or OneNote Web App

Source : http://code.msdn.microsoft.com/SharePoint-2010-101-Code-da251182/view/SamplePack/

Download SharePoint 15 Tech Preview SDK

SharePoint 15 Technical Preview Managed Object Model SDK contains reference topics focusing only on types and members that are called by other Microsoft applications. This reference does not document the full SharePoint 15 managed object model. That documentation will accompany a later release of SharePoint 15.

Download Link : http://www.microsoft.com/download/en/details.aspx?id=28768
Source : http://microsoftfeed.com/2012/download-sharepoint-15-tech-preview-sdk/

Top Rated SharePoint Sites for 2011

http://www.fiatspa.com/en-US/Pages/Home.aspx

http://www.ataturkairport.com/en-EN/Pages/Main.aspx

http://www.volvocars.com/Pages/default.aspx

http://www.embraer.com/en-US/Pages/Home.aspx

http://www.sharpie.com/Pages/GlobalLanding.aspx

http://www.faurecia.com/Pages/Default.aspx

http://www.kempinski.com/en/Pages/Welcome.aspx

http://www.pousadas.pt/historic-hotels-portugal/en/pages/home.aspx

http://www.trincoll.edu/Pages/default.aspx

http://www.360-5.com/Pages/default.aspx

Source : http://www.topsharepoint.com/top-rated-sharepoint-sites-for-2011

SharePoint 2010 Developer Training Course

SharePoint 2010 provides the business collaboration platform for developers to rapidly build solutions using familiar tools while leveraging a rich set of out of the box features. Visual Studio 2010 and SharePoint Designer 2010 make developers more productive and Visual Studio Team Foundation Server delivers support for application lifecycle management. Developers can integrate Line of Business data in SharePoint 2010 with read/write capability delivered by Business Connectivity Services. Sandboxed Solutions can be deployed to a shared hosting environment to limit the impact of unpredictable code to the other applications in use.

Download link : http://www.microsoft.com/download/en/details.aspx?displayLang=en&id=6184
Source : http://msdn.microsoft.com/en-us/gg620703

Service Pack 1 for Microsoft SharePoint Server 2010 (KB2460045)

Service Pack 1 (SP1) for Microsoft SharePoint Server 2010 contains new updates which improve security, performance, and stability. Additionally, the SP is a roll-up of all previously released updates.

Download Link :  http://www.microsoft.com/download/en/details.aspx?id=26623

Service Pack 1 for SharePoint 2010 Coming Soon…

by   sharepointblog@live.com   on  5/13/2011 1:50 PM

Category:  Service Pack SharePoint 2010

​Author:  Bill Baer, Senior Technical Product Manager, Microsoft Corporation

As we near the release of Service Pack 1 in late June 2011 we wanted to take a moment to share some of the important new functionality that will be brought to SharePoint 2010 with Service Pack 1.  Service Pack 1 represents stability, performance, and security enhancements that are a direct result of your feedback and designed to extend the value you are experiencing with SharePoint 2010.  

 

At this time we’re ready to share some of these improvements and as we move closer to late June 2011 we’ll be providing additional insight into additional functionality and specific fixes.

 

Site Recycle Bin

Service Pack 1 will introduce long awaited Site Recycle Bin functionality that enables self-service recovery of site collections and sites.   In the past IT Professionals were tasked with restoring entire databases to recover deleted site collections and sites and would generally require expensive restore environments to support the task.  Now in Service Pack 1 administrators can quickly and easily recover site collections and sites accidentally deleted by their owners in a process similar to that of the Recycle Bin we have for Lists, Libraries, and Documents.

Shallow Copy

If you’re using Remote BLOB Storage you’ve probably realized that when moving Site Collections (Move-SPSite) between content databases each unit of unstructured data (BLOB) was round tripped (I.e. uploaded and subsequently downloaded again) serially during the move.  This operation was both time consuming and resource intensive.  In Service Pack 1 we reduce that overhead by enabling “shallow copy” when moving Site Collections between databases where Remote BLOB Storage is used.  New Shallow Copy functionality with the Move-SPSite CmdLet enables moving site collections between content databases without moving the underlying unstructured data, i.e. Microsoft Word documents, PowerPoint Presentations, etc. significantly increasing performance and reliability for organizations using Remote BLOB Storage by simply updating the pointers to those objects in the destination content database.

 

StorMan.aspx

In SharePoint 2010 we removed StorMan.aspx (Storage Space Allocation) (seehttp://support.microsoft.com/kb/982587/EN-US) which in previous versions of SharePoint enabled granular management and insight into storage.  For example, the page would show you the top 100 documents or document libraries in terms of size.  With that information end users could the page to clean up content from their site(s) by deleting the large content that they no longer needed.  In Service Pack 1 we are bringing back an improved StorMan.aspx, enabling users to better understand where their quota is going and act upon that information to reduce the size of their sites.

 

New enhancements will improve the way you interact with information in SharePoint 2010.  Service Pack 1 adds support for working with Office Web Applications using Internet Explorer 9 in native mode improving performance or with the Google Chrome browser (for a complete list of supported browsers for SharePoint 2010 see also http://technet.microsoft.com/en-us/library/cc263526.aspx), support for Open Document Format documents, and more.

 

In addition to the new functionality Service Pack 1 provides, as with all Service Packs, it will include a number of fixes  designed to improve your experience with SharePoint 2010 and will include all Cumulative and Public Updates through the April 2011 Cumulative Update.

 

The data below is an accumulated list of all 2010 fixes that have already shipped.  These will be included in our Service Pack 1 release.  This is a combination of Cumulative Updates and Public Updates.  In addition to what is listed below, Service Pack 1 will contain more fixes in each product.  Between now and the time of release, we will publish more details about the coming changes.

• SharePoint Server 2010 February 2011 Cumulative Update
• SharePoint Foundation 2011 February Cumulative Update
• SharePoint Server 2010 December Cumulative Update
• SharePoint Foundation 2010 December 2010 Cumulative Update
• SharePoint Server 2010 October 2010 Cumulative Update
• SharePoint Foundation 2010 October 2010 Cumulative Update
• SharePoint Server 2010 August 2010 Cumulative Update
• SharePoint Foundation 2010 August 2010 Cumulative Update
• SharePoint Server 2010 June 2010 Cumulative Update (there was no consolidated update provided for June 2010)
• KB983497
• KB2124512
• KB2182938
• KB2204024
• KB2281364
• SharePoint Foundation 2010 June 2010 Cumulative Update

Enjoy Service Pack 1.  We made it for you.

 

To keep informed with up to date Service Pack 1 information subscribe to the CAPES blog athttp://blogs.technet.com/b/office_sustained_engineering/.

Source : Microsoft SharePoint Team Blog