#1 2018-04-25 04:41:13

Black Mamba
Member
Canada
Reputation: +1449
Registered: 2012-12-01
Posts: 4,231
Windows 10 Chrome 65.0

Problem using BFStats to generate server stats

I am having issues using BFStats, which is a program which was made by Mario Kohler years ago to convert CSV spreadsheets generated by BFSM (statistics.csv) to HTML pages that can be uploaded via FTP to a website.

I used the following tutorial to try and generate the HTML pages: http://elitesniperserver.com/media/tuto … e.asp?id=9

First, I downloaded and installed the latest Java SDK + Runtime Kit as pointed out by the tutorial by visting this website: http://www.oracle.com/technetwork/java/ … 33151.html

I then downloaded the "Java SE Development Kit 8u172" for Windows x64 (jdk-8u171-windows-x64.exe). After that I downloaded and installed the BFStats.zip and extracted it to a folder on my Desktop called "Stats". Here is the file directory inside this Stats folder:

zJOybmu.png

The statistics.csv file was generated by the BFRM v2.01 using the following settings (see the image below). I don't know if enabling Event log compression is the issue here, but I doubt it.

Q1yszCB.png

Now the tricky part. After having edited the "run.cmd" file found inside the "bin" folder with a text editor to point to the path where I have stored the statistics.csv file, I run the file and it gives me the following errors:


Basically it's saying that the statistics.csv file is empty even though it is not (red rectangle). I have opened it many times and can see all the games being logged there, with the player names, their scores, pings, deaths, IPs, etc. Running the file with Administrator Rights also does nothing and does not generate the HTML files inside the "www" folder.

I am using Windows 10 Home 64-bit. Has anyone else had problems with this program to generate HTML files from the CSV file?

Last edited by Black Mamba (2018-04-27 16:05:52)

Offline

    Positive reputation 0   Negative reputation 0

#2 2018-04-26 14:24:03

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Chrome 65.0

Re: Problem using BFStats to generate server stats

The "Java.lang.NullPointerException" is saying that something went critically wrong for the BFStats Java code when attempting to parse the line from the .CSV file.  And so it's ignoring the line as potentially "invalid."  But this happens during the parsing of every single line.  And so with 100% of lines ignored, BFStats declared "the file is empty" because there were no valid lines processed.

No, I've never used BFStats and don't know what it will take to solve this.  My guesses would be that possibly the Java runtime itself has long-since closed some security hole or bad coding that this application used to get away with.  Or that the data being generated into the .CSV doesn't contain data that BFStats always assumed would be there, and doesn't parse correctly without.

The BFStats program appears to have been created before BFServerManager 2.01 was out, so possibly its some difference in the format of the .CSV logging as compared to 2.0 or similar.   Maybe if you can temporarily run with 2.0 and generate a .CSV log from that, to compare against your 2.01 logs.  If there is a specific difference, even though you can't fix the BFStats program, maybe you can manually or via macros edit your 2.01 log files to be consistent with the 2.0 format before presenting them to BFStats.

I don't decompile or write Java code, so that's as far as I can reasonably guess.

Offline

    Positive reputation 1   Negative reputation 0

#3 2018-04-27 04:08:07

bud
maestro
Reputation: +1835
Location: shangri la
Registered: 2012-07-07
Posts: 3,941
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

Its supposed to put the result in a database, like MySQL

Offline

    Positive reputation 0   Negative reputation 0

#4 2018-04-27 06:58:35

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Internet Explorer 11.0

Re: Problem using BFStats to generate server stats

bud wrote:

Its supposed to put the result in a database, like MySQL

Does that actually apply to this particular tool?  Because the readme file seems to describe exactly what I would expect, in that it simply converts the CSV data into an HTML page representing that CSV data.  i.e. The CSV file "is the database" in this tool's case.

