StelmackSoft FOF2k7 Utility Suite

[w24olfpack]

Greg.

Do you have a xxx.weights file with the old 'default' where it sets everything to zero?
I used that in my draft model and now it's nerfed. I can go in an reset it but hoping for an easy fix.

[w24olfpack]

OK. Someone helped me out
For someone who would want / need the old defaults: Look here
http://www.fof-tfl.net/DraftAnalyzerDefault.weights

You have to save as.

[Ben E Lou]

I've been meaning to report this issue for a while, but keep forgetting. It's a repeatable crash that has been in Draft Analyzer for several versions (maybe forever).

1. Sort by a bar
2. Paste in new analyzer info
3. Hit "mark drafted"

It crashes when it tries to order them again.

[gstelmack]

Not forever, I didn't let you sort by bar until somewhat recently. I'll try and take a look.

[jley618]

So, I donloaded the latest suit...2.0.7, and can't seem to get Extractor to work. The paths are set up correctly, and the tool created the fofPATHS.txt file in the correct spot. I am tring to extract the current draft class.

What happens is, I open the 1st player card in the draft screen, open Extractor, and click the Extract button. Nothing happens, as it just sits there. I don't get any error messages, and the program seems to be in a locked state...

I am running Windows 7 Pro, 64 bit. Gameplan Analyzer works fine, btw....

Any ideas?

[jley618]

Figured it out. Set program to run in compatibility mode, and run as admin.

[WheelsVT]

I'm late to this party, but DB Updater is awesome.

[Doug5984]

I need some help with the utility suite, I'm trying to get it set up on my XP machine at work and it's been years since I've messed with anything FOF related. It's crashing when I try to run the resource patcher, any help would be appreciated.

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

************** Exception Text **************
System.ArgumentException: Empty file name is not legal.
Parameter name: sourceFileName
at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)
at ResourcePatcher.MainForm.buttonPatch_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.3643 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
ResourcePatcher
Assembly Version: 1.8.17.0
Win32 Version: 1.8.17.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/ResourcePatcher.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3637 (GDR.050727-3600)
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.3643 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3639 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
WindowsUtilities
Assembly Version: 1.8.17.0
Win32 Version: 1.8.17.0
CodeBase: file:///C:/Program%20Files/StelmackSoft/FOF2k7%20Utility%20Suite/WindowsUtilities.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:





When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

[gstelmack]

It doesn't know where the FOF EXE is (notice the text box is blank). Try using the FOF Exe Path and browsing for it, or run CheckPaths and tell it where everything is first.

[Doug5984]

I must not have had the latest version, I uninstalled re-installed the most recent and was able to get that to work.

However the only package available in the resource patcher is the "cyril" it appears I'm missing the xml files for the other 3.. not sure how, or why that happened... I need to get some work done so I'll mess with it later and see what I can come up with

[gstelmack]

I'm hitting my complete boredom point with FOF. I'm hanging in with IHOF for now, but really I don't have all that much interest to come up with new things for the suite. So, time to release the source in case anyone else wants to do anything with this.

Note that there is the beginnings of a ChangeTracker replacement in here, since folks are having trouble with the old one. It includes a graphical display of all bar development. Someone might want to run with that, not sure.

And of course this includes all the binary reader bits, including how far I've gotten with Solevision.

http://www.gstelmack.com/UtilitySuite/source.zip

[Hoya1]

not that i could do anything with this, but appreciate you sharing your work.

[Yoda]

Any help would be appreciated:

NHibernate.NonUniqueObjectException: a different object with the same identifier value was already associated with the session: 706525, of class: DBUpdater.Tables.FofPlayergamestats

[gstelmack]

Sounds like it's trying to insert an object with a key that already exists. It's inserting a row into FOFPlayerGameStats that is already there and it's not expecting it to be.

[Yoda]

just delete that week and redo it? Or delete the season and redo it?

[gstelmack]

Probably just the week, as it should only be trying to add for that week.

[PackerFanatic]

Is it possible to change the default location for the UtilitySuite Save Path? It doesn't look like it in Check Paths, but maybe in config file somewhere?

[gstelmack]

Not currently, no.

[ZappBrannigan]

Is there a way to "trick" DBUpdater to use .csv files that I've generated from Interrogater? I don't think I have all the EOS files.

Thanks
(P.S. thanks for the great utilities)

[aston217]

You must have all the EOS stat files (.2007, .2008, etc) for a good Interro run because that's where (I think) it gets its data.

DBUpdate is similar with the quirk that the game's current stage has to be loaded during that season (i.e, after the bowl but before season advance) for it to process that season's EOS data. It won't process EOS data from older seasons, I don't think.

