How I did it - Sharepoint

Color Calendar Events by column value

2013-01-22T13:53:00.004+00:00

First Happy New Year for everyone, hope you've all had a wonderful holiday season.

To start 2013 I bring, how to create a very nice feature for Sharepoint Calendars. How to present events with diferent colors based on a column value. There are already some nices scripts over the web on how to achieve these.Yet I tried to simplify the all procedure for easy deploy.

I'll be using a standard calendar list and will repaint the events based on the Category field. The default available values are:

Meeting
Work hours
Business
Holiday
Get-together
Gifts
Birthday
Anniversary

But you can use any other column you like.

The goal is to associate some CSS styles to each category, present the field in the calendar event title, grab it and apply the associated CSS.

Before you start, download and the following files https://docs.google.com/file/d/0BzBaIn5fuGosNnJOV2ZSRVZDYmc/edit

Now that you have the files lets do it.

1. Create a Calendar List
Ok first step is easy just create a nice Calendar list in your Sharepoint application.

2. Create a new column to be used in the calendar title
So I want to use the Category field as my color selector. In order to do it, I need a calculated column that merges the Title and Category field. Create a new calculated columna with the following formula

=Title&" ["&Category&"]"

3. Change the Calendar view
Ok now you need to change your Calendar view, in order to show this new field instead of the Title column.

4. Add JS and CSS files

Open your site in Sharepoint Designer and create two directories JS and CSS.

after that upload calendario.js into JS folder and calendario.css into CSS folder.

5. Edit Sharepoint site master page

Almost there, the final touch is to reference JS and CSS in the Master Page.

Edit you v4.master page in Sharepoint Designer and add:

and

Save the master file.

6. Enjoy your new calendar

Ok, now go back to your Sharepoint site and add some random events with diferent categories and enjoy the new colors.

Daily view

Monthly view

Weekly view

In a future post I'll show you how to configure colors, add new values for selection color and even work with multiple calendars.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Master Detail in Sharepoint (2/2)

2012-12-12T21:09:00.000+00:00

Ok, back to continue the article about creating Master Detail relationship in Sharepoint 2010.
In my previous post Master Detail in Sharepoint (1/2) I've shown you how to prepare the Master forms in order to view the Details of a Master item.

Now you need to tweak a bit the Details table form, in order to provide an easy way for the end user to add and update Detail items. Check it out how in this article.

1. Create a new Detail New Form
Using SharePoint Designer, open your site and for the Detail table, in our case Cities, create a New Custom Form.

2. Edit the new form

Using SharePoint Designer, open your site and for the Detail table, in our case Cities and create a New Custom Form. And as explained in previous article, delete the web part and re-create it.

2. Create a parameter to receive the Country ID

Ok the goal is to fill the Country automatically with the value passed by the master form. The first step is to create a parameter, for that click Parameters in Data View Tools > Options menu and press New Parameter.

Name the new parameter, in this case CountryID, make its source as Query String and in the Query String Variable give the form query variable, in this case CountryID again.

3. Link the new parameter to the Country field

Next step, is to link this parameter to the country form field. Right click the Country field and format it as Text Box.

Select the new text box and click Split to see both code and window at the same time. After that change the

text="{@Country}"

text="{$CountryID}"

4. Hide the Country row

To stop the user from changing the value of the Country field, the best is to hide it. I personally prefer to hide the entiry row. Add to the <tr> tag the following code: style="display:none"

Like this:

You have now prepared the New Form for adding Cities to a specific country, this form will be able to receive as a parameter the specific country.

Save and close the form.

5. Make sure the form is marked as default.

Important step, after creating the new form make sure it is marked as default.

6. Edit the Display Form for the Master table

Ok the last step is to change the link in the Master Form. Go back to the Country table and edit the Display Form created in the previous article Master Detail in Sharepoint (1/2). The goal is to change the URL of the link Add new item. Because the default behaviour won't pass the Country ID as a parameter, resulting in adding a City without Country.

7. Add a Content Editor Web part

At the bottom of the from add a Content Editor Web Part.

8. Inject javascript code into the Content Editor

Last step is to add a nice javascript code into the Content Editor Web Part body. Don't forget to add your site url.

var newLink = document.getElementById('idHomePageNewItem');

newLink.onclick = function(){NewItem2(event, 'http://<your_site_url_here>/Lists/City/NewCity.aspx?CountryID=' + getQueryString('ID')); return false;};

newLink.href = "";

function getQueryString(name)

