StelmackSoft FOF2k7 Utility Suite

[PhinsFan]

Many Many thanks Greg for the GP Analyzer and all the utilities for that matter. The GP analyzer will help me alot since I'm new to the game and want to improve GP. Awesome work, thanks again.

[gstelmack]

Originally Posted by isaccoubaldi

Greg, I like to know if is possible to limit only to a single (or a set of) game the data collecting?
For example instead of an entire season if I change something in the gameplan during the season and I want to study the results of this changes ...

No, right now it's all season. I could look into something like this, but keep in mind sample size is an issue as well. Make a change and a game or two may not show you all that much.

[isaccoubaldi]

Originally Posted by gstelmack

No, right now it's all season. I could look into something like this, but keep in mind sample size is an issue as well. Make a change and a game or two may not show you all that much.

Thanks for the reply. By the way the utility is really great!!

[Higgs44]

GP analyzer wont work for me. When I try to open it it gives me an error message and shuts down. All other features work, draft analyzer, etc.. Ive tried uninstalling and reinstalling, still no luck.

Im on XP

[gstelmack]

I need to know what the error message is for me to be able to help.

[Higgs44]

Originally Posted by gstelmack

I need to know what the error message is for me to be able to help.

GamePlanAnalyzer encountered a problem and needs to close. We are sorry for the inconvenience.

Then it gives me the option to send error report to microsoft.

Error signature:
EventType: clr20r3 P1: gameplananalyzer.exe P2: 2.0.1.0
P3: 4df92bfb P4: mscorlib P5: 2.0.0.0 p6: 4d352e63 P7: 344a
P8: d8 P9: system.io.filenotfoundexception

[Higgs44]

Found this and it worked....

What I did for XP was this: (I IMd Zullo... he is really smart)

1. Goto c:\Documents and Settings\user\My Documents\Stelmacksoft\utilitysuite

2. Right click and select New, then text document.

3. On line 1 of the text document write in your install path... mine looks like this:
C:\Program Files\Solecismic Software\Front Office Football 2007

4. On line 2 of the text document, write the path to where your data is stored. Mine looks like this: C:\Documents and Settings\USER\Application Data\Solecismic Software\Front Office Football 2007

5. Save the file as FOFPATH.

6. Try to open the analyzer again.

Note in the two paths "User" is probably your name. I just changed the name to "user" in these instructions.

[gstelmack]

That's the sort of thing CheckPaths is there for, and that question has been asked and answered three times in this thread over the last couple of days.

On a different note, I did find a case where the utilities that work with the new stats (Interrogator, Extender, GameplanAnalyzer, DBUpdater) could crash when run on really old seasons where games were played with guys that are no longer in FOF's data. Will be fixed in the next version.

[gstelmack]

2.0.2 (June 19, 2011): Download

• GamePlan Analyzer now has completion percentage, interceptions, and interception percentage on the team offense / defense stat pages.
• New stats available across all appropriate utilities:
  • TotalFieldPositionAfterKickoff (replaces AverageFieldPositionAfterKickoff)
  • OffensivePassPlays
  • OffensiveRunPlays
  • DefensivePassPlays
  • DefensiveRunPlays
  • SuccessfulPasses
  • SuccessfulCatches
  • SuccessfulRuns
  • BadPassesCaught
• Extender will now output all of the recent new stats in addition to the above in its CSV output. If you want to use these stats in your weights, add new rows for each one, using the column name you see in the stat output CSV as the field name at the start of the row in the weights CSV.
• Extender is now better about telling you what it is doing.
• Fixed issue with tackle for loss awarding in incorrect cases.
• Kneeldowns no longer counted as runs for stats.
• Reverses removed as possible run directions. I was wrong on how these were reported, and since they are the primary way receivers gain rushing stats (and I'm pretty sure that a receiver carrying the ball is how you know it's a reverse), I've just pulled those directions from the stat outputs.

[Ben E Lou]

Thanks! Looking forward to coding against this stuff, probably this week.

[thenewchuckd]

For the gameplan analyzer, would it be possible to only look at data from the 1st half, before the two minute warning? (or possibly other time of game restrictions). That's sort of how I analyzed people's game plans in the past... Because you never know at what time of the game they will start to make adjustments based on the score.

This is a very powerful and time saving tool, by the way.

[kuykenda]