If creating or configuring a formal SQL database was involved, it seems like that would need "at least a passing mention" in the readme. smile  But again, I haven't used this specific tool.  I just know I wouldn't need a database in order to do what this tool says its going to do.

-Trench

Offline

    Positive reputation 0   Negative reputation 0

#5 2018-04-28 04:49:03

bud
maestro
Reputation: +1835
Location: shangri la
Registered: 2012-07-07
Posts: 3,941
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

Oh, you are right! I was thinking of another stats software that was popular years ago. my fault smile

edit: i get the same error here

Last edited by bud (2018-04-28 05:02:32)

Offline

    Positive reputation 0   Negative reputation 0

#6 2018-04-28 05:29:08

Black Mamba
Member
Canada
Reputation: +1449
Registered: 2012-12-01
Posts: 4,231
Android Chrome 66.0

Re: Problem using BFStats to generate server stats

Well that sucks... any other way to generate stats?

Offline

    Positive reputation 0   Negative reputation 0

#7 2018-04-28 09:49:50

(BB)DinkW
Member
England
Reputation: +986
Location: In front of my screen
Registered: 2012-08-06
Posts: 1,708
Website
Windows 10 Microsoft Edge 16.16299

Re: Problem using BFStats to generate server stats

If you are just trying to make the CSV file into HTML you could try this

http://www.convertcsv.com/csv-to-html.htm

Offline

    Positive reputation 0   Negative reputation 0

#8 2018-04-28 15:14:05

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

Black Mamba wrote:

Well that sucks... any other way to generate stats?

I haven't run any scores/kills/deaths stats to recommend anything first-hand.

I see https://selectbf.sourceforge.io/ and https://github.com/SiphonSquirrel/jepperscore out there, but they don't appear to be for the faint of heart technical-wise.  (I believe selectbf must have been the one bud was referring to earlier.)  These systems are also for collating BF1942's own more extensive event/XML logging and not the BFServerManager CSV logging.

If you were happy with the data that was promised from just the CSV logging (just maps, players, kills, deaths), the only way I know to collate and put that into human-readable form like BFStats was going to do would be to write something yourself.

Offline

    Positive reputation 0   Negative reputation 0

#9 2018-04-28 18:59:55

Black Mamba
Member
Canada
Reputation: +1449
Registered: 2012-12-01
Posts: 4,231
Windows 10 Chrome 65.0

Re: Problem using BFStats to generate server stats

Trench wrote:
Black Mamba wrote:

Well that sucks... any other way to generate stats?

I haven't run any scores/kills/deaths stats to recommend anything first-hand.

I see https://selectbf.sourceforge.io/ and https://github.com/SiphonSquirrel/jepperscore out there, but they don't appear to be for the faint of heart technical-wise.  (I believe selectbf must have been the one bud was referring to earlier.)  These systems are also for collating BF1942's own more extensive event/XML logging and not the BFServerManager CSV logging.

If you were happy with the data that was promised from just the CSV logging (just maps, players, kills, deaths), the only way I know to collate and put that into human-readable form like BFStats was going to do would be to write something yourself.

I guess I'll just use an Excel spreadsheet to edit stats manually...

Offline

    Positive reputation 0   Negative reputation 0

#10 2018-04-29 02:55:49

bud
maestro
Reputation: +1835
Location: shangri la
Registered: 2012-07-07
Posts: 3,941
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

I was curious so i tried it on windows xp with an old java version (2002) and it still gets the same fault message. The thing is that i have a faint memory of using this software before, or something very similiar.

edit: sometimes flashbacks can be a good thing, i realized what the difference was between then and now, it seems to be some difference in the log file format between windows vs linux. Its not something one can see at a glance tho.

Found an old windows generated csv file and tried again.
_
http://37.187.19.136/stats/index.html

Last edited by bud (2018-04-29 03:54:34)

Offline

    Positive reputation 0   Negative reputation 0

#11 2018-04-29 22:31:49

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

bud wrote:

