FOF/TCY HTML Export Utility

[cwilloughby]

Hey everyone. I have begun to build this little HTML export utility for the league I am in (the USFL). Our commish want's to be able to export certain information from FOF TCY even if it isn't printable. This BETA utility makes that possible. Eventually, I hope to make it automated and have many many more features. Feel free to try it out. Post any problems or qyestions you run in to here. Functionality suggestions and input are also welcome :). This has been tested thus far against TCY, but does work against FOF. Enjoy.

http://e.1asphost.com/cwilloughby/pTCYExport.msi

[nuggett]

Any samples to look at....

Thanks.

[3ric]

Thanks! This looks like a very useful utility, I've tested it a little with FOF2k4 and managed to crash it by exporting the "Hire/View Scout and Staff" screen. Most likely because of the slash sign in the title, which creates a non-valid name in the "Output File" field of your program.

Some FOF2k4 samples:
m1.311.telia.com\~u31114559\1983 Draft.html
m1.311.telia.com\~u31114559\Best Bench Press Repetition Scores.html
m1.311.telia.com\~u31114559\Quarterback Comparison.html
m1.311.telia.com\~u31114559\The Green Page.html
m1.311.telia.com\~u31114559\The Solecismic Draft Review.html

[Flasch186]

Chris:

This looks great from the saples but I cant get the link to work. Ill have to try when i get home tonight and run wk. 1. I hope it'll be up by then, but like i said...this is all bonus.

[RedKingGold]

How come Richard Dent is listed as a Center?

[Vikings13]

Yeah looking at that 1983 draft, there are some glaring errors... Henry Ellard as a FB? Eric Dickerson as a QB?

Not sure if those are typos, but if they're not, someone needs to redo that draft file...

[cwilloughby]

Richard Dent is listed as a C because when the grid is exported, the POS is returned to the exporter as a number. These numbers are different between FOF 2004 and TCY. This means that your replaces for these grids will be different. The replaces.ini file in the program folder is currently setup to add the TCY position replacements to any column that has "Pos" as it's header. I will fix this in the future to allow multiple configurations, but for now, I would suggest keeping a seperate settings.ini file for fof and tcy, and modifying the fof settings file to point at different directories and different replaces and catalog files. Then, just rename whichever you settings file you want to use to "settings.ini" in the main program folder, and it will use these. Then, removing the sections "Pos" and "Elig" (and their entries) from your fof replaces.ini file will stop the positions from getting the wrong designation. However, you will then get them as the number, until the proper replacements are setup for those numbers. Confusing enough?

[cwilloughby]

Here is a replaces.ini file for FOF 2004. Put it in the program's folder, and rename it to "replaces.ini" (make sure you move the tcy one first) when you want to have the correct position designations for FOF 2003 exports.

http://e.1asphost.com/cwilloughby/replaces_fof.ini

[RedKingGold]

I think I will just wait for you to make the change

Thanks for a great utility

;)

[3ric]

Oh, now I understand, thanks for pointing that out, and for the new file!

I'll just add a disclaimer that there's nothing wrong with either the 1983 draft file or the export utility... :)

[cwilloughby]

No problem guys. Thanks for the feedback. Let me know if any ideas spring to mind.

[nuggett]

Great utility... Anyway to add headers to this program.

Thanks.

[cwilloughby]

Nuggett... What do you mean by headers? To the html docs?

[chinaski]

any estimate when the server is going to be back up? is this program mirrored anywhere?

[cwilloughby]

I can get to it right now. It appears that some other people were having the same problem. I will post a few different mirrors tonight when I get home. (~1130mst)

[RedKingGold]

Great Job,....I am loving this utility

I can now print out just about any screen

FANTABULOUS!!!!!

[cwilloughby]

No problem! There are a lot more things I want to do with it, time permitting. It would be cool to be able to automate the whole process, especially when you will be doing the same exports over and over again. That will take some time, however. :)

[nuggett]

Yes,

I mean headers to the HTML... Thanks.

[Flasch186]

CHRIS!! I told you this thing would be loved, Sir....you are the man. If it were automated people would die. Headers even more death. Chris.....simply fantabulous.

[Fido]

Anyone have an alternate link to this? I have yet been able to access the server and woudl like to check this out.

