"The form cannot be rendered. State Service" SharePoint 2016

"The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator. "

I got this message after trying to open infopath form on a SharePoint 2016 list ,
the solution that worked with me is the following :.

• Launch the “Farm Configuration Wizard” from central Administration
• 
  

Note: Use SharePoint farm account to run the wizard which should have db creator role.

• On the next page “Services” – Create  a new Application Pool / Choose an existing one.
• On this page you will find that the services already enabled are grayed out. You will find that “State Service” is not grayed out but automatically checked. In this page all services that are not yet enabled will be selected – make sure you unchecked the ones that you don’t need.
• Click “Next”. On the next Page – click “Skip”
• In the following page click “Finish”. This completes the activation.
You will be able to create new item on InfoPath list/ Library now.

Please comment if worked with you to be useful for others 

Download Task Rollup Webpart sp 2010

 TaskList Roll-up Webpart sp 2010

This is not mine ... but its free and published .. enjoy


https://docs.google.com/file/d/0B4BDWrvkAiUyaFJSb0RTRTVTSFE/edit?usp=sharing


ENJOY!!

How to upload and install sp 2010 template

How to upload and install sp 2010 template ? 

1- Get your wsp file

2-Go to site collection setting >> Galleries >> Solutions



3-Browse and upload your file
 


4-Click activate!

 

5-click on site actions >> new site >> you will find the template there just click create

-----------------------------------------

Here is a useful link for many templates you may use

http://www.techsolutions.net/SharePointSolutions.aspx

I wish it was easy and helpful!

Installing SharePoint 2010 in Windows 7 (64 bit)

1)      Install the following update.
2)      Extract the installation files from the setup using command d:\Software\SharePoint10\SharePointServer /extract:d\SharePointServerFiles. In my case source directory is d:\Software\SharePoint10 and target directory is d:\ SharePointServerFiles.
3)      In the target directory find the config.xml a following d:\ SharePointServerFiles \files\Setup\ and add the following line of text in configuration node <Setting Id=”AllowWindowsClientInstall” Value=”True”/>. Now your configuration file would be something like below:

01	<Configuration>

02	<Package Id="sts">

03	<Setting Id="LAUNCHEDFROMSETUPSTS" Value="Yes"/>

04	</Package>

05	<DATADIR Value="%CommonProgramFiles%\Microsoft Shared\Web ServerExtensions\14\Data" />

06	<Package Id="spswfe">

07	<Setting Id="SETUPCALLED" Value="1"/>

08	</Package>

09

10	<Logging Type="verbose" Path="%temp%" Template="SharePoint Server Setup(*).log"/>

11	<!--<PIDKEY Value="Enter Product Key Here" />-->

12	<Setting Id="SERVERROLE" Value="SINGLESERVER"/>

13	<Setting Id="USINGUIINSTALLMODE" Value="1"/>

14	<Setting Id="SETUPTYPE" Value="CLEAN_INSTALL"/>

15	<Setting Id="SETUP_REBOOT" Value="Never"/>

16	<Setting Id="AllowWindowsClientInstall" Value="True"/>

17	</Configuration>

4)      Now, it is the time to install the prerequisite installer files.  First install filter pack in the path d:\ SharePointServerFiles \PrerequisiteInstallerFiles\FilterPack\ FilterPack.msi.  Now install following components:

1. Microsoft Sync Framework
2. SQL Server Native Client
3. Windows Identity Foundation (Windows6.1-KB974405-x64.msu)

If you have Visual Studio 2010 installed in your machine then you may not have to install previous two components.
5)      Now, turn on the windows features for IIS for the components as shown in figure (AT LEAST, please). Type ‘optionalfeatures’ in run and enter to open windows features.

Fig continue:
6)      Now run setup.exe from ‘d:\ SharePointServerFiles’ to get installation wizard and choose Standalone installation to install all on one developer workstation.

7)      After the end of installation you need to run the configuration wizard. But before that you need to install some hotfix for SQL Server. Install SQL Server 2008 KB 970315 x64. You need to request the hotfix and Microsoft will send you in email the link and password that required for extraction. Note that you must install this hotfix to avoid the exception while configuration wizard is creating configuration database.
8)      Now, you can run your configuration wizard to configure SharePoint in your machine. Don’t panic; it takes time. Good luck.

Issues
1. I can open the Central Administrator site but links are not enabled in Central Administration -> Application Management -> Manage Web Applications. You cannot create new web application and extend existing one.
Sol: Make sure you have Windows Identity Foundation installed. Get it from here.  Now do not directly open the central admin site but first open Internet Explorer as administrator and open central admin page. Now, if still it is not working, you would like to use 64-bit IE (Same happened in my case). Furthermore, you can disable UAC to enable link but it is not good practice to disable UAC just for SharePoint.
2. Exception in Database Configuration step:  An exception oftype Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly ‘System.Web.DataVisualition, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.
Sol: The reason of this exception is the configuration doesn’t find the Chart Controls. Download it and install and re-run the configuration.

Hiding the Site Actions button (SP 2010)

Hiding the Site Actions button on Public Facing SharePoint Foundation (or Server) sites:

Open up SharePoint Designer

Open the Master Page being utilized for your sites

Locate the following snippet of code:

<span class="ms-siteactionsmenu" id="siteactiontd">

Add:

<SharePoint:SPSecurityTrimmedControl runat="server" Permissions="ManageSubWebs">

just before the line of code in 3.

Right click on the tag in step 3 and click on Select Tag.

Enter this after the span tag: </SharePoint:SPSecurityTrimmedControl>.

