League Daddy Rosters

[The_Niddler]

I would have to imagine that it would create 2 of every player since if I add one now with the exact same information it adds it as a second player.

But not sure how their import function works. They may have it set to delete everything that is there and then updated with the new information.

[Daw1git]

last time i did it....it created 2 of everyone but need to double check this before putting in this time to fix my roster

[ReignOnU]

And obviously you'd have to reenter your stats if you've played a game and you delete your current players. Always something to consider.

[LytezOut]

I need to have the Maryland roster done. AIM: StrtSweeper757

[The_Niddler]

Reign, I was trying to get Maryland working for LytezOut.

I have it in Excel as a CSV file and also another file still as an excel format.

When I paste either one into a PM and send it to myself, when I copy and paste out of there into leaguedaddy, it is not importing the players.

Walk me through what you are doing different than me. So I can help guys out when they need it to, please.

[huskerskev84]

Yea I finally gave up on all of this and just copied and pasted a roster into excel. Then all I could get transferred over to leaguedaddy were names and position. But it still wasn't that easy, because the first and last name were in the same field and I think put the position in the last field name maybe. All I did was enter the stats and then edit the name for the player needed. Not easy, but way easier then typing the names from scratch. I've got this to work easily before, so was a little frustrating.

[dakshdar]

When I've done this with success in the past (this year worked fine for me), I recall the following being important:

1. Paste the copied data from the online site into a text file first and save it as such (*.txt).

2. Import the txt file into excel being sure to select the proper delimiters (usually you can get it to seperate the first and last names by using either the comma or space delimiter). You also have to be sure to format the date column as a date during the importing process or it will screw it up into a weird number and you'll have a bitch of a time going back to the proper date format.

3. Make sure all your columns look good and are in the order LD asks for. This is tricky as LD shows the single player entry data as:

Name, #, Pos, Height, Weight, Year, DOB

But the import data must be in

#, Name, Pos, Height, Weight, Year, DOB

I usually just skip DOB. All it does is leave the "Age" column blank

Also, look for odd/extra columns caused by someone with a hyphenated name, a Jr, or "III" or whatever.

4. When your columns are done and correct, save as a comma delimited text file. Open that file with wordpad, copy all the lines, and paste into LD.

5. Done.

If the powers that be desire, I could work on this over the next week or two and try to do this for teams that are having trouble or can't get this to work. It only needs to be done once for all the teams for all three seasons we'll play. It does sound like it will require people to re-enter stats if they've already done so for early season games. I think I also have to be given access to the teams that need help. Alternatively I could try to post files for the teams that need it (already delimited), but that is not a great way to work it because if there is an error it will require iterating back and forth, whereas I can fix things quicker working on my own.

Just let me know (powers that be).

[ReignOnU]

I'm going to do Maryland's and walk you through it.