{

var query = window.location.search.substring(1);

var parms = query.split('&');

for (var i=0; i<parms.length; i++) {

var pos = parms[i].indexOf('=');

if (pos > 0) {

var key = parms[i].substring(0,pos);

var val = parms[i].substring(pos+1);

if(key == name)

return val;

}

return '';

}

</script>

Save the form and its done, now when you click in the Add new item link, the New Form City will received the Country ID, resulting in adding a new City into the opened Country.

In this case, I'll add Porto city to Portugal.

Ok it was a big article, with alot of steps if you miss any it won't work. So no rush, do it slowly and enjoy the result.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Master Detail in Sharepoint (1/2)

2012-12-01T17:35:00.000+00:00

Once again I say hi to my followers and Sharepoint fellows. Today I woke up with an urge to write about something that is always a pain in Sharepoint. The Master/Detail thing.

There is no direct way to implement a Master/Detail scenario in Sharepoint, yet I've been using a technique that is pretty simple to implement and very easy for the end user to understand.

As this requires some work, I decided to split it into two articles.

1. Create the Master/Detail relation and Master Forms

2. Update the new (Detail) item link and Detail Forms.

So in this article, I will show you how to create the Master/Detail relation and change the Master Table Forms to reflect it. Check it out how.

First lets pick a classic Master/Detail scenario, the Country to City relation.

1. Create the Master Table (Country)

First step, create a Custom List, name it Country and keep it with only Title Column.

2. Create the Detail Table (Cities)

Create another Custom List, name it City and add an extra Lookup column called Country and reference it to the County Master Table.

3. Add some Countries and Cities

In order to visualize the relation add some items to both tables.

You should end up with something like this:

Countries

Cities

4. Create a new Master Display Form

Ok, the tables are set, now the goal is to change the Display Form of the Country Table (Master Table), in order to show the Cities of the picked Country.

To do that, open your site in Sharepoint Designer and create a new Custom Form for Country Table and set it as default.

5. Create the Master webpart in the new form

Now open your newly created form, delete the existing DataFormWebPart and create a new Display Form, by using the Custom Form option. Like this:

You maybe wondering why I do this. Why the hell I recreated the WebPart. Well Sharepoint as a weird behaviour, bug or defect don't know. Yet, if you don't do this, whenever you add a new column to the table, you won't be able to add that new column without recreating the entire Display Form.

Now imagine, that you have a complex form, with several connected parts and some nice scripts and because you added a new column you now have to recreate the full thing (Won't go further, I'll discuss this issue in another article), just trust me recreate the WebPart :).

6. Add a Data View WebPart for the City Table

Just below the previous WebPart, add a Data View WebPart for the City Table. Like this:

You can remove the Country column if you wish.

7. Connect both WebParts

As you can see, the Data View WebPart is showing all the Cities. Now we need to connect both WebParts in order to show only the Cities for the selected Country.

Select the top WebPart (the one Displaying the Coutry) and click Add Connection and configure it as following:

Now save the form and its done.

PS: You might need to mark the created form as default again.

8. View a Country and its Cities.

Go back to your website and pick a Country, you should now see the Country item and its Cities.

All done for today, in the second article I will show you how to change the way you add and update Cities for a Country.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Get parent Summary Task and children tasks

2012-11-17T12:27:00.000+00:00

Good evening people, this week I've faced some nice challenge in Sharepoint 2010. Working with a Task, I needed to get the parent Summary Task of Task after it was added, changed or deleted, in order to update that same Summary Task with information about its children tasks.

It took me a few hours to solve this problem, yet solved it with a simple solution. Keep reading :)

1. Get the parent Summary Task after adding, updating or deleting Task event
Ok so the first step is to get the parent Summary Task, if a task is a child task of a Summary Task,

SPFolder folder = properties.ListItem.Web.GetFile(properties.ListItem.Url).ParentFolder;
SPListItem summaryTask = folder.Item;

Ok so now summaryTask is your parent Summary Task item, ready to be updated with whatever needed.

2. Get all the children Task of the previous Summary Task
So all items have an hidden field called FileDirRef, which points to the parent folder URL. In our case, our parent Summary Task. The idea is to execute a recursive query to the task list, filtering the field FileDirRef with the value of our added, uptaded or deleted Task FileDirRef.

SPQuery query = new SPQuery();

query.Query = string.Concat("<Where><Eq>",
"<FieldRef Name='FileDirRef'/>",
"<Value Type='Text'>" + properties.ListItem["FileDirRef"].ToString() + "</Value>",
"</Eq></Where>");

