Tuesday, November 22, 2011

SharePoint 2010 migration

here is a query to find where in your site the Fab 40 templates are being use, this will help you locate and take some action.
The SP migration reports give you so much information but this query will go thru all the content and find where those template ID's have been use

create table #temporal(
[Title] nvarchar(max),
[WebTemplate] int,
[FullUrl] nvarchar(max),
[LastMetadataChange] datetime
exec sp_MSforeachdb 'USE [?] IF EXISTS(select 1 from [?].Information_Schema.Tables Where Table_Name = ''Webs'')
insert into #temporal(Title, WebTemplate, FullUrl, LastMetadataChange)(
SELECT Title, WebTemplate, FullUrl, LastMetadataChange
WHERE (WebTemplate LIKE ''7%'' or WebTemplate = ''10002'')

select * from #temporal order by FullUrl
drop table #temporal

Thursday, March 26, 2009

Sharepoint and 401:Unauthorized

I'm experiencing a level of frustration that I haven't experience before, so if you install .NET 3.5 service packs 1 your search will stop working as well as every custom development you have that access the WSS Web Services. I have spend the past couple of days trying to figure out why one of my devs have stop working, for some reason the patch in the following link is applied in Production but not in testing where I normally test my stuff.

So here for you to apply it immediately after SP1 of .NET 3.5.


Thursday, September 11, 2008

New Baby Born


As per August 15 I'm a proudly father of a new baby boy almost 4 weeks now and can't stop seeing at him, and thinking of him, it's an experience that can't be properly explain, you just fall in love again with a little meatball that is just right under 5kg. here is a picture of the new one.

From Blogger Pictures

Cool features in today’s InfoPath session at Microsoft Canada


Today I attend an InfoPath session by Envision IT, It's a company that is selling sharepoint services like installing, migrating, and helping companies with their processes but I'm not planning to talk about the company (they are gold partners) but the cool stuff they show, and i'm assuming that by reading this you have a very good grasp of what SharePoint out of the box can do for you, if not just go Google "SharePoint" then keep reading.


Survey web part – Basically a web part displaying a SharePoint list, where this SharePoint list is basically a list of surveys with description of the survey and the url of the survey. And the surveys are being display one at a time in periods of 10 seconds. And the elements of the list are being published base on initial publication date and end date.

So you can have surveys spread all over your farm and display them in your main page. Example:

Who do you think is going to be the next president of the US?

See results

Answer the poll


End user training for every implementation - They mention that something very important in every implementation and they mention this as a lessons learn and a must have for a SharePoint implementation is end user training. To be honest SharePoint is very user friendly but users with an initial, end user training, can take SharePoint to an advance level. So will push a little bit more in my organization to deploy this training to every single computer user to empower them, and take this to the next level.


Expenses report – Actually the first InfoPath demo is the expenses report but imagine taking this expenses report to the next level where you click on create a new expense report and the InfoPath form connects directly to your bank to get the statement thru a web service and populate the description and all the fields in your expenses report and you just submit this for approval. Ill plan to do this in the near future.

Saturday, June 7, 2008

Visual Studio 2008 Extensions, Version 1.2, Long wait nothing new (WSS 3.0)

It’s been a long wait and a lot of speculation around Visual studio extensions 2008, but as with everything that you wait for a long time and start thinking that is going to solve all of our problems once you have it it’s not enough for you, that’s what just happened with me and VS2008 Extensions.
VS2008 extensions have the same functionality as VS2005 extensions but its working with visual studio 2008 nothing new nothing fancy, so my recommendation would be and that’s what I use for day to day, WSPBuilder a few other tools but mainly WSPBuilder.
In teched the announce the new SharePoint webpage it’s a very very good resource for asp.NET developers that would like to start developing in WSS and MOSS and the link is HERE.
And in order to download the best project or VS2008 Addin for developing sharepoint applications is HERE.
And finally where to download Windows SharePoint Services 3.0 Tools: Visual Studio 2008 Extensions, Version 1.2 is HERE.

And here is a picture or screenshot of the Extensions running VS2005. (Its the same as VS2008 NO ENHANCEMENTS!!!.

Thursday, May 29, 2008

Incremental number on the InfoPath form title hosted as a webpage

Let’s say you want an electronic Form and the identifier of the form needs to be an auto incremental number or ‘some text’ plus an incremental number and you have chosen SharePoint to host your electronic form and InfoPath as your tool to design your form, there is a very good article on how to do this, I’m just extending this useful information and adding some screen shots to it.

Base article

Very simple video to look at the instructions.

Friday, May 23, 2008

SharePoint Permissions

I have been asking this same thing a couple of times now, that's why I decided to blog around this.

It's very simple straight forward and here is a video about the basic permissions handling.

This contains:

Break permission inheritance from the parent site.
Create the 3 default groups in SharePoint site, for Viewers, Contributors, Owner.
Add one user to one of the groups.
Delete one user from one of the group.
In order to add an AD group to a SharePoint group is the same way as adding a user, and with this in mind you just manage the AD group.

Next time ill add voice to the video.