[cwilloughby]

Hey, you should be able to do HTML headers on the secont tab (format) in the HTML Header section. Just overwrite it with what you want to show above the table in the html. You can also do table formatting, and your HTML footer in the appropriate boxes there as well.

[cwilloughby]

Can someone host this somewhere so that the people that cannot get to it can download it? I can IM it to someone if needed.

[nuggett]

Thanks, but not sure how to put the header in.... Is there a simple way.

[primelord]

Wow we are into the 4th day of this thread and SkyDog has not linked to it in the refernce thread yet. Me thinks the H.N.I.C. is slipping. :)

[Flasch186]

true

[Ben E Lou]

Heh. Never saw it. Y'all gotta tell a brutha somethin'. Believe it or not, I don't read every thread around here. ;) Taking appropriate action now.

[RendeR]

Quick question, is this utility still available, and does it work with FOF4 at all?

[3ric]

Render -
it's available here: http://fidosoft.com/FOF/page.viewproject.php?ID=11 and it should work with FOF4, but some changes to the "replaces.ini" file might be neccessary.

[cwilloughby]

Thanks 3ric!

Yes, it is available from Fido's site.

Also, it should work with any version as long as you are printing from a grid. Keep in mind, the replace files may need to be modified for older versions. This can be done by clearing the replaces file that exists now (except the header), printing a roster from within FOFv4, and then entering the appropriate coorelations between the printed number and the true position on the grid. It is actually a lot easier than it sounds.

[j25352857]

I'm having problems getting this to show the correct positions for the players. I installed the new replaces.ini file into the export utility folder, but I'm still getting output that lists incorrect positions. Can somebody tell me what I'm doing wrong? Thanks in advance.

[RendeR]

when you right click to export the file, there is a section you can highlite and change the position info, you have to change the positions stuff there, it doesn't work to just edit the replaces.ini file

I took a couple hours to figure this out and felt really dumb afterward...

[fantastic flying froggies]

I've just started playing TCY again, and therefore have just installed your utility.

Excellent work, just awesome !

[cwilloughby]

Thanks!
I've been wanting to do some updates to it, and hope to get to them in the near future.

Keep in mind that it will also work with all FOF versions to export their grids, not just TCY.

[BigDog]

I cannot seem to get to the file on the fido site. I am running a multi-sport sim universe and just added TCY to the mix.... I could really use some help getting this utility!

Thanks,
Chris
BigDog Sports http://bigdog.simhosting.com

[gstelmack]

I've updated Draft Analyzer to use the output from this utility if the output matches an FOF draft class imported from TCY. Details over at http://dynamic2.gamespy.com/%7Efof/forums/showthread.php?p=604199#post604199

[Ben E Lou]

Anyone tried this utility with 5.1a?

[cwilloughby]

I haven't tested it myself. It should be completely compatible, however, because it relies solely on the grids, which are a component of windows. That means that until Jim drastically changes the way he does grids, it should be compatible with all releases/updates.

EDIT: Grammar. Bleh.

[Ben E Lou]

<TABLE><TBODY><TR><TD>$$2018</TD><TD>Kansas City Chiefs 31, Atlanta Falcons 17</TD></TR><TR><TD>**2017</TD><TD>Atlanta Falcons 30, New Jersey Jets 28</TD></TR><TR><TD>2016</TD><TD>Kansas City Chiefs 35, Detroit Lions 24</TD></TR><TR><TD>2015</TD><TD>Detroit Lions 24, Pittsburgh Steelers 7</TD></TR><TR><TD>2014</TD><TD>Baltimore Ravens 22, Arizona Cardinals 17</TD></TR><TR><TD>2013</TD><TD>Detroit Lions 16, Tennessee Titans 14</TD></TR><TR><TD>2012</TD><TD>Oakland Raiders 35, Seattle Seahawks 19</TD></TR><TR><TD>2011</TD><TD>Oakland Raiders 30, Minnesota Vikings 17</TD></TR><TR><TD>$$2010</TD><TD>Oakland Raiders 16, Atlanta Falcons 13</TD></TR><TR><TD>2009</TD><TD>Oakland Raiders 31, Detroit Lions 13</TD></TR><TR><TD>2008</TD><TD>Tampa Bay Bucs 20, New England Patriots 10</TD></TR><TR><TD>2007</TD><TD>Detroit Lions 27, Jacksonville Jaguars 24</TD></TR><TR><TD>2006</TD><TD>Tennessee Titans 26, New Orleans Saints 21</TD></TR><TR><TD>2005</TD><TD>Baltimore Ravens 22, Tampa Bay Bucs 20</TD></TR><TR><TD>2004</TD><TD>Buffalo Bills 17, St. Louis Rams 10</TD></TR></TBODY></TABLE>