query.ViewAttributes = "Scope=\"Recursive\"";

foreach (SPListItem auxItem in properties.List.GetItems(query))
{
//appply your code here
}

PS: One note, this will show only the sub Task items, if in your Summary Task you have sub Summary Tasks, you can access them through folder.SubFolders collection.

Hope it helps, took me a few hours to make this 10 code lines :)

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Add summary task to task list programatically

2012-11-14T22:08:00.000+00:00

Hello again, recently I've tried to add a summary task in a task list in an event receiver.
For my surprise that turned out to be more difficult then I initially expected. Nevertheless, the solution is pretty simple.

Check it out

In your event receiver apply the following code changing:

The name of the Task list
The name of the Summary Task content type
URL of the Task list
Summary Task title

string TaskListName = "Tasks";

string SummaryTaskContentType = "Summary Task";

string TaskListUrl = "{site url}/Lists/Tasks";

string SummaryTaskTitle = "My Summary Task";

SPList myList = SPContext.Current.Web.Lists[TaskListName];

SPContentType type = myList.ContentTypes[SummaryTaskContentType];

SPListItem newItem = myList.Items.Add(TaskListUrl , SPFileSystemObjectType.Folder, SummaryTaskTitle );

newItem["ContentTypeId"] = type.Id;

newItem.SystemUpdate();

Pretty simple isn't it ;)

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Dismistifying AfterProperties & BeforeProperties

2012-09-11T12:14:00.002+01:00

Hi folks, just logged for a fast writing. Everytime I need to code an event receiver I always face the problem of what to use in order to get the Changed Values and Original Values of the event Item.

Guess we all know the:

SPItemEventProperties.AfterProperties
SPItemEventProperties.BeforeProperties
SPItemEventProperties.ListItem

The pain is to understand what values this properties contain in each of the events of a List or Library.

Did some debugging and found nothing new, yet with a small trick in Library events.

Check it out ...

1. Custom list

	AfterProperties	BeforeProperties	ListItem
ItemAdding	Changed value	Nothing	Null
ItemAdded	Changed value	Nothing	Changed value
ItemUpdating	Changed value	Nothing	Original value
ItemUpdated	Changed value	Nothing	Changed value
ItemDeleting	Nothing	Nothing	Item
ItemDeleted	Nothing	Nothing	Null

2. Library

	AfterProperties	BeforeProperties	ListItem
ItemAdding	Nothing	Nothing	Nothing
ItemAdded	Nothing	Nothing	Changed value
ItemUpdating	Changed value	Nothing/Original value	Original value
ItemUpdated	Changed value	Nothing/Original value	Changed value
ItemDeleting	Nothing	Nothing	Item
ItemDeleted	Nothing	Nothing	Nothing

Nothing new right? Well, before writing this article I did a web search and found a board much like this one.

Yet see the change in the BeforeProperties for the Library events.

Why two values for the ItemUpdated and ItemUpdating? Easy enough.

When you add a new document to a document library the events fired are in this order: ItemAdding > ItemAdded. Until here nothing new.

Well right after you add a new document the EditForm pops up in order to allow you to change any properties for the document.

The events that are fired for this Form after you press Save are: ItemUpdating > ItemUpdated.

Yet, at this moment (the moment right after you add a new document), the BeforeProperties has no usefull values like it should. In fact, it has nothing. So, not only the Update events are fired, when your are adding a new document (because infact the document is already saved), as the BeforeProperties work diferently from the standard Update action.

Hope it helped and saves you some time.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Removing HTML tags from Drop Down list

2012-08-23T12:04:00.000+01:00

Hi people, got another tweak to show you.

Following a previous post Filtering lookup columns I've noticed that the selected value of a DropDown list shows HTML tags like this:

Nevertheless the items in the dropdown list are ok.

The question is, how to remove the HTML tags from the selected value?

1. Edit the form in Sharepoint Designer and Split the view

Now click on your DropDown list control, the code window should now pointing to the DropDown source code.

2. Edit the selectedvalue tag

You can now see that the tag selectedvalue is pointing to the Field Name, in my case "Tabela1".

selectedvalue="{@Tabela1}"

What you have to do is just changing this part of the code to

selectedvalue="{substring-before(substring-after(@Tabela1, '>'), '<')}"

And voilá save the form and try it out.

Just one note "Tabela1" is the field name, just change it to your case.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Add a new file type

