This is part 2 of my demo project about “How to create a custom list form…” –

See this post for part one:

https://blog.kenaro.com/2010/12/29/walkthrough-create-custom-sharepoint-2010-list-form-for-deployment-in-a-visual-studio-2010-project/

Here you can download the demo project as source code:

http://spcustomlistformdemo.codeplex.com/

Let’s start…

(See “ListDefinition2” in the demo project source!)

1. Create an new List Definition project item as described in the previous blog post (“Part 1”).

2. In the ASPX file of your list form be sure to add the attribute UseLegacyForm=”True” to your Form-Tag. – Like in this screenshot:

3. Then you need to create the field edit controls by yourself. Therefore you have to add some code to the ASPX file.

Here is some demo code. (The “ListDefinition2” based upon “Announcement List Template”…)

1:                 <WebPartPages:WebPartZone  runat="server"  FrameType="None"  ID="Main"  Title="loc:Main" 

2:                     Visible="true"> 

3:                     <ZoneTemplate> 

4:                     </ZoneTemplate> 

5:                 </WebPartPages:WebPartZone> 

6: 

7:                 <!-- ikarstein: Insert such a structure for each field you want to show on you page --> 

8:                 <table  border="0"  width="100%"> 

9:                     <tr> 

10:                         <td  class="ms-toolbar"  nowrap="nowrap"> 

11:                             <SharePoint:FormToolBar  runat="server"  ControlMode="New"  /> 

12:                         </td> 

13:                     </tr> 

14:                     <tr> 

15:                         <td> 

16:                             <span  id="part1">  <!-- ikarstein: This line is important for "Attachments" --> 

17:                                 <table  border="0"  cellspacing="0"  width="100%"> 

18:                                     <!-- ikarstein: Insert such a table row for each field / BEGIN--> 

19:                                     <tr> 

20:                                         <td  width="190px"  valign="top"  class="ms-formlabel"> 

21:                                             <h3  class="ms-standardheader"> 

22:                                                 <nobr> Title<span  class="ms-formvalidation">  *</span></nobr> 

23:                                             </h3> 

24:                                         </td> 

25:                                         <td  width="400px"  valign="top"  class="ms-formbody"> 

26:                                             <SharePoint:FormField  runat="server"  ID="field_Title"  ControlMode="New"  FieldName="Title"  /> 

27:                                             <SharePoint:FieldDescription  runat="server"  ID="field_Title_Description"  FieldName="Title" 

28:                                                 ControlMode="New"  /> 

29:                                         </td> 

30:                                     </tr> 

31:                                     <!-- karstein: END --> 

32:                                     <tr> 

33:                                         <td  width="190px"  valign="top"  class="ms-formlabel"> 

34:                                             <h3  class="ms-standardheader"> 

35:                                                 <nobr> Body</nobr> 

36:                                             </h3> 

37:                                         </td> 

38:                                         <td  width="400px"  valign="top"  class="ms-formbody"> 

39:                                             <SharePoint:FormField  runat="server"  ID="field_Body"  ControlMode="New"  FieldName="Body"  /> 

40:                                             <SharePoint:FieldDescription  runat="server"  ID="field_Body_Description"  FieldName="Body" 

41:                                                 ControlMode="New"  /> 

42:                                         </td> 

43:                                     </tr> 

44:                                     <tr> 

45:                                         <td  width="190px"  valign="top"  class="ms-formlabel"> 

46:                                             <h3  class="ms-standardheader"> 

47:                                                 <nobr> Expires</nobr> 

48:                                             </h3> 

49:                                         </td> 

50:                                         <td  width="400px"  valign="top"  class="ms-formbody"> 

51:                                             <SharePoint:FormField  runat="server"  ID="field_Expires"  ControlMode="New"  FieldName="Expires"  /> 

52:                                             <SharePoint:FieldDescription  runat="server"  ID="field_Expires_Description"  FieldName="Expires" 

53:                                                 ControlMode="New"  /> 

54:                                         </td> 

55:                                     </tr> 

56:                                     <!-- ikarstein: optionally add this table row / BEGIN --> 

57:                                     <tr  id="idAttachmentsRow"> 

58:                                         <td  nowrap="true"  valign="top"  class="ms-formlabel"  width="20%"> 

59:                                             <SharePoint:FieldLabel  ControlMode="New"  FieldName="Attachments"  runat="server"  /> 

60:                                         </td> 

61:                                         <td  valign="top"  class="ms-formbody"  width="80%"> 

62:                                             <SharePoint:FormField  runat="server"  ID="AttachmentsField"  ControlMode="New"  FieldName="Attachments"  /> 

