Uncategorized

Last Day @ NBAD- Tweeeted


Sometime you sense very dissimilar like you oversight something in your life. Same feeling I am having due to my last day at NBAD. Aimed at short period of time I encountered a team which has good strength and outstanding technical communication.

A team with calm and diminish observance. I will never forget this miles stone in my life, even though I have been a slice of numerous professional team but occupied with this team like additional  work without knowing that you are burdened  

Standard
Uncategorized

UPS Synchronization Service- SharePoint Server 2016, Microsoft Identity Manager?


Recently I configured SharePoint 2016 Review release to have a deep look at the new changes contrary to 2013. During configuring user profile services I dint find User profile service Synchronization in services on server only user profile services, I checked the FIM has been removed in favor of Microsoft Identity Manager.

ups1

 

 

MIM is a separate server technology (not built-in to SharePoint Server). That means, if you have MIM running in your company, more than one SharePoint Server 2016 farm can rely upon it.

Active Directory Import (sometimes called Active Directory Direct Import) is also included with SharePoint Server 2016, and is a User Profile Synchronization alternative that will not need a separate server installation. This means that SharePoint Server 2016 offers two options for User Profile Sync.

ups2

ups2

 

Source : https://technet.microsoft.com/en-us/library/mt627723(v=office.16).aspx

 

Standard
5000 Threshold, CSOM, Javascript Object Model SharePoint, SharePoint 2013, SharePoint List Lookup, Sharepoint2010, Uncategorized

Get 50000 items from SharePoint List using JS-SharePoint Item 5000 Threshold Issue [Solved] –


My blog will help to load data from SharePoint list regardless of list-view threshold limit . I have been through many forums and even I experienced bit difficulty to load data from list having record greater than limit defined by the SharePoint administrator (threshold limit). I have created a simple JS file with some functions to load data in chunks. i.e. My JS function will automatically take the total count of list and break them in the chunks and iterate them. In the result it will provide the array of items requested by the user.

Global Varaiable

Screen shot is to provide the global variable for our JS File

Initial Method to Call from my js

Initial Method to Call from my js

Internal method of JS File, This methods will take the cound of the List and divide them as 5000 each cycle

Internal method of JS File, This methods will take the cound of the List and divide them as 5000 each cycle

 

 

 

Final Methods will runs once all the data finish loading

Final Methods will runs once all the data finish loading

Just add the attached JS file to your SharePoint Solution and call the below mentioned function. In return once the data get loaded , it will write the desired array to flatArray and update var TransactionComplete = 1; further you can use flatArray with data in your app.
JS File – Click here to Download – Rename PDF to JS

Funciton to call GetListItem(siteurl,listname,columns)

siteurl = http://sitename

listname=testlist

columns=ID,Created,Title,Column1,Column2,Column4,Column5

Result = flatArray as Array

Resultant Screen shot.

ResultArray

ResultArray

 

I hope my little efforts may save time for those who are struggling with SharePoint threshold 5000 issue.

Standard
Uncategorized

Insert, Update to SharePoint List and Published InfoPath2010 Form to SharePoint Server


In this post I would like to share the combination of little efforts using Infopath 2010 forms. In this post I will Design a new InfoPath form 2010 and that form will insert into the SharePoint list by using share Point object model.

Scenario : I have Created a List name Location, having Column Title, City and ZipCode. I will be inserting in the Location List by using InfoPath Form.

First We need to Design the InfoPath Form, during this step we need to consider some important steps.Image

Before we need to add the Event handler for the button to submit the item to the SharePoint list. just right click the button, select properties.

Image

Click Edit Form Code, after click Info path will open the Visual studio 2005 , with the event of button. Once VS2010 Open we need to Add the reference of Microsoft.SharePoint dll to the project. After use the following code to insert in the SP List Image

we can Access the Fields which we defined in the Info path by Xpath of each field check the blog for more clarification..Access Info Path Field using Xpath. 

Build the VS2005 and Close after successful build. Now our InfoPath design work has been done. we need to check some more options for publishing it and attached it to the webpart.

Once we design the Form, we need to go to the Developer Tab —- > and choose Language option as mentioned in the below screen shot.

Image

here we need to set some notes which will help us to deploy the info path form easily. First option is the filler feature , i checked only the Print option. for more info regarding the info path filler feature use the this Filler Feature.

Image

Now select Security and Trust , option and marked as Full trust , below screen shot.

Image

Choose the preferred programming language, and Then select the Compatibility option. here we need to set this Info path form as web browser form and also mentioned the url of info path web service which can let it open in browser. screen shot is below.Image

Save the form, and go to file and Select Publish option. In the published option choose the SharePoint server, enter the site url, it will create and new content type and give the published version of infopath which we can save it in our local drive.

Image

Image

now after this wizard save the xsn file to your local hard drive. this .xsn we will upload and will deploy.

Image

now do the next next and published it.

Image

Now this published wizard has created a new content type in the Server and give us a publised, administrator approved template.