Found an old windows generated csv file and tried again.
http://37.187.19.136/stats/index.html

Great find.  Perhaps it's just line endings then, if the difference isn't visually obvious?  i.e. CR/LF versus LF-only.

If so, then simply loading up the CSV file in an editor like Notepad++ and using Edit | EOL Conversion to change the line endings might let Mamba run his existing log files through the tool.  Specifically, if this is the issue, we're expecting that loading the file into Notepad++ will show down in the bottom status bar that the current line endings are "Linux (LF)", and from the Edit | EOL Conversion menu you would select "Windows (CR LF)" and then save the file with the updated line endings.

EDIT: I've only just now even turned on CSV logging on our Windows server, and never had it running on the Linux servers.  The Windows log does confirm being CR/LF, as typically expected for Windows platform.

Last edited by Trench (2018-04-29 22:35:48)

Offline

    Positive reputation 0   Negative reputation 0

#12 2018-05-01 00:23:29

bud
maestro
Reputation: +1835
Location: shangri la
Registered: 2012-07-07
Posts: 3,941
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

Nice! I wouldnt have thought of that. The linux file says Unix(LF), ill try convert it.

edit: gnarf! .. must be something more i guess, ill see if i can figure out what it is, i kinda like it when it works, small files, quick loading, no database to think about.
-
1_parser.jpg
-
About the red underlining, first time i´ve seen three "unknown" like that, its no ip and no key (last one is punkbuster)
-

Last edited by bud (2018-05-01 00:41:52)

Offline

    Positive reputation 0   Negative reputation 0

#13 2018-05-01 17:35:09

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

Hmm.  Line endings certainly would have fit with "it fails on every single line, such that by the end it thinks there were a total of zero valid lines."  So if it's not that, then there "must" be some more obvious difference in the data, such as quotes used in one where quotes weren't used in the other; a different number of total columns; or some other difference that "is true for every single line."

If you wanted to PM your Linux versus Windows examples, I'd be interested to try and identify the difference too.  If the data in the examples you have isn't something you want to disseminate, that's understandable as well.  It would need to be as an attachment or something else that preserves the binary format the files, so maybe admin at ea117.com is the better way to send, if you do.

Yeah, since he had ping and score stats, nothing seems logical about why that one line would have an unknown IP or unknown key hash.  In the short time I've been running CSV logging, there have already been a couple times where at the end of the round it simply says "unable to save CSV stats" instead of appending them as expected.  So could just be buggy.

Offline

    Positive reputation 0   Negative reputation 0

#14 2018-05-02 00:50:57

bud
maestro
Reputation: +1835
Location: shangri la
Registered: 2012-07-07
Posts: 3,941
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

Yeah this is a weird one alright. I sent you a pm so you can take a closer look at those files.

Offline

    Positive reputation 0   Negative reputation 0

#15 2018-05-04 03:08:35

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

bud wrote:

Yeah this is a weird one alright. I sent you a pm so you can take a closer look at those files.

Two conclusions:

  • BFStats can't parse a date from 2010 or later.

  • If BFStats can't parse the first date in the file, the entire file is declared unparseable.  (Presumably because he wants to compare each later entry against the time stamp(s) collected, but the initial time stamp collected was invalid.  So this perpetually fails for every additional line parsed from the file.)

A current three-day statistics.csv file from my own Windows-based server also fails to parse with the same "file is empty, cannot generate any output" outcome.  So was able to rule out "from a Windows server" as constant for success too.  After seeing java.lang.NumberFormatException errors being thrown in addition to the java.lang.NullPointerException error, the focus shifted towards all the various numbers being logged, and the difference between the successful and failing statistics.csv files.