Thanks for adding the completion percentage! Program looks great!

[gstelmack]

Originally Posted by thenewchuckd

For the gameplan analyzer, would it be possible to only look at data from the 1st half, before the two minute warning? (or possibly other time of game restrictions). That's sort of how I analyzed people's game plans in the past... Because you never know at what time of the game they will start to make adjustments based on the score.

I've been thinking about this and how I might want to do it, yes.

[kuykenda]

Hea Stelmack. I was hoping you could add defensive formations to the "Team Defense" tab. "Rush Versus Defensive Coverage" and "Pass Versus Defensive Coverage" would be great to see on our own Team Defense page. I would like to see how my defensive coverage formations do against the run and pass in games that my own team has played. Currently I would have to go to check the league wide data as a reference to what coverages have certain success rates vs the run and pass. I would prefer to see how my own team does to try to pin down what exactly is working best for my defensive personnel. Thanks in advance.

[jzicc]

TRYING TO RUN DRAFTANALYZER and this is the error that results :

eventype:clr20r3 P1:draftanalyzer.exe P2:2.0.1.0
P3: 4df92bfc P4: windowsutilitites P5: 2.0.1.0 P6: 4df92bf8
P7: 21 P8:78 P9:system.io.filenotfoundexception


ANY IDEAS?

(gameplananalyzer works fine by the way)

[gstelmack]

There is usually a stack available with errors like that. That would be helpful to track it down.

[gstelmack]

Originally Posted by kuykenda

Hea Stelmack. I was hoping you could add defensive formations to the "Team Defense" tab. "Rush Versus Defensive Coverage" and "Pass Versus Defensive Coverage" would be great to see on our own Team Defense page. I would like to see how my defensive coverage formations do against the run and pass in games that my own team has played. Currently I would have to go to check the league wide data as a reference to what coverages have certain success rates vs the run and pass. I would prefer to see how my own team does to try to pin down what exactly is working best for my defensive personnel. Thanks in advance.

Probably, will have to check.

[jzicc]

Originally Posted by gstelmack

There is usually a stack available with errors like that. That would be helpful to track it down.

Not sure if that was a reply to me --- but where would I get that info ---?

[gstelmack]

Originally Posted by jzicc

Not sure if that was a reply to me --- but where would I get that info ---?

There is usually something like a "Show More Info" button or similar on the dialog...

[jzicc]

Originally Posted by gstelmack

There is usually something like a "Show More Info" button or similar on the dialog...

here's a small portion:


Except. Info
code: 0xe0434f4d flags : 0x00000001

record 0x000000000000000 address 0x000000007c812afb

Sys info

windows nt 5.1 build: 2600
CPU ….
CPU ….

Module 1
Draftanalyzer.exe
image Base: 0x00400000 Image size: 0x00000000
Checksum 0x00000000 time stamp: 0x4df92bfc


The modules 1-35 and then THREADs and memory ranges: lots of hexadec stuff...

[gstelmack]

No, that's not it. Not sure why it's not giving you a good stack.

But it's saying file not found. There aren't many files it would be looking for, so maybe a reinstall of the suite will help here.

[Firefly]

Thanks for the great work, gstelmack!

I just ran the GP Analyzer and I sense a slight disturbance in the Force. Analyzer gives me a total of 18,257 pass attempts in the league, but the in-game the total in the team passing screen is 18,321. The number of completions does match, so the passcomp% is off by .2%

It's a bit odd.

[gstelmack]

Originally Posted by Firefly

Thanks for the great work, gstelmack!

I just ran the GP Analyzer and I sense a slight disturbance in the Force. Analyzer gives me a total of 18,257 pass attempts in the league, but the in-game the total in the team passing screen is 18,321. The number of completions does match, so the passcomp% is off by .2%

It's a bit odd.

Not sure, I'd have to track them down. I throw out all penalties that aren't added on to the end of the play, and I throw out spikes. There may well be something I'm throwing out that I shouldn't. Maybe fake punts / kicks?

[Firefly]

I've never even seen a single fake punt/kick in MP, so I think not. But it's very possible that the game includes spikes. If that's the case, then all the better! GP's numbers would then be more reliable than FOF's.

My team was 13-3 so we rarely trail, and the number of attempts are reported accurately. Further, I don't recall us ever spiking the ball -and I watch every game in Solevision. So it may well be spikes.

