StelmackSoft FOF2k7 Utility Suite

[flair1234]

I get the following error when I try to upload my draft order:


Parse error: syntax error, unexpected '(', expecting '}' in /homepages/35/d108269658/htdocs/pfl/draft/import_draft_order_run.php on line 80

[Ben E Lou]

I haven't used Interrogator in a long time, but I'm trying to set up a web site for a league that started in the FOF2K4 era. Is there some trick that I've forgotten to making playergamestats.csv spit out all seasons instead of just one? I don't recall having to do it one season at a time, but it's only spitting out the current season right now.

[gstelmack]

Originally Posted by Ben E Lou

I haven't used Interrogator in a long time, but I'm trying to set up a web site for a league that started in the FOF2K4 era. Is there some trick that I've forgotten to making playergamestats.csv spit out all seasons instead of just one? I don't recall having to do it one season at a time, but it's only spitting out the current season right now.

Look over on the right. There is a checkbox for "Process from Season", and a textbox below. By default the box is checked and the textbox has the current season. Uncheck the box to get everything (and go take a nap for a mature league), or set the season to an appropriate point.

[Ben E Lou]

I was doing that. It turned out that I didn't have all of the right files in the leagues folder.

[Erik Holland]

Guys,

Is it possible to import the priority list from the DraftAnalyser into the Draft Conscripter?

If i export to .csv and try to import that file there are no players updated.

Thanks!

[gstelmack]

The latest Draft Analyzer and the latest Conscripter should support that feature. Make sure you have the Draft Order column correct in Analyzer, and make sure you are using the correct import function in Conscripter.

[Erik Holland]

Thanks, didn't see you had a new version.

[jley618]

Please help.

Ok, I have the latest Extractor, and Draft Analyzer. One of the leagues I'm in is using 1.28.5 version of Conscriptor, which only has the import extractor file option.

I ran extractor over the draft class. Opened that file in Draft Analyzer, and massaged the data, and now have a good order. Can I now import that order into Conscriptor as my priority list of players?

Thanks!

[gstelmack]

No, you need the 1.28.7 version of Conscriptor to do that.

[aston217]

How does one generate DraftOrder.csv?

Is it 'Export Draftees'?

What does this do? Put all 'marked' players into the queue in Conscriptor?

[gstelmack]

Originally Posted by aston217

How does one generate DraftOrder.csv?

Is it 'Export Draftees'?

What does this do? Put all 'marked' players into the queue in Conscriptor?

Not quite. That one is useful for transferring players marked as drafted between instances of Analyzer. In the good ol' days, with live drafts in my office league, I could send that file out as the AI made picks. Nowadays with online draft utilities, it is mostly useful for running Analyzer on multiple machines and keeping them up to date.

You want the latest version of Draft Analyzer, and use "Export Draft Order (Conscriptor)". If you don't have the latest version, that option won't exist for you.

And what this does is take the 100 players using the "Draft Order" column (far right) and export them to that CSV, which you then import using the latest version of Conscriptor. There are many tools in Analyzer for manipulating the Draft Order column.

[Ben E Lou]

Minor annoyance with Extender: if you run the Career bit after the regular season is over, the "Best Seasons" piece of it does not include the current season. It doesn't pick that up until after you end season.

[gstelmack]

Originally Posted by Ben E Lou

Minor annoyance with Extender: if you run the Career bit after the regular season is over, the "Best Seasons" piece of it does not include the current season. It doesn't pick that up until after you end season.

I have a vague recollection that that is correct. I can't remember if that was going to be an easy fix, or far more difficult because the current season isn't in the stats files. I'll need to look into it.

[gstelmack]

• Extender now picks up the current season for "Best Seasons" awards.
• New utility: Check Paths. Displays the 3 paths critical to the Utility Suite: where FOF is installed, where FOF saves its games, and where the Utility Suite saves its data. Clicking any of the 3 buttons opens an Explorer window in that directory.

Ben, Terry Fulton's 2026 WOOF season shows up now, but let me know if you find other issues.

That new utility may be useful even if the suite doesn't have troubles finding things, since it can open any of those directories directly.

[Ben E Lou]

Originally Posted by gstelmack

• Extender now picks up the current season for "Best Seasons" awards.
• New utility: Check Paths. Displays the 3 paths critical to the Utility Suite: where FOF is installed, where FOF saves its games, and where the Utility Suite saves its data. Clicking any of the 3 buttons opens an Explorer window in that directory.

