26 January 2018

Delete local Outlook Inbox Rules

In my existing local Outlook setup, my Inbox rules had grown up to an inmanagable amount. So I decided to clean the slate. However, I had no desire to press the Delete button over and over again.

Using PowerShell I was able to actually delete these local InboxRules with the script below.

Warning: this is a destructive script! Use at your own risk.

To use: just replace the  "YOUR INBOX NAME HERE" with your own inbox name and execute in a PowerShell shell of choice.
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
#################################################################################
# Title: delete outlook rules
# Description: deletes all outlook rules for a specific user
# 2018-01-26
################################################################################# 
Add-Type -assembly "Microsoft.Office.Interop.Outlook"
$Outlook = New-Object -comobject Outlook.Application

$namespace = $Outlook.GetNameSpace("MAPI")
$folder = $namespace.GetDefaultFolder([Microsoft.Office.Interop.Outlook.OlDefaultFolders]::olFolderInbox)
$inbox = $namespace.Folders.Item("YOUR INBOX NAME HERE").Folders.Item("Inbox")
$store = $inbox.Store
$rules = $store.GetRules()
$rulescount = $rules.Count
"Number of rules found: $rulescount"

$index = 0
do
{
    $rules.Remove(1)
    $index++
}while ($index -le $rulescount)
$rules.Save()

$rulesleft = $inbox.Store.GetRules().count
"Number of rules left: $rulesleft"

Remove-Variable Outlook
Code formatted with: http://hilite.me/

I'm by no means a PowerShell expert. There might be better ways to do this. This little script gave me some pleasure assembling however and hopefully it helps someone else too.

10 September 2015

The required category ‘Microsoft.TestCaseCategory’ does not exist in team project ‘[projectname]’

When connecting to our TFS 2015 project with Microsoft Test Manager two of our team members were unable to connect, instead receiving:

The required category ‘Microsoft.TestCaseCategory’ does not exist in team project ‘[projectname]’

Googling for solutions I came across http://www.almguide.com/2011/01/the-required-category-microsoft-testcasecategory-does-not-exist-in-team-project-projectname/. I checked on my machine what the state of the categories was using the following statement.

witadmin.exe exportcategories /collection:http://[yourtfsinstance:port]/tfs/[collectionname]

Turns out that they were there and it was a complete list. So far so good. However, running the statement on my colleagues machine (or using his credentials on my machine, which led to the same result): not a single category...only the category element root tag...

In effect this had to be the root cause for the exception message in Test Manager 2015. After connecting to the TFS database and starting a profile and rerunning the export statement, I saw no actual database activity, which led me to think that some caching mechanism was in place. Rebuilding the TFS cache can be done by using the following command:

witadmin rebuildcache /collection:http://[yourtfsinstance:port]/tfs/[collectionname]
The statement finished swiftly probably because our TFS instance is relatively young, you milage may vary as there is a warning upon execution that states:
To avoid server performance issues, you should not run this command during typical operating hours.
After rebuilding the cache everyone was able to connect to the team project as intended! 
Hope this helps someone.

20 August 2015

TF246019: Team Foundation Server trial period expired

After upgrading TFSRC2 to the RTM version I installed Release Management for Team Foundation Server 2015. 

Wanting to connect to the TFS I was presented with the TF246019 error message.



Context: the TFS instance was upgraded from a TFS2015 RC to the TFS2015 RC2 and finally to the TFS2015 RTM. Being the RTM version it has a proper license. 
The error message has also presented itself when it was still a TFS2015 RC2 instance.

Rebooting the server resolved the issue.

Hope this helps somebody.

29 July 2015

TFS2015 RC2 upgrade - Backlog Explorer empty - Backlog and Capacity empty

Microsoft released TFS 2015 RC2, read about it in Brian Harry's blog

Upon upgrading the bits on the existing TFS2015 RC, I noticed that the Backlog Explorer was empty when I was looking at the existing sprints.
However, using the Board option in the sprint pane did show the existing backlog items as well as show the navigation options in the Backlog Explorer.


Clicking on the Capacity gave similar results: no capacity planning screen and an empty Backlog Explorer.

What was the case? This particular instance is a TFS test machine that has been closed for the current team and did not have any team members at the time of the upgrade.

The solution? Adding one team member to the team project and refreshing the webpage. This restored the functionality as we all come to know it. Removing the team member also did not result in the functionality breaking again.


Conclusion: an upgrade glitch for projects without team members with an easy fix.

Hope this helps someone.

16 November 2009

Pagoda Sunday