[Bako]

I've read thru the thread and I have run into an issue.

I'm on Vista

Trying to run the GP Analyzer

First thing I did was run the Check Path

The Check Path shows just Line 1 blank

I went to C:\Program Files\StelmackSoft\FOF2k7 Utility Suite to create the FOFPath.txt, but the only option I have is to create a new folder. Once I do that I see no Line 1 or 2?

How do I create a line to insert my paths?

Help please.

[Bako]

Scratch that. Got it up and running. My wife will be glad I no longer break down fake football games

[gstelmack]

2.0.3 (June 23, 2011): Download

• GamePlan Analyzer now has defense by coverage on the Team Defense page.
• GamePlan Analyzer now shows offensive playcalling tendencies in the first half in addition to the full-game table.

[gstelmack]

2.0.4 (July 24, 2011): Download

• Interrogator no longer displays tables, it will just dump to CSV. This means it uses quite a bit less memory than before.
• Interrogator status update while running improved.

[Yoda]

I am starting up a league with a dispersal draft, and was running the DBU before the draft started, and got this:

I tried to run the updater and got this:

Loading game data...
Reading file gefl0002.fju
Reading file gefl0002.fpd
Game data loaded, processing database...
Connected to MySQL server 108.59.255.76 version: 5.1.56-log
MySQL server does not have correct tables, adding now...Done!
MySQL connection closed.
DB connection opened.
Exception Hit, aborted!
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(T Key key)
at DBUpdater.DBUpdaterForm.DoStageUpdate()
at DBUpdater.DBUpdaterForm.RunUpdate()
DB connection closed.
Finished!
Run Time: 0min 11sec

[gstelmack]

I don't think that's going to work. The game is in a weird state until the dispersal draft has finished, and I'm not set up to handle that state. Everything will be fine after the dispersal draft.

[Yoda]

Just wanted to check, thanks!

[gstelmack]

As part of the WOOF site move, my site is moving as well. It may be down for a day or two while DNS propagates, so if you have troubles just wait and try again later.

[RipMurdock]

I can't run Extractor. I'm using WIN7 64-bit. I think I have all the proper security settings but I'm not positive. Path Checker says I'm using the right paths. Gameplan Analyzer works and Draft Analyzer works.

When I open Extractor and click on Extract, it freezes. If I open Extractor using "Run as Administrator" and click on Extract, the following error message appears:

"Could not read from shared memory: 536 Waiting for a process to open the other end of the pipe."

Any help would be appreciated.

[dzilla77]

I also run in XP compatibility mode for SP3. I think you also need to be running FOF in admin mode as well.

[gstelmack]

I develop on Win7 64-bit and don't have an issue. A virus checker could be blocking the DLL injection I'm using for this, not sure what else.

[RipMurdock]

Originally Posted by dzilla77

I also run in XP compatibility mode for SP3. I think you also need to be running FOF in admin mode as well.

FOF in admin mode worked. Thank you.

[Hoosierbuckeye]

Stupid question of the day...

i open the game, open interrogator, i click on file, it asks me for a game...

and I have an empty box...

it's gotta be something simple, but in plainspeak, not the unfamiliar jargon I don't grasp well, tell me how stupid I am and help me fix it..

hello mcfly would be a good way to start the explanation process

[gstelmack]

Don't open the game, just run Interrogator. If you have an empty box, run the CheckPaths utility that comes with the suite and see what it says. If it's empty, you need to create an FOFPath.txt file, put it in the documents\stelmacksoft\utilitysuite folder, and put the paths to the FOF install and the app data area that FOF puts all its data. There are details on this throughout the thread.

[Hoosierbuckeye]

extender question...what does the abbreviations...kcvr and thrat mean?

[Hoosierbuckeye]

looking for a workaround on the csv teamimagemap. We have a team, D.C. Titans, and when I enter them on the .csv file as D.C., extender won't open. When i enter them as DC, it opens, but that little red x appears, and it isn't linking to the image... ideas?

[gstelmack]

Did you put quotes around "D.C." in the CSV file? That may help. Otherwise, not sure, would have to debug.

[Hoosierbuckeye]

Originally Posted by gstelmack

Did you put quotes around "D.C." in the CSV file? That may help. Otherwise, not sure, would have to debug.

Thanks...that did it...

[Hoosierbuckeye]