What you *can* do is try to build your database manually from the Interrogator CSV files, although there's weird stuff with Transactions that I've never been able to figure out.

[ZappBrannigan]

Originally Posted by aston217

You must have all the EOS stat files (.2007, .2008, etc) for a good Interro run because that's where (I think) it gets its data.

DBUpdate is similar with the quirk that the game's current stage has to be loaded during that season (i.e, after the bowl but before season advance) for it to process that season's EOS data. It won't process EOS data from older seasons, I don't think.

What you *can* do is try to build your database manually from the Interrogator CSV files, although there's weird stuff with Transactions that I've never been able to figure out.

Thanks, that's what I was afraid of. Not sure if I have enuff php/mysql skill to do it manually

[gstelmack]

DBUpdater will go through every file available to it. If you run it for the first time on a league with history, the only thing you lose out on is retirement years for players, and you'll be missing some players that FOF deletes even though they appeared in some games. These may be minor enough for you not to care, but if you want full details the general recommendation is to restore the end-of-season backups one at a time for the league starting at the beginning and running each stage.

If you are missing the actual yearly stat files, then you are screwed, the data is simply not available. Interrogator vs DBUpdater won't matter, unless you just mean you have older Interrogator CSVs laying around. That would be very tricky to do manually.

[ZappBrannigan]

Originally Posted by gstelmack

DBUpdater will go through every file available to it. If you run it for the first time on a league with history, the only thing you lose out on is retirement years for players, and you'll be missing some players that FOF deletes even though they appeared in some games. These may be minor enough for you not to care, but if you want full details the general recommendation is to restore the end-of-season backups one at a time for the league starting at the beginning and running each stage.

If you are missing the actual yearly stat files, then you are screwed, the data is simply not available. Interrogator vs DBUpdater won't matter, unless you just mean you have older Interrogator CSVs laying around. That would be very tricky to do manually.

Thanks for the reply. Sorry for being obtuse, but when you say stat files do you mean the files for each year, e.g. leaguename.2009, leaguename.2010, etc? We have those, but I don't know how to extract the data from them to create the EOS files to import into DBUpdater. Can it be done? thanks.

[gstelmack]

Originally Posted by ZappBrannigan

Thanks for the reply. Sorry for being obtuse, but when you say stat files do you mean the files for each year, e.g. leaguename.2009, leaguename.2010, etc? We have those, but I don't know how to extract the data from them to create the EOS files to import into DBUpdater. Can it be done? thanks.

DBUpdater reads those directly. It reads the FOF data directly. If you have everything you need to open the league in FOF and can browse all the stats and career records, then just run DBUpdater on the league, you don't need to do anything else.

[ZappBrannigan]

Originally Posted by gstelmack

DBUpdater reads those directly. It reads the FOF data directly. If you have everything you need to open the league in FOF and can browse all the stats and career records, then just run DBUpdater on the league, you don't need to do anything else.

Just tried this with a new database. I have all the historical data for the league (2003 to 2023) and all the stats/career records are present in game. And Interrogator seems to create all the .csv files just fine if I set it to 2003 and let it run through all the seasons. But DBUpdater only populates the database with data from the current year (2023 thru week 16). It doesn't give me any errors. Any ideas?

[Dutch]

I think dbupdater only operates from the current year, so to get the entire history you would have to load up year #1, dbupdate, year #2, dbupdate, etc.

[PackerFanatic]

And you have to make sure that you are running the very last update from those seasons, in order to get all the history. It's a painstaking process to get history in there, but definitely worth it.

[ZappBrannigan]

thanks PFan and Dutch. Now that gstelmack has released the code it probably wouldn't be impossible to get in there and change it to do multiple seasons

[w24olfpack]

Question on Extender.
It gets confused because we have two New Yorks.

In teamimage I have one a New York G and the other ad New York J.

Is there another way to go about this ?

[General Mike]

Resource Patcher question, using Windows 7, Suite version 2.07

The Icy/Cuervo/Dutch packages aren't showing up in the box where they should be.

[aston217]

Originally Posted by ZappBrannigan

thanks PFan and Dutch. Now that gstelmack has released the code it probably wouldn't be impossible to get in there and change it to do multiple seasons

Yeah, if anybody out there is a good enough programmer to work with this released source (i.e, not me), this would be #1 on my wish list.

Question, in gameresults, is it by design that "HomePassYards" and "HomeRushYards", etc, are actually only the stats of the leader for each team?

The "HomeMiddleRushYards", etc, and "ScreenPassYards", etc, appear to be for the whole team, so this is a little confusing. I guess if you want actual cumulative stats from a game, the proper place to go would be fof_playergamestats and sum up?

