Thursday, 30 March 2017

Infopath forms Unable to attach files after creation i.e, unable to attach by the time of edit


If InfoPath Form is having issues while attaching any document to the form during the Edit mode of the form.
Attachments are working fine when New Item is created, but having issues with the Edit Form


Issue Resolution:
In order to fix this, we need to make some Web.Config changes and have to add the following tag.

<appSettings>
     <add key="aspnet:MaxHttpCollectionKeys" value="4000" />
 </appSettings>


Issue Caused By:
The error traced from the logs is “Operation is not valid due to the current state of the object”.

This will happen due to the post back control size limit. If there are more number of controls in the post back submission of any page, it causes the above mentioned issue. Actually the Form is quite big and having a lot of controls.

Monday, 27 March 2017

"The Selected Cells Are Read-Only” When Pasting Into A Datasheet View…

How To Get Around “The Selected Cells Are Read-Only” When Pasting Into A Datasheet View…

I ran into an issue when trying to paste data into a datasheet view:
20140520Image02
All my columns seemed to be fine, and I know I had pasted items before. So I did a little research, and found it was a problem with multi-line text fields that were set for Enhanced Rich Text:
20140520Image01
If you have a column in the datasheet view that is set to Enhanced Rich Text, you get the read-only error. If I change that to Rich Text (or Plain Text), then I can paste in the new information with no problem.
Recording it here so I’ll remember it later. 🙂

Tuesday, 14 March 2017

Managed Metadata column on a SharePoint 2010 list does not display values added from term store



Symptoms

Users are not able to see the values in a Managed Metadata
column on a SharePoint list.The only users who can view the
 metadata values are 'Site Collection Administrators'and any
 user who was given the permissions from the 
'Policy for Web Application' page in Central Administration.
Additionally, users with 'Contribute' or 'Full Controll' permissions
are able to see the values on 'editform.aspx' page. 




Cause

'NT AUTHORITY\Authenticated Users' is removed from
'People and Groups' list for the site collection on a classic-mode
web application. This issue can also occur if 
'All Authenticated Users' is removed from 'People and Groups'
list for the site collection on a classic-mode web application.


Resolution

Browse to 
'http://<URLforSiteCollection>/Lists/TaxonomyHiddenList'
with Site Collection administrator privileges and add the 
following users/groups to the list.For classic web application,
add 'NT AUTHORITY\authenticated users' with 'Read' permissions on List


For claims-based web application, add 'All Authenticated Users' with 

'Read' Permissions on List


Note: 'TaxonomyHiddenList' is a hidden list and is not visible in the UI 

Friday, 3 March 2017

Enabling Open option for Forms to open in outlook for SharePoint

1.
 Login to the server -> inetmgr(IIS) -> Click on the server name -> On right side select MIME types -> Double click on it and then Click on Add.
File name extension: .oft
MIME type: application/vnd.ms-outlook

2. Run the following below Powershell script on the SharePoint Management Shell.

$webApp = Get-SPWebApplication "http://webapplication name"
If ($webApp.AllowedInlineDownloadedMimeTypes -notcontains "application/vnd.ms-outlook")
{
  $webApp.AllowedInlineDownloadedMimeTypes.Add("application/vnd.ms-outlook")
  $webApp.Update()
  Write-Host "application/vnd.ms-outlook added to AllowedInlineDownloadedMimeTypes"
  }