2012-07-30T16:15:00.001+01:00

Ok here is another nice tip. I recently needed to add to the context menu (ECB menu) of a file the "Edit in ..." command. Basically, if the native application is WebDav compatible I want to be able to edit any file for the referenced application, just from the browser, instead of navigating throw the Explorer View. (This will only work for Internet Explorer)

Like this:

Check it out, this is pretty fast yet very helpfull.

1. Create an icon file

Use your favorite image editor to create an image file with 16x16, preferebly PNG format.

And save the image file into the server folder %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES

2. Edit the DOCICON.XML file (backup the file first ;-))

Next open, using your favorite text editor, the docicon.xml file located in the server folder %COMMONPROGRAMFILES%\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML.

Add one line for each file type like this:

Just change:

Key="pdf" to Key="your_file_extension"
Value="pdf.png" to Key="image_file_name" (created in first step)
EditText="PDF-XChange Viewer" to Edit="name_of_the_native_application" (this is the name that will appear in the context menu (ECB)

3. Reset server and try

All done, just iisreset your server and try it.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Explorer view is too slow

2012-06-15T14:56:00.001+01:00

Ok I've passed the last day and a half trying to find a solution for a know problem.

Some users, were facing huge low performance copying files to a Document Library in Explorer View. After alot of web surfing without getting anywhere I add a sparkle idea that worked finally.

Check it out.

1. Typical solution: Disable the "Automatically Detect Settings" from IE
Ok this is the typical cause of the problem WebDav protocol and the feature for proxy automatic detection don't like each other.

Open IE and go to Tools->Internet Options->Connections->LAN settings uncheck "Automatically Detect Settings". Like this:

Ok, if this doesn't solve your problem, like it happened to me check next solution

2. Anti-virus solutions is messing with WebDavAV traffic

After burning my eyebrows and almost in tears, I disabled my anti-virus realtime protection. In my case Kaspersky. Surprisingly, Explorer View went live almost immediately.

As I want anti-virus realtime protection, I started to disable parts of that protection and found out that "IM anti-virus protection" was the problem. Yet, this only happens in Kaspersky 2012

If you are using Kaspersky 2012, or your antivirus as also IM protection. Do one of the following:

Disable IM Protection

Enable IM protection only for inboud messages

Hope it helps and saves you time, after all unticking one small check box took me a few hours, lol.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Format Date in Custom Display Form

2012-06-13T08:34:00.000+01:00

Hi guys, here is another nice trick that took me a while to get.

Imagine you have a list with a Date field, only showing date value, not Time. If you create a Custom Display Form in Sharepoint Designer, you wiill see something incredible.

Date field shows Time value
Date field shows less 1 hour, which might lead to show one less day in date value

Just like this:

Ok the goal is to format the date value, check how I did it.

1. Edit your custom form in Sharepoint Designer

Open your custom form in Sharepoint Designer and select the date value.

2. Add a format Formula

Click the Formula button and write the following Formula:

ddwrt:FormatDate(string(@Date), 1033, 1)

Don't forget to use the string function!! Will give you an error in XPath bla bla bla...
1033 is the locale code, check other locale codes here List of Locale Codes
1 is the date format, the possible values are 1, 4, 5, 7,12, 13 or 15, each represent a different date format, pick the one that suites you better.

3. Save the custom form and its done

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

List of Locale Codes

2012-06-12T10:28:00.004+01:00

Use the LCID Dec values for the FormatDate function.

Language - Country/Region	LCID Hex	LCID Dec
Afrikaans - South Africa	0436	1078
Albanian - Albania	041c	1052
Alsatian	0484	1156
Amharic - Ethiopia	045e	1118
Arabic - Saudi Arabia	0401	1025
Arabic - Algeria	1401	5121
Arabic - Bahrain	3c01	15361
Arabic - Egypt	0c01	3073
Arabic - Iraq	0801	2049
Arabic - Jordan	2c01	11265
Arabic - Kuwait	3401	13313
Arabic - Lebanon	3001	12289
Arabic - Libya	1001	4097
Arabic - Morocco	1801	6145
Arabic - Oman	2001	8193
Arabic - Qatar	4001	16385
Arabic - Syria	2801	10241
Arabic - Tunisia	1c01	7169
Arabic - U.A.E.	3801	14337
Arabic - Yemen	2401	9217
Armenian - Armenia	042b	1067
Assamese	044d	1101
Azeri (Cyrillic)	082c	2092
Azeri (Latin)	042c	1068
Bashkir	046d	1133
Basque	042d	1069
Belarusian	0423	1059
Bengali (India)	0445	1093
Bengali (Bangladesh)	0845	2117
Bosnian (Bosnia/Herzegovina)	141A	5146
Breton	047e	1150
Bulgarian	0402	1026
Burmese	0455	1109
Catalan	0403	1027
Cherokee - United States	045c	1116
Chinese - People's Republic of China	0804	2052
Chinese - Singapore	1004	4100
Chinese - Taiwan	0404	1028
Chinese - Hong Kong SAR	0c04	3076
Chinese - Macao SAR	1404	5124
Corsican	0483	1155
Croatian	041a	1050
Croatian (Bosnia/Herzegovina)	101a	4122
Czech	0405	1029
Danish	0406	1030
Dari	048c	1164
Divehi	0465	1125
Dutch - Netherlands	0413	1043
Dutch - Belgium	0813	2067
Edo	0466	1126
English - United States	0409	1033
English - United Kingdom	0809	2057
English - Australia	0c09	3081
English - Belize	2809	10249
English - Canada	1009	4105
English - Caribbean	2409	9225
English - Hong Kong SAR	3c09	15369
English - India	4009	16393
English - Indonesia	3809	14345
English - Ireland	1809	6153
English - Jamaica	2009	8201
English - Malaysia	4409	17417
English - New Zealand	1409	5129
English - Philippines	3409	13321
English - Singapore	4809	18441
English - South Africa	1c09	7177
English - Trinidad	2c09	11273
English - Zimbabwe	3009	12297
Estonian	0425	1061
Faroese	0438	1080
Farsi	0429	1065
Filipino	0464	1124
Finnish	040b	1035
French - France	040c	1036
French - Belgium	080c	2060
French - Cameroon	2c0c	11276
French - Canada	0c0c	3084
French - Democratic Rep. of Congo	240c	9228
French - Cote d'Ivoire	300c	12300
French - Haiti	3c0c	15372
French - Luxembourg	140c	5132
French - Mali	340c	13324
French - Monaco	180c	6156
French - Morocco	380c	14348
French - North Africa	e40c	58380
French - Reunion	200c	8204
French - Senegal	280c	10252
French - Switzerland	100c	4108
French - West Indies	1c0c	7180
Frisian - Netherlands	0462	1122
Fulfulde - Nigeria	0467	1127
Galician	0456	1110
Georgian	0437	1079
German - Germany	0407	1031
German - Austria	0c07	3079
German - Liechtenstein	1407	5127
German - Luxembourg	1007	4103
German - Switzerland	0807	2055
Greek	0408	1032
Greenlandic	046f	1135
Guarani - Paraguay	0474	1140
Gujarati	0447	1095
Hausa - Nigeria	0468	1128
Hawaiian - United States	0475	1141
Hebrew	040d	1037
Hindi	0439	1081
Hungarian	040e	1038
Ibibio - Nigeria	0469	1129
Icelandic	040f	1039
Igbo - Nigeria	0470	1136
Indonesian	0421	1057
Inuktitut	045d	1117
Irish	083c	2108
Italian - Italy	0410	1040
Italian - Switzerland	0810	2064
Japanese	0411	1041
K'iche	0486	1158
Kannada	044b	1099
Kanuri - Nigeria	0471	1137
Kashmiri	0860	2144
Kashmiri (Arabic)	0460	1120
Kazakh	043f	1087
Khmer	0453	1107
Kinyarwanda	0487	1159
Konkani	0457	1111
Korean	0412	1042
Kyrgyz (Cyrillic)	0440	1088
Lao	0454	1108
Latin	0476	1142
Latvian	0426	1062
Lithuanian	0427	1063
Luxembourgish	046e	1134
Macedonian	042f	1071
Malay - Malaysia	043e	1086
Malay - Brunei Darussalam	083e	2110
Malayalam	044c	1100
Maltese	043a	1082
Manipuri	0458	1112
Maori - New Zealand	0481	1153
Mapudungun	0471	1146
Marathi	044e	1102
Mohawk	047c	1148
Mongolian (Cyrillic)	0450	1104
Mongolian (Mongolian)	0850	2128
Nepali	0461	1121
Nepali - India	0861	2145
Norwegian (Bokmål)	0414	1044
Norwegian (Nynorsk)	0814	2068
Occitan	0482	1154
Oriya	0448	1096
Oromo	0472	1138
Papiamentu	0479	1145
Pashto	0463	1123
Polish	0415	1045
Portuguese - Brazil	0416	1046
Portuguese - Portugal	0816	2070
Punjabi	0446	1094
Punjabi (Pakistan)	0846	2118
Quecha - Bolivia	046B	1131
Quecha - Ecuador	086B	2155
Quecha - Peru	0C6B	3179
Rhaeto-Romanic	0417	1047
Romanian	0418	1048
Romanian - Moldava	0818	2072
Russian	0419	1049
Russian - Moldava	0819	2073
Sami (Lappish)	043b	1083
Sanskrit	044f	1103
Scottish Gaelic	043c	1084
Sepedi	046c	1132
Serbian (Cyrillic)	0c1a	3098
Serbian (Latin)	081a	2074
Sindhi - India	0459	1113
Sindhi - Pakistan	0859	2137
Sinhalese - Sri Lanka	045b	1115
Slovak	041b	1051
Slovenian	0424	1060
Somali	0477	1143
Sorbian	042e	1070
Spanish - Spain (Modern Sort)	0c0a	3082
Spanish - Spain (Traditional Sort)	040a	1034
Spanish - Argentina	2c0a	11274
Spanish - Bolivia	400a	16394
Spanish - Chile	340a	13322
Spanish - Colombia	240a	9226
Spanish - Costa Rica	140a	5130
Spanish - Dominican Republic	1c0a	7178
Spanish - Ecuador	300a	12298
Spanish - El Salvador	440a	17418
Spanish - Guatemala	100a	4106
Spanish - Honduras	480a	18442
Spanish - Latin America	580a	22538
Spanish - Mexico	080a	2058
Spanish - Nicaragua	4c0a	19466
Spanish - Panama	180a	6154
Spanish - Paraguay	3c0a	15370
Spanish - Peru	280a	10250
Spanish - Puerto Rico	500a	20490
Spanish - United States	540a	21514
Spanish - Uruguay	380a	14346
Spanish - Venezuela	200a	8202
Sutu	0430	1072
Swahili	0441	1089
Swedish	041d	1053
Swedish - Finland	081d	2077
Syriac	045a	1114
Tajik	0428	1064
Tamazight (Arabic)	045f	1119
Tamazight (Latin)	085f	2143
Tamil	0449	1097
Tatar	0444	1092
Telugu	044a	1098
Thai	041e	1054
Tibetan - Bhutan	0851	2129
Tibetan - People's Republic of China	0451	1105
Tigrigna - Eritrea	0873	2163
Tigrigna - Ethiopia	0473	1139
Tsonga	0431	1073
Tswana	0432	1074
Turkish	041f	1055
Turkmen	0442	1090
Uighur - China	0480	1152
Ukrainian	0422	1058
Urdu	0420	1056
Urdu - India	0820	2080
Uzbek (Cyrillic)	0843	2115
Uzbek (Latin)	0443	1091
Venda	0433	1075
Vietnamese	042a	1066
Welsh	0452	1106
Wolof	0488	1160
Xhosa	0434	1076
Yakut	0485	1157
Yi	0478	1144
Yiddish	043d	1085
Yoruba	046a	1130
Zulu	0435	1077
HID (Human Interface Device)	04ff	1279

List copied from http://msdn.microsoft.com/en-us/goglobal/bb964664

SharePoint 2010: Hide Recently Modified

2012-06-05T13:40:00.000+01:00

Hi again, after a long wait. Saddly last month couldn't free some time to write a bit. Nevertheless I'm back and with some new tips that will post in the following days.

So the first one is to show, how can you hide the Recently Modified box from the Quick Launch area, in a Wiki Page Library.

Create a new site with a Wiki Page Library
You should get something like this

As you can see there is a, sometimes, annoying Recently Modified box in the Quick Launch.

So check how to hide it in 2 easy steps.

1. Edit Master page in Sharepoint Designer
Ok open your site, go to Master Pages and edit the file V4.master in Code view

2. Paste the following in code between Head tag

Ok now paste this code anywhere between the tag Head and save the changes

3. YAY!!! Refresh your site and its done.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Filtering lookup columns

2012-04-09T19:18:00.000+01:00

Good day all, I bring you another tweak for Sharepoint. In Sharepoint 2010 and Cascade Lookups I've shown you how to filter a lookup column based on the value of another. Now, what if you want to filter a column, based on a query of the source list?
There are plenty of options over the web on how to do it using third-party tools. In my opinion it is always good to avoid that. Why? Well in the past I had huge problems with third-party tools, specially restoring sites with those features.

So, now, I always try to avoid third-party tools unless I've no other option.

Check how I filter columns based on queries in 6 easy steps:

Problem description

Ok you have two lists connectec by a lookup column:

List 1: Parent list

List 2: Child list connected to List 1 by ColumnA column

And now, when you are adding or editing a new item in List 2, you want to allow only to pick List 1 Active items.

Solution

1. Open your site in Sharepoint Designer

The first step is to open your Sharepoint site in Sharepoint Designer 2010.

In the Site Objets pane select Data Sources, there your should have one data source for each List in the site.

2. Duplicate List1 data source

Right click in your parent list data source, ours List 1, and click in Copy and Modify

In General tab give your data source a unique name and define in Source tab the filter you want. In our case "State Equals 'Active'", like this:

3. Create new custom forms

In your child list, our List 2, create new custom forms, for New and Edit item. Repeat steps 4 to 6 for each form. Don't forget to make the new custom forms the default ones.

4. Delete the Form Field of ColumnA

Edit your form and delete the Form Field associated to ColumnA

5. Insert a new data source

In the Insert tab, insert a new data source and pick the one you created in step 2.

6. Insert a Sharepoint Drop Down control

After inserting the data source, go again to Insert tab and insert a Data View DropDownList from Sharepoint controls.

Ok now that you added everything needed, you just need to configure the newly added field to map the fitlered data source. Pick the field and click Data Fields ... link

In data field, pick the lookup column.

In data source, pick the data source added in step 5

For the display text, pick the field you want to be displaied to the user

For the field value, pick the value passed to the lookup column, tipically ID field.

Ok save everything and go to your site. You should be getting something like this:

ColumnA only shows items from List 1 which State field has the value Active.

Hope you enjoyed it and if you want to see this working, download the following site template Filter Lookup Site Template.

NOTE: This is an english template, if that is not your Sharepoint installation language you will need to install the English Language Pack, check it how in here.

Datasheet View not working

2012-04-08T12:05:00.000+01:00

This will be one fast tip.

Recently I was struggling with Datasheet View, in some clients it simply didn't show. So how I did it in 30 seconds?

The icon was enabled, but kept receiving the following message:

After digging a while I find out the problem. I was using Office 2010 x64 with IE x32.
That means the datasheet view components weren't installed correctly. I need the x86 version of the components. In my case, I couldn't install Microsoft Office Access database engine 2010 x86 version, as I have Office 2010 x64. So the option now is to have Microsoft Office Access database engine 2007 x86 instead.

If that is your case follow the link http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 pick the version suited to your IE version, install it and bam it should work.

I even tried this components in a computer without any Office application installed. Amazingly I also worked.

If you want to keep in touch, feel free to Subscribe to How I did it - Sharepoint Foundation 2010

Sharepoint 2010 and Cascade Lookups

2012-04-05T20:39:00.000+01:00

Here I am for another great tip. One of the things that lack in Sharepoint 2010 is the ability to create Cascade Lookup columns. This is, to filter the options of a lookup column based on the value of another.

Around the web you can find many solutions, I used one hosted in Codeplex http://spcd.codeplex.com. The documentation needs some tweak, here you might see how I managed to put it to work.

Also, it has a little problem with Chrome, that I solved.

The problem

Supose the following, you have 3 lists.

List1 > Column1

List2 > Column2 and Column3

Column3 is a lookup connected to Column1 in List1

List3 > Column4, Column5 and Column6

Column4 is a lookup connected to Column1 in List1

Column5 is a lookup connected to Column2 in List2

Now the goal is to filter the options of the lookup field Column5 based on the value of Column4.

The solution

1. Download spcd.js

There is a version of spcd.js in Codeplex, but that version does not work in Google Chrome. I have created a new version which can be downloaded frm here.

2. Upload spcd.js to your Sharepoint site

Now that you have spcd.js script, just upload it into your Sharepoint site. You can upload it to a Library or use Sharepoint Desinger to upload it into a Folder. Up to you, pick the one you like more.

3. Create the lists in Sharepoint

If you have not created the lists, now it is the time. Create the lists and connect them with Lookup columns.

4. Create a new item custom form and make it default form

Use Sharepoint Desinger to create a new custom form, in your list with the two fields (mine List3). Don't forget to mark it as the Default one.

5. Add a Content Editor web part to the new form

Now, edit the newly created form and add a Content Editor web part after the form webpart (the script will not work if you place the Content Editor before the form webpart)

6. Configure the Content Editor web part

Last, edit the Content Editor web part in HTML and add the following code to it:

var ccd1 = new cascadeDropdowns("Column4", "Column5", "Column3", "List2", "Column2");

</script>

where:

script_location: is the folder or library path where your uploaded spcd.js. Use relative path, if you place the full http:/server/library/scd.js, the script will not work.

Column4: Is the display name of the Parent column in List3

Column5: Is the display name of the Child column in List3

Column3: Is the internal name of the column in List2 linked to List1

List2: Is the display name of List2

Column2: Is the internal name of the column in List2 that feed the Child column (Column5)

PS: When creating column, avoid special characters in the name, as the internal name will be a mess because of it. It will work, but the column is a bit more ugly.

7. Try it!!

Ok, now that you put it all together just try to add a new item into List3. You should be getting something like this:

If not, well e-mail me pedro.rosae@gmail.com, I will help you out.

Want a shorcut, download a site template fully configured here. The language of this template is English, so if you are using a non-english Sharepoint installation don't forget to install the English Language Pack, check how to do it at Installing Sharepoint Foundation 2010 Language Pack - Windows 7.

Installing Sharepoint Foundation 2010 Language Pack - Windows 7

2012-03-30T23:45:00.003+01:00

Ok now that you have a Sharepoint Development Environment installed in Windows 7, in order to create localized content you will also need Sharepoint Language Pack. Again, installing it in Windows 7 (at least Professional edition) isn't straightforward.

So how i dit it in 4 easy steps:

1. Download Sharepoint Foundation 2010 Language Pack

Microsoft Sharepoint Fondation 2010 Language Pack

Download only the language you need and note, no need to download the language pack used in the Sharepoint Foundation 2010 installation.

2. Extract Microsoft Sharepoint Foundation 2010 Language Pack installer

You will need to change some files inside the installer package, if you try to run it as is, you will receive and error with a message that operating system is not supported.

So execute the following command in the installer folder:
SharePointLanguagePack.exe /extract:c:\SharePointLanguageFiles

This will extract all the files into c:\SharePointLanguageFiles

3. Edit config.xml

Ok, last but not least, edit in your favorite text file editor the c:\SharePointFiles\files\Setup\config.xml and add the line

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

just before

</Configuration>.

4. TWEAK DONE!! Install Microsoft Sharepoint Foundation 2010 Language Pack

Just run the file c:\SharePointLanguageFiles\Setup.exe and follow the steps. Also don't forget to rerun SharePoint 2010 Products Configuration Wizard.

Installing Sharepoint Foundation 2010 - Windows 7

2012-03-23T10:24:00.001+00:00

One of the great things of Microsoft Sharepoint Foundation 2010 is the capability of creating a development environment in Microsoft Windows 7 Professional (does not work in Windows 7 Home editions). This become pretty handy for me, my working computer is a laptop, so I can now develop applications anywhere without restrictions.

So how I did it in 6 easy steps?

1. Download Sharepoint Foundation 2010 and all the required software

2. Configure IIS web server in Windows 7

Copy and paste the following script in a command line.

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;^
IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;^
IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;^
IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics;^
IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ManagementScriptingTools;^
IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;^
IIS-RequestFiltering;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;^
IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-IIS6ManagementCompatibility;^
IIS-Metabase;IIS-WMICompatibility;WAS-WindowsActivationService;WAS-ProcessModel;^
WAS-NetFxEnvironment;WAS-ConfigurationAPI;WCF-HTTP-Activation;^
WCF-NonHTTP-Activation

3. Extract Microsoft Sharepoint Foundation 2010 installer

You will need to change some files inside the installer package, if you try to run it as is, you will receive and error with a message that operating system is not supported.

So execute the following command in the installer folder:
SharePointFoundation.exe /extract:c:\SharePointFiles

This will extract all the files into c:\SharePointFiles

4. Install Microsoft FilterPack 2.0

In the files extracted in step 3 install:
c:\SharePointFiles\PrerequisiteInstallerFiles\FilterPack\FilterPack.msi

5. Edit config.xml

6. FINALLY!! Install Microsoft Sharepoint Foundation 2010

Just run the file c:\SharePointFiles\Setup.exe and follow the steps.

Ok, you now have a small Sharepoint installation that should be used for development, but it can serve up to 10 clients, with a 10GB database. Enjoy.