Note : Actually in the real world, we will design the info path form and just save it, than go to the Site Administrator, who will published it, give us a new approved template copy and create a content type on the server, because he is the administrator.

Now we need to to upload (the published .xsn file ) it on the Central Adminitration — > General Application setting –> Info Path Form Services, select Upload form template.

Browse the .xsn file which we save it on our local pc, once upload the form template , we can verify, and upload successfully.

Image

Now we need to go to the Site Collection Administration — > Site Collection Feature—-> in the feature we can have the newly uploaded info path form feature , activate it.

To check the form is ready or not, go to the  Site action –> and Select All Site content— go to the Form Template Library , in that library you will have your newly deployed info path form.

Image

Note : It is better to Create a New Content Type, and Select Parent Content Type as Microsoft InfoPath. Then newly featured Activated form deployed on the site will come in the drop down.

Creating Content Type So that it will be come to Info path webpart. Select Parent as Microsoft Infopath

Creating Content Type So that it will be come to Info path webpart. Select Parent as Microsoft Info path

Now ,we can get the name of content type of this form by select the library setting and go down and get the content type name, this content type will be required for newly document form library, which will help us to integrate this published form to info path viewer webpart.

Image

once we scroll down

now Image

now we know the content type name of this form, now we need to add new form library, and set the content type of that newly library as highlited above. thats all.

Crate new webpart page and select the info path viewer webpart. go to the edit web part and select the newly created library, and content type. Image

click ok and apply.Image

and it is working fine with me. hope my little efforts can save a lot of time of others. apology for any typo mistakes and ready for any question and discussion.

Standard
Uncategorized

Feature а1716ее3-3996-4cf8-a2d0-83c2c27ed256 for list template 10001 is not installed in this farm,


Recently I come accross one another issue 🙂 in the SharePoint 2010, which was provided to me and I solved it . When the user try to run (SPMETAL.exe) to generate proxy code for any webpart for a Linq Query , the SPMETALEXE was throwing following error.
Feature XXXXXXXXXXXXXXXXXXXX for list template 10001 is not installed in this farm.
First I tried the SPManager Tool to search the Fetaure Id, but I didnt find the feature with the ID XXXX , so this got failed without solving issue.
I download the SPFeatureAdmin Tool to remove any faulty feature but that one also not helpful in this regards.
it was seems to me that Issue in the feature itself, at the galance i thought if I remove the feture by force form the farm then the isssue will be solved, so I tried to use STSADM command to forcefully remove it.
stsadm -o uninstallfeature -id XXXXXX -force but still the same error .

14Hive_SP_Root_Logs

14Hive_SP_Root_Logs

I post my answer on the MSDN where I get some clue, I planned to Add a new custome list template with the type 1001 and tried to deployed, but still the same error.

Solution :

Remove the Feature from the Farm, through STSADM. Keep the Feature ID.

DeactivatingFeature

DeactivatingFeature

Create new SP Empty project and Create the contenttype and create a new list definition with the list templete 10001, In my case I added the one content type and make it property Overwrite=”True” because I was having content type Error as well.

Adding List Definition with the Template Type 10001

Adding List Definition with the Template Type 10001

contenty type overwrite

contenty type overwrite

by doing this we can overwrite our content type with new fields in the Farm.

In the Last Paste the feature Id in the Properties of Feature and and deploy the solution.
Replace the same feature Id in the Feature properties.

Replace the same feature Id in the Feature properties.



Note : Attempt this blog when there is no clue of feature and the feature with the solution has lost.

Standard
Uncategorized

Remove SiteColumn through GUID 2010,Remove Corrupted Site column,Field type XXXXX is not installed properly. Go to the list settings page to delete this field, SharePoint2010


Creating a wrong type in the site column for a list sometimes create a little headache. Recently I created a site column in the VS2010 where I put type of one of my Account AS Numeric .Which is not supported in the SharePoint 2010.

SiteColumn_1 with wrong Type

SiteColumn_1 with wrong Type ,

I deployed that List, and when I browse the site column in the site setting I found some exception mentioned below,

“Field type Numeric is not installed properly. Go to the list settings page to delete this field.”

FieldName with FieldId ‘57190465-529f-4dd3-bff5-5f1e3b20426b’, exception:

w3wp.exe (0x136C)        0x1888  SharePoint Foundation

I delete the list with the following Power Shall Command, and I assumed that this will solve the issue.

Stsadm -o forcedeletelist -urlhttp://WebAppName/subsitename/lists/listname

But Issue is still there, when I click on the site column I found that same error, I Google how to delete the site column from the SharePoint Power shall. And I also do not know that exact name of site column, above image of site column is just for the reference. Where it is and what is the actual state of the site column. I checked the logs and I can only see the site column GUID.

Below power shall command create one text file and shows the GUID of the entire Site Column

$web = Get-SPWeb http://win-ctk0o0jncig

$web.AvailableFields.SchemaXml | Out-File c:\Sitecolumns_.txt

Sitecolumns_.txt, will create a one text, file with all the GUIDS of  all site column, step I used to confirm the GUID of the exception and the name of site column is same or not.