Okay, on Extender we solved the problem with D.C. by writing the csv line
"DC", but on Extractor we get the red x marks the spot image on the same team...

I think it's because ingame DC is D.C. Just an fyi...I can copy and paste one image pretty quickly....

[dzilla77]

Anybody set up some MS Access databases (or excel macros) to use interrogator databases? Just looking to improve my single player experience.

[zdub]

Originally Posted by gstelmack

I would highly recommend not using DBUpdater if you aren't familiar with basic SQL and database management. If you aren't sure how to delete rows from a table or update columns in a table, you need to find someone in your league that you trust that can help.

I'm sorry, but I'm not familiar with basic SQL. Would I still be able to use Gameplan Analyzer without knowlege and access to SQL database and server?

[aston217]

Originally Posted by zdub

I'm sorry, but I'm not familiar with basic SQL. Would I still be able to use Gameplan Analyzer?

Yes. DBupdater is for league commishes to run for the league HTML, I think. Gameplan analyzer is just load up and go, basically. There are some instructions in this thread about how to set it up if it isn't working out of the box...those should probably be included in a read-me.

[zdub]

Originally Posted by aston217

Yes. DBupdater is for league commishes to run for the league HTML, I think. Gameplan analyzer is just load up and go, basically. There are some instructions in this thread about how to set it up if it isn't working out of the box...those should probably be included in a read-me.

I found the help file on setting up the text file with the 2 directory lines. That fixed everything, and thankfully I have no use for DBUpdater. Thanks!

[3ric]

A DBUpdater problem... I have several duplicate rows in the various tables and have been trying to clean it up - however, something has been broken now:
Loading game data...
Reading file HFL00001.fju
Reading file HFL00001.fpd
Reading file HFL0000117.1994
Game data loaded, processing database...
Connected to MySQL server 108.59.255.76 version: 5.1.56-log
MySQL connection closed.
DB connection opened.
Game Stage set to 1994 Week 13
Writing teams...Done!
Writing team stadiums...Done!
Writing franchise performances...Done! (0 added)
Exception Hit, aborted!
NHibernate.ADOException: Unable to perform find ---> System.ArgumentException: The value "" is not of type "System.Int32" and cannot be used in this generic collection.
Parameter name: value
at System.ThrowHelper.ThrowWrongValueTypeArgumentException(Object value, Type targetType)
at System.Collections.Generic.List`1.VerifyValueType(Object value)
at System.Collections.Generic.List`1.System.Collections.IList.Add(Object item)
at NHibernate.Util.ArrayHelper.AddAll(IList to, IList from)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
--- End of inner exception stack trace ---
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
at NHibernate.Impl.SessionImpl.Find[T](CriteriaImpl criteria)
at NHibernate.Impl.CriteriaImpl.List[T]()
at DBUpdater.DBUpdaterForm.DoTransactionUpdates()
at DBUpdater.DBUpdaterForm.RunUpdate()
System.ArgumentException: The value "" is not of type "System.Int32" and cannot be used in this generic collection.
Parameter name: value
at System.ThrowHelper.ThrowWrongValueTypeArgumentException(Object value, Type targetType)
at System.Collections.Generic.List`1.VerifyValueType(Object value)
at System.Collections.Generic.List`1.System.Collections.IList.Add(Object item)
at NHibernate.Util.ArrayHelper.AddAll(IList to, IList from)
at NHibernate.Impl.SessionImpl.Find(CriteriaImpl criteria, IList results)
DB connection closed.
Finished!
Run Time: 0min 13sec

What could this be?

[gstelmack]

I'll have to look at the code tonight. Likely it was expecting a certain set of rows in the transaction table given the stage and did not find any, so it got back an empty query rather than one with the last transaction loaded. If you deleted all transactions for a particular season, that might cause it. The key is that if you are trying to clean out a season from the database, you essentially need to roll the whole database back to the state before the season started, then rerun. DBUpdater can handle loading everything from the current season with no issues.

For the most part cleaning out a season is easy, just delete everything for the current year, but I'd also need to look into what you need to do to the gameinfo table to make it think it's starting over with a new season.

[3ric]

Originally Posted by gstelmack

If you deleted all transactions for a particular season, that might cause it.

Yes, that's probably it... I found that all transactions were stored twice for the previous year, and was going to start over with that season when the above error happened.