The first night with effective sleep without the hourly sudden spontaneous awakening. My colleagues had a trip in mind to the Elephanta caves. I had heard about this and would involve an hourly boatride. Nice prospect. Plans have shifted however to go to Gorai. As I had never heard of this place before (not all to hard considering I'm no Mumbaiker) I was intrigued. Not in the least because my colleagues had not visited the site themselves! This time I caught even the city bus which costs a whooping Rs 7! Amazing. The busdriver unexpectedly drives calm but firm through the busy streets of North West Mumbai. However, somehow it seems that we are too slow in getting off the bus and the driver starts driving back after having reached the terminus. Some harsh words are even exchanged. Life in Mumbai goes fast: be prepared! We walk towards the river (Manori Creek) and the smell of fish enforces itself upon us. At the boat we wait for the rest of our party to arrive.





Meanwhile the floating bank is sinking more and more because of the extra wait of motorbikes and people. The ferry does not sink (thanks for the warning Ravi) and we walk towards Mumbai's newest landmark, the majestic 325-feet tall Global Vipassana Pagoda. However not yet entirely covered in gold, it's already quite impressive.



A lot remains to be done like the marble flooring but as this pagoda is funded purely based on gifts and construction has been going on for more than 11 years now, that seems like a minor problem. Inside people are meditating under a large dome. It must be an amazing site if it is completely filled.

The entry to the temple lies next to (really!) this themepark entrance



Prizewinning picture of an Indian sunset (?!)



On the road back we decide to go through with the highly anticipated plan to see a Hindi movie. The only movie I had heard off was not playing anymore (lucky for some, most people found it to be a bad movie) and the suggestion fell on Ajab Prem ki ghazab kahani.



An entertaining movie about the President of the Happy Club who falls in love with a girl. She's already in love with someone else of course. This mad story is rather simple and because of that I get at least the main plot. Combine that with slapstick humour, a little bad acting now and then, the lovely Katerina / "Jenny" (I'm writing this for you, not me! You know who you are) some strange fighting moves and fat comedy sauce topped of with some singing and dancing and my first Hindi movie was a blast. Altogether again one day well spent! Thanks guys!!

Swinging Saturday

Five AM, the alarm clock punishingly awakes me.



The promise of yesterday stings hard in my body that is unwilling to let the soft bed behind. Ravi calls and we are not going to Santa Cruz but he will be joining me at the hotel. A little sad about this sudden change, although travelling there would have been quite a challenge at that time for me, but with anticipation I head of and meet him and a colleague at the gate. We run for about 6.5km around Powai lake. The otherwise, carloaded, rikshafilled, busfilled road is almost empty. A stray dog looks sad at us when we run by. By 6:50 where back at the hotel. I'm grateful for the invitation and with this exchange of gratitude I walk back into the hotel for some excercises and a steambath (what a nice surprise!). The Dutch colleagues are enjoying breakfast (or faking it well). They are about to embark in a tour of downtown Mumbai. I decline their invitation to go there. As I have been there and especially the long ride there puts me of. Instead I go to my room and ...fall asleep. Yeah, that was kindof a surprise. Afterwards, I left for the Shri Siddhivinayak temple in Dadar.

Some onroute photo's:

First taking the riksha to Anderi station and from there by fast train in the first class compartiment (and the MENs compartiment for that matter, yes I do try to learn from experience). One riksha ride I'm at the temple. The temple itself is gated and basically sealed. I cannot take my camera inside but the local salesman will guard it for me. As compensation, I buy some offerings for Lord Ganesha and take them inside. Dropping my shoes at yet another booth, I enter the temple. All the fences considering, it does not feel crowded so I consider myself very very lucky given that once it get's crowded in India it is oppressingly crowded. Not part of my comfortzone... Inside the temple one has to walk around it and enter a shrine where you can hand over your offerings to some 'priests'? who accept your offering and exchange some items. Ganesha in his orange body smiles at the spectacle. The golden glow of the shrine adds even more atmosfere to this happening and contrary to my discomfort in crowds like this I cannot but smile.
Onwards to Bandra

More onroute pics:




where I really wanted to see the stalls at Linking road. So I found them...well lit!



And they are filled with womans clothes and shoes (very cheap: colleagues say that with a little bargaining you can get a pair for Rs 50 but you can only wair them for a month). Somehow I expected a more diverse palette for shoppers.
So that's the view for when you're hunting for bargains. Then I turned around to find this in my face:
As it is getting late, I return to Bandra station on foot and take the train to Anderi.



I abandon my earlier plan to visit St Mary's church in Bandra. Maybe next time. While on my way to the beautiful Bandra Station, some raindrops fall from the heavens. A chilly wind cools the streets. Temperature reaches a familiar 18 degrees Celsius. Back on the train to Anderi and one riksha ride later I'm back at the hotel. I really love going about and discovering Mumbai. Pity that I have so little time and that this city is so big and busy. I count my blessings for this lovely day and top it off with a few beers.

Working man

Thank God it's friday! Only one day of work and then weekend!



Remembering my old routine I enjoy breakfast at the Lake View Cafe. And since my collegues are there it's all happy chitter chatter. The guys allow me to ride with them so I gladly accept. Within 25 minutes we are at the Mumbai 2 office... my god, the road next to Powai lake has improved a lot. In my memory we used to stand in traffic jams all the time. No such thing. One smooth ride that was! So next thing, the mandatory enlistment in the books at the gate and then inside where there is nobody....it's 8:45. I find myself a spot and one by one the teammembers start arriving. It's one big 'happy happy joy joy' party in meeting everybody. Me and the team have a very constructing day and at 18:00 I return to the hotel. Somehow, I was using my voice the wrong way because I felt it starting to break down at times. At night I had planned a visit to the Velvet Lounge but as the interesting invitation of Ravi passed at lunchtime I could not refuse this unique event: to go for a run at Santa Cruz at 6 AM! So I head to bed early and have a hard time catching it...