Sharepointing

SharePoint 2010 migration

2011-11-22T12:38:00.000-08:00

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'')
BEGIN
insert into #temporal(Title, WebTemplate, FullUrl, LastMetadataChange)(
SELECT Title, WebTemplate, FullUrl, LastMetadataChange
FROM Webs
WHERE (WebTemplate LIKE ''7%'' or WebTemplate = ''10002'')

);
END
'
select * from #temporal order by FullUrl
drop table #temporal

Sharepoint and 401:Unauthorized

2009-03-26T11:23:00.000-07:00

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.

http://www.crsw.com/mark/Lists/Posts/Post.aspx?ID=44

New Baby Born

2008-09-11T17:58:00.001-07:00

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

2008-09-11T17:10:00.001-07:00

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.

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

2008-06-07T08:21:00.000-07:00

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!!!.

Incremental number on the InfoPath form title hosted as a webpage

2008-05-29T09:00:00.000-07:00

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.

SharePoint Permissions

2008-05-23T11:55:00.000-07:00

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.

Development enviroment

2008-05-19T08:29:00.000-07:00

This is my new development home environment, i'm not going to the specifics of the laptop but got 2gb ram, running Linux and on top of that developing WSS and MOSS, some Microsoft guy mention that Sharepoint developers are the elite cause of the amount of different technologies you need to learn, im adding a new variable, linux. Its been a long time and im using ir again!!!!

My first custom type, well second Enhanced image for sharepoint 2007

2008-05-16T11:36:00.000-07:00

This is a sharepoint 2007 custom type that enhances the functionality of the out of the box "Hyperlink or Picture" type. It basically allows, once added to a list, the ability to upload a picture from the custom list via open dialog box, avoiding the tedious task of uploading the picture to a picture library then copy the url and then paste the url into a "hyperlink or picture”. So instead of having a two step process you can upload a picture directly to a the custom list generate a thumbnail to show on the list view and if click on the thumbnail a popup with the real size picture will show. This was my first attempt of creating a SharePoint custom type so once i publish the code here ill appreciate any comment in order to improve it.
So if you want to know how everything works, take a look at the video.

So now you can upload pictures to your custom list or document library without the pain of uploading the files somewhere else and then copy the URL.

Currently I have a couple of problems but its fully functional, the first one is that attachments needs to be disable on the list not for Document libraries but for Custom lists, the second one is that you need to have at least one picture library in your site.I’m not going to explain how to deploy the WSP but it’s at codeplex so enjoy.

So if you want to know how everything works, take a look at the video.

And the codeplex link http://www.codeplex.com/enhancedpicture

Antigua entrada inrecuperable

2007-11-15T08:15:00.000-08:00

http://yetro.blogspot.com/