63:                                             <script  language="javascript"  type="text/javascript"> 

64:                                               var  elm = document.getElementById("idAttachmentsTable" );

65:                                               if  (elm == null  || elm.rows.length == 0)

66:                                                 document.getElementById("idAttachmentsRow" ).style.display=< span> ;

67:                                             </script> 

68:                                         </td> 

69:                                     </tr> 

70:                                     <!-- ikarstein: END --> 

71: 

72:                                     <!-- ikarstein: Add this table for "Save" and "Cancel" buttons / BEGIN --> 

73:                                     <table  width="100%"  border="0"  cellspacing="0"> 

74:                                         <tr> 

75:                                             <td  width="99%"  class="ms-toolbar"  nowrap="nowrap"> 

76:                                                 <img  src="/_layouts/images/blank.gif"  width="1"  height="18"  /> 

77:                                             </td> 

78:                                             <td  class="ms-toolbar"  nowrap="nowrap"> 

79:                                                 <SharePoint:SaveButton  runat="server"  ControlMode="New"  ID="savebutton"  /> 

80:                                             </td> 

81:                                             <td  class="ms-separator"> 

82:                                             </td> 

83:                                             <td  class="ms-toolbar"  nowrap="nowrap"  align="right"> 

84:                                                 <SharePoint:GoBackButton  runat="server"  ControlMode="New"  ID="gobackbutton"  /> 

85:                                             </td> 

86:                                         </tr> 

87:                                     </table> 

88:                                     <!-- ikarstein: END --> 

89:                             </span> 

90:                             <SharePoint:AttachmentUpload  runat="server"  ControlMode="New"  /> 

91:                             <SharePoint:ItemHiddenVersion  runat="server"  ControlMode="New"  /> 

92:                         </td> 

93:                     </tr> 

94:                 </table> 

95: 

96: 

(You see my comments inline ?! Not much, I know…)

Behind  the “<WebPartZone>” tag add the HTML code.

You can add input fields by using this snipped:

1:                                     <!-- ikarstein: Insert such a table row for each field / BEGIN--> 

2:                                     <tr> 

3:                                         <td  width="190px"  valign="top"  class="ms-formlabel"> 

4:                                             <h3  class="ms-standardheader"> 

5:                                                 <nobr> Title<span  class="ms-formvalidation">  *</span></nobr> 

6:                                             </h3> 

7:                                         </td> 

8:                                         <td  width="400px"  valign="top"  class="ms-formbody"> 

9:                                             <SharePoint:FormField  runat="server"  ID="field_Title"  ControlMode="New"  FieldName="Title"  /> 

10:                                             <SharePoint:FieldDescription  runat="server"  ID="field_Title_Description"  FieldName="Title" 

11:                                                 ControlMode="New"  /> 

12:                                         </td> 

13:                                     </tr> 

14:                                     <!-- karstein: END -->

15: 

Of course you can change the page design. You only need the tag “<SharePoint:FormField>”, optionally “<SharePoint:FieldDescription>”. In every case the “FieldName” Attribute represents the List field the input field is connected with.

You do not need to create any Code Behind!

Just add "<SharePoint:GoBackupButton>” for cancel and “<SharePoint:SaveButton>” for submit.

Furthermore you have some controls for adding attachments to your List item.

AND: It’s the same for “Edit” list form. You only need to change the attributes “ControlMode” to “Edit”… Totally easy, isn’t it?

4. Deploy it and have a look…

Mount-SPContentDatabase : Exception of type 'Microsoft.SharePoint.Upgrade.SPUpgradeException' was thrown.
At D:TempAttach_OldContentDBs_DoIt.ps1:63 char:28
+              Mount-SPContentDatabase <<<<  -WebApplication $webapp -Name $thisdb
    + CategoryInfo          : InvalidData: (Microsoft.Share...ContentDatabase:SPCmdletMountContentDatabase) [Mount-SPContentDatabase], SPUpg
   radeException
    + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletMountContentDatabase

Have a look into the SQL Server Management Studio. – The content database is read only. That’s the problem

I had to migrate a MOSS 2007 farm to SharePoint 2010. – After migration the SharePoint Help did not work. (It’s the button upper right on a SharePoint site.)

A popup window appeared and I got an empty site with the message “Help not available” (or something like that: It was a german site so the error message was german…)

I tried a new created web application with a Team Site collection. There the help does work as expected.

Then I had a look into the Windows Event Log. There I found a related error. The web application pool account of my migrated web application did not has access to the Admin Content database. But the application pool account of the new created web application was enabled to access this database. – After adding the application pool account of my migrated web application as “db_owner” the help was shown as expected.