Changing the first time stamp from the 2018 log file to replace the "1" with a "0" so that the date is 2008, and leaving the rest of the file untouched with still-2018 time stamps, and my Windows server's log now parsed and generates stats.  However, the generated stats are incomplete, and the java.lang.NumberFormatException errors continue to be thrown for the remaining 2018 date stamps in the statistics.csv file.  If you search and replace all the 2018 dates with 2008 (or anything under 2010), then zero errors are reported when running BFStats and complete stats are generated.

You should be able to confirm this with the failing Linux log example you had sent.  The first time stamp was 2016, and fails to parse the entire file.  Change that time stamp to 2010, and confirm BFStats still fails to parse the entire file.  But change that first time stamp to 2009, leaving the rest of the file untouched, and now the file parses and generates output.  But the stats aren't complete.  Replace all "201x" time stamps with "200x" (i.e. 2016, 2017 and 2018 become 2006, 2007 and 2008), and you'll see no errors reported, and the HTML pages generated will have a huge number of additional stats compared to when you only fixed the first line.

EDIT: Missed confirming that the Windows example you sent "parses successfully", because the first date in that file happened to already be 2006.  The stats generated are incomplete, however, since the remaining 2018 dates all throw java.lang.NumberFormatException errors.

-Trench

Last edited by Trench (2018-05-04 03:36:58)

Offline

    Positive reputation 0   Negative reputation 0

#16 2018-05-04 03:38:31

Black Mamba
Member
Canada
Reputation: +1449
Registered: 2012-12-01
Posts: 4,231
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

Trench wrote:
bud wrote:

Yeah this is a weird one alright. I sent you a pm so you can take a closer look at those files.

Two conclusions:

  • BFStats can't parse a date from 2010 or later.

  • If BFStats can't parse the first date in the file, the entire file is declared unparseable.  (Presumably because he wants to compare each later entry against the time stamp(s) collected, but the initial time stamp collected was invalid.  So this perpetually fails for every additional line parsed from the file.)

A current three-day statistics.csv file from my own Windows-based server also fails to parse with the same "file is empty, cannot generate any output" outcome.  So was able to rule out "from a Windows server" as constant for success too.  After seeing java.lang.NumberFormatException errors being thrown in addition to the java.lang.NullPointerException error, the focus shifted towards all the various numbers being logged, and the difference between the successful and failing statistics.csv files.

Changing the first time stamp from the 2018 log file to replace the "1" with a "0" so that the date is 2008, and leaving the rest of the file untouched with still-2018 time stamps, and my Windows server's log now parsed and generates stats.  However, the generated stats are incomplete, and the java.lang.NumberFormatException errors continue to be thrown for the remaining 2018 date stamps in the statistics.csv file.  If you search and replace all the 2018 dates with 2008 (or anything under 2010), then zero errors are reported when running BFStats and complete stats are generated.

You should be able to confirm this with the failing Linux log example you had sent.  The first time stamp was 2016, and fails to parse the entire file.  Change that time stamp to 2010, and confirm BFStats still fails to parse the entire file.  But change that first time stamp to 2009, leaving the rest of the file untouched, and now the file parses and generates output.  But the stats aren't complete.  Replace all "201x" time stamps with "200x" (i.e. 2016, 2017 and 2018 become 2006, 2007 and 2008), and you'll see no errors reported, and the HTML pages generated will have a huge number of additional stats compared to when you only fixed the first line.

EDIT: Missed confirming that the Windows example you sent "parses successfully", because the first date in that file happened to already be 2006.  The stats generated are incomplete, however, since the remaining 2018 dates all throw java.lang.NumberFormatException errors.

-Trench

I tried the method you described on your second paragraph and no errors appear. The HTML files are generated in the correct folder and everything seems to work.

If I have two different statistics.csv files from two different servers, would it be possible to merge them somehow and generate stats for the two servers.

Offline

    Positive reputation 0   Negative reputation 0

#17 2018-05-04 04:10:33

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Internet Explorer 11.0

Re: Problem using BFStats to generate server stats

Black Mamba wrote:

If I have two different statistics.csv files from two different servers, would it be possible to merge them somehow and generate stats for the two servers.