- Copied the file from umterps.com
- Paste Special - Unicode Text into Excel
- Deleted the Hometown Column
- Deleted the Varisty Letters Column
- Highlighted the Hgt column, Format - Cells - Date (used: 3/14)
- Data Sort Column A (numbers... to make sure everyone has one.. just something I do routinely now)
- Data Sort Column F (year... I replace the RS stuff with the year only just for cosmetics purposes, this file didn't have any)
- Data Sort Column C (replace the named positions with abbreviated positions)
- Highlight all columns - Find/Replace apostrophes with nothing (put in a space in the replace and backspace it out to ensure clear)
- Repeat the Find/Replace for Periods.
***Adjusting the names will vary by file, because some have it first name last and some use ",' as dividers.***
- Insert a few blank columns to the right of the name
- Highlight the name column: Data - Text to Columns - Check Delimited - Next - Uncheck Tab, Check Space, Check Treat Consecutive delimiters as one - Next - Check Text - Finish
- Review the column AFTER the last names to make sure no one was broken off, if so, fix it. (none in this case)
- Delete the extra blank columns
- For this one, you need to cut the last name column and insert it before the first name column.
- Double check that you have the right order that LD needs... (I messed up 2 of them, lol)
- File Save As .csv
- Close the file
- Navigate to the file location, select Open With (use right click if you didn't know): select Word
- Highlight all of the text - Find/Replace / with -
- Save
- Copy/Paste into PM/Import box... where ever

Here is my end result for Maryland. This should work. I always send them the disclaimer to send it back to me. I added in a few extra steps (deleting ' for instance) because I found that it was causing hang ups. Let me know if you have any issues with Maryland.

This seems like a lot, but I was pretty detailed with the steps. It really takes me about 5min, including finding the roster on a site. Super easy.

19,Hawkins,Travis,DB,5-10,190,FR
24,Graham,Avery,DB,5-10,195,FR
25,McDougle,Dexter,DB,5-10,200,FR
31,Wilson,Jeremiah,DB,5-10,175,FR
37,Johnson,Jeremiah,DB,6-1,170,FR
38,Till,Titus,DB,6-2,205,FR
39,Kearse,Desmond,DB,6-2,180,FR
40,Robinson,Matt,DB,6-3,220,FR
47,Rowson,Mario,DB,6-3,185,FR
6,Tate,Kenny,DB,6-4,220,JR
16,Green,Anthony,DB,5-11,190,JR
21,Hughes,Trenton,DB,5-11,185,JR
22,Chism,Cameron,DB,5-10,190,JR
25,Haynes,Desmond,DB,5-9,210,JR
29,Walker,Austin,DB,6-1,195,JR
48,Franklin,Eric,DB,6-2,205,SO
2,Perez,Antwine,DB,6-1,210,SR
26,Carter,Michael,DB,5-10,175,SR
27,Brown,Kevin,DB,5-10,170,SR
30,Salvatico,Mike,DB,5-9,190,SR
73,Walker,Alex,DL,6-1,280,FR
41,Whitfield,Marcus,DL,6-3,230,FR
57,Evans,Ian,DL,6-2,245,FR
91,Arnett,DeOnte,DL,6-4,275,FR
93,Monroe,Andre,DL,6-1,280,FR
97,Kilgo,Darius,DL,6-4,285,FR
98,Murphy,Clarence,DL,6-3,240,FR
39,Law,Herbert,DL,6-2,240,JR
44,Drummond,Derek,DL,6-4,245,JR
50,Davidson,Ian,DL,6-3,300,JR
55,Kabongo,Masengo,DL,6-1,275,SO
56,Ross,Isaiah,DL,6-1,260,SO
69,Kerr,Zachariah,DL,6-2,320,SO
72,Vellano,Joe,DL,6-2,285,SO
95,Anderson,Justin,DL,6-5,265,SO
96,Francis,AJ,DL,6-4,295,SO
99,Russell,Carl,DL,6-6,275,SO
15,Gloster,Drew,DL,6-2,255,SR
53,Goree,Lorne,LB,6-1,210,FR
58,Johnson,Bradley,LB,6-1,220,FR
59,Mackall,David,LB,6-3,245,FR
39,Lazerow,Steffan,LB,6-2,230,JR
40,Peterson,Nick,LB,6-2,230,JR
42,Pooler,Ben,LB,6-2,230,JR
9,Hartsfield,Demetrius,LB,6-2,235,SO
45,Murray,Avery,LB,6-1,230,SO
51,Donohue,Ryan,LB,6-1,230,SO
52,Drakeford,Darin,LB,6-1,240,SO
1,Moten,Adrian,LB,6-2,230,SR
33,Wujciak,Alex,LB,6-3,245,SR
32,Schneider,Gary,LS,6-1,200,FR
80,Parcher,Greg,LS,6-3,185,FR
92,Downs,Tim,LS,6-1,230,JR
54,Blue,Cody,OL,6-4,270,FR
58,Cary,Josh,OL,6-5,300,FR
61,Wheeler,Jake,OL,6-9,250,FR
65,Conaboy,Sal,OL,6-5,255,FR
67,White,Pete,OL,6-4,330,FR
73,Garcia,Max,OL,6-5,285,FR
74,Klemm,Nick,OL,6-5,290,FR
79,DeSouza,Pete,OL,6-6,310,FR
60,Rhodes,Chris,OL,6-3,275,JR
77,Gonnella,Andrew,OL,6-5,305,JR
90,Hampton,Maurice,OL,6-2,280,JR
51,Dillon,John,OL,6-2,285,SO
63,Fulper,Bennett,OL,6-4,295,SO
69,Simpson,Jon,OL,6-6,300,SO
75,Gilbert,Justin,OL,6-6,300,SO
76,Dill,RJ,OL,6-7,300,SO
78,Lewis,Justin,OL,6-3,315,SO
71,Pinegar,Paul,OL,6-4,290,SR
43,Ferrara,Nick,K,6-1,200,SO
37,Townsley,Ted,P,6-1,190,SR
35,Baltz,Travis,K,6-3,210,SR
5,OBrien,Danny,QB,6-3,215,FR
14,Burns,Devin,QB,6-2,185,FR
16,Brown,CJ,QB,6-3,195,FR
18,Smith,Tyler,QB,6-3,195,FR
11,Robinson,Jamarr,QB,6-1,195,JR
10,Adams,DJ,RB,5-10,220,FR
46,Moore,Rahsaan,RB,6-2,240,FR
8,Meggett,Davin,RB,5-9,215,JR
32,Brown,Haroon,RB,5-11,260,JR
36,Watson,Taylor,RB,6-2,240,JR
47,Lariviere,Paul,RB,6-1,250,JR
49,Berman,Louis,RB,6-1,230,JR
20,Douglas,Gary,RB,6-1,205,SO
23,Scott,DaRel,RB,5-11,200,SR
86,Stinebaugh,Dave,TE,6-4,240,FR
80,Watson,Lansford,TE,6-4,260,JR
34,Campbell,Devonte,TE,6-2,255,SO
81,Schlothauer,Ryan,TE,6-5,250,SO
89,Furstenburg,Matt,TE,6-4,245,SO
88,Yeatman,Will,TE,6-6,250,SR
84,Fletcher,Alex,WR,5-10,175,FR
4,Tyler,Ronnie,WR,5-9,185,JR
17,McCree,Quintin,WR,6-1,190,JR
82,Smith,Torrey,WR,6-1,200,JR
85,Logan,Tony,WR,5-10,180,JR
87,Dulin,Webb,WR,5-8,175,JR
12,Dorsey,Kevin,WR,6-2,205,SO
13,Boykins,Kerry,WR,6-1,200,SO
42,Powell,Eric,WR,6-1,200,SO
3,Williams,LaQuan,WR,6-1,190,SR
7,Cannon,Adrian,WR,6-2,204,SR
83,Lee-Odai,Emani,WR,6-2,200,SR
88,McQueeney,Joey,WR,5-10,195,SR

[ReignOnU]

FYI - my system does make all 6' tall guys into 6'1 guys... it's the the easiest way short of pills to gain an inch... or so I've heard.

[The_Niddler]

Thanks Reign, I do basically everything that you do, I was just not putting them into Word before putting them into the PM.
So that is where I was messing up and I am on a different version of Excel on my work laptop, so some of the Excel options are different options for me...

But thanks for the info. And I offered to do this for all the teams still needing it too. Like Reign, if I had admin access to leaguedaddy, it would take me just a couple minutes per team as I dont even have to save it as a CSV. Just pasting them right out of excel works when I do them under my team. It puts the proper spacing between each set of data and leaguedaddy accepts it that way.

But it was losing those spaces when I was putting them into a PM and trying to send them.

So thanks again.

If the powers that be desire, I could work on this over the next week or two and try to do this for teams that are having trouble or can't get this to work. It only needs to be done once for all the teams for all three seasons we'll play. It does sound like it will require people to re-enter stats if they've already done so for early season games. I think I also have to be given access to the teams that need help. Alternatively I could try to post files for the teams that need it (already delimited), but that is not a great way to work it because if there is an error it will require iterating back and forth, whereas I can fix things quicker working on my own.

Just let me know (powers that be).

And if AJ or someone wants me to help on leaguedaddy, I am sure between a few of us, if we all had the right access, we could start our own thread and just take certain teams and knock them out in a couple hours.

[BIGmike]

It literally takes 10-20 minutes to either sit down with your laptop in-front of the PS3 and type the rosters in or write them down on a sheet paper and then type them in your computer. I've been doing rosters on LD this way since NCAA 2004.

[ReignOnU]

We're a spoiled society, no doubt.

Niddler - There's something that's not right with admin access, I have it in LD and I still can't do other teams. It's strange. I think you have to be the commish only maybe?

[OracleHCR]

You guys could do the teams that aren't done yet and email them to BigMike, Nole or AJ and they could import them. I don't want to commit them to doing anything more than they already do (which is greatly appreciated) but it is a solution.