Category: SharePoint

We recieve this error while trying to edit ContentByQueryWebPart.

The reason for this error is because the publishing features are not enabled for the site.

So we need to enable the publishing features.

For this first activate Office Sharepoint Server Publishing Infrastructure feature found at

Site Collection Administration – Site Collection Features.

Than enable Office Sharepoint Server Publishing feature at Site Administration- Site features

Bye

I got this error while trying to perform a backup within backup and restore inside operations of Central Administration site.

I checked services on server within operations and it was showing that all the services had started, but on checking at services.msc i found out that the following service hadn’t started

Office SharePoint Server Search, after starting this service, the error got resolved.

Find more information over here

http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/dc1db06b-ac78-4547-b28d-a0d1efab3b80

Bye

We wanted to have created column value in the excel sheet for our survey responses. We modified the existing view to include the created column and then selected the option of Export to SpreadSheet. But it was not including the created column.

 

So the solution for this was to

 

Select All Responses View than

Site Actions – Edit Page – Modify the shared web part – Edit the current view – Than selecting the created column and copying the url of that page

 

http://servername:12345/_layouts/viewedit.aspx?List=%7B545889CC%2D1BE0%2D463D%2DBAA2%2D6DBEC360BA68%7D&View=%7B107DCB6B%2D83D8%2D439C%2D8996%2DF1B7782C8062%7D&Source=http%3A%2F%2Fd%2D1246%3A12345%2FLists%2FDemoSurvey%2FAllItems%2Easpx%3FPageView%3DShared

 

Get the id of the view

%7B107DCB6B%2D83D8%2D439C%2D8996%2DF1B7782C8062%7D

Which is

107DCB6B-83D8-439C-8996-F1B7782C8062

 

%7B is equal to {

%7D is equal to }

%2D is equal to –

 

Go back to survey, click on Action – Export to spreadsheet – Save the query to your machine and make the following changes in the query

 

WEB1

http://d-1246:12345/_vti_bin/owssvr.dll?

XMLDATA=1

&List={545889CC-1BE0-463D-BAA2-6DBEC360BA68}

&View={ED178AE0-E856-47FD-AB02-E1566F30E400}

&RowLimit=0&RootFolder=%2fLists%2fDemoSurvey

Selection={545889CC-1BE0-463D-BAA2-6DBEC360BA68}-{ED178AE0-E856-47FD-AB02-E1566F30E400}

EditWebPage=

Formatting=None

PreFormattedTextToColumns=True

ConsecutiveDelimitersAsOne=True

SingleBlockTextImport=False

DisableDateRecognition=False

DisableRedirections=False

SharePointApplication=http://d-1246:12345/_vti_bin

SharePointListView={ED178AE0-E856-47FD-AB02-E1566F30E400}

SharePointListName={545889CC-1BE0-463D-BAA2-6DBEC360BA68}

RootFolder=/Lists/DemoSurvey

 

 

Replace the above value with the value of your view i.e. 107DCB6B-83D8-439C-8996-F1B7782C8062.

 

Now when you will open this query it will show all the columns specified by you in the view.

 

Another option could be to use Data View web part for it and adding the required column to it through sharepoint designer. And than right clicking on it and selecting Export to Microsoft Excel from the context menu of the IE.

 

Bye

For other lists within sharepoint we have an option of
creating our own custom views.

(Settings-CreateView).

However we have no such option in case of Survey. To create
our own custom view in case of survey we can do the following

First get the id of your survey. For this select view source
of the following page

http://servername:12345/Lists/DemoSurvey/overview.aspx
of your survey.

You can get the id of the survey at following line

href=”/_layouts/listfeed.aspx?List=545889cc%2D1be0%2D463d%2Dbaa2%2D6dbec360ba68″

The id of the survey list is – 545889cc%2D1be0%2D463d%2Dbaa2%2D6dbec360ba68

Or

545889cc-1be0-463d-baa2-6dbec360ba68

%2D is equal to –

Now we need the url where in we
will use the above list id for creating custom view

For this create a simple IssueTracking
list or any other list for which we have an option of creating custom view.

Now select setting–>create
view for that newly created list

Copy the url

http://servername:12345/_layouts/ViewType.aspx?List==%7B59C5C613%2D11FB%2D44D8%2DB29E%2DC973006C062A%7D&Source=http%3A%2F%2Fd%2D1246%3A12345%2FLists%2FDemo%2520tasks%2FAllItems%2Easpx

Get this much part of the url

http://servername:12345/_layouts/ViewType.aspx?List==%7B59C5C613%2D11FB%2D44D8%2DB29E%2DC973006C062A%7D

%7B is equal to {

%7D is equal to }

Modify it in the following manner

http://servername:12345/_layouts/ViewType.aspx?List={545889cc%2D1be0%2D463d%2Dbaa2%2D6dbec360ba68}

or

http:// servername:12345:12345/_layouts/ViewType.aspx?List={545889cc-1be0-463d%2Dbaa2-6dbec360ba68}

i.e replace the list id.

Now you should be able to create your own custom views on surveys

I was getting this error while trying to build a report ( using sql server reporting services) using xml as a data source against Lists web service of SharePoint.

I was making use of GetListItems method of the Lists web service.

Finally the error was fixed by using Fiddler(web debugging tool) within which we easily view the request and responses sent back and forth.

http://www.fiddlertool.com/fiddler/

Using it I checked the soap request being passed to the web service and was able to correct the error.

For using the web service (Lists) I followed the following steps.

Selected Data Source type as XML

Connection String as the url of the web service

http://servername/_vti_bin/lists.asmx

And the following query

<Query>

<Method Namespace=“http://schemas.microsoft.com/sharepoint/soap/“ Name=“GetListItems“>

<Parameters>

<Parameter Name=“listName“>

<DefaultValue>Employee Satisfaction Survey</DefaultValue>

</Parameter>

</Parameters>

</Method>

<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>

</Query>

Bye..

 

Hi,

To specify connection string with user id and password we need to have the following things in the application defination file (.xml)

<?xml version=“1.0“?>

<LobSystem xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance“ xmlns:schemaLocation=“http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD“ Type=“Database“ Version=“1.0.0.0“ Name=“NorthwindLOBSystem“ xmlns=“http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog“>

<Properties>

<Property Name=“WildcardCharacter“ Type=“System.String“>%</Property>

</Properties>

<LobSystemInstances>

<LobSystemInstance Name=“NorthwindInstance“>

<Properties>

<Property Name=“DatabaseAccessProvider“ Type=“System.String“>SqlServer</Property>

<Property Name=“AuthenticationMode“ Type=“System.String“>PassThrough</Property>

<Property Name=“RdbConnection Data Source“ Type=“System.String“>d-2926</Property>

<Property Name=“RdbConnection Integrated Security“ Type=“System.String“ />

<Property Name=“RdbConnection Initial Catalog“ Type=“System.String“>Northwind</Property>

<Property Name=“RdbConnection User ID“ Type=“System.String“>sa</Property>

<Property Name=“RdbConnection Password“ Type=“System.String“>sa</Property>

<Property Name=“RdbConnection Pooling“ Type=“System.String“>false</Property>

</Properties>

</LobSystemInstance>

</LobSystemInstances>

<Entities>

We need not to specify any value for Integrated Security as we are using sql authentication

And can specify user id and password with RdbConnection User ID and Password Property.

Bye…