Yup. It works.

What does the (WO) mean?

<TABLE><TBODY><TR><TD>Name</TD><TD>Team</TD><TD>Pos</TD><TD>Exp</TD></TR><TR><TD>Larry Kantz</TD><TD>New York Giants</TD><TD>QB</TD><TD>2</TD></TR><TR><TD>Alan Perkins</TD><TD>Dallas Cowboys</TD><TD>QB</TD><TD>3</TD></TR><TR><TD>Jerome Mickens</TD><TD>Washington Redskins</TD><TD>C</TD><TD>2</TD></TR><TR><TD>Jerry Buckner</TD><TD>Tennessee Titans</TD><TD>TE(WO)</TD><TD>2</TD></TR><TR><TD>Darnell Bailey</TD><TD>Buffalo Bills</TD><TD>C</TD><TD>2</TD></TR><TR><TD>Ben Hall</TD><TD>Dallas Cowboys</TD><TD>TE(WO)</TD><TD>2</TD></TR><TR><TD>Larry Long</TD><TD>Philadelphia Eagles</TD><TD>C(WO)</TD><TD>2</TD></TR><TR><TD>Marco Sullivan</TD><TD>Green Bay Packers</TD><TD>TE(WO)</TD><TD>2</TD></TR><TR><TD>Clarence Barton</TD><TD>San Diego Chargers</TD><TD>TE(WO)</TD><TD>2</TD></TR><TR><TD>Herman Wentworth</TD><TD>New England Patriots</TD><TD>FB</TD><TD>2</TD></TR><TR><TD>Bert Fisher</TD><TD>New Orleans Saints</TD><TD>QB</TD><TD>2</TD></TR><TR><TD>Riddick Price</TD><TD>Chicago Bears</TD><TD>QB(WO)</TD><TD>2</TD></TR><TR><TD>Vincent Grzecki</TD><TD>Arizona Cardinals</TD><TD>C</TD><TD>2</TD></TR><TR><TD>Bennie Washington</TD><TD>Jacksonville Jaguars</TD><TD>QB</TD><TD>2</TD></TR><TR><TD>Reuben George</TD><TD>Carolina Panthers</TD><TD>T</TD><TD>2</TD></TR><TR><TD>Burt Hundley</TD><TD>Buffalo Bills</TD><TD>T</TD><TD>2</TD></TR><TR><TD>Dwayne Sinclair</TD><TD>Houston Texans</TD><TD>TE(WO)</TD><TD>2</TD></TR><TR><TD>Antoine Cortez</TD><TD>Cleveland Browns</TD><TD>RB(WO)</TD><TD>2</TD></TR><TR><TD>Hunter Webb</TD><TD>Jacksonville Jaguars</TD><TD>FB</TD><TD>2</TD></TR><TR><TD>Michael Zink</TD><TD>St. Louis Rams</TD><TD>C(WO)</TD><TD>2</TD></TR></TBODY></TABLE>

[cwilloughby]

When reading the grids, some data is represented as numbers (positions are one of these). The replaces parameters take care of replacing them with the apropriate text.

That said, the replaces file that comes with it is for TCY which had those positions. The hell if I remember what the WO stood for now :).

It is very easy to modify what these get exported as, though.

If there is a need for it, I can repost the FOF2k4 version of the replaces.ini sometime tonight.

[gottimd]

Wookie Odor?

[cwilloughby]

Haha. Okay. It's nothing at all.

EDIT: This was posted in reply to SkyDog. Damn dirty sorting!

[Ben E Lou]

{Stuff}

If there is a need for it, I can repost the FOF2k4 version of the replaces.ini sometime tonight.That would be great, if you don't mind!