Ben, Terry Fulton's 2026 WOOF season shows up now, but let me know if you find other issues.

I didn't think about it and haven't checked for it, but I wonder if "Best Rookie Season" has the same issue.

That new utility may be useful even if the suite doesn't have troubles finding things, since it can open any of those directories directly.

Very much so. That's a nice time-saver. Thanks!

[Dutch]

Sweet! Love the path check utility, great idea!

[gstelmack]

Originally Posted by Ben E Lou

I didn't think about it and haven't checked for it, but I wonder if "Best Rookie Season" has the same issue.

If it does, it should still be fixed. Current season data wasn't being put in the data structure used to check for "best season" bits.

[Hoya1]

silly question, as I'm assuming I'm likely the only guy with this condition.

I formatted my laptop, re-installed the Utility suite and FOF. since this point, I couldn't get the Utility suite to register any of my saved game files. Not a huge deal as I'm able to utilize on my desktop.
I just recently updated to the latest version and thought I'd check out the file path utility. My FOF Install Path is blank. When I click on it to manually find it, the app crashes.

I'm running Vista 64bit. Again, not a huge deal as I can utilize my desktop for anything which requires the Utility suite to parse game data

these are the crash details

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: Cannot start process because a file name has not been provided.
at System.Diagnostics.Process.Start()
at System.Diagnostics.Process.Start(ProcessStartInfo startInfo)
at System.Diagnostics.Process.Start(String fileName)
at CheckPaths.CheckPathsForm.buttonFOFInstallPath_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4206 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
CheckPaths
Assembly Version: 1.9.8.0
Win32 Version: 1.9.8.0
CodeBase: file:///C:/Program%20Files%20(x86)/StelmackSoft/FOF2k7%20Utility%20Suite/CheckPaths.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4205 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0

[Hoya1]

going to try and download .net framework 4

[gstelmack]

I'm not surprised that it crashes if the path is blank. The big question is why is it blank. I'll have to look into some options there. In the meantime, you can try using the FOFPath.txt trick from earlier in this thread.

[Hoya1]

Originally Posted by gstelmack

I'm not surprised that it crashes if the path is blank. The big question is why is it blank. I'll have to look into some options there. In the meantime, you can try using the FOFPath.txt trick from earlier in this thread.

I had actually tried that earlier and it did not work. It's something that I believe I must have done. Before formatting, I had the utility suite and FOF installed and with no issues.

I will maybe un-install and re-install FOF.

edit
re-install of FOF didn't help either. this is strange.

[Ben E Lou]

Feature request for Analyzer: a way to more accurately weight no-combine players against the rest of the class. I'm thinking...

1. Remove the weights on the apparent 0*40yarddash type calculations for the combines you can't see, and only use the ones you can see. (Note that some players at the same positions will have position drills, while others won't.) In other words, if I have it weighted for WR...

5--sol
9--40
8--bench
8--agl
2--brj
4--posdrl

That's a total of 36. Assume you can only see sol and posdrl for the no-combine WR. 9 "ratings points" are used by me there, so multiply just those two combines by 4 to get the combine score (20 sol, 16 posdrl). And then...


2. Give the user another pair of bar vs. combine boxes for no-combine players. I'd want to weight bars much higher than combines for no-combine guys.

[Bisbo]

When I try to run extractor (latest version) it won't begin to process the open player card, and then freezes - any suggestions?

[Yoda]

Help please:
Querying historical players...Updating historical players... Exception Hit, aborted!
NHibernate.ADOException: could not insert: [DBUpdater.Tables.FofPlayerhistorical#24983][SQL: INSERT INTO fof_playerhistorical (Position, LastName, FirstName, NickName, Experience, Height, Weight, InHallOfFame, HallOfFameYear, HallOfFameVote, BirthYear, BirthMonth, BirthDay, College, DraftRound, DraftPick, HomeTown, DraftedBy, YearDraft, YearRetired, PoG, Rings, PoWMentions, PoWWins, FourQHero, QBWins, QBLosses, QBTies, ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] ---> MySql.Data.MySqlClient.MySqlException: Duplicate entry '24983' for key 'PRIMARY'
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd)
at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)
--- End of inner exception stack trace ---
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Object obj, ISessionImplementor session)
at NHibernate.Impl.ScheduledInsertion.Execute()
at NHibernate.Impl.SessionImpl.Execute(IExecutable executable)
at NHibernate.Impl.SessionImpl.ExecuteAll(IList list)
at NHibernate.Impl.SessionImpl.Execute()
at NHibernate.Impl.SessionImpl.Flush()
at NHibernate.Transaction.AdoTransaction.Commit()
at DBUpdater.DBUpdaterForm.DoPlayerHistoricalUpdates()
at DBUpdater.DBUpdaterForm.RunUpdate()
MySql.Data.MySqlClient.MySqlException: Duplicate entry '24983' for key 'PRIMARY'
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at NHibernate.Impl.BatcherImpl.ExecuteNonQuery(IDbCommand cmd)
at NHibernate.Impl.NonBatchingBatcher.AddToBatch(IExpectation expectation)
at NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object id, Object[] fields, Boolean[] notNull, Int32 j, SqlCommandInfo sql, Object obj, ISessionImplementor session)
DB connection closed.
Finished!
Run Time: 1min 56sec