I checked SharePoint Manager, SharePoint designer, that may be i can remove that site column but the same error occurred on both the SharePoint tool. The Only way I got is to remove the sitecolleciton because it was my sandbox solution, or to remove it form the content database.

For site collection SharePoint is managing a content database, more or less its also depend on your requirement. check this helpful link : Unique Content Database per SharePoint Site Collection I am going to remove the site column form the SP Content database where it is managing all the site columns.

Go to the Central Administration -> Application Management -> View All Site Collections

This will list the Site Collection and the database it resides in.

Now that you know the Database Name time to head over to the SQL Server.

Db_1_Sitecollection, Database Site collection

Db_1_Sitecollection, Database Site collection

In the mentioned Database, SharePoint is managing the content of the site collection.

SELECT * FROM [ContentDBName of Site collection ].[dbo].[ContentTypes] WHERE Definition Like ‘%GuiId of your site column%’

Delete FROM [ContentDBName of Site collection ].[dbo].[ContentTypes] WHERE Definition Like ‘%GuiId of your site column%’.

Helpful Source
Helpful Source

Standard
Uncategorized

Correlation Tokens in SharePoint 2010 Workflow [WorkFlows in Visual Studio 2010]


One of the greate feature I found in the SharePoint is the Powerfull engine for developing the Workflows by visual studio 2010. some of the greate feature I love to capture in my blog, which help me out in future to remember whenever I need any one of them. The most immense topic is corelation properties.

I used Co-releatoin property in the BizTalk Server 2006, Still I quite impress with this Microsoft methodology to integrate different line of business. In sp 2010 again I am using the co-relation property in one of my workflow.

You can consider a correlation token as a unique identifier that enables mapping between the objects in a workflow and the environment that is hosting the Windows  Workflow Foundation (WF) workflow runtime.

Useful Link : http://msdn.microsoft.com/en-us/library/ms475438.aspx

Whenver you create a sequential workflow project in Visual Studio 2010 for SharePoint , it will prompt to ask name several times, which may confusion with which will be the workflow name.

There are actually three names that are used when creating workflows in Visual Studio 2010.

The first is the name of the project item,

second the name of the workflow itself—as defined in the Elements.xml file under the workflow project item folder

third is the name of the association.

(1) Create a new Project in Vs2010, Select SharePoint Template form left pane and Choose Sequential WorkFlow item from right pane.

Creating a Sequential workflow project

Creating a Sequential workflow project

(2) Deployed it as a Farm Solution because it is a site workflow.

Deployed as Farm Solution bcs its SiteWorkFlow which do not need any list to associate

(3) Choose a site workflow.

Choose it as site workflow bcs it no need to have any list

Choose it as site workflow bcs it no need to have any list

 

 
(4) Check History list to capture the history log of the workflow, And Task to Create Task in our workflow. Click Finish.

Setting WorkFlowHisotyList for History of WorkFlow

Setting WorkFlowHisotyList for History of WorkFlow

(5) Simple WorkFlow project has been created. Our First event on this WorkFlow is OnWorkFlowInitiated event.
Create a TaskToken as MyToken and Define the Task Id by Click on the Properties and also create an new GUID for our Task.

Simple Workflow Project Created, Drag Create Task method form ToolBox

Simple Workflow Project Created, Drag Create Task method form ToolBox

define the properties of the Task in the vs2010

define the properties of the Task in the vs2010

(7) Now Create new Task Properties.

Creating Task properties of mytask

Creating Task properties of mytask

(8) Generating Method Invoking Event to provide description and title for the task. We can also provide more detail regarding the Task but now we just put title and description, and mentioned new Guid for this Task.

methodEnvoking of MyTask event

methodEnvoking of MyTask event

setting the description and the title of our new Task

setting the description and the title of our new Task

co-relate the Workflow Task with onTaskChange Event
co-relate the Workflow Task with onTaskChange Event

(9) Drag a OnTeskChange event, and put name as WhenMyTaskChange.On the Properties set the Corelation Token as of TaskToken, so that both will be use a same uniuque corelation Id and set as MyTask_Id.

Define the Same Tasktoen with TaskChange event

Define the Same Tasktoen with TaskChange event

(10) Drag the Code Executer (Code Activity) on the design , and set the methodinvoking on which we are updating a content of our list. we can do anything with list, add update delete list , content type etc. Previously in BiZtalk server 2006 it CodeActivity was not there for this we used to add the classlibrary for data manipulation.

using execute code to update list

using execute code to update list

updating list very sime :)

updating list very sime 🙂

(11) Choose site workflow

going to site workflow

going to site workflow

out co-relation workflow

(12) Waiting for task to change, workflow status is Inprogress.

inprogress and wating for task to change

inprogress and wating for task to change

log history and of task in workflow

log history and of task in workflow

(13) Change the Content of Task to Change so that it will resume the workflow.

changing content of task to co-relation works

changing content of task to co-relation works

workflow complete when task change

workflow complete when task change

Standard