Also, how far is that changetracker replacement from completion?

[scorp]

anyone install the suite win 8? the setup program wants .net 2.0 I h4.5 and it thinks I don't have the .net framework and won't intall.
so my guess is intall 2.0 if I find that.

[PackerFanatic]

Has anyone come up with a good way to get around the stupid hosts that won't allow remote DB connections? I had thought about doing a local MySQL DB, exporting there, then running the SQL to update the remote DB, but that seems A) way too time-consuming and B) maybe not even likely with how big some of those tables can get (and will continue to get). Or does anyone have a better stats alternative from jdavidbaker's that they would host for us?

[aston217]

Originally Posted by PackerFanatic

Or does anyone have a better stats alternative from jdavidbaker's that they would host for us?

What do you mean by this?

I thought Stelmack's suite was the only database supplier we have available to us (I could be wrong, I'm fairly new to the game) and even if not, any other stats suite would invariably deal with the same issues of requiring a very large database, no?

[helseld]

Originally Posted by MajikMan77

Trying to run ResourcePatcher to edit the UI with one of the presets (eg Icy) and while CheckPaths show the three correct directories, when I run the file all three check boxes to select the new UI stuff doesn't show up. Only the make org backup, fof exe path and patch buttons show up.

Brand new install to default directories. It also works as intended on a Fof 6.3 file in a backup folder but not the newier 6.4 version.

Any ideas anyone?

I've been going thru this thread for what seems like forever trying to research this same problem (lol, could have saved a lot of time by starting at the end rather than the beginning). Will much appreciate anyone responding that has an answer.

[ouzo66]

I'm having a problem with QBs in the Draft Analyzer. For "Bars", "Comb", and "Rate" is shows "NaN" instead of the numbers. It works on my home computers but not my work computers.

[ezpkns34]

Originally Posted by General Mike

Resource Patcher question, using Windows 7, Suite version 2.07

The Icy/Cuervo/Dutch packages aren't showing up in the box where they should be.

Originally Posted by helseld

I've been going thru this thread for what seems like forever trying to research this same problem (lol, could have saved a lot of time by starting at the end rather than the beginning). Will much appreciate anyone responding that has an answer.

Same problem here. Since nobody is addressing this issue, I assume nobody knows how (or cares) to resolve it. If that's the case, anyone got a link to an older version of the resource patcher?

Thanks


Nevermind, found an old version of it (1.9.14) on my external HD. If anyone else wants a link to it, just ask

[aston217]

I have 2.05, Windows 7, and no issues. It's possible that people just aren't able to recreate it?

[aston217]

DBUpdate issue:

there's a team that has a cap loss, this year of (310,000).

That's -310,000, so I'm not certain how this is possible. But nonetheless, that's what it shows, and DBUpdate is writing this as 18446744073709241616.

[Cap Heresy]

Are there any pros/cons as to how to install the suite?

Application file or Windows Installer Package file?

[Cap Heresy]

Originally Posted by Cap Heresy

Are there any pros/cons as to how to install the suite?

Application file or Windows Installer Package file?

Without intending to cast aspersions, it seems like esoteric questions get answered a lot faster than newbie questions. Is there somewhere else I should be asking newbie questions?

[aston217]

Uh, I don't understand the question.

Does either one not work?

[Cap Heresy]

Originally Posted by aston217

Uh, I don't understand the question.

Does either one not work?

I haven't executed yet. The download contained two types of files named "setup", the ones I mentioned. I would think I don't need to execute both. Maybe one is for Macs? I'm just being careful.

[gstelmack]

The exe checks to make sure you have all the prerequisites (proper version of .NET, etc), the .msi is the actual installer. For most modern systems it probably won't matter, but when in doubt always run "setup.exe".

[Cap Heresy]

Originally Posted by gstelmack

The exe checks to make sure you have all the prerequisites (proper version of .NET, etc), the .msi is the actual installer. For most modern systems it probably won't matter, but when in doubt always run "setup.exe".

OK, thanks Greg.

[GridGlory]

Installed Draft Analyzer and its working fine, but I don't see as much info as others on the bottom of the main screen. I attached a screen shot. Has anyone else run into this? Any ideas at all would be greatly appreciated.

[gstelmack]

You installed the FOF2k4 one, not the FOF2k7 one.

[Mistwood19]

[nickelback]

Anyone gotten the draft analyzer to work for FOF7 yet?

[dzilla77]

Originally Posted by nickelback

Anyone gotten the draft analyzer to work for FOF7 yet?

It sorta works - it reports an error (which you can ignore), but I think it is analyzing the combines accurately.