Discussion Board
Welcome Guest! You can login or register. Login or Register.

Options
Go to last post Go to first unread
Zero2Cool  
#1 Posted : Monday, May 16, 2011 1:41:13 PM(UTC)
Thank you to all who registered and posted and provided help. In the next coming weeks to months the transition to the new site will be completed.


It was far more difficult than probably worth, but I have all of the members from here imported over and ready to authorize their accounts with the new PackersHome. I'll write up a doc on how to do that next week.

The DotNetNuke (main CMS framework) took to the new members flawlessly with the module I hacked. The YAF (YetAnotherForum) software however took each member and put them in alphabetical order and assigned them the wrong UserId. What does this mean to you? Well, each post is tied to a UserId and if that UserId is wrong, the post will appear to have been made by someone else.

The issue with this is the UserId field is an auto identify field and I'm having trouble figuring out how to update said field. Once that's figure out, I'll be able to import the topics and then the posts.

The forum categories have been created successfully as well. I had to re-identify them which is why the site was down yesterday for a few hours.


Anyhooters ...

I'm leaving Thursday after work for Green Bay, WI to bring Keiana to her mother's for the summer. This means, I probably won't be touching the new website until I get back sometime late next week.

Today, we'll probably have movie night.
Tuesday, hit Buffalo Wild Wings then watch the two NCIS finales
Wednesday, getting our hair(s) cut
Thursday, driving to Wisconsin


I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.
vikesrule  
#2 Posted : Monday, May 16, 2011 4:20:35 PM(UTC)
" said: Go to Quoted Post
...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.
Zero2Cool  
#3 Posted : Monday, May 16, 2011 4:30:23 PM(UTC)
" said: Go to Quoted Post
" said: Go to Quoted Post
...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.


Definitely, however, she's 9 and is already wanting to play with her friends because "Daddy, I won't see them ALL summer long!!". LoL

We had a lot of fun over the weekend.
vikesrule  
#4 Posted : Monday, May 16, 2011 6:59:17 PM(UTC)
" said: Go to Quoted Post
" said: Go to Quoted Post
" said: Go to Quoted Post
...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.


Definitely, however, she's 9 and is already wanting to play with her friends because "Daddy, I won't see them ALL summer long!!". LoL

We had a lot of fun over the weekend.


Dang...she's 9? I was still thinking of your daughter as being about 6 years old.
Time flies.....and I can understand her and the friends thing.

You're doing fine......carry on. :icon_smile:
68md  
#5 Posted : Monday, May 16, 2011 8:37:16 PM(UTC)
" said: Go to Quoted Post
" said: Go to Quoted Post
...I might have time, but I'm thinking any free time we'll end up killing with watching movies or what not.


Just chill on the site Z2C....spend time with your daughter!
The site will go on or not, whatever.... but your daughter is growing up and before you know it, she'l be grown.


Second that ! As slow as things are in the NFL period...enjoy your family and a sometime around titletown. :thumbleft:
Zero2Cool  
#6 Posted : Monday, May 16, 2011 11:26:25 PM(UTC)
It's crazy, in a few months, she's gonna be 10. I definitely am not robbing time from her for anything. Usually the site steals sleep time, lol.
Pack93z  
#7 Posted : Tuesday, May 17, 2011 1:26:23 PM(UTC)
Hmmm... can't seem to log into the new environment.. can't even resend a password..
Zero2Cool  
#8 Posted : Tuesday, May 17, 2011 1:43:41 PM(UTC)
" said: Go to Quoted Post
Hmmm... can't seem to log into the new environment.. can't even resend a password..


That's good, I've asked everyone to keep away. If someone logs in and makes a post, it'll ruin the structure, at least, until I figure out how the heck to get the userid's to match between DNN and YAF.

The DNN to YAF user importer put all of the DNN users in alphabetical order, then imported them. So now all the userid's are wrong. Just my friggin luck.


Code:

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%order by user%'







Shawn, would you be able to make a backup of the database and upload it for me? I can't access it from work via management studio. I have to go through the stored procedures and find which one is doing the alphabetizing and comment it out and then redo a mass user import once again.
Zero2Cool  
#9 Posted : Tuesday, May 17, 2011 1:59:21 PM(UTC)
Code:
sp_helptext 'GetUsersByUserName'
Zero2Cool  
#10 Posted : Tuesday, May 17, 2011 4:26:44 PM(UTC)
Stupid ass Guest account in YAF is screwing shit up.

