Guys,

Apologies for not coming back on this sooner, time is the enemy. I did find a solution if I can call it that and have successfully migrated from AS to Community Social. To get there I ran probably a dozen or so scenarios noting what what worked and what didn't each time. So if you bear with me I'll try and put my notes into something meaningfully and post back here within the week.

Time is still the enemy.

Okay Guys. I don't know how much this will help but will give you some idea of what I did. I have a lot of notes but this is a scenario of the end result. A lot depends on your site position ie. number of Groups and integrated Forums. My site was relatively simple yet it literally took me hundreds of hours of testing. Hope you can get something out of it.

**********
Before running this process the site was at DNN 6.1.5. Active Forums integrated with Active Social
Before running the Migration tool I made the following changes:-

1. I was using the AS Welcome Centre Module in the header on every page. DELETED every instance of the Welcome Centre.

2. Then I looked at My Groups and the Forums attached to thoase Groups. Out of just eight Groups there was just one Group that I needed to retain. And Two Group Forums. Deleted all the Groups and their Forums that were not being kept. Then disconnected the associaltion between the Forumd and the Groups (Remove the integration Keys).

3. Then moved the Forums into the General Forum. The one that was no longer being associated with a Group was moved into a General Forum Group. The other I moved into a new Forum Group titled RV Social Groups. I later set the permissions for this Forum for Members of the new Security Role that was created with the Migration of the Group. (After migration a Group becomes a Role in the Role Group "Social Groups")

NOTE: The Group Migration in my case only ever showed one Group to move. Fortunately it was the one I wanted to keep. It did move however in all the testing there was an option to select Groups but just one was dispalyed.

4. When you are satified that you have all the Group/Forum ducks aligned we can proceed to Upgrade the site from 6.1.5 to 6.2.7

4a. Upgrade AF to 5.0.3

4b. Now the next thing to look at was the Profile Pictures. They don't move but we run the Migration process anyway in case there is some hidden working in there. In the User Profile Setting they are "Profile Pictures" in 6.2.7 they are handle by the "Photos" Property.
The Profile Pics are in - Portals\0\activesocial\profiles\_icons

NOTE: My site has close to 4,000 members and around 1,000 had ever posted a Profile Pic. After the Migration I went through each one and uploaded their Photo from a backup on my Local machine. Did a hundred or more each day. The image number is the User ID (eg. pp_2_150_150.png) pp_2. 2 is the UserID. With a Select query find the Username then Manage the User.

Copy the _icons folder to somewhere (Desktop) and delete all the images from the _icons folder. So there is actually nothing to move.

5. Now that you have upgraded to 6.2.7 set up a new page "Migration" using Dark Knight as per the Migration proceedure. Drop the Migration tool onto it. (Assuming you have installed the extension).

Run the first three proceedures.
a.Move Profile Pictures. (Even though there is nothing there run it anyway)
b.Move Friends
c.Group Migration (Problems if you have more than one)

d. Journal - DON'T RUN THIS. JUST THE FIRST THREE.

6. To see what worked

SET UP DNN Social pages following Bruce Chapmans blog.

http://www.ifinity.com.au/2012/07/31/... .

Now I did this at least 12 times and have many pages of what worked and what didn't. When I looked back over them it was all a bit conveluted. So before doing this on your production site test on a development site.

There was a couple of SQL scipts that I ran as well that I can't seem to find. I'll track them down and add them here.

FROM MY NOTES:

DELETE * FROM ActiveSocial_Groups all AS Groups [Goldstream]

DELETE SocialGroup_Admin, SocialGroup_Member FROM Roles NOTE: Deleted directly on the DB if issues occur retore #17 and delete from the Interface.

UPDATE RoleID 16 in Roles [Goldstream Owners] SET CreatedByUserID = '3201'

SQL SCRIPT Do this to set USER 3201 as Owner of Goldstream

UPDATE [rvsupertramp-615-10-01].[dbo].[ald_UserRoles] Check UserRoleID first
SET [IsOwner] = '0'
WHERE UserRoleID = '7982'
GO
DELETE ID 3,4,5,6,7 FROM RolesSetings

SET in RoleSettings all Group Settings to reflect Owners (See local table)

DELETE Social Groups from RoleGroups

BACKUP - DATABASE POSITION #18

SQL SCRIPT Delete Verification Role Role from all users.

DELETE FROM ald_UserRoles WHERE RoleID = '11'

SQL SCRIPT Delete the User Role Verified Users

DELETE FROM ald_Roles WHERE RoleID = '11'

CREATE new user Tester Six (Tester6; tester6) - Test roles applied.

NEW USER is admitted to the "Unverified uswr" role only.

EXISTING USERS still not able to write on their Journal. Can write on other members Journal. Admins and SuperUsers can write on their journals.

DELETE Profile Settings > Profile Property > asProfilePicture (Active Social) NB. This action will most likely break the Avatars in the Forum. Change Token in Forum templates. to [ProfilePhoto]

This is a lesson that should teach all website entrepreneurs that putting time and money into commercial and closed source products is a waste of time. The day that the software dies will come sooner than later.  Use the open source stuff. Learn to code or hire a programmer to create the special sauce. Each time I have put my trust in a closed source DNN module I have ended up regretting it.  They will disappear. They will have bugs. They don't support future DNN versions. The vendor will be gone. Your users data handled by their code will be almost inaccessible and undocumented.