It "looks" like it should be fine?  It does appear to be "intended" for a single server's stats, but it seems like the only thing that would really be affected in a way that creates misleading results is the server stats for "time of day".

In the second .CSV file, just skip the first two lines (the "header rows" that simply describe what's in each field) and cut-n-paste the rest of the file content into the end of the first .CSV and see how it goes.  Using a copy of the .CSV files and not the originals, of course.

-Trench

EDIT: A word

Last edited by Trench (2018-05-04 04:11:10)

Offline

    Positive reputation 0   Negative reputation 0

#18 2018-05-04 04:12:41

Black Mamba
Member
Canada
Reputation: +1449
Registered: 2012-12-01
Posts: 4,231
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

Trench wrote:
Black Mamba wrote:

If I have two different statistics.csv files from two different servers, would it be possible to merge them somehow and generate stats for the two servers.

It "looks" like it should be fine?  It does appear to be "intended" for a single server's stats, but it seems like the only thing that would really be affected in a way that creates misleading results is the server stats for "time of day".

In the second .CSV file, just skip the first two lines (the "header rows" that simply describe what's in each field) and cut-n-paste the rest of the file content into the end of the first .CSV and see how it goes.  Using a copy of the .CSV files and not the originals, of course.

-Trench

EDIT: A word

Thanks, I'll try that!

Offline

    Positive reputation 0   Negative reputation 0

#19 2018-05-04 06:15:59

bud
maestro
Reputation: +1835
Location: shangri la
Registered: 2012-07-07
Posts: 3,941
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

Nice work, i had never thought of that!  i opened the statistic.template for o looksie, but couldnt see any obvious problem with it that could lead to this problem, neither with the run.cmd. So i guess it might be the "bfstats.jar" thats causing it.

I found a little gem in that template tho (lol) smile

-- player names filter. this regular expression will be matched against the player name. if it matches the player
    -- will NOT show up in the statistic. so it's kind of a "ban list" (you can even rule out your most hated clan :-) )
    --
    -- the example below will match against any player that has "f*ck", "f*ck" (or the l33t versions like "Fcker") in
    -- their name or is named "Player" or "player"
    -- a good introduction on regular expressions can be found here: http://etext.lib.virginia.edu/helpsheets/regex.html
    <VAR:BAN_PLAYERS>.*[Ff]u*ck.*|[Pp]layer</VAR>

Offline

    Positive reputation 1   Negative reputation 0

#20 2018-05-04 06:26:43

Black Mamba
Member
Canada
Reputation: +1449
Registered: 2012-12-01
Posts: 4,231
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

Does anyone know the formula that is used to calculate the "Score" column on the generated HTML pages?

Offline

    Positive reputation 0   Negative reputation 0

#21 2018-05-04 12:19:46

Hydra{SRB}
$hbp
Gibraltar
Reputation: +851
Registered: 2016-03-10
Posts: 1,583
Website
Windows 7 Firefox 59.0

Re: Problem using BFStats to generate server stats

Offline

    Positive reputation 0   Negative reputation 0

#22 2018-05-04 13:23:57

Trench
Member
United States
Reputation: +129
Registered: 2014-05-05
Posts: 221
Windows 10 Chrome 66.0

Re: Problem using BFStats to generate server stats

Black Mamba wrote:

Does anyone know the formula that is used to calculate the "Score" column on the generated HTML pages?

I assumed it's just addition of the "Score" value logged for the player at the end of each round.  i.e. Their score, versus their kills, versus their deaths.  Each one of those values are being separately added together to create a total core, total kills and total deaths for all of the the rounds that have been logged for this player.

What are you observing that suggests it might be something other than that?

-Trench

EDIT: Clarification of "Are all simply being added together."

Last edited by Trench (2018-05-05 16:06:17)

Offline

    Positive reputation 0   Negative reputation 0

Board footer