(I have no screenshots of that. Sorry. But I think, that can be reproduced easily by removing the application pool account from the Admin Content database.)

Today I got this error:

(“The server could not complete your request. For more specific information, click the Details button.”)

I clicked the “Details” button as commanded.

(“Below is the message that the server returned. For more information, contact your Internet service provider or web server administrator.”)

I asked myself (because I’m the web server administrator in this case) – I had no answer for me.

I clicked: “OK” and “OK” and got:

(‘An error occurred while trying to fetch data from your SharePoint site. Unexpected response from the server. The content type type of the response is “” This status code is “OK”.’)

“OK”??????????? Okay…

…

I read the event viewer log:

WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/64923656
 Exception: System.ServiceModel.ServiceActivationException: The service '/_vti_bin/client.svc' cannot be activated due to an exception during compilation.  The exception message is: Security settings for this service require Windows Authentication but it is not enabled for the IIS application that hosts this service.. ---> System.NotSupportedException: Security settings for this service require Windows Authentication but it is not enabled for the IIS application that hosts this service.
   at System.ServiceModel.Channels.HttpChannelListener.ApplyHostedContext(VirtualPathExtension virtualPathExtension, Boolean isMetadataListener)
   at System.ServiceModel.Channels.HttpTransportBindingElement.BuildChannelListener[TChannel](BindingContext context)
   at System.ServiceModel.Channels.BindingContext.BuildInnerChannelListener[TChannel]()
   at System.ServiceModel.Channels.MessageEncodingBindingElement.InternalBuildChannelListener[TChannel](BindingContext context)
   at System.ServiceModel.Channels.WebMessageEncodingBindingElement.BuildChannelListener[TChannel](BindingContext context)
   at System.ServiceModel.Channels.BindingContext.BuildInnerChannelListener[TChannel]()
   at System.ServiceModel.Channels.Binding.BuildChannelListener[TChannel](Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, BindingParameterCollection parameters)
   at System.ServiceModel.Description.DispatcherBuilder.MaybeCreateListener(Boolean actuallyCreate, Type[] supportedChannels, Binding binding, BindingParameterCollection parameters, Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, ServiceThrottle throttle, IChannelListener& result, Boolean supportContextSession)
   at System.ServiceModel.Description.DispatcherBuilder.BuildChannelListener(StuffPerListenUriInfo stuff, ServiceHostBase serviceHost, Uri listenUri, ListenUriMode listenUriMode, Boolean supportContextSession, IChannelListener& result)
   at System.ServiceModel.Description.DispatcherBuilder.InitializeServiceHost(ServiceDescription description, ServiceHostBase serviceHost)
   at System.ServiceModel.ServiceHostBase.InitializeRuntime()
   at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)
 Process Name: w3wp
 Process ID: 7248

…………….. It was my mistake. ………………………….

An hour before I configured my SharePoint Site to use KERBEROS. – In the IIS I configured the Web application “Authentication” settings: I choose the provider “Negotiate” but I also removed “NTLM”. This was my fault.

This is the correct setting:

… on the SharePoint 2010 with german system language of my customer the message text was “Fehler bei PowerPoint Web App. Wiederholen Sie den Vorgang.”

In the SharePoint log I found this lines:

First: “Could not find default ServiceProxy or it does not implement IWacServiceApplicationProxy”

Second: “Unhandled exception caught when executing web method handler: System.NullReferenceException”

The Solution:

There was a missing setting for the Service Application Default Proxy Group

Go to: Central Administration –> Application Management –> Configure service application association  ==> click the link (e.g. “default”) in column “Application Proxy Group” of your web application.

You should see something like that:

Check the missing proxy. Click OK. That’s it…

Today I got this error while opening a Word document stored in a SharePoint library. This document should be opened in the Word Web App. – IT WAS A DOCUMENT IN A MIGRATED CONTENT DATABASE…

(“Word Web App cannot open this document for viewing because of an unexpected error. To view this document, open it in Microsoft Word.”)

I looked into SharePoint log and found this error message:

(“Requesting item that was not generated”)

Then I looked into Windows Event Viewer and found this critical error event:

(“SQL Database ‘…’ on SQL Server instance ‘…’ not found. Aditional error information from SQL Server is included below.” … Followed by some messages in german (because the SQL Servers language is german)… “Fehler bei der Anmeldung” which means: “Access Denied”

Solution:

The Service Account of the SharePoint Web Services System needs “db_owner” rights on the migrated content databases!!! (You see this account in the event log message!!!)