[cwilloughby]

Didn't forget about this, was stuck working pretty late.

I'll try and get it up tonight. :wink::wink:

[fantastic flying froggies]

What does the (WO) mean?

Seing as this output is from TCY, my swag would be Walk-On.

[cwilloughby]

As promised...

A FOF replaces.ini
hxxp://www.usfl-fof.com/TCYHTMLExport/fof_replaces.zip

FOF Setup options:
I. Run TCY HTML Export twice on same machine (TCY and FOF).
II. Run TCY HTML Export once for FOF.

I. Two copies.
1. Install the program.
2. Browse to where you installed it.
3. Copy the folder and paste it, renaming it to signify FOF usage.
4. Overwrite the replaces.ini file within the new folder with the one in the zip.
5. Delete the catalog.ini (if it exists).
6. Clear the ExportOptions and Exports folders.
7. Run the EXE in this folder for FOF exports or the one in the TCY folder for TCY exports.

II. FOF Only
1. Install the program.
2. Browse to where you installed it.
3. Overwrite the replaces.ini file within the main folder with the one in the zip.
4. Delete the catalog.ini (if it exists).
5. Clear the ExportOptions and Exports folders.
6. Run TCY Html Export as normal to export from FOF.

Let me know if any of you have any problems...

[maximus]

cwilloughby, great job on this utility. I was looking for a utility that could do this and gstelmack advised me to look at your utility. :) Thanks again.

[Gallifrey]

It will not work on my home PC for some reason.
It does work on a PC at my wifes office.

I think the error I get has to do with 'private.ini' can't be found or written.
I need to look at it again to remember.

[maximus]

First off, even though I already said this before-I love this utility. Now when Jim comes out with another version of FOF I can keep these stats from FOF2004 in a database to be compared to stats from the newer version. This way I can keep my league consistant. :)

OK, the only thing I've noticed so far about the HTML output is that when importing it into a access for database purposes "sacked yards" read as "field 14". I have to rename the field which is no big deal but I'm just wondering why it does that. :confused:

Either way, I am having one hell of a time with this utulity. IMO one of the best ones made for FOF2004 because it allows me to track & compile player & team data at will. This is great for scouting purposes.

Thanks again cwilloughby. :)

[cwilloughby]

First off, even though I already said this before-I love this utility. Now when Jim comes out with another version of FOF I can keep these stats from FOF2004 in a database to be compared to stats from the newer version. This way I can keep my league consistant. :)

OK, the only thing I've noticed so far about the HTML output is that when importing it into a access for database purposes "sacked yards" read as "field 14". I have to rename the field which is no big deal but I'm just wondering why it does that. :confused:

Either way, I am having one hell of a time with this utulity. IMO one of the best ones made for FOF2004 because it allows me to track & compile player & team data at will. This is great for scouting purposes.

Thanks again cwilloughby. :)

No problem! I'm glad that you enjoy it.

[cwilloughby]

It will not work on my home PC for some reason.
It does work on a PC at my wifes office.

I think the error I get has to do with 'private.ini' can't be found or written.
I need to look at it again to remember.

Try uninstalling and reinstalling it.

Let me know,
Chris W.

[hitmanwa]

Meh, I can't figure this out to save my life. I keep getting runtime errors for some reason.

[cwilloughby]

What are you doing when you get these errors?'

PM me for an email address where you can send screen caps detailing the problems.

Chris W.

[gottimd]

What does the (WO) mean?


Was this ever answered? I ran the export on the Draft Preview screen, and many of the players have (WO) next to their name. I was trying to create a Mock Draft code based on Team Needs and availability/ranking of players in those positions from the draft preview screen.

[Ben E Lou]

Was this ever answered? I ran the export on the Draft Preview screen, and many of the players have (WO) next to their name. I was trying to create a Mock Draft code based on Team Needs and availability/ranking of players in those positions from the draft preview screen.It is left over from TCY. It means "walk-on.'

[gottimd]

Thanks, I'll just sort them by position, and manually change those positions that are needed to be changed.

[jshipman2]

I can't get this utility to work. Could someone give me a step by step of how to get it to work?

[Ben E Lou]