[Yoda]

Do I just delete record 24983 and re-run the DBU?

[gstelmack]

Probably, although I'd be a bit worried about the state of data / database that it thinks it needs to add that player as a new one and not just update him. You didn't have to redo a stage or something did you?

Also you may need to remove more than him, I wouldn't be surprised to see a slew of errors depending on what went wrong (like all rookies or something).

[Yoda]

No, I didn't redo anything.

[Yoda]

Any other ideas on what to do then?

[gstelmack]

If it's going to re-add him, you should be able to just delete him. It may only be the one record. If you get a cascade, though, something is really off between the database and the game data.

[Yoda]

I deleted the record and it updated fine.

[3ric]

Greg, what do I need to delete to restore the playergamestats rows for one single week? I'm having this problem on my site where DBupdater probably couldn't complete all inserts for that week, which means several players are missing entries.

[Ben E Lou]

Do you have mysql query browser installed, 3ric? If so, you can just

DELETE FROM fof_playergamestats where year=(select curyear from fof_gameinfo) and week=(select week-1 from fof_gameinfo)

[Ben E Lou]

Actually, come to think about it, you know enough php to do this. Even if you don't have MySQL Query Browser, you can just create a quick page that does that query and point it to your db on my server.

[3ric]

No, I have the query browser, and I thought of it myself. Thing is, it doesn't work, and I think it's because we're in week 11, and it's week 7 which is missing the data. Just deleting the week 7 playergamestats isn't enough.

[3ric]

OK, deleting playergamestats for week 7-11 seemed to do the trick, DBUpdater has been working at it for quite a while now.

[gstelmack]

1.9.9 (April 29, 2011): Download

• Draft Analyzer now remembers the order players were picked in when doing "Mark Drafted" if that info is available, and places it in the CSV if you export the data.
• Draft Analyzer now lets you specify different Bars and Combines global weights for players that did not attend the combine. For these players, only Solecismic and, if available, Position Drill will be used to determine their combine score when combined with this new weight. The Bars weight works normally, you can just weight it differently for the no combine guys.
• Extractor allows you to specify what file to write the data to if you don't like the default FOFRoster.csv setting.
• DBUpdater now writes a new table named "fof_futuredrafts" with the same content as the "GameDrafts" table output by Interrogator. This tells you who owns future picks. Note that this does not contain an actual order, but rather it's a mapping of who owns each team's pick in the upcoming 3-4 seasons.

[Yoda]

Originally Posted by gstelmack

Extractor allows you to specify what file to write the data to if you don't like the default FOFRoster.csv setting.

[whomario]

i just reinstalled FOF a couple days ago, then installed your new magic-pack: can´t get the resource-patcher to work, crashes when i try to put in the FOFexe path (right when i click the button)

any ideas ? Am on Windows 7 64 bit

edit : when using the path checker, the column for the install stays empty and when i click it it crashes as well. The game works though and IS installed ...

[gstelmack]

Try the instructions here:

http://operationsports.com/fofc/showpost.php?p=2425992&postcount=1186

to force a path. It can't find the FOF installation path for some reason.

[gstelmack]

Questions for the next version of DraftAnalyzer. I'm finally collecting some of the additional conventional wisdom and adding it in. For example:



Here you can see masked pairs linked on the right, and Punishing Hitter marked with a green background to show that it is a bar that is rarely if ever masked for that position.

