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.