Anyone got a copy of this utility? The download link is now broken.

[Cringer]

Anyone got a copy of this utility? The download link is now broken.

Duuuuuuuuuuuuude. I PMed this info to you a while back with a new link. Let me see if I can find it again.

[Cringer]

http://www.operationsports.com/fofc/showthread.php?t=44101&highlight=html+exporter

[Ben E Lou]

Bump.

Does anyone have the FOF replaces.ini file? Link below is dead.

--Lou

As promised...

A FOF replaces.ini
hxxp://www.usfl-fof.com/TCYHTMLExport/fof_replaces.zip

FOF Setup options:
I. Run TCY HTML Export twice on same machine (TCY and FOF).
II. Run TCY HTML Export once for FOF.

I. Two copies.
1. Install the program.
2. Browse to where you installed it.
3. Copy the folder and paste it, renaming it to signify FOF usage.
4. Overwrite the replaces.ini file within the new folder with the one in the zip.
5. Delete the catalog.ini (if it exists).
6. Clear the ExportOptions and Exports folders.
7. Run the EXE in this folder for FOF exports or the one in the TCY folder for TCY exports.

II. FOF Only
1. Install the program.
2. Browse to where you installed it.
3. Overwrite the replaces.ini file within the main folder with the one in the zip.
4. Delete the catalog.ini (if it exists).
5. Clear the ExportOptions and Exports folders.
6. Run TCY Html Export as normal to export from FOF.

Let me know if any of you have any problems...

[gottimd]

anyone have this program, all links are dead, even the relink to Fido.

[sovereignstar]

http://www.joenitedstatesofamerica.com/pTCYExport-1.msi

[gstelmack]

I'd love to see cwilloughby come back on here and explain the technical implementation of this. I'm stumped at the "extract data from the FOF ListView controls" stage and could use that bit of help (there are other things I could do with my utilities if I could do this).

[Ben E Lou]

As promised...

A FOF replaces.ini
hxxp://www.usfl-fof.com/TCYHTMLExport/fof_replaces.zip

FOF Setup options:
I. Run TCY HTML Export twice on same machine (TCY and FOF).
II. Run TCY HTML Export once for FOF.

I. Two copies.
1. Install the program.
2. Browse to where you installed it.
3. Copy the folder and paste it, renaming it to signify FOF usage.
4. Overwrite the replaces.ini file within the new folder with the one in the zip.
5. Delete the catalog.ini (if it exists).
6. Clear the ExportOptions and Exports folders.
7. Run the EXE in this folder for FOF exports or the one in the TCY folder for TCY exports.

II. FOF Only
1. Install the program.
2. Browse to where you installed it.
3. Overwrite the replaces.ini file within the main folder with the one in the zip.
4. Delete the catalog.ini (if it exists).
5. Clear the ExportOptions and Exports folders.
6. Run TCY Html Export as normal to export from FOF.

Let me know if any of you have any problems...FOF replaces file link broken. Anyone have a copy of this?

[MacroGuru]

Bump...Looking for this....

[twothree]

Bump...Looking for this....

pTCYExport-1.msi sent to your yahoo mail address. Sorry, I don't have the fof_replaces.zip file, but if I remember correctly all you have to do is a bit of work on the replaces.ini file to change the position codes from the default TCY codes to the ones that give the correct positions for FOF.

[MacroGuru]

pTCYExport-1.msi sent to your yahoo mail address. Sorry, I don't have the fof_replaces.zip file, but if I remember correctly all you have to do is a bit of work on the replaces.ini file to change the position codes from the default TCY codes to the ones that give the correct positions for FOF.

Thanks.

[Joe]

does this even work with FOF2k7?

[Ben E Lou]

does this even work with FOF2k7?Based on how I recall it working, I would think so.

If someone will email it to benelou AT bellsouth.net, I can host it and point to it from the Reference Thread.

[twothree]

If someone will email it to benelou AT bellsouth.net, I can host it and point to it from the Reference Thread.

Sent.

[legendsport]

Does anyone have this? I looked for it on the reference thread and didn't see it? I'm hoping to add TCY to my AFLAC league. If someone could email it to me at commish-at-simsportleagues.com, or let me know where it can be found, that'd be much appreciated.