Work around..
Current Site, merge Zero2Cool and SlickVision, keep SlickVision UserID of 4 to avoid offsetting every UserID by 1 when imported to YAF.

Prior to DNN user import, add UserID 3 with bogus values.

This will maintain UserID integrity for topics and posts import.
Methodikal  
#11 Posted : Wednesday, May 18, 2011 9:26:06 PM(UTC)
Okay, I think we're back up?
Zero2Cool  
#12 Posted : Wednesday, May 18, 2011 9:48:20 PM(UTC)
Pretty neat how it's showing the OLDEST topics first. Obviously, a lot of kinks to work through. :sigh:
Zero2Cool  
#13 Posted : Wednesday, May 18, 2011 10:21:13 PM(UTC)
Zero2Cool said: Go to Quoted Post
Pretty neat how it's showing the OLDEST topics first. Obviously, a lot of kinks to work through. :sigh:


There are several oddities with the new software because of the hasty import. The main one you'll notice aside from the above quote, is many posts lost their "structure". It was pretty difficult to grab the data properly and then import it while maintaining said structure. (i just noticed IE9 there's no spell check on here) ... anyhow ... the good news since everything is set up, I can simple turn my INSERT into and UPDATE after I figure out how to retain the proper post/message structure.

The other side is gone and that was taken out of my hands so I know most will hate this platform, but I am confident over the coming weeks and months I'll morph it into something you'll be glad to browse to.

vikesrule  
#14 Posted : Thursday, May 19, 2011 12:33:37 AM(UTC)
Zero2Cool said: Go to Quoted Post
There are several oddities with the new software because of the hasty import. The main one you'll notice aside from the above quote, is many posts lost their "structure". It was pretty difficult to grab the data properly and then import it while maintaining said structure. (i just noticed IE9 there's no spell check on here) ... anyhow ... the good news since everything is set up, I can simple turn my INSERT into and UPDATE after I figure out how to retain the proper post/message structure.

The other side is gone and that was taken out of my hands so I know most will hate this platform, but I am confident over the coming weeks and months I'll morph it into something you'll be glad to browse to.



I must say Kevin, you "busted your butt" on this one. Your last minute scrambling and hard work....most impressive indeed.
I am sure that people would have survived for a few more days/weeks, but I know what this site means to you, so...well done, well done indeed!

I make it a policy to never hire cheeseheads....but I would hire you :)
4PackGirl  
#15 Posted : Thursday, May 19, 2011 4:31:03 AM(UTC)
wow - gotta check this place out for awhile & get used to things. great job, kev. :)
rabidgopher04  
#16 Posted : Thursday, May 19, 2011 4:39:18 AM(UTC)
Quick reply gives me an error about an object.

Great job, Kevin. Thanks for all the work you have done and maintaining a great site!
Pack93z  
#17 Posted : Thursday, May 19, 2011 5:17:00 AM(UTC)
Was able to use quick reply in a YAF newly created thread.. maybe it errors only on imported threads. Need Help Thread.
68md  
#18 Posted : Thursday, May 19, 2011 5:56:43 AM(UTC)
I am in ...Looks great !
Rss Feed
Users browsing this topic
Guest
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error

