Archive
How to break a SharePoint list in less than minutes
My client asked me today the limitation of Sharepoint 2010 in terms of number of words per column types, lines and attachments.
I found the answers in Microsoft website and also this blog http://sharepointgadget.blogspot.co.uk/2010/05/limits-in-sharepoint-2010.html that has a good summary.
But then I wanted to prove myself what “Multiple Lines of Text : 192 Maximum Value” really meant for my end user language, so now is the reference to my title “how to break Sharepoint”:
– In a Sharepoint list, I create a Multi-lines column
– Add the value “0123456789” to have 10 characters, then copy and paste this value a few times to have a few hundreds.
– Now be crazy and copy and paste is a lot, I used Word to count my characters and I arrive to 1Mo.
– From here Internet Explorer (I was pasting in a Datasheet mode) crashed, I could have let it think for 30 minutes but decided to crash it after 5.
– Now re-open IE and this list….
– It cannot open ! to be precise: the page opens but doesn’t load anything (blank page).
– And worse: if the list is also showing in a webpart on a page that page won’t open either. Quite an issue if that page is a homepage right ?
Now I had a problem: the list default view cannot be opened because it contains my very large value in a column, and you can only point to the list settings if you know the unique ID of the list (url http://sharepointsite/_layouts/listedit.aspx?List=%7B3C68CBBE%2D3F51%2D402A%2DA584%GD61A0F8C5AFA1%7D)
To fix it: open the site in SharePoint Designer, then open the list gives the option to
The column are now editable and I can change my “Multiple lines of text” to be “Single line of text”
By doing this the long text value in the column will be truncated (and rich text lost if any).
Don’t forget to close the Column edit tab in Sharepoint designer and save the changes.
Now any page containing the view and the list itself can be opened again.
Recommended Podcast
Top Posts
- Calculated Column Formula: Probability and impact analysis for risks #SharePoint #SP2010 #ProjectServer #PS2010 #EPM #MSProject #in
- So, you want to delete users with the Azure AD Graph API? Good luck with that!
- Contact
- SharePoint Page Performance
- Retrieving the Project GUID with JavaScript CSOM #PS2013 #PS2010 #MSProject #Office365 #in
- Using Knockout.js in a SharePoint Context
- Reading a SharePoint Online (Office 365) List from a Console Application (the easy way)
- Welcome to the new Project – getting started Part 2 #MSProject #PPM #Office365 #PowerPlatform #ProjectMangement #ModernWorkManagement #CDS #PMOT #PMO
Archives
Tags
.NET Android Azure Business Intelligence C# Calculated Column Certification Chris Clements Client Object Model CodePlex conference CU Development EPM Excel Form Services 2010 François Souyri InfoPath 2010 Information Rights Management iOS iPad iPhone IRM ISCLondon JavaScript JQuery Microsoft Word Mobile Application MOSS 2007 Office 365 Office 2010 Other Performance PowerBI PowerShell Presentation Project Project 2010 Project 2013 Project Conference 2012 Project Management Project Managment Project Online Project Server Project Server 2007 Project Server 2010 Project Server 2013 PS2007 PS2010 Rights Management Server RMS Search SharePoint SharePoint 2010 SharePoint 2013 SharePoint 2016 SharePoint Designer 2010 SharePoint Online SharePoint Saturday UK SP.ClientContext.get_current() SP2010 SP2016 Speaking Engagements SPF 2010 sql server reporting services Supported File Types TechEd Europe 2012 Technical Preview visio Visual Studio 2010 Visual Web Part Web Part Windows 7 Workflow WSS 3.0Blog Stats
- 617,610 hits