search

MarkBaggett / srum-dump

A forensics tool to convert the data in the Windows srum (System Resource Usage Monitor) database to an xlsx spreadsheet.
GNU General Public License v3.0
596 stars 96 forks source link

srum_dump_csv.exe outputs blank lines between rows #16

Closed ItsPaPPy closed 5 years ago

ItsPaPPy commented 5 years ago

the xlsx option produces data on each line, but the CSV option outputs data, and then a blank line. see picture

image

nrrpinto commented 5 years ago

As a consequence of this, the calculations are wrong. For example, in file srumNetworkUsage.csv, in line 3 the formula is =sum(H2:I2) and in line 5 the formula is =sum(H3:I3), but in line 2 there is nothing and in line 3 there is the values from what should be line 2, if we arrange the data into columns, it will make wrong calculations.

image

image

MarkBaggett commented 5 years ago

Thanks for reporting this issue. I will take a look at it and try to determine the cause.

MarkBaggett commented 5 years ago

Hello. I have good news and bad news. The good news is there are no more blank lines. I released a major rewrite of srum-dump. srum-dump2 has a GUI, acquires live files and mroe. I also moved ALL of the csv functionality to a new tool called ese2csv. It dumps much more than just SRUM files. It dumps any ese files. The bad news is I removed calculated fields from the program with the update. Let me know if calculated fields were a critical component and I can look at adding them back in. Please give ese2csv a try. You'll find it here.

https://github.com/MarkBaggett/ese-analyst