So we packed our things and went to Uppsala to buy a fishtank and fishes. The kids have been asking for fishes for a very long time and we ourselves wanted some too. We’ve been pretty close a few times but always backed down at the last minute for the very same reason each time and one would think that we would’ve remembered that reason for this time but we didn’t and were close to once again back down. The reason is simple and logical but still easy to forget. The thing is that we want to go in and come home with fishes, but having no tank and needing to buy a tank means that it will take atleast a week to make the right atmosphere for the fishes in the tank. Then we can buy a few, then next week a few more and so forth.

Well, this time we went for it 🙂 We bought a 54l tank, some plants, gravle and some stuff that we need to put in the water. I’ll post some pictures while we’re washing all the gravel and setting it up.

Bumped into an article about the trends that are coming up under 2009 and I must say that most of them seem very very nice. Allthough some of them were already heavly used under 2008 and even under 2007, it’s still nice to see that the ”future” is being kind to them. More PNG transparency will force people to stop using IE6 and that can only count as positive and great! 🙂

The article is divided in two parts and worth the reading.

Part 1
Part 2

wow… does this mean that gamers have a hard time finding dates when using a ”normal” date site?

http://www.game4adate.com/ and to quote their page:
”Game 4 A Date is fun, it’s easy and more importantly, it’s about putting you in touch with people who share that same genuine passion as you do for all things videogames. So go on then, are you Game 4 A Date?”

I don’t know… my first thought is that a person that is VERY much into gaming might need to hook up with someone that can take that person down to earth. Putting two addicts to game together doesn’t really seem like a good idea at all. And if you’re not that much of a gamefreak, then you don’t really need to be on a site that is concentrated on dates for gamefreaks.

The only use could be cross countries perhaps…. some gamer in australia that wants to hook up with a gamer in sweden perhaps…..

But I’m gonna go and do a Simon Cowell and give it a …..

simon-cowell

The new version of EPiServers migration tool is supposed to support user personalization migration to the new enviroment. The good news is that it does migrate all users and generates a new password. The bad news is that it forgets which pages they subscribed too and the interval.

On this project, we also use SubscriptionCategories which basicly sends a newsletter everytime a page is created under that category which of course didn’t get migrated to the new enviroment.

What you need to know is open up a connection to the old database and fill up a datatable with info from tblUserProperty, tblSID and tblUser. You need to bring up the username, email (we use the email as username for all subscribers), interval, categories and which pages they subscribe too. I had to make three different queries to bring up what I needed though, one for the categories, one for the interval and one for the pages. I’m sure that an SQL genius can make it in one call.

Once you’ve filled up your datatable, bind it to a repeater and just print it all out. Might be nice to see it work before you do a full migration atempt. Once in the repeater, I call for the method I made to update the subscription information.

[sourcecode language=’csharp’]
private void UpdateUserSubscription(string user, int page, string categories)
{
EPiServerProfile profile = EPiServerProfile.Get(user);
profile[”SubscribeCategories”] = categories;
profile.SubscriptionInfo.Interval = CheckUserInterval(user);
profile.SubscriptionInfo.SubscribeTo(new PageReference(page));
profile.Save();
}

[/sourcecode]

Basicly, you need to load up the profile you wish to alter and then fill it up with whatever information you need. SubscribeCategories is the custom part of our subscription and the rest is interval and page to subscribe to. Just dont forget to save your profile, otherwise it wont save it to the database. The only time you don’t need to save the profile is if you’re altering the currentuser which is logged in. Then you can call on the methods you like and they will work without save. But when altering users that are not logged in, you’ll always need to save.

It has been a very rough season. Started off awfully and kept it just as bad. It has taken way to many games to try and find the harmony I had last season but it seems like it has arrived. A few wins in a row has pushed us a bit away from the relegation fight and even a mid-table position can be possible to achieve. But with a tiny transfer budget of 1.8 million quid and a few new player that can barely speak english didn’t make things easy 🙂 I’m actually almost running the same team as last season and doing better than with the ones I bought in. Oliver Ouefio has been the best purchase so far since he came as a free agent and now all the big clubs are after him.

Ouefio

And here are just a few of the clubs that whish to purchase him.

picture-4

Here’s the graph of how the season has been. Not the most glamorous but atleast we’re above the surface.

picture-12

And here’s the table. 9 points in the safe zone but a mid-table position would be really great. Maybe next season I’ll get a bit more transfer cash since we’ve been gone positive every month with huge profits.

picture-21

Transfer window is now open and I’m just hoping I can keep my keyplayers.