I'm not sure where else to go from here, though. One option is to add some searches / sorts to bubble some of these key unmasked bars to the top. For example, "bring all TEs with a Big Play Receiving > 50 to the top", or "all QBs with Sense Rush > 50 to the top", or maybe instead I should just have a "sort by bar X" to cover all these cases which has been asked for quite some time (that's a bit of a nasty feature to get back in, but what the heck). Is there any other "conventional wisdom" that folks can think of a way to get in here? Does the presentation above look good for those features? Any other specific ideas or suggestions?

[gstelmack]

Originally Posted by gstelmack

or maybe instead I should just have a "sort by bar X" to cover all these cases which has been asked for quite some time (that's a bit of a nasty feature to get back in, but what the heck).

Or maybe I just needed to put my mind to it. Done for the next version.

Other suggestions remain welcome. I think we could do a lot with some the lessons learned out there, I'm really just not quite sure how to apply them within this tool.

[gstelmack]

1.9.10 (May 3, 2011): Download

• DraftAnalyzer now lets you show the individual calculated combine ratings that are summed to generate the global combine rating in addition to the raw scores and the standard deviations. This should help with tweaking weights, or with filtering out guys with low combine scores that don't matter much to you.
• DraftAnalyzer now allows you to sort by any bar from the View menu.
• DraftAnalyzer now connects "masked pairs" bars.
• DraftAnalyzer now highlights bars that are believed to rarely be masked with a green background.
• DraftAnalyzer now has buttons to reset all position weights (how impoitant each position is) to FOF defaults, or to all 1s.

I don't promise I'm accurate on the masked pairs or rarely-masked bars, feel free to send me corrections.

[Hoya1]

anyone else have any issues with this utility not being able to identify the FOF install directory? This area is left blank and then when I click this block, the app crashes.

My gut feeling is that there is something wrong with my elicense. Have this issue on my laptop which I formatted and had to recently re-install. My desktop was fine. I just bought a new desktop and tried to unlicense the game on my old one and it errored out....error 31. I contacted support and was told that this is something on their end. I took the liberty to try and download the game and test my luck to try to validate with my same license. It worked! I downloaded the utility suite and click the install paths....the install path is blank again. I click it and it crashes.
will hopefully have this resolved with elicense and see if this helps anything


EDIT
forgot to add the FOFpath.txt fix and that seemed to work. we'll see what happens with the elicense issue in the next few days

[scorp]

I've been running an older version of the draft analyzer, it appears, downloaded the new version last night, nice job on all the improvements.

One question, what are the white lines I see? Some in the bars, some next to the bars, and some far from them they have to mean something.

[gstelmack]

Originally Posted by scorp

I've been running an older version of the draft analyzer, it appears, downloaded the new version last night, nice job on all the improvements.

One question, what are the white lines I see? Some in the bars, some next to the bars, and some far from them they have to mean something.

They are a very, very, very, very, very, very, very rough approximation to where the bar MIGHT be based on combines. Don't look at the absolute placement, but focus on relative placement. It's a quick at-a-glance "hey, his bench press says he should have a high blocking strength, but the blocking strength bar is really low" kind of stuff, not "hey, his bench press says his blocking strength bar should be 85, but the bar is only at 82, woohoo creeping 3 points!" kind of stuff.

[scorp]

Ok, Thank you sir.

[dwardzala]

I just updated and installed these on a new computer (win 7).

Several of the windows in analyzer are just a bit too short and cut off part of the last button or input fields (cancel button on weights and defensive back leader birthday)

I am running 1920 x 1080 resolution. Any way to fix this?

[scorp]

The analyzer uses just the comb/bars ratios for players who have combine scores, and the other info height weight etc for non combine players?

I have been playing around with the DA alot lately on a past draft, I have several OL and DL guys showing up very high and changing bar weights does not seem to move them.
These players are not that good and have 400 or so org. draft order ratings.

Am I missing something in DA to help weed these guys out ?

[gstelmack]

Originally Posted by dwardzala

I just updated and installed these on a new computer (win 7).

Several of the windows in analyzer are just a bit too short and cut off part of the last button or input fields (cancel button on weights and defensive back leader birthday)

I am running 1920 x 1080 resolution. Any way to fix this?

You must have your font size cranked up. Either the desktop DPI setting, or the font size setting. I run the same res for development and Analyzer takes up maybe 3/4 of the screen.

[dwardzala]

Originally Posted by gstelmack

You must have your font size cranked up. Either the desktop DPI setting, or the font size setting. I run the same res for development and Analyzer takes up maybe 3/4 of the screen.

I'll check the font size, but its not analyzer itself, its only the pop ups for editing chemistry dates and combine/bar weights.