Save the Master Page.

Approve and publish if required

Chart Web Part SharePoint 2010

CHART WEB PART SP 2010

Categories:Charts and Graphs; Out of the Box; Site Manager/Power User; MOSS; WSS; 2007; 2010

So you want to use an out of the box SharePoint pie chart to tell you how many list items have a certain status (or other column choice)?

So you want to use an out of the box (OOB) SharePoint pie chart to tell you how many list items have a certain status (or other column choice)? Trying to add that web part to a page and setting its target list as the list you want will not work. Many 3rd party tools exist to deal with this exact limitation of the OOB charting web part.
The good news is that in SharePoint 2010 there is an easy way to get this data graphed with the OOB pie chart using a little known trick. For this example I will show you how to set up a Task list where you want to show the Status field count values in a pie chart.

Step 1

Create a custom list called StatusLookUp and add an item for each status you want to have. The items in the list will be used as statuses in the “Status” column via a lookup column.

Step 2

Create the list you want to use to track your tasks, for this example I am calling it ProjectStatus. If you already have a list this will work as well, you will need to migrate your status column data though. After you have your list setup, create a column called StatusLookup. It will be a Lookup column type and you will use the StatusLookUp list as your input. After creating this column you will need to migrate your current Status column data to this column if you already have a list, if not create a few test items and set their status using this column.
This will be a small burden to migrate the statuses of each item but well worth it. I recommend doing it programatically via .Net as a console app or ASPX page. The code for that will simply loop through your list and set the new column data as the current column data with the exception that you will need to format that data to fit into a lookup field type.

This is my basic list with 4 projects that I am tracking and what the status is of each. Note that the StatusLookup field is a lookup of the StatusLookUp list and not the OOB Status field.

Step 3

Create a new Lookup column in your StatusLookup list. Call the column Count and reference the column that you just created in your ProjectStatus list. Be sure the column contains “(Count Related)” in the name. Now that you have created your new Status field in your list and migrated the data over, go back to your original StatusLookup list and create a new column that is a lookup of the column that you just created as a lookup to this list. It sounds like a crazy loop but when you do this it returns a count of the number of occurrences instead of the same data.

Step 4

Add the chart web part to the page and connect it to your Status Lookup list. Set the Count as your Y axis and the Title as your X axis. Finally, customize your chart to be a pie graph and set your data to display as you wish. Viola! Since this post is about the data and not really about the pie chart I skimmed this part but trust me, you can totally just add the web part and walk through the setup wizard and get the data you need.

InfoPath - Get the current user without writing code

InfoPath - Get the current user without writing code

* This works at InfoPath as well as InfoPath Forms Services.

1. With InfoPath opened go to Tools > Data Connections, and click 'add...' to add a new data connection to the form. This opens up the Data Connection Wizard.
2. We want to receive data from the WS about the current user, so choose receive data' and click next.
3. Our data source is a WS so choose 'Web Service' and next.
4. Now you will have to point the wizard to the WS. Type an address similar to this: http://ServerName/_vti_bin/UserProfileService.asmx  and click next.
5. Here you get a list of all methods for that WS, choose GetUserProfileByName and click next.
6. In this screen you can specify what parameters are sent to the method, we are relying on the method's ability to return the current user name if no value is passed to it, so we will leave this as is (no value is passed to the method) and click next.
7. Click next and make sure 'Automatically retrieve data when form is opened' is checked.
8. Finish the wizard.

1. Add a textbox to the form.
2. Go to the first textbox's properties (double click it).
3. In the 'Default Value' part, click the 'fx' button next to the 'Value' field. this opens up the formula builder dialog.
   
   
   
4. Click 'Insert field or group'.
   
   
   
5. In the data sources drop down, choose the GetUserProfileByName data source.
6. Expand all groups under the 'dataFields' group, and choose the 'value' field. Don't click OK yet!
   
   
   
7. With data 'value' field selected, click the 'Filter Data...' button and 'Add...'.
8. In the first drop down (value) select 'Select a field or group...' and choose the 'Name' field under the 'PropertyData' group.
   
   
   
   
   
9. Leave the middle drop down as is ('is equal to') and in the last drop down choose 'type a text...'.
   
   
   
10. This is the part where you specify which property to put in the textbox. As we said the method returns multiple properties about the user. For this textbox we want to put the user's first name in, so type 'FirstName' (this is case sensitive!). I have included the property list you can use here (just below), so if you want some other property, just type its name instead.
11. That's it, all we have to do is to confirm everything so Click 'OK' for every open dialog box until you are back in the design mode.
12. click 'Preview' and see the wonder!
13. If you want more details repeat steps 1-11 and enter different property names in step 10.

 here is the complete list of default profile properties get returned by the userprofileservice. I think they are pretty self explained:
UserProfile_GUID
AccountName
FirstName
LastName
PreferredName
WorkPhone
Office
Department
Title
Manager
AboutMe
PersonalSpace
PictureURL
UserName
QuickLinks
WebSite
PublicSiteRedirect
SPS-Dotted-line
SPS-Peers
SPS-Responsibility
SPS-Skills
SPS-PastProjects
SPS-Interests
SPS-School
SPS-SipAddress
SPS-Birthday
SPS-MySiteUpgrade
SPS-DontSuggestList
SPS-ProxyAddresses
SPS-HireDate
SPS-LastColleagueAdded
SPS-OWAUrl
SPS-ResourceAccountName
SPS-MasterAccountName
Assistant
WorkEmail
CellPhone
Fax
HomePhone