Fan Shout
Zero2Cool (18-Jun) : Tiger?
gbguy20 (18-Jun) : hot wife and he chases old women
Nonstopdrivel (18-Jun) : Oh, and one count of felony first-degree burglary.
Nonstopdrivel (18-Jun) : He's also charged with at least one count on kidnapping and two counts of attempted rape.
nerdmann (18-Jun) : Yeah, wtf Kellen?
Nonstopdrivel (18-Jun) : Kellen Winslow accused of raping and sexually assaulting several women between the ages of 54 and 86.
Zero2Cool (15-Jun) : Today's Birthdays: Toddy (26)
Cheesey (11-Jun) : Thanks Kevin.
Cheesey (11-Jun) : Ok.
Zero2Cool (11-Jun) : Alan, it's an online stream.
Zero2Cool (11-Jun) : McCarthy speaks at 10am, so probably 11am for practice start.
Zero2Cool (11-Jun) : McCarthy speaks at 10am, so probably 11am for practice start.
Cheesey (11-Jun) : I don’t know if I can get that station.
Zero2Cool (11-Jun) : Listen to 107.5 the fan they'll tell you. I'm at airport.
Cheesey (11-Jun) : Thanks for trying WPR! I guess I’ll have to just wing it.
wpr (11-Jun) : Cheesey, The Packer's site says Nitschke Field. 12 am to 11:59 pm. I don't think they know
Cheesey (11-Jun) : Come on!! U smart guys can help me on this!
Cheesey (11-Jun) : Do any of you know what time the Packers mini camp practice is tomorrow?
Zero2Cool (11-Jun) : Vince Lombardi would have been 105 today
Zero2Cool (11-Jun) : If I were Owens, after reading what some of the voters have said. I'd say F YOU too. Shady process.
Zero2Cool (11-Jun) : Apparently it costs the inductees a LOT of money to attend.
beast (10-Jun) : Or if Owens is avoiding all HoF activity? Or if he's trying to figure a way to make money off this. Simply saying he's not going to be there doesn't tell me enough
beast (10-Jun) : I feel as if I need more details. Owens said he's not physical showing up, but he could still give a speech via video.
Zero2Cool (9-Jun) : Using 32 reporter votes is wrong.
Zero2Cool (9-Jun) : They held grudges against him, and ignored his excellence on the field. Bogus shit. Political garbage.
Zero2Cool (9-Jun) : Owens has a point. Absolutely garbage how voters acted, and have responded.
buckeyepackfan (9-Jun) : The HOF needs to conveniently forget to include Owen's in the ceremonies, then fake apologize after.
gbguy20 (8-Jun) : Kevin, suggestion box. move the applaud button to the bottom of the post so i don't have to scroll back up after reading a good post. same goes for quote button i suppose
Cheesey (7-Jun) : Well...I wonder what HE is protesting. Maybe that he made WAY too much money?
Nonstopdrivel (7-Jun) : Wait, what? He bitches for years about not having been selected, and now he won't attend the ceremony?
Zero2Cool (7-Jun) : Hall of Fame announces that Terrell Owens has informed them he will NOT attend the enshrinement ceremony in August.
Nonstopdrivel (5-Jun) : Looking at some of the multiyear rookie UDFA contracts made me think of it. But now I see it's standard to sign them for three years.
packerfanoutwest (4-Jun) : Tavais or Tyrell,,,what's your question/point and why?
Nonstopdrivel (3-Jun) : Probably I was thinking about Tyrell Sutton (Northwestern -- went to the Panthers).
Nonstopdrivel (3-Jun) : Apparently, I'm full of shit. The amount of money teams are allowed to spend on UDFA signing bonuses is extremely small.
Please sign in to use Fan Shout
2018 Packers Schedule
Sunday, Sep 9 @ 7:20 PM
BEARS
Sunday, Sep 16 @ 12:00 PM
VIKINGS
Sunday, Sep 23 @ 12:00 PM
Redskins
Sunday, Sep 30 @ 12:00 PM
BILLS
Sunday, Oct 7 @ 12:00 PM
Lions
Monday, Oct 15 @ 7:15 PM
49ERS
Sunday, Oct 28 @ 3:25 PM
Rams
Sunday, Nov 4 @ 7:20 PM
Patriots
Sunday, Nov 11 @ 12:00 PM
DOLPHINS
Thursday, Nov 15 @ 7:20 PM
Seahawks
Sunday, Nov 25 @ 7:20 PM
Vikings
Sunday, Dec 2 @ 12:00 PM
CARDINALS
Sunday, Dec 9 @ 12:00 PM
FALCONS
Sunday, Dec 16 @ 12:00 PM
Bears
Sunday, Dec 23 @ 12:00 PM
Jets
Sunday, Dec 30 @ 12:00 PM
LIONS
Think About It
Think About It
Recent Topics
4h / Green Bay Packers Talk / nerdmann

8h / Fantasy Sports Talk / Smokey

18-Jun / Green Bay Packers Talk / Cheesey

18-Jun / Around The NFL / Nonstopdrivel

16-Jun / Green Bay Packers Talk / Cheesey

16-Jun / Green Bay Packers Talk / Cheesey

16-Jun / Random Babble / Cheesey

15-Jun / Green Bay Packers Talk / nerdmann

15-Jun / Green Bay Packers Talk / blueleopard

15-Jun / Green Bay Packers Talk / beast

14-Jun / Green Bay Packers Talk / Cheesey

13-Jun / Random Babble / wpr

13-Jun / Green Bay Packers Talk / TheKanataThrilla

12-Jun / Random Babble / CFB Risk

12-Jun / Random Babble / Cheesey

Headlines