GROUPTHINK: How do we know that Team ID#1 has the 3.16 pick?

[Ben E Lou]

This has to do with FOF7, but isn't knowledge specific to it, so I thought it might be better dealt with in this sub-forum. I'm trying to determine if this is a bug, or just a way of recording data that I don't understand. I figure if we can figure out how one of these works, all will be unlocked. My team (Atlanta, Team ID#1) owns the 3(16) pick in this draft. In the "Draft Order" section of universe_info.csv, 3(16) is listed as Team#25, which is SF. Ok, fine. I traded last season with SF for their 3rd round pick. So the "Draft Order" section of universe_info.csv is supposed to tell me which team originally owned the pick, it appears.

But then I look at "Draft Pick Owner, This Year" and 3(16) is listed as....15. Hmmmm....Maybe they're not in draft pick order but in team order? So...the entry that is "Draft Pick Owner - This Year,3,25,24"n't seem to help me much either. The fact that the "Draft Pick Owner, This Year" picks are re-ordered like they are leads me to believe that the key is there, but so far I'm missing it. Little help? I've attached the two relevant files. The draftorder.txt is the print screen of the actual draft order. Universe_info.csv is the export from the game. Thoughts?

[cuervo72]

Listed as 25, you mean. My guess is that Jim tracks two things (just as the tracker for FOBL (http://www.thefobl.com/draft/tracker.php) does), the original team ID and the current holder team ID, but is only exporting the former. It's showing SFO as the team id for the 4th round pick of theirs you hold too. Really, both would be useful for us.

[Ben E Lou]

Could be a typo in the post. Check the files for verification. I am on the move today. I just posted that quickly to try to get it resolved because I am trying to update the draft order for my league.

[cuervo72]

Also - that's how the export looks straight from the game? I would rather be without the entire first column, and lines 2-4. They are useful, but for the purpose of importing into a database...well, they make you parse the file with a script to do that, rather than just importing a simple csv. Not a big deal if you have a tool to do it, but someone has to build that tool.

[cuervo72]

Draft Order 3 14 12
Draft Order 3 15 26
Draft Order 3 16 25
Draft Order 3 17 21
Draft Order 3 18 28
Draft Order 3 19 14
Draft Order 3 20 4
Draft Order 3 21 19
Draft Order 3 22 8
Draft Order 3 23 17
Draft Order 3 24 15
Draft Order 3 25 3
Draft Order 3 26 9
Draft Order 3 27 1

[digamma]

more like NERDTHINK, amirite?

[gstelmack]

Just pull up the source code for my utility suite, I had this figured out once upon a time. Current year differs from future year...

[gstelmack]

Okay, looking over the files, I remember now:

The top section (Draft Order) is "which team owns 3(16)?". The bottom section (Draft Pick Owner) is "which team owns team 16's pick?". The bottom section for this year's draft is only useful if you want to do something like "3.16 - SF (from ATL)".

[gstelmack]

Also - that's how the export looks straight from the game? I would rather be without the entire first column, and lines 2-4. They are useful, but for the purpose of importing into a database...well, they make you parse the file with a script to do that, rather than just importing a simple csv. Not a big deal if you have a tool to do it, but someone has to build that tool.

That's similar to how I used to do it with Interrogator. The top few lines (game stage, salary cap, min salary) went in a different file. The Draft bits went in their own.

[Ben E Lou]

Just pull up the source code for my utility suite, I had this figured out once upon a time. Current year differs from future year...Greg, if I had the first clue how to udnerstand your source code, I would have re-written DBUpdater for FOF7 by now. I need more help than that. I'm not remotely a pro at this.

[cuervo72]

Yeah, I am too used to dealing with your exports (and mistakenly thought that the new ones would resemble them). I possibly underestimated how much formatting you had to do. Where I guess we're headed is something like what a tool like StatsLab does for OOTP (or what dbupdater did, I guess), where there's just a package that rips through the csv files. I was probably one of the few holdouts that used an import command to load the csv as it was.

[cuervo72]

(15:25:30) Ben_E_Lou: Draft Pick Owner - This Year,3,26,1
(15:25:37) Ben_E_Lou: you have to subtract 1 from the pick
(15:26:21) Ben_E_Lou: hmmm...or maybe not
((15:28:53) cuervo72: you subtract 1 from the team
(15:29:01) cuervo72: so for this year, there are lines:
(15:29:05) cuervo72: 3 1 0
(15:29:13) cuervo72: er, sorry
(15:29:17) cuervo72: 3 2 1
(15:29:22) cuervo72: 3 26 1
(15:29:37) cuervo72: so round 3, original team (2-1), current team 1
(15:29:49) cuervo72: round 3, original team (26-1), current team 1
(15:29:53) Ben_E_Lou: that's it, cuerv

[Ben E Lou]

Where I guess we're headed is something like what a tool like StatsLab does for OOTP (or what dbupdater did, I guess), where there's just a package that rips through the csv files.This is badly needed.

[flere-imsaho]

I have used spreadsheets more for FOF and FM in the course of my life than I have for work over the course of my career. True story.

[gstelmack]

I have used spreadsheets more for FOF and FM in the course of my life than I have for work over the course of my career. True story.

I can't say I've spent more time coding for FOF than I do for work, but it might be close if I compare the amount of C# coding...

[WheelsVT]

So for the Draft Pick Owner This Year columns the 1st column is the round, second column - 1 is the team's pick in question, and the third column is the team that now owns that pick?

To modify a line from Robin Hood, "why a -1 cousin?" "Because it's confusing you twit, it'll hurt more."

[cuervo72]

My only guess is that that field couldn't be zero for some reason and that the +1 was so Arizona (0) wouldn't break anything.

[WheelsVT]

But it's an export, not something used by the game. Why not just do the minus one while writing the file so it makes sense outside the code?