04 April, 2014

The site template requires that the Feature be installed in the farm


I was facing one issue while creating a new site from site template in our customer environment. This site was created in our local environment and I saved it as a template.

Below is the screenshot for the error what customer are facing.

After investigating with this feature id, I found that, there is a hidden feature named “WACustomReports” at site collection label, that need to be deactivated before saving the site as template.

Error Message: The site template requires that the Feature be installed in the farm or site collection. Troubleshoot issues with Microsoft SharePoint Foundation.

Resolution is very simple:
Please activate this feature "Web Analytics Customize Reports functionality" on the root site where you are trying to create the site based on this template. Here is the exact name - WACustomReports

OR Here is the command to activate that feature (Any feature which is missing): Enable-SPFEATURE WACustomReports –URL http://sitecollectionURL

But here is the END USER reply that I received from the end user:
“In our environment, we don’t have any access. We are only sharing the templates with instructions. Client is having only Site Collection Admin rights, not central admin rights. That’s why I deactivated this HIDDEN feature from our dev environment. Took a backup and will share with customer today.”

So bottom line: No direct access to do these things which has suggested above.

So what’s the next action plan?

Here is the resolution for this-

- Save the wsp to your desktop

- Renamed it to the .CAB file

- Extract the contents

- You will see four folders underneath ( adminListInstances, adminModules, adminPropertyBags and adminWebTemplate)

- Go for adminWebTemplate

- Go inside the "admin" folder

- You will see "ONET.XML"

- Edit with notepad

- Control F and search for WACustomReports (please refer the following screenshot) to get more clarity
- remove the lines which are for the above feature

- Save the notepad.

- Repackage the files again and save as .WSP

How to repackage it? Here are the steps:
1.   Rename WSP file to CAB and extract all the files
2.   Modify the necessary files
3.   Rebuild the correct directory structure for the solution
4.   Copy the files into that directory structure (in the right place)
5.   Create a DDF file indicating name and location of all files to be in WSP file
6.   Run MakeCab using created DDF file to create cab, and then rename cab to WSP

Reference of MakeCab:

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

If you find a different solution, please report it as a comment to this post. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.

SharePoint Timer Service Delays

Timer job plays a very vital role in the SharePoint environment as so many task’s, jobs, schedules as well as workflows are depend on it.

Bottom line (important one):
1.    Clearing the timer job history
2.    Recycling the timer service
3.    Workflows

Microsoft SharePoint Server 2010 uses the Windows SharePoint Services Timer V4 (SPTimerV4) service to run most system tasks.

How you will conclude that the timer jobs are not working as expected?
Here is the list:
o   Alerts are not working
o   Workflow: either not running / taking a long time to update
o   Updates to the farm configuration are not synchronized to the local server.

Make sure / Resolution:
a)   Start-> Run -> services.msc -> will open the services console.
b)   Press ‘S’ in the list of services and it will show you the list of SharePoint Services
c)    Right click on ‘SharePoint Timer Service” and Restart it.

d)   Ensure- it gets started successfully. If not then use the following way

e)   Start ->Run- >cmd ->it will open the console window -> net start sptimerv4

f)     If the service does not start, ensure the following parameters are correct:

g)    It should be a domain user account and is a member of the following:
·         dbcreator fixed SQL Server role
·         securityadmin fixed SQL Server role
·         db_owner fixed database role for all databases in the server farm

h)   If the account has sufficient permissions, confirm the password by typing the password for the account, retyping the password in the Confirm password box, and then clicking OK.

If the workflows are taking long time to complete then please change the frequency:
stsadm -o setproperty -propertyname "job-workflow" -propertyvalue "every 1 minutes between 0 and 59" -url http://webapplication
For more information, please see http://technet.microsoft.com/en-us/library/cc424970.aspx. The default value is "every 5 minutes between 0 and 59"
If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

29 March, 2014

Design and Publish the Infopath form - SharePoint 2010 / SharePoint 2013

InfoPath Form Designer: 
Software application for Designing, distributing, submitting and filling the form which contains hierarchical tree view of folders and data fields. It is used to create and save the information on a web server when hosted on SharePoint.

Create a Blank Form : InfoPath Designer -> File -> New -> Blank Form.
E.g. SharePoint Site Request Form




Add 3 Sections in the Blank Form Field -> Get Sections option from the Control Tool Properties

Insert 3 Separate tables from the INSERT (Navigation Tool bar) option to the sections




Populate the required label name and assign the necessary control field to the labels from the Control Tool Properties.



Right Click on the Filed Properties -> Assign Unique name for Separate field.
For People/Group Picker field Properties -> Specify a SharePoint Site to query for People and Groups.



For the Date/Time Filed, Insert Formula as today() (on Insert Function option) -> It will display today’s date on the form.



For every Drop-Down List type Controls -> Specify the needed Choice value on the Property box.

Don’t forget to click on “Cannot be blank” option which means this field in the form should be filled up with the values.

E.g. 1: Location: Asia, Europe…



E.g. 2: Site Template: Blank, Team…..




Add Button Option in the Form for Submit the Request



Create New Rule for the Submit Button -> Rule Type: Action -> Run these action: Add -> Submit data



Add New Data Connection to submit the form: Click on Submit Data to document Library on SP Site



Specify the Document Library name and File name for the Data.


Publish the Form to a Document Library




Click on File -> Publish -> SharePoint Server -> Publishing Wizard will open
Specify the Location of SharePoint Site



Click on “Enable this form to be filled out by using a browser”



Click on the Radio button for “Document Library” to publish the form as a template in a document library.

On this step, create a new document library or Update the form template in an existing document library based on the need.



Click on Next and in the final dialog box; verify the Form information and Publish.

 By using Design Option in the InfoPath Designer, Design your Form as like this!!!!!

27 March, 2014

This website has been configured to disallow editing with SharePoint Designer

Issue Description : When i tried to open a site in sharepoint designer , it throws a below error.

Error message : "This website has been configured to disallow editing with SharePoint Designer"

Resolution:

1.Go to Central administration
2.Application Management Ã  Manage WebApplication 
3.Select the web application having issue.
4.In the Ribbon, Click on General Setting Ã  Sharepoint Designer Settings 
5.Check "Enable Sharepoint Designer" .

That's It . Now i am able to open the Site in designer.

26 March, 2014

Sign in as different user in SharePoint Designer 2010 / 2013

Sign in as different user is always useful whenever we are doing any troubleshooting any access, custom functionality, extracting the databases etc…

When we open the site in browser mode then sign in as different user is always easy to switch as well as use but in terms of designer it’s difficult to find out the option. While working on some requirements, i came across this problem and took some time to figure out this tweak but finally got it!

Please refer the following steps as well as screenshots to find out where is this option:

1)   Open your site in SharePoint designer (designer 2010/ 2013)
2)   Bottom of the task in SPD, you will find this small icon – please refer the following screenshot.

3)   If you click on it then it will show you the ‘logged in user name”

 
4)   If you want to ‘sign in as different user’ then click OK.
5)   As soon as you will click OK, it will give you the username and password window.
6)   Enter the username and password (domain\username)
7)   Hit OK.

That’s it – you are done!

If you have any queries/questions regarding the mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.